FARR_CONTRMNLFFD

Transparent Table Application Table
35 Fields 1 CDS Views

Draft Table for C_RAContrMnlFlfmtTP

FARR_CONTRMNLFFD is an SAP database table in S/4HANA. Draft Table for C_RAContrMnlFlfmtTP. It contains 35 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_RAContrMnlFlfmtDraft view_entity from BASIC

Fields (35)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY revenueaccountingcontract farr_cds_contract_id Revenue Contract
companycode bukrs Company Code
companycodename butxt Company Name
accountingprinciple accounting_principle Accounting Principle
businesspartner bu_partner Busn. Partner
businesspartnername farr_cds_business_partner_name BusPartName
revnacctgcontractdescription farr_description Description
customer kunnr Customer
customername md_customer_name Name of Customer
totcontractualprcinslsdoccrcy farr_cds_contractual_price Contractual Price
alloceffctamountinsalesdoccrcy farr_corr_amt Allocation Effect
racontracthasallocationeffect farr_cds_has_alloc_effect Has Allocation Effect
salesdocumentcurrency waers Currency
revnacctgsalesorganization farr_sales_org Sales Org.
salesorganizationname salesorganizationname Sales Organization Description
numberofperformanceobligations farr_cds_num_of_pobs Number of Performance Obligations
revnacctgcontractstatus farr_contract_status Contract Status
revnacctgcontractstatusname farr_cds_contr_status_text Contract Status Description
racontractstatuscriticality int1 INT1
racontractlastsaveddatetime timestampl Time Stamp
revnacctgcontractcreationdate fis_cc_erfdt Created On
revnacctgcontractcreatedbyuser fis_cc_erfnm Created By
createdbyuserdescription vdm_userdescription Description
isbusinesspurposecompleted farr_dpp_is_blocked Blocked
racontractlastchangedbyusr fis_aufaenam Last Changed By
lastchangedbyuserdescription vdm_userdescription Description
racontractcompletiondate farr_cds_contr_completion_date Completion Date
racontracthasassetsimpairment farr_cds_has_impair_of_assets Contract was Terminated Early
revncontrassetsimpairmentdate farr_asset_impairment_date Contr. Term. Date
ratiounit farr_quantity_unit Unit of Measure
recognizedrevnuptocurperdpct farr_fulfilled_rev_progress Revenue Fulfillment Progress
uptocurperiodrecognizedrevenue farr_recog_amt Recognizable Revenue
ratotalopenrevninslsdoccrcy farr_open_revenue Open Revenue
racontractiscreatedbycontrmgr farr_rar_version_code RAR version code

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.

-- Draft Table for C_RAContrMnlFlfmtTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FARR_CONTRMNLFFD (
    MANDT,                           -- Client [mandt]
    REVENUEACCOUNTINGCONTRACT,       -- Revenue Contract [farr_cds_contract_id]
    COMPANYCODE,                     -- Company Code [bukrs]
    COMPANYCODENAME,                 -- Company Name [butxt]
    ACCOUNTINGPRINCIPLE,             -- Accounting Principle [accounting_principle]
    BUSINESSPARTNER,                 -- Busn. Partner [bu_partner]
    BUSINESSPARTNERNAME,             -- BusPartName [farr_cds_business_partner_name]
    REVNACCTGCONTRACTDESCRIPTION,    -- Description [farr_description]
    CUSTOMER,                        -- Customer [kunnr]
    CUSTOMERNAME,                    -- Name of Customer [md_customer_name]
    TOTCONTRACTUALPRCINSLSDOCCRCY,   -- Contractual Price [farr_cds_contractual_price]
    ALLOCEFFCTAMOUNTINSALESDOCCRCY,  -- Allocation Effect [farr_corr_amt]
    RACONTRACTHASALLOCATIONEFFECT,   -- Has Allocation Effect [farr_cds_has_alloc_effect]
    SALESDOCUMENTCURRENCY,           -- Currency [waers]
    REVNACCTGSALESORGANIZATION,      -- Sales Org. [farr_sales_org]
    SALESORGANIZATIONNAME,           -- Sales Organization Description [salesorganizationname]
    NUMBEROFPERFORMANCEOBLIGATIONS,  -- Number of Performance Obligations [farr_cds_num_of_pobs]
    REVNACCTGCONTRACTSTATUS,         -- Contract Status [farr_contract_status]
    REVNACCTGCONTRACTSTATUSNAME,     -- Contract Status Description [farr_cds_contr_status_text]
    RACONTRACTSTATUSCRITICALITY,     -- INT1 [int1]
    RACONTRACTLASTSAVEDDATETIME,     -- Time Stamp [timestampl]
    REVNACCTGCONTRACTCREATIONDATE,   -- Created On [fis_cc_erfdt]
    REVNACCTGCONTRACTCREATEDBYUSER,  -- Created By [fis_cc_erfnm]
    CREATEDBYUSERDESCRIPTION,        -- Description [vdm_userdescription]
    ISBUSINESSPURPOSECOMPLETED,      -- Blocked [farr_dpp_is_blocked]
    RACONTRACTLASTCHANGEDBYUSR,      -- Last Changed By [fis_aufaenam]
    LASTCHANGEDBYUSERDESCRIPTION,    -- Description [vdm_userdescription]
    RACONTRACTCOMPLETIONDATE,        -- Completion Date [farr_cds_contr_completion_date]
    RACONTRACTHASASSETSIMPAIRMENT,   -- Contract was Terminated Early [farr_cds_has_impair_of_assets]
    REVNCONTRASSETSIMPAIRMENTDATE,   -- Contr. Term. Date [farr_asset_impairment_date]
    RATIOUNIT,                       -- Unit of Measure [farr_quantity_unit]
    RECOGNIZEDREVNUPTOCURPERDPCT,    -- Revenue Fulfillment Progress [farr_fulfilled_rev_progress]
    UPTOCURPERIODRECOGNIZEDREVENUE,  -- Recognizable Revenue [farr_recog_amt]
    RATOTALOPENREVNINSLSDOCCRCY,     -- Open Revenue [farr_open_revenue]
    RACONTRACTISCREATEDBYCONTRMGR,   -- RAR version code [farr_rar_version_code]
    PRIMARY KEY (MANDT, REVENUEACCOUNTINGCONTRACT)
);

Learn More