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