P_PrmtHbPOSingleScheduleLine

DDL: P_PRMTHBPOSINGLESCHEDULELINE SQL: PMMRPLDPOSS Type: view COMPOSITE
9 Fields 2 Data Sources

P_PrmtHbPOSingleScheduleLine is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_CntrlPurOrderScheduleLine, P_PrmtHbPurOrdSchedLineHelp3) and exposes 9 fields with key fields PurchaseOrder, PurchaseOrderItem, ExtSourceSystem.

Data Sources (2)

SourceAliasJoin Type
I_CntrlPurOrderScheduleLine I_CntrlPurOrderScheduleLine inner
P_PrmtHbPurOrdSchedLineHelp3 P_PrmtHbPurOrdSchedLineHelp3 from

Annotations (7)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #COMPOSITE view
VDM.private true view
AbapCatalog.sqlViewName PMMRPLDPOSS view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder I_CntrlPurOrderScheduleLine PurchaseOrder Purchasing Document
KEY PurchaseOrderItem I_CntrlPurOrderScheduleLine PurchaseOrderItem Purchasing Document Item
KEY ExtSourceSystem I_CntrlPurOrderScheduleLine ExtSourceSystem Connected System ID
ScheduleLine I_CntrlPurOrderScheduleLine ScheduleLine Schedule Line
ScheduleLineDeliveryDate I_CntrlPurOrderScheduleLine ScheduleLineDeliveryDate Delivery Date
ScheduleLineDeliveryTime I_CntrlPurOrderScheduleLine ScheduleLineDeliveryTime Time
PerformancePeriodStartDate I_CntrlPurOrderScheduleLine PerformancePeriodStartDate Start of Performance Period
PerformancePeriodEndDate I_CntrlPurOrderScheduleLine PerformancePeriodEndDate End of Performance Period
DelivDateCategory I_CntrlPurOrderScheduleLine DelivDateCategory Delivery Date

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 P_PrmtHbPOSingleScheduleLine.
-- 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.
-- SQL view name: PMMRPLDPOSS

CREATE VIEW P_PrmtHbPOSingleScheduleLine AS
SELECT
  I_CntrlPurOrderScheduleLine.PurchaseOrder AS PurchaseOrder,
  I_CntrlPurOrderScheduleLine.PurchaseOrderItem AS PurchaseOrderItem,
  I_CntrlPurOrderScheduleLine.ExtSourceSystem AS ExtSourceSystem,
  I_CntrlPurOrderScheduleLine.ScheduleLine AS ScheduleLine,
  I_CntrlPurOrderScheduleLine.ScheduleLineDeliveryDate AS ScheduleLineDeliveryDate,
  I_CntrlPurOrderScheduleLine.ScheduleLineDeliveryTime AS ScheduleLineDeliveryTime,
  I_CntrlPurOrderScheduleLine.PerformancePeriodStartDate AS PerformancePeriodStartDate,
  I_CntrlPurOrderScheduleLine.PerformancePeriodEndDate AS PerformancePeriodEndDate,
  I_CntrlPurOrderScheduleLine.DelivDateCategory AS DelivDateCategory
FROM P_PrmtHbPurOrdSchedLineHelp3
INNER JOIN I_CntrlPurOrderScheduleLine ON /* join condition not captured in parsed metadata */
;

Learn More