I_ProcessOrderPhaseTP

DDL: I_PROCESSORDERPHASETP Type: view_entity TRANSACTIONAL
137 Fields 1 Data Sources

Process Order Phase - TP

I_ProcessOrderPhaseTP is a Transactional CDS View that provides data about "Process Order Phase - TP" in SAP S/4HANA. It reads from 1 data source (R_ProcessOrderPhaseTP) and exposes 137 fields with key fields OrderInternalID, OrderPhaseInternalID.

Data Sources (1)

SourceAliasJoin Type
R_ProcessOrderPhaseTP R_ProcessOrderPhaseTP projection

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #NONE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.sapObjectNodeType.name ProcessOrderPhase view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #TRANSACTIONAL view
EndUserText.label Process Order Phase - TP view

Fields (137)

KeyFieldSource TableSource FieldDescription
KEY OrderInternalID OrderInternalID Plan No.f.Oper.
KEY OrderPhaseInternalID OrderPhaseInternalID
ProcessOrder ProcessOrder Order
ProcessOrderSequence ProcessOrderSequence
ProcessOrderPhase ProcessOrderPhase
SuperiorOperation SuperiorOperation
SuperiorOperationInternalID SuperiorOperationInternalID Sup. Op. Node
OrderPhaseText OrderPhaseText
PhaseHasLongText PhaseHasLongText
LongTextLanguage LongTextLanguage Long Text Lang
PhaseStandardTextCode PhaseStandardTextCode Std Text Key
PhaseIsToBeDeleted PhaseIsToBeDeleted
Plant Plant Valuation Area
ProductionResource ProductionResource
ProductionResourceInternalID ProductionResourceInternalID Object ID
ProductionResourceType
PhaseControlProfile PhaseControlProfile Control Key
ControlRecipeDestination ControlRecipeDestination
FactoryCalendar FactoryCalendar Factory Calendar
Reservation Reservation Reservation
NumberOfConfirmationSlips NumberOfConfirmationSlips No. of Conf. Slips
ConfirmationGroup ConfirmationGroup
NumberOfPhaseConfirmations NumberOfPhaseConfirmations
NumberOfCapacities NumberOfCapacities Number
CapacityRequirement CapacityRequirement
ChangeNumber ChangeNumber Change Number
ObjectInternalID ObjectInternalID Object number
CostElement CostElement G/L Account
EmployeeSuitability EmployeeSuitability
EmployeeWageType EmployeeWageType Wage type
EmployeeWageGroup EmployeeWageGroup Wage Group
NumberOfEmployees NumberOfEmployees No. employees
NumberOfTimeTickets NumberOfTimeTickets No.TimeTickets
PhaseSetupGroupCategory PhaseSetupGroupCategory Setup group cat
PhaseSetupGroup PhaseSetupGroup Setup group key
PhaseSetupType PhaseSetupType Setup Type Key
BillOfOperationsType BillOfOperationsType Task List Type
MasterRecipeGroup MasterRecipeGroup Group
MasterRecipe MasterRecipe Group Counter
MasterRecipePhaseIntID MasterRecipePhaseIntID Task list node
ExtProcgPhaseHasSubcontrg ExtProcgPhaseHasSubcontrg Subcontracting
PurchasingInfoRecordCategory PurchasingInfoRecordCategory Infotype
PurgInfoRecdDataIsFixed PurgInfoRecdDataIsFixed
PurchasingInfoRecord PurchasingInfoRecord Info Record
PurchaseOutlineAgreement PurchaseOutlineAgreement Agreement
PurchaseOutlineAgreementItem PurchaseOutlineAgreementItem Item
PurgInfoRecNonStockItmSortTerm PurgInfoRecNonStockItmSortTerm Sort Term
PurchaseOrder PurchaseOrder Purchasing Document
PurchaseOrderItem PurchaseOrderItem Purchasing Document Item
Supplier Supplier Supplier
GoodsRecipientName GoodsRecipientName Recipient Name
PurchaseRequisition PurchaseRequisition Requisition
PurchaseRequisitionItem PurchaseRequisitionItem Requisn. item
PurchaseRequisitionPlndDlvDurn PurchaseRequisitionPlndDlvDurn
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingGroup PurchasingGroup Purchasing Group
NumberOfPhasePriceUnits NumberOfPhasePriceUnits Price Unit
OpExternalProcessingCurrency OpExternalProcessingCurrency Currency
OpExternalProcessingPrice OpExternalProcessingPrice Price
MaterialGroup MaterialGroup Product Group
UnloadingPointName UnloadingPointName Unloading Point Name
InspectionLotType InspectionLotType Inspection Type
CompanyCode CompanyCode Receiver Company Code
BusinessArea BusinessArea Business Area
ControllingArea
ProfitCenter ProfitCenter Profit Center
RequestingCostCenter RequestingCostCenter Req.cost center
CostingVariant CostingVariant
CostingSheet CostingSheet Costing Sheet
FunctionalArea FunctionalArea Sendr Fctl Area
ErlstSchedldExecStrtDte ErlstSchedldExecStrtDte Earl.start date
ErlstSchedldExecStrtTime ErlstSchedldExecStrtTime
ErlstSchedldExecEndDte ErlstSchedldExecEndDte EarliestEndDate
ErlstSchedldExecEndTime ErlstSchedldExecEndTime
LtstSchedldExecStrtDte LtstSchedldExecStrtDte Latest start
LtstSchedldExecStrtTime LtstSchedldExecStrtTime
LtstSchedldExecEndDte LtstSchedldExecEndDte Lat.finish date
LtstSchedldExecEndTime LtstSchedldExecEndTime
ActualExecutionStartDate ActualExecutionStartDate Execution Start Date
ActualExecutionStartTime ActualExecutionStartTime
ActualProcessingStartDate ActualProcessingStartDate
ActualProcessingStartTime ActualProcessingStartTime
ActualProcessingEndDate ActualProcessingEndDate
ActualProcessingEndTime ActualProcessingEndTime
ActualExecutionEndDate ActualExecutionEndDate Execution End Date
ActualExecutionEndTime ActualExecutionEndTime
OrderPhaseUnit OrderPhaseUnit Act/op UoM
OpQtyToBaseQtyDnmntr OpQtyToBaseQtyDnmntr
OpQtyToBaseQtyNmrtr OpQtyToBaseQtyNmrtr
ReferenceQuantity ReferenceQuantity Comm Refer Quantity
OpPlannedTotalQuantity OpPlannedTotalQuantity
OpPlannedScrapQuantity OpPlannedScrapQuantity
OpTotalConfirmedYieldQty OpTotalConfirmedYieldQty
OpTotalConfirmedScrapQty OpTotalConfirmedScrapQty
StandardWorkQuantityUnit1 StandardWorkQuantityUnit1 Std value unit
StandardWorkQuantity1 StandardWorkQuantity1 Standard Value
CostCtrActivityType1 CostCtrActivityType1 Activity Type
StandardWorkQuantityUnit2 StandardWorkQuantityUnit2 Std value unit
StandardWorkQuantity2 StandardWorkQuantity2 Standard Value
CostCtrActivityType2 CostCtrActivityType2 Activity Type
StandardWorkQuantityUnit3 StandardWorkQuantityUnit3 Std value unit
StandardWorkQuantity3 StandardWorkQuantity3 Standard Value
CostCtrActivityType3 CostCtrActivityType3 Activity Type
StandardWorkQuantityUnit4 StandardWorkQuantityUnit4 Std value unit
StandardWorkQuantity4 StandardWorkQuantity4 Standard Value
CostCtrActivityType4 CostCtrActivityType4 Activity Type
StandardWorkQuantityUnit5 StandardWorkQuantityUnit5 Std value unit
StandardWorkQuantity5 StandardWorkQuantity5 Standard Value
CostCtrActivityType5 CostCtrActivityType5 Activity Type
StandardWorkQuantityUnit6 StandardWorkQuantityUnit6 Std value unit
StandardWorkQuantity6 StandardWorkQuantity6 Standard Value
CostCtrActivityType6 CostCtrActivityType6 Activity Type
WorkQuantityUnit1 WorkQuantityUnit1
ConfirmedWorkQuantity1 ConfirmedWorkQuantity1
NoFurtherWorkQuantity1IsExpd NoFurtherWorkQuantity1IsExpd
WorkQuantityUnit2 WorkQuantityUnit2
ConfirmedWorkQuantity2 ConfirmedWorkQuantity2
NoFurtherWorkQuantity2IsExpd NoFurtherWorkQuantity2IsExpd
WorkQuantityUnit3 WorkQuantityUnit3
ConfirmedWorkQuantity3 ConfirmedWorkQuantity3
NoFurtherWorkQuantity3IsExpd NoFurtherWorkQuantity3IsExpd
WorkQuantityUnit4 WorkQuantityUnit4
ConfirmedWorkQuantity4 ConfirmedWorkQuantity4
NoFurtherWorkQuantity4IsExpd NoFurtherWorkQuantity4IsExpd
WorkQuantityUnit5 WorkQuantityUnit5
ConfirmedWorkQuantity5 ConfirmedWorkQuantity5
NoFurtherWorkQuantity5IsExpd NoFurtherWorkQuantity5IsExpd
WorkQuantityUnit6 WorkQuantityUnit6
ConfirmedWorkQuantity6 ConfirmedWorkQuantity6
NoFurtherWorkQuantity6IsExpd NoFurtherWorkQuantity6IsExpd
BusinessProcess BusinessProcess Business Process
BusinessProcessEntryUnit BusinessProcessEntryUnit
BusinessProcessConfirmedQty BusinessProcessConfirmedQty
NoFurtherBusinessProcQtyIsExpd NoFurtherBusinessProcQtyIsExpd
BusinessProcRemainingQtyUnit BusinessProcRemainingQtyUnit
BusinessProcessRemainingQty BusinessProcessRemainingQty
_OrderredirectedtoI_ProcessOrderTP

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_ProcessOrderPhaseTP.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_ProcessOrderPhaseTP AS
SELECT
  OrderInternalID,
  OrderPhaseInternalID,
  ProcessOrder,
  ProcessOrderSequence,
  ProcessOrderPhase,
  SuperiorOperation,
  SuperiorOperationInternalID,
  OrderPhaseText,
  PhaseHasLongText,
  LongTextLanguage,
  PhaseStandardTextCode,
  PhaseIsToBeDeleted,
  Plant,
  ProductionResource,
  ProductionResourceInternalID,
  PhaseControlProfile,
  ControlRecipeDestination,
  FactoryCalendar,
  Reservation,
  NumberOfConfirmationSlips,
  ConfirmationGroup,
  NumberOfPhaseConfirmations,
  NumberOfCapacities,
  CapacityRequirement,
  ChangeNumber,
  ObjectInternalID,
  CostElement,
  EmployeeSuitability,
  EmployeeWageType,
  EmployeeWageGroup,
  NumberOfEmployees,
  NumberOfTimeTickets,
  PhaseSetupGroupCategory,
  PhaseSetupGroup,
  PhaseSetupType,
  BillOfOperationsType,
  MasterRecipeGroup,
  MasterRecipe,
  MasterRecipePhaseIntID,
  ExtProcgPhaseHasSubcontrg,
  PurchasingInfoRecordCategory,
  PurgInfoRecdDataIsFixed,
  PurchasingInfoRecord,
  PurchaseOutlineAgreement,
  PurchaseOutlineAgreementItem,
  PurgInfoRecNonStockItmSortTerm,
  PurchaseOrder,
  PurchaseOrderItem,
  Supplier,
  GoodsRecipientName,
  PurchaseRequisition,
  PurchaseRequisitionItem,
  PurchaseRequisitionPlndDlvDurn,
  PurchasingOrganization,
  PurchasingGroup,
  NumberOfPhasePriceUnits,
  OpExternalProcessingCurrency,
  OpExternalProcessingPrice,
  MaterialGroup,
  UnloadingPointName,
  InspectionLotType,
  CompanyCode,
  BusinessArea,
  ProfitCenter,
  RequestingCostCenter,
  CostingVariant,
  CostingSheet,
  FunctionalArea,
  ErlstSchedldExecStrtDte,
  ErlstSchedldExecStrtTime,
  ErlstSchedldExecEndDte,
  ErlstSchedldExecEndTime,
  LtstSchedldExecStrtDte,
  LtstSchedldExecStrtTime,
  LtstSchedldExecEndDte,
  LtstSchedldExecEndTime,
  ActualExecutionStartDate,
  ActualExecutionStartTime,
  ActualProcessingStartDate,
  ActualProcessingStartTime,
  ActualProcessingEndDate,
  ActualProcessingEndTime,
  ActualExecutionEndDate,
  ActualExecutionEndTime,
  OrderPhaseUnit,
  OpQtyToBaseQtyDnmntr,
  OpQtyToBaseQtyNmrtr,
  ReferenceQuantity,
  OpPlannedTotalQuantity,
  OpPlannedScrapQuantity,
  OpTotalConfirmedYieldQty,
  OpTotalConfirmedScrapQty,
  StandardWorkQuantityUnit1,
  StandardWorkQuantity1,
  CostCtrActivityType1,
  StandardWorkQuantityUnit2,
  StandardWorkQuantity2,
  CostCtrActivityType2,
  StandardWorkQuantityUnit3,
  StandardWorkQuantity3,
  CostCtrActivityType3,
  StandardWorkQuantityUnit4,
  StandardWorkQuantity4,
  CostCtrActivityType4,
  StandardWorkQuantityUnit5,
  StandardWorkQuantity5,
  CostCtrActivityType5,
  StandardWorkQuantityUnit6,
  StandardWorkQuantity6,
  CostCtrActivityType6,
  WorkQuantityUnit1,
  ConfirmedWorkQuantity1,
  NoFurtherWorkQuantity1IsExpd,
  WorkQuantityUnit2,
  ConfirmedWorkQuantity2,
  NoFurtherWorkQuantity2IsExpd,
  WorkQuantityUnit3,
  ConfirmedWorkQuantity3,
  NoFurtherWorkQuantity3IsExpd,
  WorkQuantityUnit4,
  ConfirmedWorkQuantity4,
  NoFurtherWorkQuantity4IsExpd,
  WorkQuantityUnit5,
  ConfirmedWorkQuantity5,
  NoFurtherWorkQuantity5IsExpd,
  WorkQuantityUnit6,
  ConfirmedWorkQuantity6,
  NoFurtherWorkQuantity6IsExpd,
  BusinessProcess,
  BusinessProcessEntryUnit,
  BusinessProcessConfirmedQty,
  NoFurtherBusinessProcQtyIsExpd,
  BusinessProcRemainingQtyUnit,
  BusinessProcessRemainingQty
FROM R_ProcessOrderPhaseTP
;

Learn More