I_CNTRLPURORDERSCHEDULELINE

CDS View
36 Fields 13 CDS Views

Central Purchase Order Schedule Line

I_CNTRLPURORDERSCHEDULELINE is a CDS View in S/4HANA. Central Purchase Order Schedule Line. It contains 36 fields. 13 CDS views read from this table.

CDS Views using this table (13)

ViewTypeJoinVDMDescription
C_CntrlPOItemNextDelivery view left_outer CONSUMPTION Central PO Item Next Delivery
I_CntrlPurOrderScheduleLineTP view from TRANSACTIONAL Central Purchase Order Schedule Line
I_PrmtHbPurOrdItmSchdLnAPI01 view from BASIC Schedule Line of Purchase Order in Procurement Hub
P_AnaHubPurOrdSchdlnMigrData view inner CONSUMPTION Migration data for Hub po Schedule line
P_CntrlPOItemDeliveryDuration view from CONSUMPTION Central PO Item Delivery Duration
P_CntrlPOItemGRQuantity view from CONSUMPTION Central PO Item GR Quantity
P_CntrlPOItemNextDelivery view inner CONSUMPTION Central PO Item Next Delivery
P_CntrlPOItemNextDelivery1 view from CONSUMPTION Central PO Item Next Delivery 1
P_CNTRLPOITEMSCHDLNDELIVERY view from CONSUMPTION Central PO Item Delivery Duration
P_PrmtHbPOSingleScheduleLine view inner COMPOSITE Get data of only one Schedule Line
P_PrmtHbPurOrdSchedLineHelp1 view from COMPOSITE Helper view to get only one Schedule Line
P_PrmtHbPurOrdSchedLineHelp2 view inner COMPOSITE Helper view to get only one Schedule Line
P_PrmtHbPurOrdSchedLineHelp3 view inner COMPOSITE Helper view to get only one Schedule Line

Fields (36)

KeyField CDS FieldsUsed in Views
KEY ExtSourceSystem ExtSourceSystem 5
KEY PurchaseOrder ebeln,PurchaseOrder 6
KEY PurchaseOrderItem ebelp,PurchaseOrderItem 6
KEY ScheduleLine etenr,ScheduleLine 3
KEY ScheduleLineDeliveryDate eindt,ScheduleLineDeliveryDate 4
CommittedDeliveryDate dat01 1
DelivDateCategory DelivDateCategory,lpein 2
GoodsIssueDate wadat 1
GoodsIssueTime wauhr 1
LoadingDate lddat 1
LoadingTime lduhr 1
MaterialStagingTime mbuhr 1
NoOfRemindersOfScheduleLine mahnz 1
PerformancePeriodEndDate enddate,PerformancePeriodEndDate 3
PerformancePeriodStartDate PerformancePeriodStartDate,startdate 3
PrevDelivQtyOfScheduleLine ameng 1
ProductAvailabilityDate mbdat 1
PurchaseOrderQuantityUnit PurchaseOrderQuantityUnit 1
PurchaseRequisition banfn,PurchaseRequisition 2
PurchaseRequisitionItem bnfpo,PurchaseRequisitionItem 2
RoughGoodsReceiptQty RoughGoodsReceiptQty,wemng 2
SchedgLineDataAgingFilterDate _dataaging 1
SchedLinePrevDelivDate altdt 1
SchedLineStscDeliveryDate SchedLineStscDeliveryDate,slfdt 2
ScheduleLineCommittedQuantity mng02 1
ScheduleLineDeliveryTime ScheduleLineDeliveryTime,uzeit 2
ScheduleLineIsFixed fixkz 1
ScheduleLineIssuedQuantity wamng 1
ScheduleLineOrderDate bedat 1
ScheduleLineOrderQuantity menge,ScheduleLineOrderQuantity 2
SchedulingAgreementReleaseType abart 1
SourceOfCreation estkz 1
STOLatestPossibleGRDate eldat 1
STOLatestPossibleGRTime eluhr 1
TransportationPlanningDate tddat 1
TransportationPlanningTime tduhr 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.

-- Central Purchase Order Schedule Line
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CNTRLPURORDERSCHEDULELINE (
    EXTSOURCESYSTEM,
    PURCHASEORDER,
    PURCHASEORDERITEM,
    SCHEDULELINE,
    SCHEDULELINEDELIVERYDATE,
    COMMITTEDDELIVERYDATE,
    DELIVDATECATEGORY,
    GOODSISSUEDATE,
    GOODSISSUETIME,
    LOADINGDATE,
    LOADINGTIME,
    MATERIALSTAGINGTIME,
    NOOFREMINDERSOFSCHEDULELINE,
    PERFORMANCEPERIODENDDATE,
    PERFORMANCEPERIODSTARTDATE,
    PREVDELIVQTYOFSCHEDULELINE,
    PRODUCTAVAILABILITYDATE,
    PURCHASEORDERQUANTITYUNIT,
    PURCHASEREQUISITION,
    PURCHASEREQUISITIONITEM,
    ROUGHGOODSRECEIPTQTY,
    SCHEDGLINEDATAAGINGFILTERDATE,
    SCHEDLINEPREVDELIVDATE,
    SCHEDLINESTSCDELIVERYDATE,
    SCHEDULELINECOMMITTEDQUANTITY,
    SCHEDULELINEDELIVERYTIME,
    SCHEDULELINEISFIXED,
    SCHEDULELINEISSUEDQUANTITY,
    SCHEDULELINEORDERDATE,
    SCHEDULELINEORDERQUANTITY,
    SCHEDULINGAGREEMENTRELEASETYPE,
    SOURCEOFCREATION,
    STOLATESTPOSSIBLEGRDATE,
    STOLATESTPOSSIBLEGRTIME,
    TRANSPORTATIONPLANNINGDATE,
    TRANSPORTATIONPLANNINGTIME,
    PRIMARY KEY (EXTSOURCESYSTEM, PURCHASEORDER, PURCHASEORDERITEM, SCHEDULELINE, SCHEDULELINEDELIVERYDATE)
);

Learn More