P_PROCORDAORLIST_2

CDS View
69 Fields 7 CDS Views

Process Orders for AOR

P_PROCORDAORLIST_2 is a CDS View in S/4HANA. Process Orders for AOR. It contains 69 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
P_ProcOrderOperationDurn view inner COMPOSITE Process Order Operation Durations
P_ProcOrdInspLotUsgeDcsnCodeR view_entity from COMPOSITE Process Order Inspection Lots with Usage Decision Code R
P_ProcOrdInspRjctdChar view from COMPOSITE process order inspection lot characteristics
P_ProcOrdMgmtBasic_2 view_entity from COMPOSITE Process order
P_ProcOrdMgmtOperation view inner COMPOSITE Process order operation basic view
P_ProcOrdOperationQtyIssue view inner COMPOSITE Process order operations quantity issue
P_ProcOrdOpQualityIssAggrgn view inner COMPOSITE Process order quality issue aggregation

Fields (69)

KeyField CDS FieldsUsed in Views
KEY OrderID ProcessOrder 1
_BusinessArea _BusinessArea 1
_SettlementReservation _SettlementReservation 1
ActualCostsCostingVariant ActualCostsCostingVariant 1
BillOfMaterialCategory BillOfMaterialCategory 1
BillOfMaterialVariant BillOfMaterialVariant 1
BillOfMaterialVariantUsage BillOfMaterialVariantUsage 1
BillOfMaterialVersion BillOfMaterialVersion 1
BillOfOperations BillOfOperations 1
BillOfOperationsGroup BillOfOperationsGroup 1
BillOfOperationsType BillOfOperationsType 1
BillOfOperationsUsage BillOfOperationsUsage 1
BillOfOperationsVariant BillOfOperationsVariant 1
BillOfOperationsVersion BillOfOperationsVersion 1
BOMExplosionDate BOMExplosionDate 1
BOMValidityStartDate BOMValidityStartDate 1
BOOExplosionDate BOOExplosionDate 1
BOOInternalVersionCounter BOOInternalVersionCounter 1
BOOValidityStartDate BOOValidityStartDate 1
BusinessArea BusinessArea 1
CapacityActiveVersion CapacityActiveVersion 1
CapacityRequirement CapacityRequirement 1
CapacityRqmtHasNotToBeCreated CapacityRqmtHasNotToBeCreated 1
ChangeNumber ChangeNumber 1
CompanyCode CompanyCode 1
ConditionApplication ConditionApplication 1
ControllingArea ControllingArea 2
CostCenter CostCenter 1
CostElement CostElement 1
CostingSheet CostingSheet 1
CreatedByUser CreatedByUser 1
Currency Currency 1
FunctionalArea FunctionalArea 1
GLAccount GLAccount 1
InspectionLot InspectionLot 2
IsMarkedForDeletion IsMarkedForDeletion 1
LastChangeDate LastChangeDate 1
LastChangedByUser LastChangedByUser 1
LastChangeTime LastChangeTime 1
LeadingOrder LeadingOrder 1
MasterProductionOrder MasterProductionOrder 1
Material BillOfOperationsMaterial 1
MaterialBaseUnit BaseUnit 1
MfgOrderConfirmation MfgOrderConfirmation 1
MfgOrderConfirmedReworkQty MfgOrderConfirmedReworkQty 1
MfgOrderHasMultipleItems MfgOrderHasMultipleItems 1
MfgOrderHierarchyLevel MfgOrderHierarchyLevel 1
MfgOrderIsPartOfCollvOrder MfgOrderIsPartOfCollvOrder 1
MfgOrderSuperiorMfgOrder SuperiorOrder 1
ObjectInternalID OrdObjectInternalID 1
OrderCategory ManufacturingOrderCategory 1
OrderIsEventBasedPosting OrderIsEventBasedPosting 1
OrderIsNotCostedAutomatically OrderIsNotCostedAutomatically 1
OrderSequenceNumber OrderSequenceNumber 1
OrdIsNotSchedldAutomatically OrdIsNotSchedldAutomatically 1
PlannedCostsCostingVariant PlannedCostsCostingVariant 1
PlannedTotalQtyInBaseUnit PlndQtyInBaseUnit 1
PriorityCode ManufacturingOrderImportance 1
ProdnProcgIsFlexible ProdnProcgIsFlexible 1
ProductCostCollector ProductCostCollector 1
ProfitCenter ProfitCenter 1
ReferenceOrder ReferenceOrder 1
Reservation Reservation 1
ResponsibleCostCenter ResponsibleCostCenter 1
ResponsiblePlannerGroup ResponsiblePlannerGroup 1
ScheduledBasicEndDate ScheduledBasicEndDate 3
ScheduledBasicStartDate ScheduledBasicStartDate 3
TechnicalCompletionDate MfgOrderActualCompletionDate 1
TotalCommitmentDate MfgOrderTotalCommitmentDate 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Process Orders for AOR
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_PROCORDAORLIST_2 (
    ORDERID,
    _BUSINESSAREA,
    _SETTLEMENTRESERVATION,
    ACTUALCOSTSCOSTINGVARIANT,
    BILLOFMATERIALCATEGORY,
    BILLOFMATERIALVARIANT,
    BILLOFMATERIALVARIANTUSAGE,
    BILLOFMATERIALVERSION,
    BILLOFOPERATIONS,
    BILLOFOPERATIONSGROUP,
    BILLOFOPERATIONSTYPE,
    BILLOFOPERATIONSUSAGE,
    BILLOFOPERATIONSVARIANT,
    BILLOFOPERATIONSVERSION,
    BOMEXPLOSIONDATE,
    BOMVALIDITYSTARTDATE,
    BOOEXPLOSIONDATE,
    BOOINTERNALVERSIONCOUNTER,
    BOOVALIDITYSTARTDATE,
    BUSINESSAREA,
    CAPACITYACTIVEVERSION,
    CAPACITYREQUIREMENT,
    CAPACITYRQMTHASNOTTOBECREATED,
    CHANGENUMBER,
    COMPANYCODE,
    CONDITIONAPPLICATION,
    CONTROLLINGAREA,
    COSTCENTER,
    COSTELEMENT,
    COSTINGSHEET,
    CREATEDBYUSER,
    CURRENCY,
    FUNCTIONALAREA,
    GLACCOUNT,
    INSPECTIONLOT,
    ISMARKEDFORDELETION,
    LASTCHANGEDATE,
    LASTCHANGEDBYUSER,
    LASTCHANGETIME,
    LEADINGORDER,
    MASTERPRODUCTIONORDER,
    MATERIAL,
    MATERIALBASEUNIT,
    MFGORDERCONFIRMATION,
    MFGORDERCONFIRMEDREWORKQTY,
    MFGORDERHASMULTIPLEITEMS,
    MFGORDERHIERARCHYLEVEL,
    MFGORDERISPARTOFCOLLVORDER,
    MFGORDERSUPERIORMFGORDER,
    OBJECTINTERNALID,
    ORDERCATEGORY,
    ORDERISEVENTBASEDPOSTING,
    ORDERISNOTCOSTEDAUTOMATICALLY,
    ORDERSEQUENCENUMBER,
    ORDISNOTSCHEDLDAUTOMATICALLY,
    PLANNEDCOSTSCOSTINGVARIANT,
    PLANNEDTOTALQTYINBASEUNIT,
    PRIORITYCODE,
    PRODNPROCGISFLEXIBLE,
    PRODUCTCOSTCOLLECTOR,
    PROFITCENTER,
    REFERENCEORDER,
    RESERVATION,
    RESPONSIBLECOSTCENTER,
    RESPONSIBLEPLANNERGROUP,
    SCHEDULEDBASICENDDATE,
    SCHEDULEDBASICSTARTDATE,
    TECHNICALCOMPLETIONDATE,
    TOTALCOMMITMENTDATE,
    PRIMARY KEY (ORDERID)
);

Learn More