0PP_GET_ORDER_DETAILS

Retrieve Order details (Header, Item & Operations) | #TRAN | Extraction method: F1 | No Delta | Component:
Tables used: AFKO, AFPO, AFVV, AFRU, CRHD ... +7 more
Column Name Description
APPLID Application ID for Manufacturing Dashboard
AUFNR Order Number
AUFPL Routing number of operations in the order
OBJNR Object number
Column Name Description
Column Name Description
📏 Base Unit of Measure (GMEIN):
GASMG Total Scrap Quantity in the Order
GAMNG Total order quantity
📏 Base Unit of Measure (MEINS_I):
PAMNG_I Fixed quantity of scrap from production
PGMNG_I Total planned order quantity
📏 Unit of measure for in-house production (AMEIN_I):
MCPAMNG_I Fixed production scrap qty in unit of in-house production
MCPGMNG_I Total planned order quantity in unit of in-house production
PSAMG_I Scrap quantity in item
PSMNG_I Order Item Quantity
WEMNG_I Quantity of goods received
IAMNG_I Actual scrap quantity from an order item
📏 Unit of measure for execution time (DFZEH_I):
S_DFZ_I Target execution time
I_DFZ_I Actual execution time
P_DLZ_I Planned lead time
S_DLZ_I Target lead time
I_DLZ_I Actual lead time
PS_FREI_I Planned/target deviation in scheduled release date
PI_FREI_I Planned/actual deviation in scheduled release date
SI_FREI_I Target/actual deviation in scheduled release date
PS_STAR_I Planned/target deviation in start date
PI_STAR_I Planned/actual deviation in scheduled start date
SI_STAR_I Target/actual schedule deviation in start date
PS_LIEF_I Planned/target deviation in scheduled delivery date
PI_LIEF_I Planned/actual deviation in scheduled delivery date
SI_LIEF_I Target/actual deviation in scheduled delivery date
📏 Unit of Measure for Capacity Requirements (KEINH_I):
KSUMS_I Total target capacity requirements
📏 Unit for execution time (exact) (DFZEXEH_I):
S_DFZ_EX_I Target execution time (exact)
I_DFZ_EX_I Actual execution time (exact)
S_DLZ_EX_I Target lead time (exact)
I_DLZ_EX_I Actual lead time (exact)
📏 Unit of measure for activity (MEINH_O):
BMSCH_O Base Quantity
MGVRG_O Operation quantity
ASVRG_O Operation Scrap Quantity
LMNGA_O Total quantity confirmed
XMNGA_O Total Scrap Quantity Confirmed
GMNGA_O Total Delivered Lot Size
RMNGA_O Total Confirmed Rework Quantity
📏 Unit of Measure for Queue Time (WRTZE_O):
WARTZ_O Queue time used for scheduling
📏 Unit of Measure for Setup Time (RSTZE_O):
RUEST_O Scheduled setup time
I_RUEST_O Actual setup time
📏 Unit of measure for processing time (BEAZE_O):
BEARZ_O Scheduled processing time
I_BEARZ_O Actual processing time
📏 Unit of Measure for Teardown (ARUZE_O):
ABRUE_O Scheduled teardown time
I_ABRUE_O Actual teardown
📏 Unit of Measure for Wait Time (LIGZE_O):
LIEGZ_O Wait Time Used for Scheduling
V_LIEGZ_O Wait Time Used for Scheduling
📏 Unit of Measure for Move Time (TRAZE_O):
TRANZ_O Move time used for scheduling
📏 Unit of Measure for Capacity Requirements (KEINH_O):
KRUES_O Scheduled cap. requirements for the op. segment "setup"
KBEAS_O Scheduled cap. requirements for the op. segment "processing"
KABRS_O Scheduled cap. requirements for the op. segment teardown
📏 Unit of measure for execution time (DFZEH_O):
S_DFZ_O Target execution time
I_DFZ_O Actual execution time
S_DLZ_O Target lead time
I_DLZ_O Actual lead time
Z_TAB_O Deviation from scheduled input date
A_TAB_O Deviation in scheduled output date
R_TAB_O Relative schedule deviation
📏 Unit of measure for standard value 1 (VGE01_O):
SMNG1_O Quantity to be confirmed for activity type 1
ZMNG1_O Target quantity of activity type 1
ZMNG1OZ_O Target quantity/activity type 1 w/o perfmnce efficiency rate
LSTEFF1_O Efficiency of activity type 1
📏 Unit of measure for standard value 2 (VGE02_O):
SMNG2_O Quantity to be confirmed for activity type 2
ZMNG2_O Target quantity of activity type 2
ZMNG2OZ_O Target quantity/activity type 2 w/o perfmnce efficiency rate
LSTEFF2_O Efficiency of activity type 2
📏 Unit of measure for standard value 3 (VGE03_O):
SMNG3_O Quantity to be confirmed for activity type 3
ZMNG3_O Target quantity of activity type 3
ZMNG3OZ_O Target quantity/activity type 3 w/o perfmnce efficiency rate
LSTEFF3_O Efficiency of activity type 3
📏 Unit of measure for standard value 4 (VGE04_O):
SMNG4_O Quantity to be confirmed for activity type 4
ZMNG4_O Target quantity of activity type 4
ZMNG4OZ_O Target quantity/activity type 4 w/o perfmnce efficiency rate
LSTEFF4_O Efficiency of activity type 4
📏 Unit of measure for standard value 5 (VGE05_O):
SMNG5_O Quantity to be confirmed for activity type 5
ZMNG5_O Target quantity of activity type 5
ZMNG5OZ_O Target quantity/activity type 5 w/o perfmnce efficiency rate
LSTEFF5_O Efficiency of activity type 4
📏 Unit of measure for standard value 6 (VGE06_O):
SMNG6_O Quantity to be confirmed for activity type 6
ZMNG6_O Target quantity of activity type 6
ZMNG6OZ_O Target quantity/activity type 6 w/o perfmnce efficiency rate
LSTEFF6_O Efficiency of activity type 6
📏 Unit of measure for 1st activity to be confirmed (ILE01_O):
ISM01_O Confirmed activity 1 - activity type
📏 Unit of measure for 2nd activity to be confirmed (ILE02_O):
ISM02_O Confirmed activity 2 - activity type
📏 Unit of measure for 3rd activity to be confirmed (ILE03_O):
ISM03_O Confirmed activity 3 - activity type
📏 Unit of measure for 4th activity to be confirmed (ILE04_O):
ISM04_O Confirmed activity 4 - activity type
📏 Unit of measure for 5th activity to be confirmed (ILE05_O):
ISM05_O Confirmed activity 5 - activity type
📏 Unit of measure for 6th activity to be confirmed (ILE06_O):
ISM06_O Confirmed activity - activity type 6
📏 Unit for execution time (exact) (DFZEXEH_O):
S_DFZ_EX_O Target execution time (exact)
I_DFZ_EX_O Actual execution time (exact)
S_DLZ_EX_O Target lead time (exact)
I_DLZ_EX_O Actual lead time (exact)
📏 Unit of Measure for Business Process Quantity (IPRE1_O):
IPRZ1_O Confirmed Quantity/Activity for Business Process
Column Name Description
ERDAT Created On
AEDAT Change Date for Order Master
GLTRP Basic finish date
GSTRP Basic start date
FTRMS Scheduled release date
GLTRS Scheduled finish
GSTRS Scheduled start
GSTRI Actual start date
GETRI Confirmed Order Finish Date
GLTRI Actual finish date
FTRMI Actual release date
FTRMP Planned Release Date
VDATU Date of update for statistics updating
GLUZS Scheduled finish time
GSUZS Scheduled Start (Time)
GSUZI Actual start time
GEUZI Confirmed Order Finish (Time)
ETRMP_I Opening Date of the Planned Order
STRMP_I Planned Order Planned Start Date
LTRMP_I Delivery Date From Planned Order
LTRMI_I Actual Delivery/Finish Date
BUDAT_I Posting date delivery/finish date, actual
SSADD_O Latest target input date
IADD_O Actual input date
FSAVD_O Earliest scheduled start: Execution (date)
SSAVD_O Latest scheduled start: Execution (date)
SSAVZ_O Latest scheduled start: Execution (time)
ISDD_O Actual Execution Start Date
ISDZ_O Actual Execution Start Time
ISAVD_O Actual Operation Start Date
FSEDD_O Earliest scheduled finish: Execution (date)
SSEDD_O Latest scheduled finish: Execution (date)
SSEDZ_O Latest scheduled finish: Execution (time)
IEDD_O Actual Execution End Date
IEDZ_O Actual Execution End Time
IEAVD_O Actual Operation End Date
N_IEAVD_O Actual end of successor operation
VDATU_O Date of update for statistics updating
BUDAT_O Posting date of last confirmation
SSADZ_O Latest target input (time of day)
IADZ_O Actual input (time of day)
Column Name Description
AUTYP Order category Show values
FA_FREI Order has status RELEASED Show values
FA_GLFT Order has status DELIVERED Show values
FA_RUECK Order has status CONFIRMED Show values
FA_TGLI Order has Status PDLV Show values
FA_TRUEC Order has status PARTIALLY CONFIRMED Show values
KAPKZ_O SFIS indicator for cumulative updating of capacity data Show values
VG_FREI_O Operation has status RELEASED Show values
VG_RUECK_O Operation has status CONFIRMED Show values
VG_TRUEC_O Operation has status PARTIALLY CONFIRMED Show values
VG_RMAN_O Operation has status RMAN Show values
Column Name Description Domain name
GRPVAR Variant Name RALDB_VARI
INDVAR Variant Name RALDB_VARI
AUART Order Type AUFART
BUKRS Company Code BUKRS
WERKS Plant WERKS
PLGRP Responsible Planner Group or Department VAGRP
DISPO MRP controller for the order DISPO
FEVOR Production Supervisor FEVOR
VERID Production Version VERID
MDV01 Production line MDVXX
MDV02 Planning identification 2 MDVXX
KUNUM Customer Number KUNNR
TERKZ Scheduling type TERART
LEAD_AUFNR Leading Order in Current Processing AUFNR
MAUFNR Number of Superior Order AUFNR
I_AUFNR_I Order Number AUFNR
POSNR_I Order item number CO_POSNR
MATNR_I Material Number MATNR
PWERK_I Planning Plant for an Order WERKS
UMREZ_I Numerator for Conversion to Base Units of Measure UMBSZ
UMREN_I Denominator for conversion to base units of measure UMBSN
PLNUM_I Planned Order PLNUM
KDAUF_I Sales Order VBELN
KDPOS_I Sales Order Item POSNR
KDEIN_I Delivery schedule for sales order NUM04
LGORT_I Storage location LGORT
SAFNR_I Run schedule header number SA_AUFNR
VERID_I Production Version VERID
SERNR_I BOM explosion number SERNR
CHARG_I Batch Number CHARG
GSBER_I Business Area GSBER
SOPNR_I Sales Operations Planning Order SAFNR
PLCHK1P_I Plausibility check: item w/o actual start CHAR1
PLCHK2P_I Plausibility Check: Actual Finish Date before Start Date CHAR1
GRUND_I Reason for Scrap CO_AGRND
PSPNR_I Production Lot (WBS Element) PS_POSNR
AUFPL_O Routing number of operations in the order AUFPL
APLZL_O Internal counter CIM_COUNT
ZAEHL_O Internal counter CIM_COUNT
PLNFL_O Sequence PLNFOLGE
VORNR_O Operation/Activity Number VORNR
ARBID_O Object ID NUM08
KAPAR_O Capacity category KAPART
KAPID_O Capacity ID KAPID
ARBPL_O Work Center ARBPL
WERKS_O Plant WERKS
STEUS_O Control key STEUS
OBJNR_O Object number J_OBJNR
UMREN_O Denominator for conversion to base units of measure UMBSN
UMREZ_O Numerator for Conversion to Base Units of Measure UMBSZ
VERTL_O Distribution function for capacity requirements VERTEILUNG
KALID_O Factory Calendar WFCID
PLCHK1V_O Plausibility check: operation without actual input CHAR1
PLCHK2V_O Plausibility Check: Actual End of Op. Before Actual Input CHAR1
PLCHK3V_O Plausibility check: invalid milestone confirmation CHAR1
UVORN_O Suboperation VORNR
ZGR01_O Target performance efficiency rate for activity type 1 PROZENT101
ZGR02_O Target performance efficiency rate for activity type 2 PROZENT101
ZGR03_O Target performance efficiency rate for activity type 3 PROZENT101
ZGR04_O Target performance efficiency rate for activity type 4 PROZENT101
ZGR05_O Target performance efficiency rate for activity type 5 PROZENT101
ZGR06_O Target performance efficiency rate for activity type 6 PROZENT101
VERAN_O Person Responsible for the Work Center AP_VERAN
PLANR_O Capacity Responsible Planner Group KAPPLANER
REFOP24_O Reference operation set REFOP24
PLNTY_O Task List Type PLNTY
VPLTY_O Task list type for reference PLNTY
PLNNR_O Key for Task List Group PLNNR
PLNKN_O Number of the Task List Node KNTNR
VPLNR_O Group of the referenced task list PLNNR
STDKN_O Node of operation within reference operation set KNTNR
LOART_O Wage type LOART
QUALF_O Suitability QUALF
LOGRP_O Wage Group LOHNGRP
GRUND_O Reason for Variance CO_AGRND
PERNR_O Personnel number PERNR
ARBII_O Actual operating resources object identification CR_OBJID
WERKSI_O Plant WERKS
ARBPLI_O Work Center ARBPL
VERANI_O Person Responsible for the Work Center AP_VERAN
RUECK_O Completion confirmation number for the operation CO_RUECK
LAR01_O 1. CO activity LSTAR
LAR02_O 2. CO activity LSTAR
LAR03_O 3. CO activity LSTAR
LAR04_O 4. CO activity LSTAR
LAR05_O 5. CO activity LSTAR
LAR06_O 6. CO activity LSTAR