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 Financing Order UUID
finord_id FPF_FINORD_ID Financing Order ID
financing_type FPF_FINANCING_TYPE Financing Type
financing_system FPF_FINANCING_SYSTEM Financing System
finord_status FPF_FINORD_STATUS Status
finord_amt FPF_FINORD_AMT Amount
finord_curr FPF_FINORD_CURR Financing Order Curr
external_id FPF_FINORD_EXTERNAL_ID External ID
is_crdit_note_netting FPF_IS_CRNTNET Credit Note Netting
supplier_id FPF_LIFNR Supplier
paying_company_code FPF_PAYING_COMPANY_CODE Paying Company Code
net_due_date FPF_DUE_DATE 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
funder_bank_type FPF_FUNDER_BANK_TYPE Funder Bank Type
funder_bank_hash FPF_FUNDER_BANK_HASH Funder Bank Hash
financing_discount_type FPF_DISCOUNT_TYPE Discount Type
payment_terms FPF_PAYMENT_TERMS Payment Terms
finord_cshdisc_amt FPF_CSHDISC_AMT Cash Discount Amount
document_reference_id FPF_XBLNR Reference
payment_method FPF_PAYMENT_METHOD 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 Purpose Completed

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,              -- Financing Order UUID [FPF_FINORD_UUID]
    FINORD_ID,                -- Financing Order ID [FPF_FINORD_ID]
    FINANCING_TYPE,           -- Financing Type [FPF_FINANCING_TYPE]
    FINANCING_SYSTEM,         -- Financing System [FPF_FINANCING_SYSTEM]
    FINORD_STATUS,            -- Status [FPF_FINORD_STATUS]
    FINORD_AMT,               -- Amount [FPF_FINORD_AMT]
    FINORD_CURR,              -- Financing Order Curr [FPF_FINORD_CURR]
    EXTERNAL_ID,              -- External ID [FPF_FINORD_EXTERNAL_ID]
    IS_CRDIT_NOTE_NETTING,    -- Credit Note Netting [FPF_IS_CRNTNET]
    SUPPLIER_ID,              -- Supplier [FPF_LIFNR]
    PAYING_COMPANY_CODE,      -- Paying Company Code [FPF_PAYING_COMPANY_CODE]
    NET_DUE_DATE,             -- 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,                -- Funder [FPF_FUNDER]
    FUNDER_BANK_TYPE,         -- Funder Bank Type [FPF_FUNDER_BANK_TYPE]
    FUNDER_BANK_HASH,         -- Funder Bank Hash [FPF_FUNDER_BANK_HASH]
    FINANCING_DISCOUNT_TYPE,  -- Discount Type [FPF_DISCOUNT_TYPE]
    PAYMENT_TERMS,            -- Payment Terms [FPF_PAYMENT_TERMS]
    FINORD_CSHDISC_AMT,       -- Cash Discount Amount [FPF_CSHDISC_AMT]
    DOCUMENT_REFERENCE_ID,    -- Reference [FPF_XBLNR]
    PAYMENT_METHOD,           -- 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,                 -- Purpose Completed [FPF_XBLOCKED]
    PRIMARY KEY (MANDT, FINORD_UUID)
);

Learn More