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
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