FARR_D_CONTR_D

Transparent Table Application Table
33 Fields 1 CDS Views

Draft Table for Revenue Accounting Contract

FARR_D_CONTR_D is an SAP database table in S/4HANA. Draft Table for Revenue Accounting Contract. It contains 33 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_RevenueAccountingContrDraft view_entity from BASIC Revenue Contract - Draft

Fields (33)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY revenueaccountingcontract farr_cds_contract_id Revenue Contract
companycode bukrs Company Code
accountingprinciple accounting_principle Accounting Principle
businesspartner bu_partner Busn. Partner
revnacctgcontractdescription farr_description Description
revnacctgcontractcategory farr_contract_category Contract Category
customer kunnr Customer
totcontractualprcinslsdoccrcy farr_cds_contractual_price Contractual Price
alloceffctamountinsalesdoccrcy farr_corr_amt Allocation Effect
contrtobeallcdamtinslsdoccrcy farr_corr_amt Allocation Effect
racontracthasallocationeffect farr_cds_has_alloc_effect Has Allocation Effect
salesdocumentcurrency waers Currency
revnacctgsalesorganization farr_sales_org Sales Org.
numberofperformanceobligations farr_cds_num_of_pobs Number of Performance Obligations
revnacctgcontractstatus farr_contract_status Contract Status
racontractstatuscriticality int1 INT1
racontractismanuallyallocated farr_manual_price_alloc Manu Price Allocated
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
racontractlastchangedate farr_last_change_on Changed on
racontractcompletiondate farr_cds_contr_completion_date Completion Date
racontractissettosystemalloc farr_manual_changed Manual Changed
racontrhasmnlprcallocconflict farr_mnl_price_alloc_conflict Allocation Conflict
raattributehasconflict farr_attr_conflict Attr conflict
racontracthasassetsimpairment farr_cds_has_impair_of_assets Contract was Terminated Early
perfoblgnhassprdgconflict farr_spread_conflict Spreading Conflict
racontractisuniversal farr_universal_rev_rec_contr Universal Rev Contr

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 Revenue Accounting Contract
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FARR_D_CONTR_D (
    MANDT,                           -- Client [mandt]
    REVENUEACCOUNTINGCONTRACT,       -- Revenue Contract [farr_cds_contract_id]
    COMPANYCODE,                     -- Company Code [bukrs]
    ACCOUNTINGPRINCIPLE,             -- Accounting Principle [accounting_principle]
    BUSINESSPARTNER,                 -- Busn. Partner [bu_partner]
    REVNACCTGCONTRACTDESCRIPTION,    -- Description [farr_description]
    REVNACCTGCONTRACTCATEGORY,       -- Contract Category [farr_contract_category]
    CUSTOMER,                        -- Customer [kunnr]
    TOTCONTRACTUALPRCINSLSDOCCRCY,   -- Contractual Price [farr_cds_contractual_price]
    ALLOCEFFCTAMOUNTINSALESDOCCRCY,  -- Allocation Effect [farr_corr_amt]
    CONTRTOBEALLCDAMTINSLSDOCCRCY,   -- Allocation Effect [farr_corr_amt]
    RACONTRACTHASALLOCATIONEFFECT,   -- Has Allocation Effect [farr_cds_has_alloc_effect]
    SALESDOCUMENTCURRENCY,           -- Currency [waers]
    REVNACCTGSALESORGANIZATION,      -- Sales Org. [farr_sales_org]
    NUMBEROFPERFORMANCEOBLIGATIONS,  -- Number of Performance Obligations [farr_cds_num_of_pobs]
    REVNACCTGCONTRACTSTATUS,         -- Contract Status [farr_contract_status]
    RACONTRACTSTATUSCRITICALITY,     -- INT1 [int1]
    RACONTRACTISMANUALLYALLOCATED,   -- Manu Price Allocated [farr_manual_price_alloc]
    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]
    RACONTRACTLASTCHANGEDATE,        -- Changed on [farr_last_change_on]
    RACONTRACTCOMPLETIONDATE,        -- Completion Date [farr_cds_contr_completion_date]
    RACONTRACTISSETTOSYSTEMALLOC,    -- Manual Changed [farr_manual_changed]
    RACONTRHASMNLPRCALLOCCONFLICT,   -- Allocation Conflict [farr_mnl_price_alloc_conflict]
    RAATTRIBUTEHASCONFLICT,          -- Attr conflict [farr_attr_conflict]
    RACONTRACTHASASSETSIMPAIRMENT,   -- Contract was Terminated Early [farr_cds_has_impair_of_assets]
    PERFOBLGNHASSPRDGCONFLICT,       -- Spreading Conflict [farr_spread_conflict]
    RACONTRACTISUNIVERSAL,           -- Universal Rev Contr [farr_universal_rev_rec_contr]
    PRIMARY KEY (MANDT, REVENUEACCOUNTINGCONTRACT)
);

Learn More