1. Home
  2. Resources
  3. SAP Tables
  4. CIF_APOORD - Orders for APO in APO Format

SAP Table CIF_APOORD

Orders for APO in APO Format

CIF_APOORD (Orders for APO in APO Format) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link CIF_APOORD to other SAP tables.

CIF_APOORD table fields

Field Data element Checktable Datatype Length Decimals
ORDNR Order Number AUFNR CHAR 12 0
OBJECTTYPE Object Type in OLTP System CIFOBJTYPE CHAR 1 0
0 Stock
1 Purchase Requisition
2 Purchase Order/Scheduling Agreement
3 Sales Order
4 Forecast Order
5 Planned Order
6 Production Order/Network/Process Order
7 Reservation
8 New Order, Not Yet in OLTP System
9 Shipping notifications
A Confirmations for Purchase Orders
B Delivery
T Shipment
I Inspection Lot
P Network/Project Order
M Maintenance Order
ORDERGUID General Data Element for GUID Fields CIFGUID CHAR 22 0
SIMVERSION Simulation Version or Long-Term Planning Version CIFSIMVER CHAR 10 0
METHOD Method to be Executed During the Transfer of an Object CIFMETHOD CHAR 1 0
D Delete (for example a schedule line)
C Change (for example a schedule line)
N New (for example a schedule line)
R Remove total object (for example deletion of an order)
A Add, Stock is Added or Reduced
M Maintain, New or Change but not Delete
RSNUM Number of Reservation/Dependent Requirement RSNUM NUMC 10 0
PROD_PLANT Plant CIFPLANT CHAR 20 0
PROD_VER Production Version CIFPRODVER CHAR 4 0
PRODUCABLE Single-Character Indicator for Order and Operation Status CIFSTATFLG CHAR 1 0
NO_FIN_ASS Single-Character Indicator for Order and Operation Status CIFSTATFLG CHAR 1 0
INPUT_FIX Single-Character Indicator for Order and Operation Status CIFSTATFLG CHAR 1 0
OUTPUT_FIX Single-Character Indicator for Order and Operation Status CIFSTATFLG CHAR 1 0
DATE_FIXED Single-Character Indicator for Order and Operation Status CIFSTATFLG CHAR 1 0
EXPLOTIME BOM Explosion Time CIFEXPLODT DEC 15 0
STARTTIME Start Date CIFORDSTA DEC 15 0
ENDTIME End date CIFORDEND DEC 15 0
PROC_TYPE Procurement Type BESKZ CHAR 1 0
E In-house production
F External procurement
NULL No procurement
X Both procurement types
VENDOR Location CIFLOCNO CHAR 20 0
CONFIG Configuration (internal object number) CUOBJ NUMC 18 0
PRIORITY Order Priority in APO Format CIFPRIO INT1 3 0
PPMNR External PPM KEY CIFPPMKEYE CHAR 60 0
CONVERTNOW Indicator: Convert Planned Order to Production Order CIFCONVERT CHAR 1 0
LOCID Location ID CIFLOCID CHAR 22 0
CUOBJ_TYPE Category of External ID of Configuration (CUOBJ) CIFCUOBJTY CHAR 1 0
G ID Is a 32-Byte GUID
I ID Is a CUOBJ
CUOBJ_ID External Identification of CUOBJ CIFCUOBJID CHAR 32 0
EXPLODENEW Re-Explode Master Data CIFEXPLNEW CHAR 1 0
CDP_ACTIVE Characteristic Dependent Plannning Active CIFCDPACTV RAW 1 0
RELEASENOW Indicator: Release Order CIFRELNOW CHAR 1 0
PCMFLAG Order is Part of a Campaign CIFPCMFLAG CHAR 1 0
X Yes
NULL No
ATPSTATE ATP Status of an Order CIFATPSTAT CHAR 1 0
1 Order not ATP Checked
2 Order ATP Checked, not Confirmed
3 Order ATP Checked, Paritally Confirmed
4 Order ATP Checked, Completely Confirmed
CONFDATE Total Confirmation Date for Order Item from ATP CIFCNFDATE DEC 15 0
EXT_ORDNR Order Number AUFNR CHAR 12 0
STATUSREL Status: Released CIFSTATREL CHAR 1 0
NULL Undefined (No Value Set)
1 Created
2 Partially Released
3 Released
STATUSCNF Status Confirmed CIFSTATCNF CHAR 1 0
NULL Undefined (No Value Set)
1 No Confirmation Sent
2 Partially Confirmed
3 Confirmed
APOAPPL Order Application in APO CIFAPOAPPL CHAR 1 0
1 CDPS: PPDS Order
2 EOG: 'Extended Order Generation' Order
3 SNP: SNP Order
4 MOD: Modelmix Order
5 VS: Vehicle Scheduling Order
6 TMPL: 'Template PPM' Order
7 PIR: Planned Independent Requirement
8 CTP: 'Capable to Promise' Order
9 CTPE: 'Capable to Promise EOG' Order
L LPP Order
M Multi-Item Order
U Original Order for Order Combination
Z Combined Order
C CTP LPP Order
OPRSENDALL Transfer Indicator: All Relevant Objects CIFSENDALL CHAR 1 0
NULL Send Individual Relevant Objects
X Send All Relevant Objects
NODESNDALL Transfer Indicator: All Relevant Objects CIFSENDALL CHAR 1 0
NULL Send Individual Relevant Objects
X Send All Relevant Objects
SCHCH Scheduling-Relevant Change in Planned Order CIFSCHCH CHAR 1 0
X Yes
NULL No
DISVF MRP Procedure CIFDISVF CHAR 1 0
B Reorder point planning
D Material requirements planning
N No MRP
S Forecast-based planning
M Master production scheduling
R Time-phased materials planning
W Replenishment (IS Retail)
X Without MRP, with BOM explosion
UPDCNTR CIF Update Counter for Execution Objects CIFUPDCNTR NUMC 5 0
00000 Current Change Status
PLNUM Order Number AUFNR CHAR 12 0
GROUP_ID SNP Order Group ID SNPGRPID CHAR 22 0
GROUP_NO SNP Order Group Number SNPGRPNO NUMC 12 0
IS_ISSUED Status of Goods Movements IS_ISSUED INT1 3 0
0 Unknown
1 No Goods Movements Posted
2 Goods Movements Posted