I_PURORDSCHEDULELINEBASIC

CDS View
15 Fields 5 CDS Views

Purchasing Document Schedule Line Basic

I_PURORDSCHEDULELINEBASIC is a CDS View in S/4HANA. Purchasing Document Schedule Line Basic. It contains 15 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
C_OverduePurchaseOrder view from CONSUMPTION Overdue Purchase Orders
C_POMassUpdtDelivSchedItm view from CONSUMPTION Delivery Schedule Lines
I_PurOrdScheduleLineAPI01 view from BASIC Schedule Line in Purchase Order
I_PurOrdScheduleLineTP view from TRANSACTIONAL Transactional View for PO Schedule Line
P_NumberOfScheduleLines view from CONSUMPTION Retrieves the number of schedule lines

Fields (15)

KeyField CDS FieldsUsed in Views
KEY PurchaseOrder PurchaseOrder 1
KEY PurchaseOrderItem PurchaseOrderItem 1
KEY PurchaseOrderScheduleLine ScheduleLine 1
_PurchaseRequisitionItem _PurchaseRequisitionItem 1
Batch Batch 1
BatchBySupplier BatchBySupplier 1
PerformancePeriodEndDate PerformancePeriodEndDate 1
PerformancePeriodStartDate PerformancePeriodStartDate 1
PurchaseOrderQuantityUnit PurchaseOrderQuantityUnit 1
PurchaseRequisition PurchaseRequisition 1
PurchaseRequisitionItem PurchaseRequisitionItem 1
RoughGoodsReceiptQty RoughGoodsReceiptQty 1
SchedLineStscDeliveryDate SchedLineStscDeliveryDate 1
ScheduleLineDeliveryDate ScheduleLineDeliveryDate 1
ScheduleLineOrderQuantity ScheduleLineOrderQuantity 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 Basic
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PURORDSCHEDULELINEBASIC (
    PURCHASEORDER,
    PURCHASEORDERITEM,
    PURCHASEORDERSCHEDULELINE,
    _PURCHASEREQUISITIONITEM,
    BATCH,
    BATCHBYSUPPLIER,
    PERFORMANCEPERIODENDDATE,
    PERFORMANCEPERIODSTARTDATE,
    PURCHASEORDERQUANTITYUNIT,
    PURCHASEREQUISITION,
    PURCHASEREQUISITIONITEM,
    ROUGHGOODSRECEIPTQTY,
    SCHEDLINESTSCDELIVERYDATE,
    SCHEDULELINEDELIVERYDATE,
    SCHEDULELINEORDERQUANTITY,
    PRIMARY KEY (PURCHASEORDER, PURCHASEORDERITEM, PURCHASEORDERSCHEDULELINE)
);

Learn More