FTRF_FDOC
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_RblsFinancingDoc | view_entity | from | BASIC | Receivables Financing Document |
Fields (23)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | client | abap.clnt | ||||
| KEY | document_uuid | ftrf_financing_doc_uuid | ||||
| document_id | ftrf_financing_doc_id | |||||
| document_external_id | ftrf_financing_doc_extid | |||||
| financing_type | ftrf_financing_type | |||||
| document_status | ftrf_financing_doc_status | |||||
| document_date | ftrf_financing_doc_date | |||||
| agrmt_uuid | ftrf_agrmt_uuid | |||||
| funder_id | ftrf_funder | |||||
| funder_bank_account_id | ftrf_funder_bank_acct_id | |||||
| application | frp_rp_appl | |||||
| company_code | fis_bukrs | Company Code | ||||
| transaction_currency | ftrf_currency | |||||
| prepayment_amount | ftrf_prepayment_amt | |||||
| financing_fee_amount | ftrf_fee_amt | |||||
| financing_fee_pct | ftrf_fee_pct | |||||
| maturity_payment_amount | ftrf_maturity_amt | |||||
| maturity_payment_date | ftrf_maturity_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 |
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, -- ftrf_financing_doc_uuid
DOCUMENT_ID, -- ftrf_financing_doc_id
DOCUMENT_EXTERNAL_ID, -- ftrf_financing_doc_extid
FINANCING_TYPE, -- ftrf_financing_type
DOCUMENT_STATUS, -- ftrf_financing_doc_status
DOCUMENT_DATE, -- ftrf_financing_doc_date
AGRMT_UUID, -- ftrf_agrmt_uuid
FUNDER_ID, -- ftrf_funder
FUNDER_BANK_ACCOUNT_ID, -- ftrf_funder_bank_acct_id
APPLICATION, -- frp_rp_appl
COMPANY_CODE, -- Company Code [fis_bukrs]
TRANSACTION_CURRENCY, -- ftrf_currency
PREPAYMENT_AMOUNT, -- ftrf_prepayment_amt
FINANCING_FEE_AMOUNT, -- ftrf_fee_amt
FINANCING_FEE_PCT, -- ftrf_fee_pct
MATURITY_PAYMENT_AMOUNT, -- ftrf_maturity_amt
MATURITY_PAYMENT_DATE, -- 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, -- ftrf_xblocked
PRIMARY KEY (CLIENT, DOCUMENT_UUID)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA