P_POITMSCHDLNLASTPOSTGDTEENHCD

CDS View
28 Fields 1 CDS Views

PO Item Schd Line Last Posting Date

P_POITMSCHDLNLASTPOSTGDTEENHCD is a CDS View in S/4HANA. PO Item Schd Line Last Posting Date. It contains 28 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_POItemClosedScheduleLines view inner CONSUMPTION PO Item Closed Schedule Line

Fields (28)

KeyField CDS FieldsUsed in Views
KEY PurchaseOrder PurchaseOrder 1
KEY PurchaseOrderItem PurchaseOrderItem 1
KEY ScheduleLine ScheduleLine 1
AccountAssignmentCategory AccountAssignmentCategory 1
diff_create ExpectedNoOfDays 1
diff_create_giposting ActualNoOfDays 1
diff_giposting DelayInNoOfDays 1
ItemIncotermsClassification ItemIncotermsClassification 1
ItemIncotermsLocation1 ItemIncotermsLocation1 1
ItemIncotermsLocation2 ItemIncotermsLocation2 1
ItemIncotermsTransferLocation ItemIncotermsTransferLocation 1
LastPostingDate LastPostingDate 1
Material Material 1
MaterialGroup MaterialGroup 1
Plant Plant 1
POIncotermsClassification POIncotermsClassification 1
POIncotermsLocation1 POIncotermsLocation1 1
POIncotermsLocation2 POIncotermsLocation2 1
POIncotermsTransferLocation POIncotermsTransferLocation 1
PreviousMonthDate PreviousMonthDate 1
PreviousWeekDate PreviousWeekDate 1
PurchaseOrderDate PurchaseOrderDate 1
PurchaseOrderItemQty OrderQuantity 1
PurchaseOrderQuantityUnit PurchaseOrderQuantityUnit 1
SchedLineStscDeliveryDate SchedLineStscDeliveryDate 1
ScheduleLineOrderQuantity ScheduleLineOrderQuantity 1
Supplier Supplier 1
SupplyingPlant SupplyingPlant 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.

-- PO Item Schd Line Last Posting Date
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_POITMSCHDLNLASTPOSTGDTEENHCD (
    PURCHASEORDER,
    PURCHASEORDERITEM,
    SCHEDULELINE,
    ACCOUNTASSIGNMENTCATEGORY,
    DIFF_CREATE,
    DIFF_CREATE_GIPOSTING,
    DIFF_GIPOSTING,
    ITEMINCOTERMSCLASSIFICATION,
    ITEMINCOTERMSLOCATION1,
    ITEMINCOTERMSLOCATION2,
    ITEMINCOTERMSTRANSFERLOCATION,
    LASTPOSTINGDATE,
    MATERIAL,
    MATERIALGROUP,
    PLANT,
    POINCOTERMSCLASSIFICATION,
    POINCOTERMSLOCATION1,
    POINCOTERMSLOCATION2,
    POINCOTERMSTRANSFERLOCATION,
    PREVIOUSMONTHDATE,
    PREVIOUSWEEKDATE,
    PURCHASEORDERDATE,
    PURCHASEORDERITEMQTY,
    PURCHASEORDERQUANTITYUNIT,
    SCHEDLINESTSCDELIVERYDATE,
    SCHEDULELINEORDERQUANTITY,
    SUPPLIER,
    SUPPLYINGPLANT,
    PRIMARY KEY (PURCHASEORDER, PURCHASEORDERITEM, SCHEDULELINE)
);

Learn More