SUPPLIERFREIGHTINVOICE

SUPPLIERFREIGHTINVOICE is an SAP database table in S/4HANA. It contains 13 fields.

Fields (13)

KeyField CDS FieldsUsed in Views
KEY SuplrFrtInvcReqUUID SuplrFrtInvcReqUUID 1
BillFromPtyBusPrpsIsCompleted BillFromPtyBusPrpsIsCompleted 1
CarrierBusPurposeIsCompleted CarrierBusPurposeIsCompleted 1
CarrierUUID CarrierUUID 1
FrtCarrInvcID FrtCarrInvcID 1
InvoiceDate InvoiceDate 1
PayeeBusPurposeIsCompleted PayeeBusPurposeIsCompleted 1
PaymentTerms PaymentTerms 1
PurchasingGroupExternalID PurchasingGroupExternalID 1
PurchasingOrgExternalID PurchasingOrgExternalID 1
PurgOrgCompanyCode PurgOrgCompanyCode 1
SuplrFrtInvcReqCategory SuplrFrtInvcReqCategory 1
SuplrFrtInvcReqType SuplrFrtInvcReqType 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SUPPLIERFREIGHTINVOICE (
    SUPLRFRTINVCREQUUID,
    BILLFROMPTYBUSPRPSISCOMPLETED,
    CARRIERBUSPURPOSEISCOMPLETED,
    CARRIERUUID,
    FRTCARRINVCID,
    INVOICEDATE,
    PAYEEBUSPURPOSEISCOMPLETED,
    PAYMENTTERMS,
    PURCHASINGGROUPEXTERNALID,
    PURCHASINGORGEXTERNALID,
    PURGORGCOMPANYCODE,
    SUPLRFRTINVCREQCATEGORY,
    SUPLRFRTINVCREQTYPE,
    PRIMARY KEY (SUPLRFRTINVCREQUUID)
);