SAP VSAUFK_CN Version: Order master data Table

Overview

VSAUFK_CN is a standard SAP S/4HANA table that stores Version: Order master data data. There are total 116 fields in the VSAUFK_CN table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table VSAUFK_CN belongs to Simulation (PS-SIM) module and is located in the package R/3 Application development: Version Management (CNVS).

In addition, following links provide an overview of foreign key relationships, if any, that link VSAUFK_CN to other SAP tables and standard CDS views available based on VSAUFK_CN table in S/4HANA 2020.

Techincal Settings of VSAUFK_CN

Below are technical details of the table VSAUFK_CN

Buffering not allowed
No buffering
Storage type is Column Store

List of VSAUFK_CN Fields

The following table gives you an overview of the fields available in VSAUFK_CN

Field	Description	Data Element	Check Table	Data Type	Length
MANDT	Client	MANDT	T000	CLNT	3
VSNMR	Number or description of a version	VSNMR		CHAR	12
AUFNR	Order Number	AUFNR		CHAR	12
AUART	Order Type	AUFART	T003O	CHAR	4
AUTYP	Order category	AUFTYP		NUMC	2
REFNR	Reference Order Number	AUFREFNR	AUFK	CHAR	12
ERNAM	Entered By	AUFERFNAM		CHAR	12
ERDAT	Created On	AUFERFDAT		DATS	8
AENAM	Last Changed By	AUFAENAM		CHAR	12
AEDAT	Change Date for Order Master	AUFAEDAT		DATS	8
KTEXT	Description	AUFTEXT		CHAR	40
LTEXT	Long Text Exists	AUFLTEXT		CHAR	1
BUKRS	Company Code	BUKRS	T001	CHAR	4
WERKS	Plant	WERKS_D	T001W	CHAR	4
GSBER	Business Area	GSBER	TGSB	CHAR	4
KOKRS	Controlling Area	KOKRS	TKA01	CHAR	4
CCKEY	Cost Collector Key	CCKEY		CHAR	23
KOSTV	Responsible cost center	AUFKOSTV		CHAR	10
STORT	Location	AUFSTORT	T499S	CHAR	10
SOWRK	Location Plant	AUFSOWRK	T001W	CHAR	4
ASTKZ	Identifier for Statistical Order	AUFSTKZ		CHAR	1
WAERS	Order Currency	AUFWAERS	TCURC	CUKY	5
ASTNR	Order Status	AUFASTNR	TKO03	NUMC	2
STDAT	Date of Last Status Change	AUFSTDAT		DATS	8
ESTNR	Status Reached so Far	AUFESTNR	TKO03	NUMC	2
PDAT1	Planned release date	AUFPDAT1		DATS	8
PDAT2	Planned completion date	AUFPDAT2		DATS	8
PDAT3	Planned closing date	AUFPDAT3		DATS	8
IDAT1	Release Date	AUFIDAT1		DATS	8
IDAT2	Technical Completion Date	AUFIDAT2		DATS	8
IDAT3	Close Date	AUFIDAT3		DATS	8
OBJID	Object ID	CCOBJID		CHAR	1
VOGRP	Group of Disallowed Transactions	AUFSPSET	TKAVG	CHAR	4
LOEKZ	Deletion Flag	AUFLOEKZ		CHAR	1
PLGKZ	Identifier for Planning with Line Items	PLGKZ		CHAR	1
KVEWE	Usage of the condition table	KVEWE	T681V	CHAR	1
KAPPL	Application	KAPPL	T681A	CHAR	2
KALSM	Costing Sheet	AUFKALSM	T683	CHAR	6
ZSCHL	Overhead key	AUFZSCHL		CHAR	6
ABKRS	Processing group	AUFABKRS	TKO08	NUMC	2
KSTAR	Settlement Cost Element	AUFKSTAR	CSKB	CHAR	10
KOSTL	Cost Center for Basic Settlement	AUFKOSTL	CSKS	CHAR	10
SAKNR	G/L Account for Basic Settlement	AUFSAKNR	SKB1	CHAR	10
SETNM	Allocation Set	AUFSETNM		CHAR	12
CYCLE	Cost center to which costs are actually posted	ST_KOSTL	CSKS	CHAR	10
SDATE	Start Date	SDATE		DATS	8
SEQNR	Sequence Number	AUFSEQNR		NUMC	4
USER0	Applicant	AUFUSER0		CHAR	20
USER1	Applicant's telephone number	AUFUSER1		CHAR	20
USER2	Person Responsible	AUFUSER2		CHAR	20
USER3	Telephone number of person in charge	AUFUSER3		CHAR	20
USER4	Estimated total costs of order	AUFUSER4		CURR	11
USER5	Application date	AUFUSER5		DATS	8
USER6	Department	AUFUSER6		CHAR	15
USER7	Work Start	AUFUSER7		DATS	8
USER8	End of Work	AUFUSER8		DATS	8
USER9	Identifier for work permit issued	AUFUSER9		CHAR	1
OBJNR	Object number	J_OBJNR	ONR00	CHAR	22
PRCTR	Profit Center	PRCTR	CEPC	CHAR	10
PSPEL	Work breakdown structure element (WBS element)	PS_PSP_ELE	VSPRPS_CN	NUMC	8
AWSLS	Variance Key	AWSLS	TKV01	CHAR	6
ABGSL	Results Analysis Key	ABGR_SCHL	TKKAA	CHAR	6
TXJCD	Tax Jurisdiction	TXJCD	TTXJ	CHAR	15
FUNC_AREA	Functional Area	FKBER	TFKB	CHAR	16
SCOPE	Object Class	SCOPE_CV		CHAR	2
PLINT	Indicator for Integrated Planning	PLINT		CHAR	1
KDAUF	Sales Order Number	KDAUF		CHAR	10
KDPOS	Item number in Sales Order	KDPOS		NUMC	6
AUFEX	External order number	AUFEX		CHAR	20
IVPRO	Investment Measure Profile	IM_PROFIL	TAPRF	CHAR	6
LOGSYSTEM	Logical System	LOGSYSTEM	TBDLS	CHAR	10
FLG_MLTPS	Order Has Multiple Items	CO_MLTPS		CHAR	1
ABUKR	Requesting company code	IM_ABUKRS	T001	CHAR	4
AKSTL	Requesting cost center	PS_AKSTL	CSKS	CHAR	10
SIZECL	Scale of investment objects	IM_SIZECL	TAIF5	CHAR	2
IZWEK	Reason for Investment	IZWEK	T087I	CHAR	2
UMWKZ	Reason for Environmental Investment	AM_UMWKZ	T087K	CHAR	5
KSTEMPF	Indicator: Direct cost collector	CO_KSTEMPF		CHAR	1
ZSCHM	Interest Profile for Project/Order Interest Calculation	PS_ZSCHM	TPI01	CHAR	7
PKOSA	Cost Collector for Production Process	PKOSA_D		CHAR	12
ANFAUFNR	Requesting order	AUFANFNR	AUFK	CHAR	12
PROCNR	Production Alternative	CKML_PROCNR		NUMC	12
PROTY	Process Category (Procurement/Consumption)	CKML_PROZESS_TYP		CHAR	4
RSORD	Refurbishment order indicator (PM)	RSORD		CHAR	1
BEMOT	Accounting Indicator	BEMOT	TBMOT	CHAR	2
ADRNRA	Address Number	AD_ADDRNUM		CHAR	10
ERFZEIT	Time created	CO_INS_TIME		TIMS	6
AEZEIT	Changed At	CO_CHG_TIME		TIMS	6
CSTG_VRNT	Costing Variant	CK_KLVAR		CHAR	4
COSTESTNR	Cost Estimate Number for Cost Est. w/o Qty Structure	CK_KALNR		NUMC	12
VERAA_USER	Person Responsible for CO Internal Order	VERAA_USER		CHAR	12
ZNAMES	PATIENT NAME	ZNAME		CHAR	20
EEW_AUFK_PS_DUMMY	Dummy function in length 1	DUMMY		CHAR	1
VNAME	Joint venture	JV_NAME	T8JV	CHAR	6
RECID	Recovery Indicator	JV_RECIND	T8JJ	CHAR	2
ETYPE	Equity type	JV_ETYPE	T8JG	CHAR	3
OTYPE	Joint Venture Object Type	JV_OTYPE		CHAR	4
JV_JIBCL	JIB/JIBE Class	JV_JIBCL	T8J6A	CHAR	3
JV_JIBSA	JIB/JIBE Subclass A	JV_JIBSA	T8J6C	CHAR	5
JV_OCO	JV original cost object	JV_OR_CO		CHAR	1
ORGKEY	Order Number	AUFNR	*	CHAR	12
EXT_AUFNR	Order Number	AUFNR	*	CHAR	12
INACT	Version inactive indicator	VSINACT		CHAR	1
AUFK_STATUS	Status Combination	ACTCMB_DELE	ACTCMB_TAB	INT1	3
CPD_UPDAT	Time Stamp	/CPD/PFP_TSTMP		DEC	15
/CUM/INDCU	CU: Order is Used for Compatible Units	/CUM/INDCU		CHAR	1
/CUM/CMNUM	CU: Construction Measure Number	/CUM/CMNUM		CHAR	12
/CUM/AUEST	CU: Automatic Copy of Estimated Costs	/CUM/AUEST		CHAR	1
/CUM/DESNUM	CU: Design Number	/CUM/DESNUM	*	CHAR	12
AD01PROFNR	Dynamic Item Processor Profile	AD01PROFNR		CHAR	8
VAPLZ	Main work center for maintenance tasks	GEWRK		CHAR	8
WAWRK	Plant associated with main work center	WERGW	*	CHAR	4
FERC_IND	Regulatory indicator	FE_IND	FERC_C7	CHAR	4
CLAIM_CONTROL	Claim creation control indicator	WTYSC_CLAIM_CONTROL	WTYSCC_CLM_CONT	CHAR	1
UPDATE_NEEDED	Claim inconsistency with order indicator	WTYSC_UPDATE_NEEDED		CHAR	1
UPDATE_CONTROL	Claim update trigger point from service order	WTYSC_UPDATE_CONTROL	WTYSCC_UPDT_CONT	CHAR	1

Foreign Key Relationships

A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VSAUFK_CN

Table Name	Field	Cardinality	Check Table
VSAUFK_CN	ABGSL	C: CN	TKKAA
VSAUFK_CN	ABKRS	1: CN	TKO08
VSAUFK_CN	ABUKR	1: CN	T001
VSAUFK_CN	AKSTL	1: CN	CSKS
VSAUFK_CN	ANFAUFNR	1: CN	AUFK
VSAUFK_CN	ASTNR	1: CN	TKO03
VSAUFK_CN	AUART	1: CN	T003O
VSAUFK_CN	AUFK_STATUS	:	ACTCMB_TAB
VSAUFK_CN	AWSLS	C: CN	TKV01
VSAUFK_CN	BEMOT	:	TBMOT
VSAUFK_CN	BUKRS	1: CN	T001
VSAUFK_CN	CLAIM_CONTROL	:	WTYSCC_CLM_CONT
VSAUFK_CN	CYCLE	1: CN	CSKS
VSAUFK_CN	ESTNR	1: CN	TKO03
VSAUFK_CN	ETYPE	C: CN	T8JG
VSAUFK_CN	FERC_IND	:	FERC_C7
VSAUFK_CN	FUNC_AREA	:	TFKB
VSAUFK_CN	GSBER	1: CN	TGSB
VSAUFK_CN	IVPRO	C: CN	TAPRF
VSAUFK_CN	IZWEK	1: CN	T087I
VSAUFK_CN	JV_JIBCL	C: CN	T8J6A
VSAUFK_CN	JV_JIBSA	C: CN	T8J6C
VSAUFK_CN	KALSM	1: CN	T683
VSAUFK_CN	KAPPL	1: CN	T681A
VSAUFK_CN	KOKRS	1: CN	TKA01
VSAUFK_CN	KOSTL	1: CN	CSKS
VSAUFK_CN	KSTAR	1: CN	CSKB
VSAUFK_CN	KVEWE	1: CN	T681V
VSAUFK_CN	LOGSYSTEM	1: CN	TBDLS
VSAUFK_CN	MANDT	1: CN	T000
VSAUFK_CN	OBJNR	1: 1	ONR00
VSAUFK_CN	PRCTR	1: CN	CEPC
VSAUFK_CN	PSPEL	C: CN	VSPRPS_CN
VSAUFK_CN	RECID	C: CN	T8JJ
VSAUFK_CN	REFNR	1: CN	AUFK
VSAUFK_CN	SAKNR	1: CN	SKB1
VSAUFK_CN	SIZECL	1: CN	TAIF5
VSAUFK_CN	SOWRK	1: CN	T001W
VSAUFK_CN	STORT	1: CN	T499S
VSAUFK_CN	TXJCD	:	TTXJ
VSAUFK_CN	UMWKZ	1: CN	T087K
VSAUFK_CN	UPDATE_CONTROL	:	WTYSCC_UPDT_CONT
VSAUFK_CN	VNAME	C: CN	T8JV
VSAUFK_CN	VOGRP	1: CN	TKAVG
VSAUFK_CN	WAERS	1: CN	TCURC
VSAUFK_CN	WERKS	1: CN	T001W
VSAUFK_CN	ZSCHM	1: CN	TPI01

SAP VSAUFK_CN Version: Order master data Table

Overview

Techincal Settings of VSAUFK_CN

List of VSAUFK_CN Fields

Foreign Key Relationships

Other References