I_SUPLRFRTINVCREQUESTITEM

CDS View
6 Fields 6 CDS Views

Supplier Freight Invoice Request Item

I_SUPLRFRTINVCREQUESTITEM is a CDS View in S/4HANA. Supplier Freight Invoice Request Item. It contains 6 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
C_CollabnApplMngFrtOrdChrgNote view_entity inner CONSUMPTION Freight Order Charges Notes
C_FreightSettlementAccrualItem view_entity from CONSUMPTION Supplier Freight Invoice Request Item
I_FrtCarrInvcInvcAmt view_entity from COMPOSITE Invoice Amount for Freight Carrier Invc
I_FrtCarrInvcVarcAmt view_entity from COMPOSITE Variance Amount for Freight Carrier Invoice
P_CollabnApplCarrInvcReqItem view_entity from CONSUMPTION Carrier Invoice Items
P_CollabnFrtOrdChrgFilterFo view from CONSUMPTION Private view to exclude FO with invoice

Fields (6)

KeyField CDS FieldsUsed in Views
KEY SuplrFrtInvcReqItemUUID FrtCarrInvcItemUUID,SuplrFrtInvcReqItemUUID 3
KEY SuplrFrtInvcReqUUID FrtCarrInvcUUID,SuplrFrtInvcReqUUID 4
KEY TransportationOrderUUID TransportationOrderUUID 5
SupplierFreightInvoiceReqItem SupplierFreightInvoiceReqItem 1
TransportationOrderItemUUID TransportationOrderItemUUID 2
TransportationOrderStageUUID TransportationOrderStageUUID 2

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.

-- Supplier Freight Invoice Request Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SUPLRFRTINVCREQUESTITEM (
    SUPLRFRTINVCREQITEMUUID,
    SUPLRFRTINVCREQUUID,
    TRANSPORTATIONORDERUUID,
    SUPPLIERFREIGHTINVOICEREQITEM,
    TRANSPORTATIONORDERITEMUUID,
    TRANSPORTATIONORDERSTAGEUUID,
    PRIMARY KEY (SUPLRFRTINVCREQITEMUUID, SUPLRFRTINVCREQUUID, TRANSPORTATIONORDERUUID)
);

Learn More