SAP ABAP Table OREXT (CO order fields for external data transfer)
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 | INTTAB | Structure |
Structure | OREXT | Table Relationship Diagram |
Short Description | CO order fields for external data transfer |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
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 | AUFNR | AUFNR | AUFNR | CHAR | 12 | 0 | Order Number | * | |
2 | AUART | AUFART | AUFART | CHAR | 4 | 0 | Order Type | * | |
3 | KTEXT | AUFTEXT | TEXT40 | CHAR | 40 | 0 | Description | ||
4 | KOKRS | KOKRS | CACCD | CHAR | 4 | 0 | Controlling Area | * | |
5 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
6 | GSBER | GSBER | GSBER | CHAR | 4 | 0 | Business Area | * | |
7 | WERKS | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | * | |
8 | PRCTR | PRCTR | PRCTR | CHAR | 10 | 0 | Profit Center | * | |
9 | KOSTV | AUFKOSTV | KOSTL | CHAR | 10 | 0 | Responsible cost center | * | |
10 | POSID | PS_POSID | PS_POSID | CHAR | 24 | 0 | Work Breakdown Structure Element (WBS Element) | ||
11 | STORT | AUFSTORT | AP_STAND | CHAR | 10 | 0 | Location | * | |
12 | SOWRK | AUFSOWRK | WERKS | CHAR | 4 | 0 | Location plant | * | |
13 | ASTNR | AUFASTNR | AUFSTNR | NUMC | 2 | 0 | Order status | * | |
14 | VOGRP | AUFSPSET | VOGRP | CHAR | 4 | 0 | Group of disallowed transactions | * | |
15 | PDAT1 | AUFPDAT1 | DATUM | DATS | 8 | 0 | Planned release date | ||
16 | PDAT2 | AUFPDAT2 | DATUM | DATS | 8 | 0 | Planned completion date | ||
17 | PDAT3 | AUFPDAT3 | DATUM | DATS | 8 | 0 | Planned closing date | ||
18 | ASTKZ | AUFSTKZ | XFELD | CHAR | 1 | 0 | Identifier for statistical order | ||
19 | WAERS | AUFWAERS | WAERS | CUKY | 5 | 0 | Order Currency | * | |
20 | KALSM | AUFKALSM | KALSM | CHAR | 6 | 0 | Costing Sheet | * | |
21 | ZSCHL | AUFZSCHL | CHAR6 | CHAR | 6 | 0 | Overhead key | ||
22 | ABGSL | ABGR_SCHL | ABGR_SCHL | CHAR | 6 | 0 | Results Analysis Key | * | |
23 | AWSLS | AWSLS | AWSLS | CHAR | 6 | 0 | Variance Key | * | |
24 | ABKRS | AUFABKRS | AKREIS | NUMC | 2 | 0 | Processing group | * | |
25 | KSTAR | AUFKSTAR | KSTAR | CHAR | 10 | 0 | Settlement cost element | * | |
26 | KOSTL | AUFKOSTL | KOSTL | CHAR | 10 | 0 | Cost center for basic settlement | * | |
27 | SAKNR | AUFSAKNR | SAKNR | CHAR | 10 | 0 | G/L account for basic settlement | * | |
28 | USER0 | AUFUSER0 | AUFUSER0 | CHAR | 20 | 0 | Applicant | ||
29 | USER1 | AUFUSER1 | AUFUSER1 | CHAR | 20 | 0 | Applicant's telephone number | ||
30 | USER2 | AUFUSER2 | AUFUSER2 | CHAR | 20 | 0 | Person Responsible | ||
31 | USER3 | AUFUSER3 | AUFUSER3 | CHAR | 20 | 0 | Telephone number of person in charge | ||
32 | USER4 | CHAR14 | CHAR14 | CHAR | 14 | 0 | Text field length 14 | ||
33 | USER5 | AUFUSER5 | AUFUSER5 | DATS | 8 | 0 | Application date | ||
34 | USER6 | AUFUSER6 | AUFUSER6 | CHAR | 15 | 0 | Department | ||
35 | USER7 | AUFUSER7 | AUFUSER7 | DATS | 8 | 0 | Work Start | ||
36 | USER8 | AUFUSER8 | AUFUSER8 | DATS | 8 | 0 | End of Work | ||
37 | USER9 | AUFUSER9 | AUFUSER9 | CHAR | 1 | 0 | Identifier for work permit issued | ||
38 | VNAME | JV_NAME | JV_NAME | CHAR | 6 | 0 | Joint venture | * | |
39 | RECID | JV_RECIND | JV_RECIND | CHAR | 2 | 0 | Recovery Indicator | * | |
40 | ETYPE | JV_ETYPE | JV_ETYPE | CHAR | 3 | 0 | Equity type | * | |
41 | TXJCD | TXJCD | TXJCD | CHAR | 15 | 0 | Tax Jurisdiction | * | |
42 | JV_JIBCL | JV_JIBCL | JV_JIBCL | CHAR | 3 | 0 | JIB/JIBE Class | * | |
43 | JV_JIBSA | JV_JIBSA | JV_JIBSA | CHAR | 5 | 0 | JIB/JIBE Subclass A | * | |
44 | SCOPE | SCOPE_CV | SCOPE_CV | CHAR | 2 | 0 | Object Class | ||
45 | KDAUF | KDAUF | VBELN | CHAR | 10 | 0 | Sales Order Number | * | |
46 | KDPOS | KDPOS | NUM06 | NUMC | 6 | 0 | Item number in Sales Order | ||
47 | AUFEX | AUFEX | AUFEX | CHAR | 20 | 0 | External order number | ||
48 | IVPRO | IM_PROFIL | IM_PROFIL | CHAR | 6 | 0 | Investment measure profile | * | |
49 | AKSTL | PS_AKSTL | KOSTL | CHAR | 10 | 0 | Requesting cost center | * | |
50 | .INCLU-_1 | 0 | 0 | COBRB part for Taking Over External Settlmt Rules re Order | |||||
51 | PERBZ_1 | PERBZ_LD | PERBZ_LD | CHAR | 3 | 0 | Settlement type | ||
52 | URZUO_1 | URZUO | CO_SCZUO | CHAR | 3 | 0 | Source Assignment | * | |
53 | PROZS_1 | CHAR6 | CHAR6 | CHAR | 6 | 0 | Character field of length 6 | ||
54 | AQZIF_1 | CHAR13 | CHAR13 | CHAR | 13 | 0 | Character field 13 digits | ||
55 | BETRR_1 | CHAR21 | CHAR21 | CHAR | 21 | 0 | Field Name | ||
56 | KONTY_1 | KONTY | J_OBART_LD | CHAR | 2 | 0 | Account assignment category | ||
57 | GSBER_1 | GSBER | GSBER | CHAR | 4 | 0 | Business Area | * | |
58 | BUKRS_1 | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
59 | HKONT_1 | SAKNR | SAKNR | CHAR | 10 | 0 | G/L Account Number | * | |
60 | PRCTR_1 | PRCTR | PRCTR | CHAR | 10 | 0 | Profit Center | * | |
61 | KOSTL_1 | BRGKOSTL | KOSTL | CHAR | 10 | 0 | Receiver cost center | * | |
62 | AUFNR_1 | AUFNR | AUFNR | CHAR | 12 | 0 | Order Number | * | |
63 | POSID_1 | PS_POSID | PS_POSID | CHAR | 24 | 0 | Work Breakdown Structure Element (WBS Element) | ||
64 | ANLN1_1 | ANLN1 | ANLN1 | CHAR | 12 | 0 | Main Asset Number | * | |
65 | ANLN2_1 | ANLN2 | ANLN2 | CHAR | 4 | 0 | Asset Subnumber | * | |
66 | NPLNR_1 | NPLNR | AUFNR | CHAR | 12 | 0 | Network Number for Account Assignment | * | |
67 | VORNR_1 | VORNR | VORNR | CHAR | 4 | 0 | Operation/Activity Number | ||
68 | KDAUF_1 | KDAUF | VBELN | CHAR | 10 | 0 | Sales Order Number | * | |
69 | KDPOS_1 | KDPOS | NUM06 | NUMC | 6 | 0 | Item number in Sales Order | ||
70 | KSTRG_1 | KSTRG | KSTRG | CHAR | 12 | 0 | Cost Object | * | |
71 | PRZNR_1 | CO_PRZNR | CO_PRZNR | CHAR | 12 | 0 | Business Process | * | |
72 | .INCLU-_2 | 0 | 0 | COBRB part for Taking Over External Settlmt Rules re Order | |||||
73 | PERBZ_2 | PERBZ_LD | PERBZ_LD | CHAR | 3 | 0 | Settlement type | ||
74 | URZUO_2 | URZUO | CO_SCZUO | CHAR | 3 | 0 | Source Assignment | * | |
75 | PROZS_2 | CHAR6 | CHAR6 | CHAR | 6 | 0 | Character field of length 6 | ||
76 | AQZIF_2 | CHAR13 | CHAR13 | CHAR | 13 | 0 | Character field 13 digits | ||
77 | BETRR_2 | CHAR21 | CHAR21 | CHAR | 21 | 0 | Field Name | ||
78 | KONTY_2 | KONTY | J_OBART_LD | CHAR | 2 | 0 | Account assignment category | ||
79 | GSBER_2 | GSBER | GSBER | CHAR | 4 | 0 | Business Area | * | |
80 | BUKRS_2 | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
81 | HKONT_2 | SAKNR | SAKNR | CHAR | 10 | 0 | G/L Account Number | * | |
82 | PRCTR_2 | PRCTR | PRCTR | CHAR | 10 | 0 | Profit Center | * | |
83 | KOSTL_2 | BRGKOSTL | KOSTL | CHAR | 10 | 0 | Receiver cost center | * | |
84 | AUFNR_2 | AUFNR | AUFNR | CHAR | 12 | 0 | Order Number | * | |
85 | POSID_2 | PS_POSID | PS_POSID | CHAR | 24 | 0 | Work Breakdown Structure Element (WBS Element) | ||
86 | ANLN1_2 | ANLN1 | ANLN1 | CHAR | 12 | 0 | Main Asset Number | * | |
87 | ANLN2_2 | ANLN2 | ANLN2 | CHAR | 4 | 0 | Asset Subnumber | * | |
88 | NPLNR_2 | NPLNR | AUFNR | CHAR | 12 | 0 | Network Number for Account Assignment | * | |
89 | VORNR_2 | VORNR | VORNR | CHAR | 4 | 0 | Operation/Activity Number | ||
90 | KDAUF_2 | KDAUF | VBELN | CHAR | 10 | 0 | Sales Order Number | * | |
91 | KDPOS_2 | KDPOS | NUM06 | NUMC | 6 | 0 | Item number in Sales Order | ||
92 | KSTRG_2 | KSTRG | KSTRG | CHAR | 12 | 0 | Cost Object | * | |
93 | PRZNR_2 | CO_PRZNR | CO_PRZNR | CHAR | 12 | 0 | Business Process | * | |
94 | .INCLU-_3 | 0 | 0 | COBRB part for Taking Over External Settlmt Rules re Order | |||||
95 | PERBZ_3 | PERBZ_LD | PERBZ_LD | CHAR | 3 | 0 | Settlement type | ||
96 | URZUO_3 | URZUO | CO_SCZUO | CHAR | 3 | 0 | Source Assignment | * | |
97 | PROZS_3 | CHAR6 | CHAR6 | CHAR | 6 | 0 | Character field of length 6 | ||
98 | AQZIF_3 | CHAR13 | CHAR13 | CHAR | 13 | 0 | Character field 13 digits | ||
99 | BETRR_3 | CHAR21 | CHAR21 | CHAR | 21 | 0 | Field Name | ||
100 | KONTY_3 | KONTY | J_OBART_LD | CHAR | 2 | 0 | Account assignment category | ||
101 | GSBER_3 | GSBER | GSBER | CHAR | 4 | 0 | Business Area | * | |
102 | BUKRS_3 | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
103 | HKONT_3 | SAKNR | SAKNR | CHAR | 10 | 0 | G/L Account Number | * | |
104 | PRCTR_3 | PRCTR | PRCTR | CHAR | 10 | 0 | Profit Center | * | |
105 | KOSTL_3 | BRGKOSTL | KOSTL | CHAR | 10 | 0 | Receiver cost center | * | |
106 | AUFNR_3 | AUFNR | AUFNR | CHAR | 12 | 0 | Order Number | * | |
107 | POSID_3 | PS_POSID | PS_POSID | CHAR | 24 | 0 | Work Breakdown Structure Element (WBS Element) | ||
108 | ANLN1_3 | ANLN1 | ANLN1 | CHAR | 12 | 0 | Main Asset Number | * | |
109 | ANLN2_3 | ANLN2 | ANLN2 | CHAR | 4 | 0 | Asset Subnumber | * | |
110 | NPLNR_3 | NPLNR | AUFNR | CHAR | 12 | 0 | Network Number for Account Assignment | * | |
111 | VORNR_3 | VORNR | VORNR | CHAR | 4 | 0 | Operation/Activity Number | ||
112 | KDAUF_3 | KDAUF | VBELN | CHAR | 10 | 0 | Sales Order Number | * | |
113 | KDPOS_3 | KDPOS | NUM06 | NUMC | 6 | 0 | Item number in Sales Order | ||
114 | KSTRG_3 | KSTRG | KSTRG | CHAR | 12 | 0 | Cost Object | * | |
115 | PRZNR_3 | CO_PRZNR | CO_PRZNR | CHAR | 12 | 0 | Business Process | * | |
116 | .INCLUDE | 0 | 0 | ||||||
117 | ABUKR | IM_ABUKRS | BUKRS | CHAR | 4 | 0 | Requesting company code | * | |
118 | SIZECL | IM_SIZECL | SIZECL | CHAR | 2 | 0 | Scale of investment objects | * | |
119 | IZWEK | IZWEK | IZWEK | CHAR | 2 | 0 | Reason for investment | * | |
120 | UMWKZ | AM_UMWKZ | AM_UMWKZ | CHAR | 5 | 0 | Reason for environmental investment | * | |
121 | CYCLE | ST_KOSTL | KOSTL | CHAR | 10 | 0 | Cost center to which costs are actually posted | * | |
122 | PLINT | PLINT | XFELD | CHAR | 1 | 0 | Indicator for Integrated Planning | ||
123 | ZSCHM | PS_ZSCHM | PS_ZSCHM | CHAR | 7 | 0 | Interest Profile for Project/Order Interest Calculation | * | |
124 | OTYPE | JV_OTYPE | JV_OTYPE | CHAR | 4 | 0 | Joint Venture Object Type | ||
125 | JV_OCO | JV_OR_CO | JV_OR_COB | CHAR | 1 | 0 | JV original cost object | ||
126 | ANFAUFNR | AUFANFNR | AUFNR | CHAR | 12 | 0 | Requesting order | * | |
127 | FUNC_AREA | FKBER | FKBER | CHAR | 16 | 0 | Functional Area | * | |
128 | CSTG_VRNT | CK_KLVAR | KLVAR | CHAR | 4 | 0 | Costing Variant | * | |
129 | VERAA_USER | VERAA_USER | XUBNAME | CHAR | 12 | 0 | Person Responsible for CO Internal Order | USR02 |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | OREXT | VERAA_USER | USR02 | BNAME |
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in |