R_PURCHASINGDOCSCHEDULELINE

CDS View
25 Fields 2 CDS Views

Purchasing Document Schedule Line

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

CDS Views using this table (2)

ViewTypeJoinVDMDescription
R_PPS_PurOrderScheduleLine view_entity from COMPOSITE Purchase Order Schedule Line
R_PurchaseOrderScheduleLine view from BASIC Purchase Order Schedule Line

Fields (25)

KeyField CDS FieldsUsed in Views
KEY PurchasingDocument PurchaseOrder 2
KEY PurchasingDocumentItem PurchaseOrderItem 2
KEY ScheduleLine ScheduleLine 2
Batch Batch 2
BatchBySupplier BatchBySupplier 2
DelivDateCategory DelivDateCategory 2
GoodsIssueDate GoodsIssueDate 2
GoodsIssueTime GoodsIssueTime 2
LoadingDate LoadingDate 2
LoadingTime LoadingTime 2
PerformancePeriodEndDate PerformancePeriodEndDate 2
PerformancePeriodStartDate PerformancePeriodStartDate 2
ProductAvailabilityDate ProductAvailabilityDate 2
ProductAvailabilityTime ProductAvailabilityTime 2
PurchaseRequisition PurchaseRequisition 2
PurchaseRequisitionItem PurchaseRequisitionItem 2
RoughGoodsReceiptQty RoughGoodsReceiptQty 2
RouteSchedule RouteSchedule 2
SchedLineStscDeliveryDate SchedLineStscDeliveryDate 2
ScheduleLineDeliveryDate ScheduleLineDeliveryDate 2
ScheduleLineDeliveryTime ScheduleLineDeliveryTime 2
ScheduleLineOrderDate ScheduleLineOrderDate 2
ScheduleLineOrderQuantity ScheduleLineOrderQuantity 2
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,
    SCHEDULELINEDELIVERYDATE,
    SCHEDULELINEDELIVERYTIME,
    SCHEDULELINEORDERDATE,
    SCHEDULELINEORDERQUANTITY,
    TRANSPORTATIONPLANNINGDATE,
    TRANSPORTATIONPLANNINGTIME,
    PRIMARY KEY (PURCHASINGDOCUMENT, PURCHASINGDOCUMENTITEM, SCHEDULELINE)
);

Learn More