FTRF_FDOC

Transparent Table Application Table

Receivables Financing Document

FTRF_FDOC is an SAP database table in S/4HANA. Receivables Financing Document. It contains 23 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_RblsFinancingDoc view_entity from BASIC Receivables Financing Document

Fields (23)

KeyField Data ElementDescription DomainTypeLength
KEY client abap.clnt
KEY document_uuid FTRF_FINANCING_DOC_UUID Document UUID
document_id FTRF_FINANCING_DOC_ID Document ID
document_external_id FTRF_FINANCING_DOC_EXTID Document External ID
financing_type FTRF_FINANCING_TYPE Financing Type
document_status FTRF_FINANCING_DOC_STATUS Document Status
document_date FTRF_FINANCING_DOC_DATE Document Date
agrmt_uuid FTRF_AGRMT_UUID Agreement UUID
funder_id FTRF_FUNDER Funder
funder_bank_account_id FTRF_FUNDER_BANK_ACCT_ID Financing Funder Bank Account ID
application FRP_RP_APPL Application
company_code FIS_BUKRS Company Code
transaction_currency FTRF_CURRENCY Currency
prepayment_amount FTRF_PREPAYMENT_AMT Prepayment
financing_fee_amount FTRF_FEE_AMT Financing Fee
financing_fee_pct FTRF_FEE_PCT Financing Fee (%)
maturity_payment_amount FTRF_MATURITY_AMT Maturity Payment
maturity_payment_date FTRF_MATURITY_DUE Maturity Payment Due
created_by ABP_CREATION_USER Created By
created_at ABP_CREATION_TSTMPL Created On
last_changed_by ABP_LOCINST_LASTCHANGE_USER Changed By
last_changed_at ABP_LOCINST_LASTCHANGE_TSTMPL Changed On
xblocked FTRF_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.

-- Receivables Financing Document
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FTRF_FDOC (
    CLIENT,                   -- abap.clnt
    DOCUMENT_UUID,            -- Document UUID [FTRF_FINANCING_DOC_UUID]
    DOCUMENT_ID,              -- Document ID [FTRF_FINANCING_DOC_ID]
    DOCUMENT_EXTERNAL_ID,     -- Document External ID [FTRF_FINANCING_DOC_EXTID]
    FINANCING_TYPE,           -- Financing Type [FTRF_FINANCING_TYPE]
    DOCUMENT_STATUS,          -- Document Status [FTRF_FINANCING_DOC_STATUS]
    DOCUMENT_DATE,            -- Document Date [FTRF_FINANCING_DOC_DATE]
    AGRMT_UUID,               -- Agreement UUID [FTRF_AGRMT_UUID]
    FUNDER_ID,                -- Funder [FTRF_FUNDER]
    FUNDER_BANK_ACCOUNT_ID,   -- Financing Funder Bank Account ID [FTRF_FUNDER_BANK_ACCT_ID]
    APPLICATION,              -- Application [FRP_RP_APPL]
    COMPANY_CODE,             -- Company Code [FIS_BUKRS]
    TRANSACTION_CURRENCY,     -- Currency [FTRF_CURRENCY]
    PREPAYMENT_AMOUNT,        -- Prepayment [FTRF_PREPAYMENT_AMT]
    FINANCING_FEE_AMOUNT,     -- Financing Fee [FTRF_FEE_AMT]
    FINANCING_FEE_PCT,        -- Financing Fee (%) [FTRF_FEE_PCT]
    MATURITY_PAYMENT_AMOUNT,  -- Maturity Payment [FTRF_MATURITY_AMT]
    MATURITY_PAYMENT_DATE,    -- Maturity Payment Due [FTRF_MATURITY_DUE]
    CREATED_BY,               -- Created By [ABP_CREATION_USER]
    CREATED_AT,               -- Created On [ABP_CREATION_TSTMPL]
    LAST_CHANGED_BY,          -- Changed By [ABP_LOCINST_LASTCHANGE_USER]
    LAST_CHANGED_AT,          -- Changed On [ABP_LOCINST_LASTCHANGE_TSTMPL]
    XBLOCKED,                 -- Purpose Completed [FTRF_XBLOCKED]
    PRIMARY KEY (CLIENT, DOCUMENT_UUID)
);