SAP ABAP Table VSAUFK_CN (Version: Order master data)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ SRM-EBP (Application Component) Enterprise Buyer
⤷ CNVS (Package) R/3 Application development: Version Management
⤷ SRM-EBP (Application Component) Enterprise Buyer
⤷ CNVS (Package) R/3 Application development: Version Management
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | VSAUFK_CN | Table Relationship Diagram |
Short Description | Version: Order master data |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | .INCLUDE | 0 | 0 | Version: PS version, version-related key fields | |||||
3 | VSNMR | VSNMR | VSNMR | CHAR | 12 | 0 | Number or description of a version | ||
4 | AUFNR | AUFNR | AUFNR | CHAR | 12 | 0 | Order Number | * | |
5 | AUART | AUFART | AUFART | CHAR | 4 | 0 | Order Type | * | |
6 | AUTYP | AUFTYP | AUFTYP | NUMC | 2 | 0 | Order category | ||
7 | REFNR | AUFREFNR | AUFNR | CHAR | 12 | 0 | Reference order number | AUFK | |
8 | ERNAM | AUFERFNAM | USNAM | CHAR | 12 | 0 | Entered by | ||
9 | ERDAT | AUFERFDAT | DATUM | DATS | 8 | 0 | Created on | ||
10 | AENAM | AUFAENAM | USNAM | CHAR | 12 | 0 | Last changed by | ||
11 | AEDAT | AUFAEDAT | DATUM | DATS | 8 | 0 | Change date for Order Master | ||
12 | KTEXT | AUFTEXT | TEXT40 | CHAR | 40 | 0 | Description | ||
13 | LTEXT | AUFLTEXT | XFELD | CHAR | 1 | 0 | Long Text Exists | ||
14 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | T001 | |
15 | WERKS | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | T001W | |
16 | GSBER | GSBER | GSBER | CHAR | 4 | 0 | Business Area | * | |
17 | KOKRS | KOKRS | CACCD | CHAR | 4 | 0 | Controlling Area | TKA01 | |
18 | CCKEY | CCKEY | CCKEY | CHAR | 23 | 0 | Cost collector key | ||
19 | KOSTV | AUFKOSTV | KOSTL | CHAR | 10 | 0 | Responsible cost center | * | |
20 | STORT | AUFSTORT | AP_STAND | CHAR | 10 | 0 | Location | * | |
21 | SOWRK | AUFSOWRK | WERKS | CHAR | 4 | 0 | Location plant | T001W | |
22 | ASTKZ | AUFSTKZ | XFELD | CHAR | 1 | 0 | Identifier for statistical order | ||
23 | WAERS | AUFWAERS | WAERS | CUKY | 5 | 0 | Order Currency | TCURC | |
24 | ASTNR | AUFASTNR | AUFSTNR | NUMC | 2 | 0 | Order status | * | |
25 | STDAT | AUFSTDAT | DATUM | DATS | 8 | 0 | Date of last status change | ||
26 | ESTNR | AUFESTNR | AUFSTNR | NUMC | 2 | 0 | Status reached so far | * | |
27 | PHAS0 | AUFPHAS0 | XFELD | CHAR | 1 | 0 | Phase "Order created" | ||
28 | PHAS1 | AUFPHAS1 | XFELD | CHAR | 1 | 0 | Phase "Order released" | ||
29 | PHAS2 | AUFPHAS2 | XFELD | CHAR | 1 | 0 | Phase "order completed" | ||
30 | PHAS3 | AUFPHAS3 | XFELD | CHAR | 1 | 0 | Phase "order closed" | ||
31 | PDAT1 | AUFPDAT1 | DATUM | DATS | 8 | 0 | Planned release date | ||
32 | PDAT2 | AUFPDAT2 | DATUM | DATS | 8 | 0 | Planned completion date | ||
33 | PDAT3 | AUFPDAT3 | DATUM | DATS | 8 | 0 | Planned closing date | ||
34 | IDAT1 | AUFIDAT1 | DATUM | DATS | 8 | 0 | Release date | ||
35 | IDAT2 | AUFIDAT2 | DATUM | DATS | 8 | 0 | Technical completion date | ||
36 | IDAT3 | AUFIDAT3 | DATUM | DATS | 8 | 0 | Close date | ||
37 | OBJID | CCOBJID | CHAR1 | CHAR | 1 | 0 | Object ID | ||
38 | VOGRP | AUFSPSET | VOGRP | CHAR | 4 | 0 | Group of disallowed transactions | * | |
39 | LOEKZ | AUFLOEKZ | XFELD | CHAR | 1 | 0 | Deletion flag | ||
40 | PLGKZ | PLGKZ | XFELD | CHAR | 1 | 0 | Identifier for planning with line items | ||
41 | KVEWE | KVEWE | KVEWE | CHAR | 1 | 0 | Usage of the Condition Table | * | |
42 | KAPPL | KAPPL | KAPPL | CHAR | 2 | 0 | Application | * | |
43 | KALSM | AUFKALSM | KALSM | CHAR | 6 | 0 | Costing Sheet | T683 | |
44 | ZSCHL | AUFZSCHL | CHAR6 | CHAR | 6 | 0 | Overhead key | ||
45 | ABKRS | AUFABKRS | AKREIS | NUMC | 2 | 0 | Processing group | * | |
46 | KSTAR | AUFKSTAR | KSTAR | CHAR | 10 | 0 | Settlement cost element | * | |
47 | KOSTL | AUFKOSTL | KOSTL | CHAR | 10 | 0 | Cost center for basic settlement | CSKS | |
48 | SAKNR | AUFSAKNR | SAKNR | CHAR | 10 | 0 | G/L account for basic settlement | * | |
49 | SETNM | AUFSETNM | SETNR | CHAR | 12 | 0 | Allocation set | ||
50 | CYCLE | ST_KOSTL | KOSTL | CHAR | 10 | 0 | Cost center to which costs are actually posted | CSKS | |
51 | SDATE | SDATE | SDATE | DATS | 8 | 0 | Start Date | * | |
52 | SEQNR | AUFSEQNR | SQNR | NUMC | 4 | 0 | Sequence number | * | |
53 | USER0 | AUFUSER0 | AUFUSER0 | CHAR | 20 | 0 | Applicant | ||
54 | USER1 | AUFUSER1 | AUFUSER1 | CHAR | 20 | 0 | Applicant's telephone number | ||
55 | USER2 | AUFUSER2 | AUFUSER2 | CHAR | 20 | 0 | Person Responsible | ||
56 | USER3 | AUFUSER3 | AUFUSER3 | CHAR | 20 | 0 | Telephone number of person in charge | ||
57 | USER4 | AUFUSER4 | AUFUSER4 | CURR | 11 | 2 | Estimated total costs of order | ||
58 | USER5 | AUFUSER5 | AUFUSER5 | DATS | 8 | 0 | Application date | ||
59 | USER6 | AUFUSER6 | AUFUSER6 | CHAR | 15 | 0 | Department | ||
60 | USER7 | AUFUSER7 | AUFUSER7 | DATS | 8 | 0 | Work Start | ||
61 | USER8 | AUFUSER8 | AUFUSER8 | DATS | 8 | 0 | End of Work | ||
62 | USER9 | AUFUSER9 | AUFUSER9 | CHAR | 1 | 0 | Identifier for work permit issued | ||
63 | OBJNR | J_OBJNR | J_OBJNR | CHAR | 22 | 0 | Object number | ONR00 | |
64 | PRCTR | PRCTR | PRCTR | CHAR | 10 | 0 | Profit Center | ||
65 | PSPEL | PS_PSP_ELE | PS_POSNR | NUMC | 8 | 0 | Work breakdown structure element (WBS element) | VSPRPS_CN | |
66 | AWSLS | AWSLS | AWSLS | CHAR | 6 | 0 | Variance Key | * | |
67 | ABGSL | ABGR_SCHL | ABGR_SCHL | CHAR | 6 | 0 | Results Analysis Key | ||
68 | TXJCD | TXJCD | TXJCD | CHAR | 15 | 0 | Tax Jurisdiction | * | |
69 | SCOPE | SCOPE_CV | SCOPE_CV | CHAR | 2 | 0 | Object Class | ||
70 | PLINT | PLINT | XFELD | CHAR | 1 | 0 | Indicator for Integrated Planning | ||
71 | KDAUF | KDAUF | VBELN | CHAR | 10 | 0 | Sales Order Number | ||
72 | KDPOS | KDPOS | NUM06 | NUMC | 6 | 0 | Item number in Sales Order | ||
73 | AUFEX | AUFEX | AUFEX | CHAR | 20 | 0 | External order number | ||
74 | IVPRO | IM_PROFIL | IM_PROFIL | CHAR | 6 | 0 | Investment measure profile | * | |
75 | LOGSYSTEM | LOGSYSTEM | LOGSYS | CHAR | 10 | 0 | Logical System | TBDLS | |
76 | FLG_MLTPS | CO_MLTPS | KREUZ | CHAR | 1 | 0 | Order with multiple items | ||
77 | ABUKR | IM_ABUKRS | BUKRS | CHAR | 4 | 0 | Requesting company code | T001 | |
78 | AKSTL | PS_AKSTL | KOSTL | CHAR | 10 | 0 | Requesting cost center | CSKS | |
79 | SIZECL | IM_SIZECL | SIZECL | CHAR | 2 | 0 | Scale of investment objects | * | |
80 | IZWEK | IZWEK | IZWEK | CHAR | 2 | 0 | Reason for investment | * | |
81 | UMWKZ | AM_UMWKZ | AM_UMWKZ | CHAR | 5 | 0 | Reason for environmental investment | * | |
82 | KSTEMPF | CO_KSTEMPF | CO_KSTEMPF | CHAR | 1 | 0 | Indicator: Direct cost collector | ||
83 | ZSCHM | PS_ZSCHM | PS_ZSCHM | CHAR | 7 | 0 | Interest Profile for Project/Order Interest Calculation | * | |
84 | PKOSA | PKOSA_D | AUFNR | CHAR | 12 | 0 | Cost collector for production process PROCNR | * | |
85 | PROCNR | CKML_PROCNR | CK_KALNR | NUMC | 12 | 0 | Production alternative | * | |
86 | PROTY | CKML_PROZESS_TYP | CKML_PROZESS_TYP | CHAR | 4 | 0 | Process Category (Procurement/Consumption) | * | |
87 | RSORD | RSORD | XFELD | CHAR | 1 | 0 | Refurbishment order indicator (PM) | ||
88 | BEMOT | BEMOT | BEMOT | CHAR | 2 | 0 | Accounting Indicator | * | |
89 | ADRNRA | AD_ADDRNUM | AD_ADDRNUM | CHAR | 10 | 0 | Address number | * | |
90 | ERFZEIT | CO_INS_TIME | UZEIT | TIMS | 6 | 0 | Time created | ||
91 | AEZEIT | CO_CHG_TIME | UZEIT | TIMS | 6 | 0 | Changed at | ||
92 | .INCLUDE | 0 | 0 | ||||||
93 | .INCLUDE | 0 | 0 | JV data: (gjv_data_1),jv_oco | |||||
94 | .INCLUDE | 0 | 0 | JV data: (vname,recid,etype),otype,jv_jibcl,jv_jibsa | |||||
95 | .INCLUDE | 0 | 0 | General assignments of application objects | |||||
96 | VNAME | JV_NAME | JV_NAME | CHAR | 6 | 0 | Joint venture | * | |
97 | RECID | JV_RECIND | JV_RECIND | CHAR | 2 | 0 | Recovery Indicator | * | |
98 | ETYPE | JV_ETYPE | JV_ETYPE | CHAR | 3 | 0 | Equity type | * | |
99 | OTYPE | JV_OTYPE | JV_OTYPE | CHAR | 4 | 0 | Joint Venture Object Type | ||
100 | JV_JIBCL | JV_JIBCL | JV_JIBCL | CHAR | 3 | 0 | JIB/JIBE Class | * | |
101 | JV_JIBSA | JV_JIBSA | JV_JIBSA | CHAR | 5 | 0 | JIB/JIBE Subclass A | * | |
102 | JV_OCO | JV_OR_CO | JV_OR_COB | CHAR | 1 | 0 | JV original cost object | ||
103 | .INCLUDE | 0 | 0 | Version-include for AFKO | |||||
104 | ORGKEY | AUFNR | AUFNR | CHAR | 12 | 0 | Order Number | * | |
105 | EXT_AUFNR | AUFNR | AUFNR | CHAR | 12 | 0 | Order Number | * | |
106 | INACT | VSINACT | XFELD | CHAR | 1 | 0 | Version inactive indicator |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | VSAUFK_CN | ABUKR | T001 | BUKRS | 1 | CN | |
2 | VSAUFK_CN | AKSTL | CSKS | KOSTL | 1 | CN | |
3 | VSAUFK_CN | BUKRS | T001 | BUKRS | REF | 1 | CN |
4 | VSAUFK_CN | CYCLE | CSKS | KOSTL | 1 | CN | |
5 | VSAUFK_CN | KALSM | T683 | KALSM | REF | 1 | CN |
6 | VSAUFK_CN | KOKRS | TKA01 | KOKRS | REF | 1 | CN |
7 | VSAUFK_CN | KOSTL | CSKS | KOSTL | 1 | CN | |
8 | VSAUFK_CN | LOGSYSTEM | TBDLS | LOGSYS | REF | 1 | CN |
9 | VSAUFK_CN | MANDT | T000 | MANDT | KEY | 1 | CN |
10 | VSAUFK_CN | OBJNR | ONR00 | OBJNR | REF | 1 | 1 |
11 | VSAUFK_CN | PSPEL | VSPRPS_CN | VSNMR | REF | C | CN |
12 | VSAUFK_CN | REFNR | AUFK | AUFNR | REF | 1 | CN |
13 | VSAUFK_CN | SOWRK | T001W | WERKS | REF | 1 | CN |
14 | VSAUFK_CN | WAERS | TCURC | WAERS | REF | 1 | CN |
15 | VSAUFK_CN | WERKS | T001W | WERKS | REF | 1 | CN |
History
Last changed by/on | SAP | 20110908 |
SAP Release Created in |