R_PURCHASINGDOCSCHEDULELINE

CDS View
30 Fields 2 CDS Views

Purchasing Document Schedule Line

R_PURCHASINGDOCSCHEDULELINE is a CDS View in S/4HANA. Purchasing Document Schedule Line. It contains 30 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
R_PurchaseOrderScheduleLine view from BASIC Purchase Order Schedule Line
R_STOScheduleLine view_entity from BASIC Schedule Line for Stock Transport Order

Fields (30)

KeyField CDS FieldsUsed in Views
KEY PurchasingDocument PurchaseOrder 1
KEY PurchasingDocumentItem PurchaseOrderItem 1
KEY ScheduleLine ScheduleLine 2
Batch Batch 1
BatchBySupplier BatchBySupplier 1
DelivDateCategory DelivDateCategory 2
GoodsIssueDate GoodsIssueDate 2
GoodsIssueTime GoodsIssueTime 2
LoadingDate LoadingDate 2
LoadingTime LoadingTime 2
PerformancePeriodEndDate PerformancePeriodEndDate 1
PerformancePeriodStartDate PerformancePeriodStartDate 1
ProductAvailabilityDate ProductAvailabilityDate 1
ProductAvailabilityTime ProductAvailabilityTime 1
PurchaseRequisition PurchaseRequisition 2
PurchaseRequisitionItem PurchaseRequisitionItem 2
RoughGoodsReceiptQty RoughGoodsReceiptQty 2
RouteSchedule RouteSchedule 1
SchedLineStscDeliveryDate SchedLineStscDeliveryDate 1
ScheduleLineCommittedQuantity ScheduleLineCommittedQuantity 1
ScheduleLineDeliveryDate ScheduleLineDeliveryDate 2
ScheduleLineDeliveryTime ScheduleLineDeliveryTime 2
ScheduleLineIsFixed ScheduleLineIsFixed 1
ScheduleLineOrderDate ScheduleLineOrderDate 1
ScheduleLineOrderQuantity ScheduleLineOrderQuantity 2
StockTransferDeliveredQuantity StockTransferDeliveredQuantity 1
STOLatestPossibleGRDate STOLatestPossibleGRDate 1
STOLatestPossibleGRTime STOLatestPossibleGRTime 1
TransportationPlanningDate TransportationPlanningDate 2
TransportationPlanningTime TransportationPlanningTime 2

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Purchasing Document Schedule Line
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE R_PURCHASINGDOCSCHEDULELINE (
    PURCHASINGDOCUMENT,
    PURCHASINGDOCUMENTITEM,
    SCHEDULELINE,
    BATCH,
    BATCHBYSUPPLIER,
    DELIVDATECATEGORY,
    GOODSISSUEDATE,
    GOODSISSUETIME,
    LOADINGDATE,
    LOADINGTIME,
    PERFORMANCEPERIODENDDATE,
    PERFORMANCEPERIODSTARTDATE,
    PRODUCTAVAILABILITYDATE,
    PRODUCTAVAILABILITYTIME,
    PURCHASEREQUISITION,
    PURCHASEREQUISITIONITEM,
    ROUGHGOODSRECEIPTQTY,
    ROUTESCHEDULE,
    SCHEDLINESTSCDELIVERYDATE,
    SCHEDULELINECOMMITTEDQUANTITY,
    SCHEDULELINEDELIVERYDATE,
    SCHEDULELINEDELIVERYTIME,
    SCHEDULELINEISFIXED,
    SCHEDULELINEORDERDATE,
    SCHEDULELINEORDERQUANTITY,
    STOCKTRANSFERDELIVEREDQUANTITY,
    STOLATESTPOSSIBLEGRDATE,
    STOLATESTPOSSIBLEGRTIME,
    TRANSPORTATIONPLANNINGDATE,
    TRANSPORTATIONPLANNINGTIME,
    PRIMARY KEY (PURCHASINGDOCUMENT, PURCHASINGDOCUMENTITEM, SCHEDULELINE)
);

Learn More