FPF_ORDER

Transparent Table Application Table
32 Fields 1 CDS Views

Payables Financing Order

FPF_ORDER is an SAP database table in S/4HANA. Payables Financing Order. It contains 32 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PayablesFinancingOrder view_entity from BASIC Payables Financing Order

Fields (32)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY finord_uuid fpf_finord_uuid
finord_id fpf_finord_id
financing_type fpf_financing_type
financing_system fpf_financing_system
finord_status fpf_finord_status
finord_amt fpf_finord_amt
finord_curr fpf_finord_curr
external_id fpf_finord_external_id
is_crdit_note_netting fpf_is_crntnet
supplier_id fpf_lifnr
paying_company_code fpf_paying_company_code
net_due_date fpf_due_date
baseline_date dzfbdt Baseline Date
cash_discount_1days dzbd1t Days 1
cash_discount_2days dzbd2t Days 2
net_payment_days dzbd3t Days Net
cash_discount_1percent dzbd1p CD Percentage 1
cash_discount_2percent dzbd2p CD Percentage 2
funder_id fpf_funder
funder_bank_type fpf_funder_bank_type
funder_bank_hash fpf_funder_bank_hash
financing_discount_type fpf_discount_type
payment_terms fpf_payment_terms
finord_cshdisc_amt fpf_cshdisc_amt
document_reference_id fpf_xblnr
payment_method fpf_payment_method
createdby abp_creation_user Created By
creationat abp_creation_tstmpl Created On
lastchangedby abp_locinst_lastchange_user Changed By
lastchangedat abp_locinst_lastchange_tstmpl Changed On
xblocked fpf_xblocked

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.

-- Payables Financing Order
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FPF_ORDER (
    MANDT,                    -- Client [mandt]
    FINORD_UUID,              -- fpf_finord_uuid
    FINORD_ID,                -- fpf_finord_id
    FINANCING_TYPE,           -- fpf_financing_type
    FINANCING_SYSTEM,         -- fpf_financing_system
    FINORD_STATUS,            -- fpf_finord_status
    FINORD_AMT,               -- fpf_finord_amt
    FINORD_CURR,              -- fpf_finord_curr
    EXTERNAL_ID,              -- fpf_finord_external_id
    IS_CRDIT_NOTE_NETTING,    -- fpf_is_crntnet
    SUPPLIER_ID,              -- fpf_lifnr
    PAYING_COMPANY_CODE,      -- fpf_paying_company_code
    NET_DUE_DATE,             -- fpf_due_date
    BASELINE_DATE,            -- Baseline Date [dzfbdt]
    CASH_DISCOUNT_1DAYS,      -- Days 1 [dzbd1t]
    CASH_DISCOUNT_2DAYS,      -- Days 2 [dzbd2t]
    NET_PAYMENT_DAYS,         -- Days Net [dzbd3t]
    CASH_DISCOUNT_1PERCENT,   -- CD Percentage 1 [dzbd1p]
    CASH_DISCOUNT_2PERCENT,   -- CD Percentage 2 [dzbd2p]
    FUNDER_ID,                -- fpf_funder
    FUNDER_BANK_TYPE,         -- fpf_funder_bank_type
    FUNDER_BANK_HASH,         -- fpf_funder_bank_hash
    FINANCING_DISCOUNT_TYPE,  -- fpf_discount_type
    PAYMENT_TERMS,            -- fpf_payment_terms
    FINORD_CSHDISC_AMT,       -- fpf_cshdisc_amt
    DOCUMENT_REFERENCE_ID,    -- fpf_xblnr
    PAYMENT_METHOD,           -- fpf_payment_method
    CREATEDBY,                -- Created By [abp_creation_user]
    CREATIONAT,               -- Created On [abp_creation_tstmpl]
    LASTCHANGEDBY,            -- Changed By [abp_locinst_lastchange_user]
    LASTCHANGEDAT,            -- Changed On [abp_locinst_lastchange_tstmpl]
    XBLOCKED,                 -- fpf_xblocked
    PRIMARY KEY (MANDT, FINORD_UUID)
);

Learn More