I_PURORDITEMDELIVERYADDRESS

CDS View

Delivery Address in Purchase Order Item

I_PURORDITEMDELIVERYADDRESS is a CDS View in S/4HANA. Delivery Address in Purchase Order Item. It contains 4 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_PODeliveryAddressFactSheet view from CONSUMPTION Purchase Order Fact Sheet Delivery Address
I_PurOrdDeliveryAddressTP view from TRANSACTIONAL Transactional View for Delivery Address in Purchase Order

Fields (4)

KeyField CDS FieldsUsed in Views
KEY PurchaseOrder PurchaseOrder 2
KEY PurchaseOrderItem PurchaseOrderItem 2
ItemDeliveryAddressID ItemDeliveryAddressID 1
ReferenceDeliveryAddressID ReferenceDeliveryAddressID 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.

-- Delivery Address in Purchase Order Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PURORDITEMDELIVERYADDRESS (
    PURCHASEORDER,
    PURCHASEORDERITEM,
    ITEMDELIVERYADDRESSID,
    REFERENCEDELIVERYADDRESSID,
    PRIMARY KEY (PURCHASEORDER, PURCHASEORDERITEM)
);