I_OrderConfirmation

Order Confirmation | view: IORDERCONF | ATTR | Extraction: Not supported | Component: Virtual Data Model in PP
Tables used: AFRU, AFVV, AUFK
Column Name Description
ConfirmationGroup Collective ID of Order Confirmations
OrderConfirmation Identifier of Single Order Confirmation
Column Name Description
Column Name Description
📏 Confirmation Unit of Measure (ConfirmationUnit):
ConfirmationYieldQuantity Yield to be Confirmed
ConfirmationScrapQuantity Scrap to Be Confirmed
ConfirmationReworkQuantity Current Confirmation Rework Quantity
ConfirmationTotalQuantity Total Quantity From Confirmation
📏 Order Unit of Measure (OrderQuantityUnit):
ConfirmedYieldQtyInOrderUnit Confirmed Yield Quantity in Order Unit of Measure
📏 Operation Unit of Measure (OperationUnit):
OpPlannedTotalQuantity Operation Total Quantity
📏 Unit of Measure for Confirmed Work Quantity 1 (OpWorkQuantityUnit1):
OpConfirmedWorkQuantity1 Already Confirmed Work Quantity (Activity) 1
📏 Unit of Measure for Confirmed Work Quantity 2 (OpWorkQuantityUnit2):
OpConfirmedWorkQuantity2 Already Confirmed Work Quantity (Activity) 2
📏 Unit of Measure for Confirmed Work Quantity 3 (OpWorkQuantityUnit3):
OpConfirmedWorkQuantity3 Already Confirmed Work Quantity (Activity) 3
📏 Unit of Measure for Confirmed Work Quantity 4 (OpWorkQuantityUnit4):
OpConfirmedWorkQuantity4 Already Confirmed Work Quantity (Activity) 4
📏 Unit of Measure for Confirmed Work Quantity 5 (OpWorkQuantityUnit5):
OpConfirmedWorkQuantity5 Already Confirmed Work Quantity (Activity) 5
📏 Unit of Measure for Confirmed Work Quantity 6 (OpWorkQuantityUnit6):
OpConfirmedWorkQuantity6 Already Confirmed Work Quantity (Activity) 6
📏 Unit for work (ActualWorkQuantityUnit):
ActualWorkQuantity Actual work
📏 Unit of Measure for Remaining Work (RemainingWorkQuantityUnit):
RemainingWorkQuantity Remaining work
📏 Unit of Measure for Business Process Quantity (BusinessProcessEntryUnit):
BusinessProcessConfirmedQty Current Quantity for Business Process
📏 Unit for Remaining Quantity of Business Process (BusinessProcRemainingQtyUnit):
BusinessProcessRemainingQty Remaining Quantity for Business Process
📏 Unit for a Break Time (BreakDurationUnit):
ActualDuration Actual Duration for Confirmation
ConfirmedBreakDuration Confirmed Break Time
Column Name Description
ConfirmationEntryDate Entry Date of Confirmation
ConfirmationEntryTime Confirmation Entry Time
LastChangeDate Date of Last Change
ConfirmationExternalEntryDate External date of entry for confirmation
ConfirmationExternalEntryTime External time of entry for confirmation
PostingDate Posting Date
ConfirmedExecutionStartDate Confirmed Start Date of Execution
ConfirmedExecutionStartTime Confirmed Start Time of Execution
ConfirmedSetupEndDate Confirmed End Date of Setup
ConfirmedSetupEndTime Confirmed End Time of Setup
ConfirmedProcessingStartDate Confirmed Start Date of Processing
ConfirmedProcessingStartTime Confirmed Start Time of Processing
ConfirmedProcessingEndDate Confirmed End Date of Processing
ConfirmedProcessingEndTime Confirmed End Time of Processing
ConfirmedTeardownStartDate Confirmed Start Date of Teardown
ConfirmedTeardownStartTime Confirmed Start Time of Teardown
ConfirmedExecutionEndDate Confirmed End Date of Execution
ConfirmedExecutionEndTime Confirmed End Time of Execution
ActualForecastEndDate Actual Forecast End Date
ActualForecastEndTime Actual Forecast End Time
Column Name Description
OrderCategory Order Category Show values
LongTextExists Long Text Exists Show values
FinalConfirmationType Final Confirmation Type Show values
IsFinalConfirmation Activation of Final Confirmation Show values
OpenReservationsIsCleared Clear Open Reservations Show values
IsReversed Indicator: Document was reversed Show values
IsReversal Confirmation record is a Cancellation Show values
IsConfirmedByMilestoneConf Confirmation was created by Milestone Confirmation Show values
MilestoneIsConfirmed Indicator: Milestone Confirmation Carried Out Show values
APIConfHasNoGoodsMovements Confirmation: No Goods Movement via API Show values
ConfirmationApplicationOrigin Origin Code: Confirmation Application Show values
OrderConfirmationType Indicator for Type of Confirmation Show values
OrderConfirmationRecordType Record Type for Confirmation Show values
WorkCenterTypeCode Object Type of the Resource Show values
NoFurtherOpWorkQuantity1IsExpd Indicator: No Remaining Work Quantity 1 is Expected Show values
NoFurtherOpWorkQuantity2IsExpd Indicator: No Remaining Work Quantity 2 is Expected Show values
NoFurtherOpWorkQuantity3IsExpd Indicator: No Remaining Work Quantity 3 is Expected Show values
NoFurtherOpWorkQuantity4IsExpd Indicator: No Remaining Work Quantity 4 is Expected Show values
NoFurtherOpWorkQuantity5IsExpd Indicator: No Remaining Work Quantity 5 is Expected Show values
NoFurtherOpWorkQuantity6IsExpd Indicator: No Remaining Work Quantity 6 is Expected Show values
NoFurtherWorkQuantityIsExpd Indicator: No Remaining Work Expected Show values
NoFurtherBusinessProcQtyIsExpd No Remaining Quantity Expected for Business Process Show values
Column Name Description Domain name
Sequence Sequence PLNFOLGE
OrderOperation Operation/Activity Number VORNR
OrderOperation_2 Operation or Phase Number VDM_VORNR
OrderInternalID Order Internal ID AUFPL
SuperiorOperationInternalID Internal ID of the Superior Operation KNTNR
ConfirmationText Confirmation Text TEXT40
CancldMfgOrderConfCount Confirmation Counter of Cancelled Confirmation CIM_COUNT
EnteredByUser User who Entered the Confirmation USNAM
LastChangedByUser Name of Person Who Changed Object USNAM
EnteredByExternalUser External creator of confirmation USNAM
ExternalSystemConfirmation External Key for Confirmation (for example, from PDC System) SYSUUID
WorkCenterInternalID Work Center Internal ID CR_OBJID
CapacityRequirementSplit Capacity Split Number INT1
ShiftGrouping Grouping for Shift Definitions and Shift Sequences SCHGRUP
ShiftDefinition Shift Definition KAPTPROG
MaterialDocument Number of Material Document BELNR
MaterialDocumentYear Material Document Year GJAHR
PlantDataCollectionID PDC Number (Specific ID for all PDC Systems) CHAR12
ProductCostCollector Cost Collector for Production Process AUFNR
Personnel Personnel Number PERNR
TimeRecording Time Recording ID ZAUSW
EmployeeWageType Employee Wage Type LOART
NumberOfEmployees Number of Employees ANZMA
PostingDateYear Calendar Year NUM4
BusinessProcess Business Process CO_PRZNR
Master Data Relations Join Conditions
Activity Type for Confirmation
  • Client
  • Activity Type for Confirmation
  • Posting Date
  • Controlling Area
  • I_ORDERCONFIRMATION.MANDT == CSLA.MANDT
  • I_ORDERCONFIRMATION.ACTIVITYTYPE == CSLA.LSTAR
  • I_ORDERCONFIRMATION.POSTINGDATE == CSLA.DATBI
  • I_ORDERCONFIRMATION.CONTROLLINGAREA == CSLA.KOKRS
Unit for Actual Dur.
  • Client
  • Unit of Measure for Actual Duration
  • I_ORDERCONFIRMATION.MANDT == T006.MANDT
  • I_ORDERCONFIRMATION.ACTUALDURATIONUNIT == T006.MSEHI
Unit for work
  • Client
  • Unit for work
  • I_ORDERCONFIRMATION.MANDT == T006.MANDT
  • I_ORDERCONFIRMATION.ACTUALWORKQUANTITYUNIT == T006.MSEHI
Time Unit of Confirmed Break Time
  • Client
  • Unit for a Break Time
  • I_ORDERCONFIRMATION.MANDT == T006.MANDT
  • I_ORDERCONFIRMATION.BREAKDURATIONUNIT == T006.MSEHI
Business Area
  • Client
  • Business Area
  • I_ORDERCONFIRMATION.MANDT == TGSB.MANDT
  • I_ORDERCONFIRMATION.BUSINESSAREA == TGSB.GSBER
Unit of Measure for Business Process Quantity
  • Client
  • Unit of Measure for Business Process Quantity
  • I_ORDERCONFIRMATION.MANDT == T006.MANDT
  • I_ORDERCONFIRMATION.BUSINESSPROCESSENTRYUNIT == T006.MSEHI
Unit for Remaining Quantity of Business Process
  • Client
  • Unit for Remaining Quantity of Business Process
  • I_ORDERCONFIRMATION.MANDT == T006.MANDT
  • I_ORDERCONFIRMATION.BUSINESSPROCREMAININGQTYUNIT == T006.MSEHI
Capacity ID
  • Client
  • Capacity ID
  • I_ORDERCONFIRMATION.MANDT == KAKO.MANDT
  • I_ORDERCONFIRMATION.CAPACITYINTERNALID == KAKO.KAPID
Company Code
  • Client
  • Company Code
  • I_ORDERCONFIRMATION.MANDT == T001.MANDT
  • I_ORDERCONFIRMATION.COMPANYCODE == T001.BUKRS
Unit of Operation
  • Client
  • Operation Unit of Measure
  • Confirmation Unit of Measure
  • I_ORDERCONFIRMATION.MANDT == T006.MANDT
  • I_ORDERCONFIRMATION.OPERATIONUNIT == T006.MSEHI
  • I_ORDERCONFIRMATION.CONFIRMATIONUNIT == T006.MSEHI
Controlling Area
  • Client
  • Controlling Area
  • I_ORDERCONFIRMATION.MANDT == TKA01.MANDT
  • I_ORDERCONFIRMATION.CONTROLLINGAREA == TKA01.KOKRS
Confirmed Degree of Qualification
  • Client
  • Employee Suitability
  • Plant
  • Production Plant
  • I_ORDERCONFIRMATION.MANDT == T423.MANDT
  • I_ORDERCONFIRMATION.EMPLOYEESUITABILITY == T423.QUALF
  • I_ORDERCONFIRMATION.PLANT == T423.WERKS
  • I_ORDERCONFIRMATION.PRODUCTIONPLANT == T423.WERKS
Confirmed wage group
  • Client
  • Plant
  • Production Plant
  • Employee Wage Group
  • I_ORDERCONFIRMATION.MANDT == T421.MANDT
  • I_ORDERCONFIRMATION.PLANT == T421.WERKS
  • I_ORDERCONFIRMATION.PRODUCTIONPLANT == T421.WERKS
  • I_ORDERCONFIRMATION.EMPLOYEEWAGEGROUP == T421.LOGRP
Language of Confirmation Text I_ORDERCONFIRMATION.LANGUAGE == T002.SPRAS
Operation Unit of Measure
  • Client
  • Operation Unit of Measure
  • Confirmation Unit of Measure
  • I_ORDERCONFIRMATION.MANDT == T006.MANDT
  • I_ORDERCONFIRMATION.OPERATIONUNIT == T006.MSEHI
  • I_ORDERCONFIRMATION.CONFIRMATIONUNIT == T006.MSEHI
Unit of confirmed activity type 1
  • Unit of Measure for Confirmed Work Quantity 1
  • Client
  • I_ORDERCONFIRMATION.OPWORKQUANTITYUNIT1 == T006.MSEHI
  • I_ORDERCONFIRMATION.MANDT == T006.MANDT
Confirmed unit of activity type 2
  • Unit of Measure for Confirmed Work Quantity 2
  • Client
  • I_ORDERCONFIRMATION.OPWORKQUANTITYUNIT2 == T006.MSEHI
  • I_ORDERCONFIRMATION.MANDT == T006.MANDT
Confirmed unit of activity type 3
  • Unit of Measure for Confirmed Work Quantity 3
  • Client
  • I_ORDERCONFIRMATION.OPWORKQUANTITYUNIT3 == T006.MSEHI
  • I_ORDERCONFIRMATION.MANDT == T006.MANDT
Confirmed unit of activity type 4
  • Unit of Measure for Confirmed Work Quantity 4
  • Client
  • I_ORDERCONFIRMATION.OPWORKQUANTITYUNIT4 == T006.MSEHI
  • I_ORDERCONFIRMATION.MANDT == T006.MANDT
Confirmed unit of activity type 5
  • Unit of Measure for Confirmed Work Quantity 5
  • Client
  • I_ORDERCONFIRMATION.OPWORKQUANTITYUNIT5 == T006.MSEHI
  • I_ORDERCONFIRMATION.MANDT == T006.MANDT
Confirmed unit of activity type 6
  • Client
  • Unit of Measure for Confirmed Work Quantity 6
  • I_ORDERCONFIRMATION.MANDT == T006.MANDT
  • I_ORDERCONFIRMATION.OPWORKQUANTITYUNIT6 == T006.MSEHI
Order Number
  • Client
  • Order Number
  • I_ORDERCONFIRMATION.MANDT == AUFK.MANDT
  • I_ORDERCONFIRMATION.ORDERID == AUFK.AUFNR
Order unit of measure
  • Client
  • Order Unit of Measure
  • I_ORDERCONFIRMATION.MANDT == T006.MANDT
  • I_ORDERCONFIRMATION.ORDERQUANTITYUNIT == T006.MSEHI
Order Type
  • Client
  • Order Type
  • I_ORDERCONFIRMATION.MANDT == T003O.CLIENT
  • I_ORDERCONFIRMATION.ORDERTYPE == T003O.AUART
Plant
  • Client
  • Plant
  • Production Plant
  • I_ORDERCONFIRMATION.MANDT == T001W.MANDT
  • I_ORDERCONFIRMATION.PLANT == T001W.WERKS
  • I_ORDERCONFIRMATION.PRODUCTIONPLANT == T001W.WERKS
Production Plant
  • Client
  • Plant
  • Production Plant
  • I_ORDERCONFIRMATION.MANDT == T001W.MANDT
  • I_ORDERCONFIRMATION.PLANT == T001W.WERKS
  • I_ORDERCONFIRMATION.PRODUCTIONPLANT == T001W.WERKS
Profit Center
  • ?
  • Client
  • Profit Center
  • Controlling Area
  • I_ORDERCONFIRMATION.[column in domain "DATBI"] == CEPC.DATBI
  • I_ORDERCONFIRMATION.MANDT == CEPC.MANDT
  • I_ORDERCONFIRMATION.PROFITCENTER == CEPC.PRCTR
  • I_ORDERCONFIRMATION.CONTROLLINGAREA == CEPC.KOKRS
Unit of Measure for Remaining Work
  • Client
  • Unit of Measure for Remaining Work
  • I_ORDERCONFIRMATION.MANDT == T006.MANDT
  • I_ORDERCONFIRMATION.REMAININGWORKQUANTITYUNIT == T006.MSEHI
Scrap Reason
  • Client
  • Reason for Variance
  • Plant
  • Production Plant
  • I_ORDERCONFIRMATION.MANDT == TRUG.MANDT
  • I_ORDERCONFIRMATION.VARIANCEREASONCODE == TRUG.GRUND
  • I_ORDERCONFIRMATION.PLANT == TRUG.WERKS
  • I_ORDERCONFIRMATION.PRODUCTIONPLANT == TRUG.WERKS