SAP ABAP Table AUFKKI (PSIS - Individual Overviews: Orders)
Hierarchy
SAP_APPL (Software Component) Logistics and Accounting
   PS-IS-REP-LOG (Application Component) Logistics
     PSIS_SINGLE (Package) PS Logistic Overview: Single Overview'
Basic Data
Table Category INTTAB    Structure 
Structure AUFKKI   Table Relationship Diagram
Short Description PSIS - Individual Overviews: Orders    
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 .INCLUDE       0   0   Order Master Data Structure for Project Reporting  
2 ARNUMMER ADMI_RUN_D ADMI_RUN CHAR 6   0   Archiving Session Number  
3 VSGRUPPE VSGRUPPE TEXT20 CHAR 20   0   Group for a project version  
4 VSNUMMER VSNMR VSNMR CHAR 12   0   Number or description of a version  
5 PRCTR PRCTR PRCTR CHAR 10   0   Profit Center CEPC
6 PRNAM IM_PRNAM IM_PRNAM CHAR 8   0   Investment program name IMTP
7 PRPOS IM_POSID IM_POSID CHAR 24   0   Identification for an investment program position  
8 PSPID PS_PSPID PS_PSPID CHAR 24   0   Project definition  
9 POSID PS_POSID PS_POSID CHAR 24   0   Work Breakdown Structure Element (WBS Element)  
10 KDAUF VBELN_VA VBELN CHAR 10   0   Sales Document VBUK
11 KDPOS POSNR_VA POSNR NUMC 6   0   Sales Document Item VBUP
12 AUFNR AUFNR AUFNR CHAR 12   0   Order Number *
13 AUART AUFART AUFART CHAR 4   0   Order Type T003O
14 AUARTTXT AUART_BEZ TEXT20 CHAR 20   0   Description of sales order type  
15 AUTYPTXT AUTYPTEXT TEXT40 CHAR 40   0   Display field for order category description  
16 REFNR AUFREFNR AUFNR CHAR 12   0   Reference order number AUFK
17 KTEXT AUFTEXT TEXT40 CHAR 40   0   Description  
18 TXTKZ AUFLTEXT XFELD CHAR 1   0   Long Text Exists  
19 LTEXT AUFLTEXT XFELD CHAR 1   0   Long Text Exists  
20 BUKRS BUKRS BUKRS CHAR 4   0   Company Code T001
21 WERKS WERKS_D WERKS CHAR 4   0   Plant T001W
22 GSBER GSBER GSBER CHAR 4   0   Business Area TGSB
23 KOKRS KOKRS CACCD CHAR 4   0   Controlling Area TKA01
24 KOSTV AUFKOSTV KOSTL CHAR 10   0   Responsible cost center CSKS
25 WAERS WAERS WAERS CUKY 5   0   Currency Key TCURC
26 KALSM AUFKALSM KALSM CHAR 6   0   Costing Sheet T683
27 ZSCHL AUFZSCHL CHAR6 CHAR 6   0   Overhead key  
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 AUFUSER4 AUFUSER4 CURR 11   2   Estimated total costs of order  
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 AWSLS AWSLS AWSLS CHAR 6   0   Variance Key TKV01
39 ABGSL ABGR_SCHL ABGR_SCHL CHAR 6   0   Results Analysis Key TKKAA
40 TXJCD TXJCD TXJCD CHAR 15   0   Tax Jurisdiction TTXJ
41 SCOPE SCOPE_CV SCOPE_CV CHAR 2   0   Object Class  
42 AENNR AENNR AENNR CHAR 12   0   Change Number AENR
43 AUFEX AUFEX AUFEX CHAR 20   0   External order number  
44 FLG_MLTPS CO_MLTPS KREUZ CHAR 1   0   Order with multiple items  
45 AKSTL PS_AKSTL KOSTL CHAR 10   0   Requesting cost center CSKS
46 GLTRP CO_GLTRP DATUM DATS 8   0   Basic finish date  
47 GSTRP CO_GSTRP DATUM DATS 8   0   Basic start date  
48 FTRMS CO_FTRMS DATUM DATS 8   0   Scheduled release date  
49 GLTRS CO_GLTRS DATUM DATS 8   0   Scheduled finish  
50 GSTRS CO_GSTRS DATUM DATS 8   0   Scheduled start  
51 GSTRI CO_GSTRI DATUM DATS 8   0   Actual start date  
52 GETRI CO_GETRI DATUM DATS 8   0   Confirmed Order Finish Date  
53 GLTRI CO_GLTRI DATUM DATS 8   0   Actual finish date  
54 FTRMI CO_FTRMI DATUM DATS 8   0   Actual release date  
55 FTRMP CO_FTRMP DATUM DATS 8   0   Planned release date  
56 RSNUM RSNUM RSNUM NUMC 10   0   Number of reservation/dependent requirements RESB
57 GASMG GASMG MENG13 QUAN 13   3   Total scrap quantity in the order  
58 GAMNG GAMNG MENG13 QUAN 13   3   Total order quantity  
59 GMEIN MEINS MEINS UNIT 3   0   Base Unit of Measure T006
60 PLNBEZ MATNR MATNR CHAR 18   0   Material Number MARA
61 PLNTY PLNTY PLNTY CHAR 1   0   Task List Type TCA01
62 PLNNR PLNNR PLNNR CHAR 8   0   Key for Task List Group  
63 PLNAL PLNAL ALTNR CHAR 2   0   Group Counter  
64 PLSVB LOSGRBIS MENG13 QUAN 13   3   To lot size  
65 PLNME PLNME MEINS UNIT 3   0   Task list unit of measure T006
66 PLSVN LOSGRVON MENG13 QUAN 13   3   From Lot Size  
67 PDATV DATUV DATUM DATS 8   0   Valid-From Date  
68 PAENR AENNR AENNR CHAR 12   0   Change Number AENR
69 PLGRP VAGRP VAGRP CHAR 3   0   Responsible planner group/department T024A
70 STLTY STLTY STLTY CHAR 1   0   BOM Category  
71 STLBEZ MATNR MATNR CHAR 18   0   Material Number MARA
72 STLST STLST STLST NUMC 2   0   BOM Statuses T415S
73 STLNR STNUM STNUM CHAR 8   0   Bill of Material  
74 SDATV DATUV DATUM DATS 8   0   Valid-From Date  
75 SBMNG BASMN MENG13 QUAN 13   3   Base quantity  
76 SBMEH MEINS MEINS UNIT 3   0   Base Unit of Measure T006
77 SAENR AENNR AENNR CHAR 12   0   Change Number AENR
78 STLAL STALT ALTNR CHAR 2   0   Alternative BOM  
79 STLAN STLAN STLAN CHAR 1   0   BOM Usage T416
80 SLSVN LOSVN MENG13 QUAN 13   3   From Lot Size  
81 SLSBS LOSBS MENG13 QUAN 13   3   To Lot Size  
82 AUFLD CO_AUFLD DATUM DATS 8   0   Date of BOM Explosion/Routing Transfer  
83 DISPO CO_DISPO DISPO CHAR 3   0   MRP controller for the order T024D
84 DSNAM DSNAM TEXT18 CHAR 18   0   Name of MRP controller  
85 FEVOR FEVOR FEVOR CHAR 3   0   Production Supervisor T024F
86 FHORI FHORI FHORI CHAR 3   0   Scheduling Margin Key for Floats T436A
87 TERKZ TERMKZ TERART CHAR 1   0   Scheduling type T482
88 REDKZ REDKZ REDKZ CHAR 1   0   Reduction indicator for scheduling  
89 APRIO CO_APRIO CHAR1 CHAR 1   0   Order priority  
90 VORGZ VORGZ NUM3 NUMC 3   0   Float before production (in days)  
91 SICHZ SICHZ NUM3 NUMC 3   0   Float after production (in days)  
92 FREIZ FREIZ NUM3 NUMC 3   0   Release period (in days)  
93 KLVARP KALKVARPLN KLVAR CHAR 4   0   Costing variant for planned costs TCK03
94 KLVARI KALKVARIST KLVAR CHAR 4   0   Costing variant for actual costs TCK03
95 GLTPP CO_GLTPP DATUM DATS 8   0   Finish date (forecast)  
96 GSTPP CO_GSTPP DATUM DATS 8   0   Forecast start date  
97 GLTPS CO_GLTPS DATUM DATS 8   0   Scheduled forecast finish  
98 GSTPS CO_GSTPS DATUM DATS 8   0   Scheduled forecast start  
99 FTRPS CO_FTRPS DATUM DATS 8   0   Scheduled release date (forecast)  
100 RDKZP REDKZP REDKZ CHAR 1   0   Reduction indicator for scheduling (forecast)  
101 TRKZP TERMKZP TERART CHAR 1   0   Scheduling type (forecast) T482
102 GLUZS CO_GLUZS UHRZT TIMS 6   0   Scheduled finish time  
103 GSUZS CO_GSUZS ATIME TIMS 6   0   Scheduled Start (Time)  
104 AUTERM CO_AUTERM KREUZ CHAR 1   0   Indicator: Schedule automatically  
105 AUCOST CO_AUCOST KREUZ CHAR 1   0   Indicator: Cost automatically  
106 AUDISP AUDISP XFELD CHAR 1   0   Ind: Reservation applicable to MRP;Purc. req. is created  
107 STUFE HISTU DEC2 DEC 2   0   Level (in Multi-Level BOM Explosions)  
108 WEGXX WEGXX DEC4 DEC 4   0   Path (for Multi-Level BOM Explosions)  
109 VWEGX WEGXX DEC4 DEC 4   0   Path (for Multi-Level BOM Explosions)  
110 MAUFNR MAUFNR AUFNR CHAR 12   0   Number of superior order AUFK
111 PRODNET CO_PRODNET KREUZ CHAR 1   0   Indicator: Order is part of collective order  
112 IASMG CO_IASMG MENG13 QUAN 13   3   Scrap confirmed for order  
113 ABARB CO_ABARB CO_ABARB NUMC 3   0   Confirmation: Degree of processing  
114 AUFNT CO_TEILNET AUFNR CHAR 12   0   Number of superior network AUFK
115 VORNT CN_VORNRT VORNR CHAR 4   0   Activity number replaced by sub-network  
116 BREAKS BREAKS XFELD CHAR 1   0   Indicator: Scheduling allowing for breaks  
117 VORGZ_TRM VORGZ_TRM PUFFER_TRM DEC 6   3   Scheduled float before production in days  
118 SICHZ_TRM SICHZ_TRM PUFFER_TRM DEC 6   3   Scheduled float after production in days  
119 TRMDT TRMDT DATUM DATS 8   0   Date of the last scheduling  
120 GLUZP CO_GLUZP UHRZT TIMS 6   0   Basic finish (time)  
121 GSUZP CO_GSUZP UHRZT TIMS 6   0   Basic start time  
122 GSUZI CO_GSUZI UHRZT TIMS 6   0   Actual start time  
123 GEUZI CO_GEUZI UHRZT TIMS 6   0   Confirmed order finish (time)  
124 GLUPP CO_GLUPP UHRZT TIMS 6   0   Forecast finish (time)  
125 GSUPP CO_GSUPP UHRZT TIMS 6   0   Forecast start (time)  
126 GLUPS CO_GLUPS UHRZT TIMS 6   0   Scheduled forecast finish time  
127 GSUPS CO_GSUPS UHRZT TIMS 6   0   Scheduled start time (Forecast)  
128 CHSCH KALSMA_CH KALSM CHAR 6   0   Search procedure for batch determination T683
129 KAPT_VORGZ KAPT_VORGZ NUM3 NUMC 3   0   Float (bef. production) remaining after finite scheduling  
130 KAPT_SICHZ KAPT_SICHZ NUM3 NUMC 3   0   Remaining float after finite scheduling  
131 LEAD_AUFNR CO_LAUFNR AUFNR CHAR 12   0   Leading order in current processing AUFK
132 PNETSTARTD CO_PSTARTD DATUM DATS 8   0   Outline start of collective network (date)  
133 PNETSTARTT CO_PSTARTT ATIME TIMS 6   0   Start time of a collective order  
134 PNETENDD CO_PENDD DATUM DATS 8   0   Outline finish of collective order (date)  
135 PNETENDT CO_PENDT ATIME TIMS 6   0   Outline finish time  
136 AUKBED AUKBED XFELD CHAR 1   0   Indicator: Calculate capacity requirements  
137 STRMP CO_STRMP DATUM DATS 8   0   Start date of the planned order  
138 ETRMP CO_ETRMP DATUM DATS 8   0   Opening date of the planned order  
139 KDEIN KDEIN NUM04 NUMC 4   0   Delivery schedule for sales order  
140 WEMNG CO_WEMNG MENG13 QUAN 13   3   Quantity of goods received for the order item  
141 IAMNG CO_IAMNG MENG13V QUAN 13   3   Expected surplus/deficit for goods receipt  
142 AMEIN CO_AUFME MEINS UNIT 3   0   Unit of measure for in-house production T006
143 MEINS LAGME MEINS UNIT 3   0   Base Unit of Measure T006
144 MATNR CO_MATNR MATNR CHAR 18   0   Material Number for Order MARA
145 MTEXT PS_MATTEXT TEXT40 CHAR 40   0   Material description  
146 PAMNG AVMNG MENG13 QUAN 13   3   Fixed quantity of scrap from production  
147 PGMNG GSMNG MENG13 QUAN 13   3   Total planned order quantity  
148 LTRMI CO_LTRMI DATUM DATS 8   0   Actual delivery/finish date  
149 LTRMP CO_LTRMP DATUM DATS 8   0   Delivery date from planned order  
150 KALNR CK_KALNR CK_KALNR NUMC 12   0   Cost Estimate Number for Cost Est. w/o Qty Structure CKHS
151 UEBTO UEBTO PRZ21 DEC 3   1   Overdelivery Tolerance Limit  
152 UEBTK UEBTK XFELD CHAR 1   0   Indicator: Unlimited Overdelivery Allowed  
153 UNTTO UNTTO PRZ21 DEC 3   1   Underdelivery Tolerance Limit  
154 INSMK INSMK INSMK CHAR 1   0   Stock Type  
155 WEPOS WEPOS XFELD CHAR 1   0   Goods Receipt Indicator  
156 BWTAR BWTAR_D BWTAR CHAR 10   0   Valuation type T149D
157 PWERK CO_PWERK WERKS CHAR 4   0   Planning plant for the order T001W
158 LGORT LGORT_D LGORT CHAR 4   0   Storage location T001L
159 VERTO SA_VERTL SA_VERTL CHAR 4   0   MRP Distribution Key T437V
160 WEBAZ PLWEZ DEC3 DEC 3   0   Goods receipt processing time in days  
161 ELIKZ ELIKZ XFELD CHAR 1   0   "Delivery Completed" Indicator  
162 SERNR SERNR SERNR CHAR 8   0   BOM explosion number SNUM
163 WEUNB WEUNB XFELD CHAR 1   0   Goods Receipt, Non-Valuated  
164 ABLAD ABLAD TEXT25 CHAR 25   0   Unloading Point  
165 WEMPF WEMPF WEMPF CHAR 12   0   Goods recipient  
166 CHARG CHARG_D CHARG CHAR 10   0   Batch Number MCHA
167 STATXT STATUSTEXT_2 CHAR80 CHAR 80   0   Edited status text  
168 FRUEHER FRUEHER_2 DAUER_9_1 QUAN 10   1   Actual start is before earliest scheduled start  
169 SPAETER SPAETER_2 DAUER_9_1 QUAN 10   1   Actual Finish/Planned Finish After Latest Scheduled Finish  
170 VERZUG VERZUG_2 DAUER_9_1 QUAN 10   1   Duration After Latest Scheduled Finish  
171 VORBEI VORBEI_2 DAUER_9_1 QUAN 10   1   Duration After Earliest Scheduled Start  
172 VEINH VERZ_EINHT MEINS UNIT 3   0   Unit for Duration of the Delay T006
173 PSPNR PS_PSP_PRO PS_PSPNR NUMC 8   0   Project definition *
174 AUFNR_INT AUFNR AUFNR CHAR 12   0   Order Number *
175 AUTYP AUFTYP AUFTYP NUMC 2   0   Order category  
176 KALID FABKL WFCID CHAR 2   0   Factory calendar key *
177 EDAUER PS_EDAUER DAUER_4_1 QUAN 5   1   Duration  
178 EDAUEH PS_DAUEH MEINS UNIT 3   0   Actual duration unit *
179 PDAUER PS_PDAUER DAUER_4_1 QUAN 5   1   Forecast duration  
180 PDAUEH PS_DAUEH MEINS UNIT 3   0   Actual duration unit *
181 IDAUER PS_IDAUER DAUER_4_1 QUAN 5   1   Actual duration  
182 IDAUEH PS_DAUEH MEINS UNIT 3   0   Actual duration unit *
183 OBJNR J_OBJNR J_OBJNR CHAR 22   0   Object number *
184 INT_ID OBJEKT_ID CHAR30 CHAR 30   0   ID/Object key  
185 LOEKZ LOEVM XFELD CHAR 1   0   Deletion Indicator  
186 LIGHT LVC_EXLED CHAR1 CHAR 1   0   ALV control: Exception as LED  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 AUFKKI ABGSL TKKAA ABGSL REF C CN
2 AUFKKI AENNR AENR AENNR    
3 AUFKKI AKSTL CSKS KOSTL REF C CN
4 AUFKKI AMEIN T006 MSEHI REF C CN
5 AUFKKI AUART T003O AUART REF 1 CN
6 AUFKKI AUFNT AUFK AUFNR REF C CN
7 AUFKKI AWSLS TKV01 AWSLS REF C CN
8 AUFKKI BUKRS T001 BUKRS REF 1 CN
9 AUFKKI BWTAR T149D BWTAR REF C CN
10 AUFKKI CHARG MCHA CHARG REF C CN
11 AUFKKI CHSCH T683 KALSM REF C CN
12 AUFKKI DISPO T024D DISPO REF C CN
13 AUFKKI FEVOR T024F FEVOR REF C CN
14 AUFKKI FHORI T436A FHORI REF C CN
15 AUFKKI GMEIN T006 MSEHI REF C CN
16 AUFKKI GSBER TGSB GSBER REF C CN
17 AUFKKI KALNR CKHS KALNR REF C CN
18 AUFKKI KALSM T683 KALSM REF 1 CN
19 AUFKKI KDAUF VBUK VBELN    
20 AUFKKI KDPOS VBUP POSNR REF C CN
21 AUFKKI KLVARI TCK03 KLVAR REF C CN
22 AUFKKI KLVARP TCK03 KLVAR REF C CN
23 AUFKKI KOKRS TKA01 KOKRS REF C CN
24 AUFKKI KOSTV CSKS KOSTL REF C CN
25 AUFKKI LEAD_AUFNR AUFK AUFNR REF C CN
26 AUFKKI LGORT T001L LGORT REF C CN
27 AUFKKI MATNR MARA MATNR REF C CN
28 AUFKKI MAUFNR AUFK AUFNR REF C CN
29 AUFKKI MEINS T006 MSEHI REF C CN
30 AUFKKI PAENR AENR AENNR REF C CN
31 AUFKKI PLGRP T024A FEVOR REF C CN
32 AUFKKI PLNBEZ MARA MATNR REF C CN
33 AUFKKI PLNME T006 MSEHI REF C CN
34 AUFKKI PLNTY TCA01 PLNTY REF 1 CN
35 AUFKKI PRCTR CEPC PRCTR REF C CN
36 AUFKKI PRNAM IMTP PRNAM   CN
37 AUFKKI PWERK T001W WERKS REF C CN
38 AUFKKI REFNR AUFK AUFNR REF C CN
39 AUFKKI RSNUM RESB RSNUM REF C CN
40 AUFKKI SAENR AENR AENNR REF C CN
41 AUFKKI SBMEH T006 MSEHI REF C CN
42 AUFKKI SERNR SNUM SERNR REF C CN
43 AUFKKI STLAN T416 STLAN REF C CN
44 AUFKKI STLBEZ MARA MATNR REF C CN
45 AUFKKI STLST T415S STLST REF C CN
46 AUFKKI TERKZ T482 TERMKZ REF C CN
47 AUFKKI TRKZP T482 TERMKZ REF C CN
48 AUFKKI TXJCD TTXJ TXJCD REF C CN
49 AUFKKI VEINH T006 MSEHI REF C CN
50 AUFKKI VERTO T437V VERTL REF C CN
51 AUFKKI WAERS TCURC WAERS REF 1 CN
52 AUFKKI WERKS T001W WERKS REF C CN
History
Last changed by/on SAP  20130529 
SAP Release Created in 50A