SAP table ORDCOM (Communication control Operation download)
SAP table ORDCOM has 3 primary key fields being MANDT,AUFPL,APLZL.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
Field
Description
Data Type
Length
Decimals
Checktable
Data Element
Client
CLNT
3
0
T000
MANDT
Routing number of operations in the order
NUMC
10
0
CO_AUFPL
General counter for order
NUMC
8
0
AFVC
CO_APLZL
VBKZ
Update indicator
CHAR
1
0
VBKZ
AUTYP
Order category
NUMC
2
0
AUFTYP
Possible values
01
Internal Order (Controlling)
02
Accrual Calculation Order (Controlling)
03
Model Order (Controlling)
04
CO Production Order
05
Product Cost Collector
06
QM Order
10
PP Production Order
20
Network
30
Maintenance order
40
Process Order
50
Inspection Lot
60
Personnel Order
70
Shipping deadlines
99
Master Planned order
AUFNR
Order Number
CHAR
12
0
*
AUFNR
APLFL
Sequence
CHAR
6
0
PLNFOLGE
VORNR
Operation/Activity Number
CHAR
4
0
VORNR
UVORN
Suboperation
CHAR
4
0
UVORN
WERKS
Plant
CHAR
4
0
*
WERKS_D
ARBPL
Work Center
CHAR
8
0
ARBPL
ERTSTAMPS
UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
DEC
15
0
TZNTSTMPS
RUECK
Completion confirmation number for the operation
NUMC
10
0
CO_RUECK
ORDCOM foreign key relationships
Table
Field
Check Table
Check Field
0 ORDCOM
APLZL
AFVC Operation within an order
AUFPL
0 ORDCOM
APLZL
AFVC Operation within an order
APLZL
1 ORDCOM
MANDT
T000 Clients
MANDT