I_PurOrdScheduleLineBasic

DDL: I_PURORDSCHEDULELINEBASIC SQL: IMMPURORDSLBASIC Type: view BASIC Package: VDM_MM_PUR_PO
43 Fields 2 Data Sources 2 Associations

Purchasing Document Schedule Line Basic

I_PurOrdScheduleLineBasic is a Basic CDS View that provides data about "Purchasing Document Schedule Line Basic" in SAP S/4HANA. It reads from 2 data sources (I_PurchaseOrder, I_PurgDocScheduleLineBasic) and exposes 43 fields with key fields PurchaseOrder, PurchaseOrderItem, PurchaseOrderScheduleLine. It has 2 associations to related views. Part of development package VDM_MM_PUR_PO.

Data Sources (2)

SourceAliasJoin Type
I_PurchaseOrder I_PurchaseOrder inner
I_PurgDocScheduleLineBasic I_PurgDocScheduleLineBasic from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_PurchaseOrder _PurchaseOrder $projection.PurchaseOrder = _PurchaseOrder.PurchaseOrder
[1..1] I_PurchaseOrderItem _PurchaseOrderItem $projection.PurchaseOrder = _PurchaseOrderItem.PurchaseOrder and $projection.PurchaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem

Annotations (13)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Purchasing Document Schedule Line Basic view
VDM.viewType #BASIC view
AbapCatalog.sqlViewName IMMPURORDSLBASIC view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.representativeKey PurchaseOrderScheduleLine view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (43)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder PurchasingDocument Purchasing Document
KEY PurchaseOrderItem PurchasingDocumentItem Purchasing Doc. Item
KEY PurchaseOrderScheduleLine ScheduleLine Schedule Line
ScheduleLine ScheduleLine Schedule Line
DelivDateCategory DelivDateCategory Delivery Date
ScheduleLineDeliveryDate ScheduleLineDeliveryDate Delivery Date
SchedLineStscDeliveryDate SchedLineStscDeliveryDate Stat. Del. Date
PerformancePeriodStartDate PerformancePeriodStartDate Start of Performance Period
PerformancePeriodEndDate PerformancePeriodEndDate End of Performance Period
ScheduleLineDeliveryTime ScheduleLineDeliveryTime Time
ScheduleLineOrderQuantity ScheduleLineOrderQuantity Scheduled Qty
RoughGoodsReceiptQty RoughGoodsReceiptQty Delivered
PurchaseOrderQuantityUnit OrderQuantityUnit Sales Unit
PurchaseRequisition PurchaseRequisition Requisition
PurchaseRequisitionItem PurchaseRequisitionItem Requisn. item
SourceOfCreation SourceOfCreation Creation Ind.
PrevDelivQtyOfScheduleLine PrevDelivQtyOfScheduleLine Replenishmt qty
NoOfRemindersOfScheduleLine NoOfRemindersOfScheduleLine No. Rem./Exp.
ScheduleLineIsFixed ScheduleLineIsFixed Fixing Ind.
ScheduleLineCommittedQuantity ScheduleLineCommittedQuantity Committed Qty
Reservation Reservation Reservation
ProductAvailabilityDate ProductAvailabilityDate Mat.Avail.Date
MaterialStagingTime MaterialStagingTime Staging Time
TransportationPlanningDate TransportationPlanningDate TranspPlngDate
TransportationPlanningTime TransportationPlanningTime Tr. Plan. Time
LoadingDate LoadingDate Loading Date
LoadingTime LoadingTime Loading Time
GoodsIssueDate GoodsIssueDate Goods Issue Date CCD
GoodsIssueTime GoodsIssueTime GI Time
STOLatestPossibleGRDate STOLatestPossibleGRDate GR End Date
STOLatestPossibleGRTime STOLatestPossibleGRTime GR End Time
StockTransferDeliveredQuantity StockTransferDeliveredQuantity Qty Delivered
ScheduleLineIssuedQuantity ScheduleLineIssuedQuantity Issued
MRPRelevantQuantity MRPRelevantQuantity Qty Reduced
Batch Batch Lot No.
BatchBySupplier BatchBySupplier Supplier Batch
_PurchaseRequisition _PurchaseRequisition
_PurchaseRequisitionItem _PurchaseRequisitionItem
_DeliveryDateCategory _DeliveryDateCategory
_PurchaseOrder _PurchaseOrder
_PurchaseOrderItem _PurchaseOrderItem
_PurchaseOrderQuantityUnit _OrderQuantityUnit
_PurchaseOrderQuantityUnitText _OrderQuantityUnitText

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_PurOrdScheduleLineBasic.
-- 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: IMMPURORDSLBASIC

CREATE VIEW I_PurOrdScheduleLineBasic AS
SELECT
  PurchasingDocument AS PurchaseOrder,
  PurchasingDocumentItem AS PurchaseOrderItem,
  ScheduleLine AS PurchaseOrderScheduleLine,
  ScheduleLine,
  DelivDateCategory,
  ScheduleLineDeliveryDate,
  SchedLineStscDeliveryDate,
  PerformancePeriodStartDate,
  PerformancePeriodEndDate,
  ScheduleLineDeliveryTime,
  ScheduleLineOrderQuantity,
  RoughGoodsReceiptQty,
  OrderQuantityUnit AS PurchaseOrderQuantityUnit,
  PurchaseRequisition,
  PurchaseRequisitionItem,
  SourceOfCreation,
  PrevDelivQtyOfScheduleLine,
  NoOfRemindersOfScheduleLine,
  ScheduleLineIsFixed,
  ScheduleLineCommittedQuantity,
  Reservation,
  ProductAvailabilityDate,
  MaterialStagingTime,
  TransportationPlanningDate,
  TransportationPlanningTime,
  LoadingDate,
  LoadingTime,
  GoodsIssueDate,
  GoodsIssueTime,
  STOLatestPossibleGRDate,
  STOLatestPossibleGRTime,
  StockTransferDeliveredQuantity,
  ScheduleLineIssuedQuantity,
  MRPRelevantQuantity,
  Batch,
  BatchBySupplier
FROM I_PurgDocScheduleLineBasic
INNER JOIN I_PurchaseOrder ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PurchaseOrder AS _PurchaseOrder ON PurchaseOrder = _PurchaseOrder.PurchaseOrder  -- association [1..1]
LEFT OUTER JOIN I_PurchaseOrderItem AS _PurchaseOrderItem ON PurchaseOrder = _PurchaseOrderItem.PurchaseOrder AND PurchaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem  -- association [1..1]
;

Learn More