FPF_ORDER_ITM

Transparent Table Application Table
23 Fields 1 CDS Views

Payables Financing Order Item

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PayablesFinancingOrderItem view_entity from BASIC Payables Financing Order Item

Fields (23)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY finord_uuid FPF_FINORD_UUID Financing Order UUID
KEY finord_itm_uuid FPF_FINORD_ITM_UUID FinOrd Item UUID
finord_id FPF_FINORD_ID Financing Order ID
finord_itm_type FPF_FINORD_ITM_TYPE FinOrd Item Type
finord_itm_amt FPF_FINORD_ITM_AMT Amount
finord_curr FPF_FINORD_CURR Financing Order Curr
company_code FPF_BUKRS Company Code
fiscal_year FPF_GJAHR Fiscal Year
accounting_doc FPF_BELNR Journal Entry
accounting_doc_itm BUZEI Item
original_payee_bkhash FPF_ORIG_PAYEE_BKHASH Ori Payee Bank Hash
original_payee FPF_ORIG_PAYEE Original Payee
original_payee_bank_type FPF_ORIG_BANK_TYPE Ori Payee Bank Type
original_payment_terms FPF_ORIG_PAYT_TERMS Ori Payment Terms
original_baseline_date FPF_ORIG_BASELINE_DATE Ori Baseline Date
original_cshdisc_amt FPF_ORIG_CSHDISC_AMT Ori Cash Disct Amt
original_cshdisc_1days FPF_ORIG_CSHDISC_1DAYS Ori Cash Disct 1 Day
original_cshdisc_2days FPF_ORIG_CSHDISC_2DAYS Ori Cash Disct 2 Day
original_net_payt_days FPF_ORIG_NET_PAYT_DAYS Ori Net Payment Days
original_cshdisc_1per FPF_ORIG_CSHDISC_1PER Ori Cash Disct 1 Per
original_cshdisc_2per FPF_ORIG_CSHDISC_2PER Ori Cash Disct 2 Per
original_payment_method FPF_ORIG_PAYT_METHOD Ori Payment Method

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 Item
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FPF_ORDER_ITM (
    MANDT,                     -- Client [MANDT]
    FINORD_UUID,               -- Financing Order UUID [FPF_FINORD_UUID]
    FINORD_ITM_UUID,           -- FinOrd Item UUID [FPF_FINORD_ITM_UUID]
    FINORD_ID,                 -- Financing Order ID [FPF_FINORD_ID]
    FINORD_ITM_TYPE,           -- FinOrd Item Type [FPF_FINORD_ITM_TYPE]
    FINORD_ITM_AMT,            -- Amount [FPF_FINORD_ITM_AMT]
    FINORD_CURR,               -- Financing Order Curr [FPF_FINORD_CURR]
    COMPANY_CODE,              -- Company Code [FPF_BUKRS]
    FISCAL_YEAR,               -- Fiscal Year [FPF_GJAHR]
    ACCOUNTING_DOC,            -- Journal Entry [FPF_BELNR]
    ACCOUNTING_DOC_ITM,        -- Item [BUZEI]
    ORIGINAL_PAYEE_BKHASH,     -- Ori Payee Bank Hash [FPF_ORIG_PAYEE_BKHASH]
    ORIGINAL_PAYEE,            -- Original Payee [FPF_ORIG_PAYEE]
    ORIGINAL_PAYEE_BANK_TYPE,  -- Ori Payee Bank Type [FPF_ORIG_BANK_TYPE]
    ORIGINAL_PAYMENT_TERMS,    -- Ori Payment Terms [FPF_ORIG_PAYT_TERMS]
    ORIGINAL_BASELINE_DATE,    -- Ori Baseline Date [FPF_ORIG_BASELINE_DATE]
    ORIGINAL_CSHDISC_AMT,      -- Ori Cash Disct Amt [FPF_ORIG_CSHDISC_AMT]
    ORIGINAL_CSHDISC_1DAYS,    -- Ori Cash Disct 1 Day [FPF_ORIG_CSHDISC_1DAYS]
    ORIGINAL_CSHDISC_2DAYS,    -- Ori Cash Disct 2 Day [FPF_ORIG_CSHDISC_2DAYS]
    ORIGINAL_NET_PAYT_DAYS,    -- Ori Net Payment Days [FPF_ORIG_NET_PAYT_DAYS]
    ORIGINAL_CSHDISC_1PER,     -- Ori Cash Disct 1 Per [FPF_ORIG_CSHDISC_1PER]
    ORIGINAL_CSHDISC_2PER,     -- Ori Cash Disct 2 Per [FPF_ORIG_CSHDISC_2PER]
    ORIGINAL_PAYMENT_METHOD,   -- Ori Payment Method [FPF_ORIG_PAYT_METHOD]
    PRIMARY KEY (MANDT, FINORD_UUID, FINORD_ITM_UUID)
);

Learn More