FARR_CONTRMNLSPD

Transparent Table Application Table
34 Fields 1 CDS Views

Draft Table for C_RAContrManualSpreadingTP

FARR_CONTRMNLSPD is an SAP database table in S/4HANA. Draft Table for C_RAContrManualSpreadingTP. It contains 34 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_RAContrManualSpreadingDraft view_entity from BASIC Revenue Contract - Draft

Fields (34)

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
accountingprinciplename accounting_princ_txt Name of AP
businesspartner bu_partner Busn. Partner
businesspartnername farr_cds_business_partner_name BusPartName
customer kunnr Customer
customername md_customer_name Name of Customer
totcontractualprcinslsdoccrcy farr_cds_contractual_price Contractual Price
alloceffctamountinsalesdoccrcy farr_corr_amt Allocation Effect
revnacctgcontractstatus farr_contract_status Contract Status
revnacctgcontractstatusname farr_cds_contr_status_text Contract Status Description
racontractlastsaveddatetime timestampl Time Stamp
racontrhasmnlprcallocconflict farr_mnl_price_alloc_conflict Allocation Conflict
revnacctgcontractcreationdate fis_cc_erfdt Created On
revnacctgcontractcreatedbyuser fis_aufaenam Last Changed By
createdbyuserdescription vdm_userdescription Description
isbusinesspurposecompleted farr_dpp_is_blocked Blocked
salesdocumentcurrency waers Currency
racontractlastchangedbyusr fis_cc_erfnm Created By
racontractlastchangedate farr_last_change_on Changed on
lastchangedbyuserdescription vdm_userdescription Description
racontracthasallocationeffect farr_cds_has_alloc_effect Has Allocation Effect
raattributehasconflict farr_attr_conflict Attr conflict
revnacctgsalesorganization farr_sales_org Sales Org.
perfoblgnhassprdgconflict farr_spread_conflict Spreading Conflict
racontractissoftdeleted farr_soft_deleted Soft Deleted
racontracthasassetsimpairment farr_cds_has_impair_of_assets Contract was Terminated Early
racontractstatuscriticality int1 INT1
salesorganizationname salesorganizationname Sales Organization Description
racontractisuniversal farr_universal_rev_rec_contr Universal Rev Contr
racontractcompletiondate farr_cds_contr_completion_date Completion Date

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_RAContrManualSpreadingTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FARR_CONTRMNLSPD (
    MANDT,                           -- Client [mandt]
    REVENUEACCOUNTINGCONTRACT,       -- Revenue Contract [farr_cds_contract_id]
    COMPANYCODE,                     -- Company Code [bukrs]
    COMPANYCODENAME,                 -- Company Name [butxt]
    ACCOUNTINGPRINCIPLE,             -- Accounting Principle [accounting_principle]
    ACCOUNTINGPRINCIPLENAME,         -- Name of AP [accounting_princ_txt]
    BUSINESSPARTNER,                 -- Busn. Partner [bu_partner]
    BUSINESSPARTNERNAME,             -- BusPartName [farr_cds_business_partner_name]
    CUSTOMER,                        -- Customer [kunnr]
    CUSTOMERNAME,                    -- Name of Customer [md_customer_name]
    TOTCONTRACTUALPRCINSLSDOCCRCY,   -- Contractual Price [farr_cds_contractual_price]
    ALLOCEFFCTAMOUNTINSALESDOCCRCY,  -- Allocation Effect [farr_corr_amt]
    REVNACCTGCONTRACTSTATUS,         -- Contract Status [farr_contract_status]
    REVNACCTGCONTRACTSTATUSNAME,     -- Contract Status Description [farr_cds_contr_status_text]
    RACONTRACTLASTSAVEDDATETIME,     -- Time Stamp [timestampl]
    RACONTRHASMNLPRCALLOCCONFLICT,   -- Allocation Conflict [farr_mnl_price_alloc_conflict]
    REVNACCTGCONTRACTCREATIONDATE,   -- Created On [fis_cc_erfdt]
    REVNACCTGCONTRACTCREATEDBYUSER,  -- Last Changed By [fis_aufaenam]
    CREATEDBYUSERDESCRIPTION,        -- Description [vdm_userdescription]
    ISBUSINESSPURPOSECOMPLETED,      -- Blocked [farr_dpp_is_blocked]
    SALESDOCUMENTCURRENCY,           -- Currency [waers]
    RACONTRACTLASTCHANGEDBYUSR,      -- Created By [fis_cc_erfnm]
    RACONTRACTLASTCHANGEDATE,        -- Changed on [farr_last_change_on]
    LASTCHANGEDBYUSERDESCRIPTION,    -- Description [vdm_userdescription]
    RACONTRACTHASALLOCATIONEFFECT,   -- Has Allocation Effect [farr_cds_has_alloc_effect]
    RAATTRIBUTEHASCONFLICT,          -- Attr conflict [farr_attr_conflict]
    REVNACCTGSALESORGANIZATION,      -- Sales Org. [farr_sales_org]
    PERFOBLGNHASSPRDGCONFLICT,       -- Spreading Conflict [farr_spread_conflict]
    RACONTRACTISSOFTDELETED,         -- Soft Deleted [farr_soft_deleted]
    RACONTRACTHASASSETSIMPAIRMENT,   -- Contract was Terminated Early [farr_cds_has_impair_of_assets]
    RACONTRACTSTATUSCRITICALITY,     -- INT1 [int1]
    SALESORGANIZATIONNAME,           -- Sales Organization Description [salesorganizationname]
    RACONTRACTISUNIVERSAL,           -- Universal Rev Contr [farr_universal_rev_rec_contr]
    RACONTRACTCOMPLETIONDATE,        -- Completion Date [farr_cds_contr_completion_date]
    PRIMARY KEY (MANDT, REVENUEACCOUNTINGCONTRACT)
);

Learn More