VSAUFK_CN

Version: Order master data | #masterdata | Component: Simulation

🔑 Keys (3)
💰 Amounts (1)
∑ Quantities
📅 Dates (15)
☰ Categorical (21)
Other (34)
🔗 Relations (47)

Column Name	Description
MANDT FK	Client
VSNMR	Number or description of a version
AUFNR	Order Number

Column Name	Description
💲 Order Currency (AUFK.WAERS):
USER4	Estimated total costs of order

Column Name	Description

Column Name	Description
ERDAT	Created On
AEDAT	Change Date for Order Master
STDAT	Date of Last Status Change
PDAT1	Planned release date
PDAT2	Planned completion date
PDAT3	Planned closing date
IDAT1	Release Date
IDAT2	Technical Completion Date
IDAT3	Close Date
SDATE	Start Date
USER5	Application date
USER7	Work Start
USER8	End of Work
ERFZEIT	Time created
AEZEIT	Changed At

Column Name	Description
AUTYP	Order category	Show values
LTEXT	Long Text Exists	Show values
ASTKZ	Identifier for Statistical Order	Show values
PHAS0	Phase "Order Created"	Show values
PHAS1	Phase "Order Released"	Show values
PHAS2	Phase "Order Completed"	Show values
PHAS3	Phase "Order Closed"	Show values
LOEKZ	Deletion Flag	Show values
PLGKZ	Identifier for Planning with Line Items	Show values
USER9	Identifier for work permit issued	Show values
SCOPE	Object Class	Show values
PLINT	Indicator for Integrated Planning	Show values
FLG_MLTPS	Order Has Multiple Items	Show values
KSTEMPF	Indicator: Direct cost collector	Show values
RSORD	Refurbishment order indicator (PM)	Show values
JV_OCO	JV original cost object	Show values
INACT	Version inactive indicator	Show values
/CUM/INDCU	CU: Order is Used for Compatible Units	Show values
/CUM/AUEST	CU: Automatic Copy of Estimated Costs	Show values
EB_POST	Event-Based Posting	Show values
UPDATE_NEEDED	Claim inconsistency with order indicator	Show values

Column Name	Description	Domain name
ERNAM	Entered By	USNAM
AENAM	Last Changed By	USNAM
KTEXT	Description	TEXT40
CCKEY	Cost Collector Key	CCKEY
KOSTV	Responsible cost center	KOSTL
OBJID	Object ID	CHAR1
ZSCHL	Overhead key	CHAR6
SETNM	Allocation Set	SETNR
SEQNR	Sequence Number	SQNR
USER0	Applicant	AUFUSER0
USER1	Applicant's telephone number	AUFUSER1
USER2	Person Responsible	AUFUSER2
USER3	Telephone number of person in charge	AUFUSER3
USER6	Department	AUFUSER6
KDAUF	Sales Order Number	VBELN
KDPOS	Item number in Sales Order	NUM06
AUFEX	External order number	AUFEX
PKOSA	Cost Collector for Production Process	AUFNR
PROCNR	Production Alternative	CK_KALNR
PROTY	Process Category (Procurement/Consumption)	CKML_PROZESS_TYP
ADRNRA	Address Number	AD_ADDRNUM
CSTG_VRNT	Costing Variant	KLVAR
COSTESTNR	Cost Estimate Number for Cost Est. w/o Qty Structure	CK_KALNR
VERAA_USER	Person Responsible for CO Internal Order	XUBNAME
EEW_AUFK_PS_DUMMY	Dummy function in length 1	DUMMY
OTYPE	Joint Venture Object Type	JV_OTYPE
ORGKEY	Order Number	AUFNR
EXT_AUFNR	Order Number	AUFNR
CPD_UPDAT	Time Stamp	/CPD/PFP_TSTMP
/CUM/CMNUM	CU: Construction Measure Number	/CUM/CMNUM
/CUM/DESNUM	CU: Design Number	/CUM/DESNUM
AD01PROFNR	Dynamic Item Processor Profile	AD01PROFNR
VAPLZ	Main work center for maintenance tasks	ARBPL
WAWRK	Plant associated with main work center	WERKS

Master Data Relations	Join Conditions
Results Analysis Key	`VSAUFK_CN.MANDT == TKKAA.MANDT` `VSAUFK_CN.ABGSL == TKKAA.ABGSL`
Processing group Processing group Client Controlling Area	`VSAUFK_CN.ABKRS == TKO08.ABKRS` `VSAUFK_CN.MANDT == TKO08.CLIENT` `VSAUFK_CN.KOKRS == TKO08.KOKRS`
Requesting company code	`VSAUFK_CN.MANDT == T001.MANDT` `VSAUFK_CN.ABUKR == T001.BUKRS`
Requesting cost center ? Requesting cost center Controlling Area	`VSAUFK_CN.MANDT == CSKS.MANDT` `VSAUFK_CN.[column in domain "DATBI"] == CSKS.DATBI` `VSAUFK_CN.AKSTL == CSKS.KOSTL` `VSAUFK_CN.KOKRS == CSKS.KOKRS`
Requesting order Requesting order Client	`VSAUFK_CN.ANFAUFNR == AUFK.AUFNR` `VSAUFK_CN.MANDT == AUFK.MANDT`
Order Status Order Status Order Type	`VSAUFK_CN.MANDT == TKO03.CLIENT` `VSAUFK_CN.ASTNR == TKO03.ASTNR` `VSAUFK_CN.AUART == TKO03.ART`
Order Type	`VSAUFK_CN.MANDT == T003O.CLIENT` `VSAUFK_CN.AUART == T003O.AUART`
Status Combination	`VSAUFK_CN.MANDT == ACTCMB_TAB.MANDT` `VSAUFK_CN.AUFK_STATUS == ACTCMB_TAB.ACTCMB`
Variance Key ? Variance Key	`VSAUFK_CN.MANDT == TKV01.MANDT` `VSAUFK_CN.[column in domain "AWOBA"] == TKV01.AWOBA` `VSAUFK_CN.AWSLS == TKV01.AWSLS`
Accounting Indicator	`VSAUFK_CN.MANDT == TBMOT.MANDT` `VSAUFK_CN.BEMOT == TBMOT.BEMOT`
Company Code	`VSAUFK_CN.MANDT == T001.MANDT` `VSAUFK_CN.BUKRS == T001.BUKRS`
Claim creation control indicator Claim creation control indicator Client	`VSAUFK_CN.CLAIM_CONTROL == WTYSCC_CLM_CONT.CLAIM_CONTROL` `VSAUFK_CN.MANDT == WTYSCC_CLM_CONT.MANDT`
Cost center to which costs are actually posted ? Cost center to which costs are actually posted Controlling Area	`VSAUFK_CN.MANDT == CSKS.MANDT` `VSAUFK_CN.[column in domain "DATBI"] == CSKS.DATBI` `VSAUFK_CN.CYCLE == CSKS.KOSTL` `VSAUFK_CN.KOKRS == CSKS.KOKRS`
Status Reached so Far Status Reached so Far Order Type	`VSAUFK_CN.MANDT == TKO03.CLIENT` `VSAUFK_CN.ESTNR == TKO03.ASTNR` `VSAUFK_CN.AUART == TKO03.ART`
Equity type Joint venture ? Company Code Equity type	`VSAUFK_CN.MANDT == T8JG.MANDT` `VSAUFK_CN.VNAME == T8JG.VNAME` `VSAUFK_CN.[column in domain "FDATE"] == T8JG.FDATE` `VSAUFK_CN.BUKRS == T8JG.BUKRS` `VSAUFK_CN.ETYPE == T8JG.ETYPE`
Regulatory indicator Regulatory indicator Client	`VSAUFK_CN.FERC_IND == FERC_C7.IND` `VSAUFK_CN.MANDT == FERC_C7.MANDT`
Functional Area	`VSAUFK_CN.MANDT == TFKB.MANDT` `VSAUFK_CN.FUNC_AREA == TFKB.FKBER`
Business Area	`VSAUFK_CN.MANDT == TGSB.MANDT` `VSAUFK_CN.GSBER == TGSB.GSBER`
Investment Measure Profile	`VSAUFK_CN.MANDT == TAPRF.MANDT` `VSAUFK_CN.IVPRO == TAPRF.IVPRO`
Reason for Investment	`VSAUFK_CN.MANDT == T087I.MANDT` `VSAUFK_CN.IZWEK == T087I.IZWEK`
JIB/JIBE Class JIB/JIBE Class Client Company Code	`VSAUFK_CN.JV_JIBCL == T8J6A.CLASS` `VSAUFK_CN.MANDT == T8J6A.MANDT` `VSAUFK_CN.BUKRS == T8J6A.BUKRS`
JIB/JIBE Subclass A Company Code JIB/JIBE Subclass A JIB/JIBE Class	`VSAUFK_CN.MANDT == T8J6C.MANDT` `VSAUFK_CN.BUKRS == T8J6C.BUKRS` `VSAUFK_CN.JV_JIBSA == T8J6C.SUBCLASS` `VSAUFK_CN.JV_JIBCL == T8J6C.CLASS`
Costing Sheet Application Costing Sheet Usage of the condition table	`VSAUFK_CN.MANDT == T683.MANDT` `VSAUFK_CN.KAPPL == T683.KAPPL` `VSAUFK_CN.KALSM == T683.KALSM` `VSAUFK_CN.KVEWE == T683.KVEWE`
Application	`VSAUFK_CN.KAPPL == T681A.KAPPL`
Controlling Area	`VSAUFK_CN.MANDT == TKA01.MANDT` `VSAUFK_CN.KOKRS == TKA01.KOKRS`
Cost Center for Basic Settlement ? Cost Center for Basic Settlement Controlling Area	`VSAUFK_CN.MANDT == CSKS.MANDT` `VSAUFK_CN.[column in domain "DATBI"] == CSKS.DATBI` `VSAUFK_CN.KOSTL == CSKS.KOSTL` `VSAUFK_CN.KOKRS == CSKS.KOKRS`
Settlement Cost Element Controlling Area Settlement Cost Element ? Client	`VSAUFK_CN.KOKRS == CSKB.KOKRS` `VSAUFK_CN.KSTAR == CSKB.KSTAR` `VSAUFK_CN.[column in domain "DATBI"] == CSKB.DATBI` `VSAUFK_CN.MANDT == CSKB.MANDT`
Usage of the condition table	`VSAUFK_CN.KVEWE == T681V.KVEWE`
Logical System	`VSAUFK_CN.LOGSYSTEM == TBDLS.LOGSYS`
Client	`VSAUFK_CN.MANDT == T000.MANDT`
Profit Center ? Controlling Area Profit Center	`VSAUFK_CN.MANDT == CEPC.MANDT` `VSAUFK_CN.[column in domain "DATBI"] == CEPC.DATBI` `VSAUFK_CN.KOKRS == CEPC.KOKRS` `VSAUFK_CN.PRCTR == CEPC.PRCTR`
Work breakdown structure element (WBS element) Work breakdown structure element (WBS element) Client	`VSAUFK_CN.PSPEL == VSPRPS_CN.VSNMR` `VSAUFK_CN.MANDT == VSPRPS_CN.MANDT`
Recovery Indicator Company Code Recovery Indicator	`VSAUFK_CN.MANDT == T8JJ.MANDT` `VSAUFK_CN.BUKRS == T8JJ.BUKRS` `VSAUFK_CN.RECID == T8JJ.RECID`
Reference Order Number Reference Order Number Client	`VSAUFK_CN.REFNR == AUFK.AUFNR` `VSAUFK_CN.MANDT == AUFK.MANDT`
G/L Account for Basic Settlement Company Code Client G/L Account for Basic Settlement	`VSAUFK_CN.BUKRS == SKB1.BUKRS` `VSAUFK_CN.MANDT == SKB1.MANDT` `VSAUFK_CN.SAKNR == SKB1.SAKNR`
Scale of investment objects	`VSAUFK_CN.MANDT == TAIF5.MANDT` `VSAUFK_CN.SIZECL == TAIF5.SIZECL`
Location Plant	`VSAUFK_CN.MANDT == T001W.MANDT` `VSAUFK_CN.SOWRK == T001W.WERKS`
Location Location Client Location Plant	`VSAUFK_CN.STORT == T499S.STAND` `VSAUFK_CN.MANDT == T499S.MANDT` `VSAUFK_CN.SOWRK == T499S.WERKS`
Tax Jurisdiction Costing Sheet Tax Jurisdiction	`VSAUFK_CN.MANDT == TTXJ.MANDT` `VSAUFK_CN.KALSM == TTXJ.KALSM` `VSAUFK_CN.TXJCD == TTXJ.TXJCD`
Reason for Environmental Investment	`VSAUFK_CN.MANDT == T087K.MANDT` `VSAUFK_CN.UMWKZ == T087K.UMWKZ`
Claim update trigger point from service order	`VSAUFK_CN.MANDT == WTYSCC_UPDT_CONT.MANDT` `VSAUFK_CN.UPDATE_CONTROL == WTYSCC_UPDT_CONT.UPDATE_CONTROL`
Joint venture Company Code Joint venture Client	`VSAUFK_CN.BUKRS == T8JV.BUKRS` `VSAUFK_CN.VNAME == T8JV.VNAME` `VSAUFK_CN.MANDT == T8JV.MANDT`
Order Currency	`VSAUFK_CN.MANDT == TCURC.MANDT` `VSAUFK_CN.WAERS == TCURC.WAERS`
Plant	`VSAUFK_CN.MANDT == T001W.MANDT` `VSAUFK_CN.WERKS == T001W.WERKS`
Interest calculation profile Interest Profile for Project/Order Interest Calculation Client	`VSAUFK_CN.ZSCHM == TPI01.ZSCHM` `VSAUFK_CN.MANDT == TPI01.MANDT`

Other Relations \| to Master Data Relations ↑	Join Conditions
Group of Disallowed Transactions ? Object ID Group of Disallowed Transactions	`VSAUFK_CN.MANDT == TKAVG.MANDT` `VSAUFK_CN.[column in domain "ACTI1"] == TKAVG.ACTIVITY` `VSAUFK_CN.OBJID == TKAVG.OBJID` `VSAUFK_CN.VOGRP == TKAVG.GRUPPE`