R_PURCHASINGDOCSCHEDULELINE

CDS View
25 Fields 1 CDS Views

Purchasing Document Schedule Line

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_PurchaseOrderScheduleLine view from BASIC Purchase Order Schedule Line

Fields (25)

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

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