R_PlannedOrderCapacityTP

DDL: R_PLANNEDORDERCAPACITYTP Type: view_entity TRANSACTIONAL
35 Fields 1 Data Sources

RAP BO Planned Order Capacity view

R_PlannedOrderCapacityTP is a Transactional CDS View that provides data about "RAP BO Planned Order Capacity view" in SAP S/4HANA. It reads from 1 data source (I_CapacityRequirementItemCap) and exposes 35 fields with key fields PlannedOrder, CapacityRequirement, CapacityRequirementItem, CapacityRqmtItemCapacity.

Data Sources (1)

SourceAliasJoin Type
I_CapacityRequirementItemCap _CapacityRequirementItemCap from

Annotations (9)

NameValueLevelField
EndUserText.label RAP BO Planned Order Capacity view view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
Metadata.ignorePropagatedAnnotations true view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (35)

KeyFieldSource TableSource FieldDescription
KEY PlannedOrder I_CapacityRequirementItemCap PlannedOrder Planned Order
KEY CapacityRequirement I_CapacityRequirementItemCap CapacityRequirement Id number
KEY CapacityRequirementItem I_CapacityRequirementItemCap CapacityRequirementItem
KEY CapacityRqmtItemCapacity I_CapacityRequirementItemCap CapacityRqmtItemCapacity
Sequence I_CapacityRequirementItemCap BillOfOperationsSequence Sequence
Operation
WorkCenter
OperationLatestStartDate I_CapacityRequirementItemCap OperationLatestStartDate Ltst Start Date
OperationLatestStartTime I_CapacityRequirementItemCap OperationLatestStartTime Ltst Start Time
OperationLatestEndDate I_CapacityRequirementItemCap OperationLatestEndDate Ltst End Date
OperationLatestEndTime I_CapacityRequirementItemCap OperationLatestEndTime Ltst End Time
OperationEarliestStartDate I_CapacityRequirementItemCap OperationEarliestStartDate Erlst Strt Date
OperationEarliestStartTime I_CapacityRequirementItemCap OperationEarliestStartTime Erlst Strt Time
OperationEarliestEndDate I_CapacityRequirementItemCap OperationEarliestEndDate Erlst End Date
OperationEarliestEndTime I_CapacityRequirementItemCap OperationEarliestEndTime Erlst End Time
OpLtstSchedldProcgStrtDte I_CapacityRequirementItemCap LtstSchedldProcStrtDte
OpLtstSchedldProcgStrtTme I_CapacityRequirementItemCap LtstSchedldProcStrtTime
OpLtstSchedldTrdwnStrtDte I_CapacityRequirementItemCap LtstSchedldTrdwnStrtDte
OpLtstSchedldTrdwnStrtTme I_CapacityRequirementItemCap LtstSchedldTrdwnStrtTime
CapacityRequirementUnit I_CapacityRequirementItemCap CapacityRequirementUnit Capacity Unit
ScheduledCapReqOpSegSetupDurn I_CapacityRequirementItemCap ScheduledCapReqOpSegSetupDurn Scheduled Setup
RemainingCapReqOpSegSetupDurn I_CapacityRequirementItemCap RemainingCapReqOpSegSetupDurn Remaining Setup
ScheduledCapReqOpSegProcgDurn I_CapacityRequirementItemCap ScheduledCapReqOpSegProcgDurn Sched. Process.
RemainingCapReqOpSegProcgDurn I_CapacityRequirementItemCap RemainingCapReqOpSegProcgDurn Rem. Processing
ScheduledCapReqOpSegTrdwnDurn I_CapacityRequirementItemCap ScheduledCapReqOpSegTrdwnDurn Sched. Teardown
RemainingCapReqOpSegTrdwnDurn I_CapacityRequirementItemCap RemainingCapReqOpSegTrdwnDurn Remain.Teardown
OperationTextendasOperationText
PlannedOrderLastChangeDateTime _PlannedOrder PlannedOrderLastChangeDateTime
MRPController
MRPPlant
CapacityInternalID I_CapacityRequirementItemCap CapacityInternalID Capacity ID
_PlannedOrder _PlannedOrder
_Capacity I_CapacityRequirementItemCap _Capacity
_CapacityRequirement I_CapacityRequirementItemCap _CapacityRequirement
_UnitOfMeasure I_CapacityRequirementItemCap _UnitOfMeasure

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 R_PlannedOrderCapacityTP.
-- 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 R_PlannedOrderCapacityTP AS
SELECT
  _CapacityRequirementItemCap.PlannedOrder AS PlannedOrder,
  _CapacityRequirementItemCap.CapacityRequirement AS CapacityRequirement,
  _CapacityRequirementItemCap.CapacityRequirementItem AS CapacityRequirementItem,
  _CapacityRequirementItemCap.CapacityRqmtItemCapacity AS CapacityRqmtItemCapacity,
  _CapacityRequirementItemCap.BillOfOperationsSequence AS Sequence,
  cast(_CapacityRequirementItemCap.Operation as pph_vornr preserving type ) AS Operation,
  _CapacityRequirementItemCap._WorkCenter.WorkCenter AS WorkCenter,
  _CapacityRequirementItemCap.OperationLatestStartDate AS OperationLatestStartDate,
  _CapacityRequirementItemCap.OperationLatestStartTime AS OperationLatestStartTime,
  _CapacityRequirementItemCap.OperationLatestEndDate AS OperationLatestEndDate,
  _CapacityRequirementItemCap.OperationLatestEndTime AS OperationLatestEndTime,
  _CapacityRequirementItemCap.OperationEarliestStartDate AS OperationEarliestStartDate,
  _CapacityRequirementItemCap.OperationEarliestStartTime AS OperationEarliestStartTime,
  _CapacityRequirementItemCap.OperationEarliestEndDate AS OperationEarliestEndDate,
  _CapacityRequirementItemCap.OperationEarliestEndTime AS OperationEarliestEndTime,
  _CapacityRequirementItemCap.LtstSchedldProcStrtDte AS OpLtstSchedldProcgStrtDte,
  _CapacityRequirementItemCap.LtstSchedldProcStrtTime AS OpLtstSchedldProcgStrtTme,
  _CapacityRequirementItemCap.LtstSchedldTrdwnStrtDte AS OpLtstSchedldTrdwnStrtDte,
  _CapacityRequirementItemCap.LtstSchedldTrdwnStrtTime AS OpLtstSchedldTrdwnStrtTme,
  _CapacityRequirementItemCap.CapacityRequirementUnit AS CapacityRequirementUnit,
  _CapacityRequirementItemCap.ScheduledCapReqOpSegSetupDurn AS ScheduledCapReqOpSegSetupDurn,
  _CapacityRequirementItemCap.RemainingCapReqOpSegSetupDurn AS RemainingCapReqOpSegSetupDurn,
  _CapacityRequirementItemCap.ScheduledCapReqOpSegProcgDurn AS ScheduledCapReqOpSegProcgDurn,
  _CapacityRequirementItemCap.RemainingCapReqOpSegProcgDurn AS RemainingCapReqOpSegProcgDurn,
  _CapacityRequirementItemCap.ScheduledCapReqOpSegTrdwnDurn AS ScheduledCapReqOpSegTrdwnDurn,
  _CapacityRequirementItemCap.RemainingCapReqOpSegTrdwnDurn AS RemainingCapReqOpSegTrdwnDurn,
  case when SubOperation.SuperiorOperationInternalID > '00000000' then SubOperation.OperationText else _CapacityRequirementItemCap._BOOOperationInternalVersion.OperationText end as OperationText AS OperationTextendasOperationText,
  _PlannedOrder.PlannedOrderLastChangeDateTime AS PlannedOrderLastChangeDateTime,
  _CapacityRequirementItemCap._PlannedOrder.MRPController AS MRPController,
  _CapacityRequirementItemCap._PlannedOrder.MRPPlant AS MRPPlant,
  _CapacityRequirementItemCap.CapacityInternalID AS CapacityInternalID,
  _CapacityRequirementItemCap._Capacity AS _Capacity,
  _CapacityRequirementItemCap._CapacityRequirement AS _CapacityRequirement,
  _CapacityRequirementItemCap._UnitOfMeasure AS _UnitOfMeasure
FROM I_CapacityRequirementItemCap AS _CapacityRequirementItemCap
;

Learn More