R_PurchaseOrderScheduleLineTP

DDL: R_PURCHASEORDERSCHEDULELINETP Type: view_entity TRANSACTIONAL Package: RAP_MM_PUR_PO
36 Fields 1 Data Sources 2 Associations

Purchase Order Schedule Line TP view

R_PurchaseOrderScheduleLineTP is a Transactional CDS View that provides data about "Purchase Order Schedule Line TP view" in SAP S/4HANA. It reads from 1 data source (R_PurchaseOrderScheduleLine) and exposes 36 fields with key fields PurchaseOrder, PurchaseOrderItem, ScheduleLine. It has 2 associations to related views. Part of development package RAP_MM_PUR_PO.

Data Sources (1)

SourceAliasJoin Type
R_PurchaseOrderScheduleLine R_PurchaseOrderScheduleLine from

Associations (2)

CardinalityTargetAliasCondition
[1..1] R_PurchaseOrderTP _PurchaseOrder $projection.PurchaseOrder = _PurchaseOrder.PurchaseOrder
[1..*] R_POSubcontractingComponentTP _SubcontractingComponent

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Purchase Order Schedule Line TP view view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.sapObjectNodeType.name PurchaseOrderScheduleLine view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view

Fields (36)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder PurchaseOrder Purchasing Document
KEY PurchaseOrderItem PurchaseOrderItem Purchasing Document Item
KEY ScheduleLine ScheduleLine Schedule Line
ScheduleLineDeliveryDate ScheduleLineDeliveryDate Delivery Date
SchedLineStscDeliveryDate SchedLineStscDeliveryDate Stat. Del. Date
PerformancePeriodStartDate PerformancePeriodStartDate Start of Performance Period
PerformancePeriodEndDate PerformancePeriodEndDate End of Performance Period
ScheduleLineDeliveryTime ScheduleLineDeliveryTime Time
Batch Batch Lot No.
BatchBySupplier BatchBySupplier Supplier Batch
ScheduleLineOrderQuantity ScheduleLineOrderQuantity Scheduled Qty
OpenPurchaseOrderQuantity OpenPurchaseOrderQuantity Open Purchase Order Quantity
PurchaseOrderQuantityUnit PurchaseOrderQuantityUnit Order Unit
Currency Currency Valuation Crcy
OpenPurchaseOrderNetAmount OpenPurchaseOrderNetAmount
PurchaseRequisition PurchaseRequisition Requisition
PurchaseRequisitionItem PurchaseRequisitionItem Requisn. item
DelivDateCategory DelivDateCategory Delivery Date
ScheduleLineOrderDate ScheduleLineOrderDate PurchOrderDate
ProductAvailabilityDate ProductAvailabilityDate Mat.Avail.Date
LoadingDate LoadingDate Loading Date
LoadingTime LoadingTime Loading Time
TransportationPlanningDate TransportationPlanningDate TranspPlngDate
TransportationPlanningTime TransportationPlanningTime Tr. Plan. Time
GoodsIssueDate GoodsIssueDate Goods Issue Date CCD
GoodsIssueTime GoodsIssueTime GI Time
RouteSchedule RouteSchedule Route Schedule
ProductAvailabilityTime ProductAvailabilityTime Matl Staging Tme
_SubcontractingComponent _SubcontractingComponent
_Currency _Currency
_PurchaseOrder _PurchaseOrder
_PurchaseOrderItem _PurchaseOrderItem
_PurchaseOrderQuantityUnit _PurchaseOrderQuantityUnit
_PurchaseRequisition _PurchaseRequisition
_PurchaseRequisitionItem _PurchaseRequisitionItem
_PurchaseOrderQuantityUnitText _PurchaseOrderQuantityUnitText

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_PurchaseOrderScheduleLineTP.
-- 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_PurchaseOrderScheduleLineTP AS
SELECT
  PurchaseOrder,
  PurchaseOrderItem,
  ScheduleLine,
  ScheduleLineDeliveryDate,
  SchedLineStscDeliveryDate,
  PerformancePeriodStartDate,
  PerformancePeriodEndDate,
  ScheduleLineDeliveryTime,
  Batch,
  BatchBySupplier,
  ScheduleLineOrderQuantity,
  OpenPurchaseOrderQuantity,
  PurchaseOrderQuantityUnit,
  Currency,
  OpenPurchaseOrderNetAmount,
  PurchaseRequisition,
  PurchaseRequisitionItem,
  DelivDateCategory,
  ScheduleLineOrderDate,
  ProductAvailabilityDate,
  LoadingDate,
  LoadingTime,
  TransportationPlanningDate,
  TransportationPlanningTime,
  GoodsIssueDate,
  GoodsIssueTime,
  RouteSchedule,
  ProductAvailabilityTime
FROM R_PurchaseOrderScheduleLine
LEFT OUTER JOIN R_PurchaseOrderTP AS _PurchaseOrder ON PurchaseOrder = _PurchaseOrder.PurchaseOrder  -- association [1..1]
LEFT OUTER JOIN R_POSubcontractingComponentTP AS _SubcontractingComponent ON /* condition not available in parsed metadata */  -- association [1..*]
;

Learn More