FARR_MGN_1_D

Transparent Table Application Table
49 Fields 2 CDS Views

Draft Table for R_RAContrMngRevnContrTP

FARR_MGN_1_D is an SAP database table in S/4HANA. Draft Table for R_RAContrMngRevnContrTP. It contains 49 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_RAContrMngRevnContrDraft view_entity from EXTENSION Manage Revenue Contract - Extn
R_RAContrMngRevnContrDraft view_entity from BASIC Draft Query for Revenue Contract

Fields (49)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY revenueaccountingcontract farr_cds_contract_id Revenue Contract
sapobjectnodetype abap.char
revnacctgcontractdescription farr_description Description
businesspartner bu_partner Busn. Partner
businesspartnername farr_cds_business_partner_name BusPartName
customer kunnr Customer
customername md_customer_name Name of Customer
accountingprinciple accounting_principle Accounting Principle
companycode bukrs Company Code
racontractlastsaveddatetime timestampl Time Stamp
fiscalyear fins_gjahr Fiscal Year
fiscalperiod fins_fiscalperiod Fiscal Period
isbusinesspurposecompleted farr_dpp_is_blocked Blocked
hasattachment boole_d TRUE
racontracthascompoundperfoblgn boole_d TRUE
racontractismanuallyallocated farr_cds_manual_price_alloc Price Allocated Manually
racontrhasmnlprcallocconflict farr_cds_has_alloc_conflict Allocation Conflict
raattributehasconflict farr_attr_conflict Attr conflict
perfoblgnhassprdgconflict farr_spread_conflict Spreading Conflict
perfoblgnhasmanualspreading farr_cds_manual_spreading_chg Spreading Changed Manually
totcontractualprcinslsdoccrcy farr_cds_contractual_price Contractual Price
racontrbalanceisdfrrdrevn boole_d TRUE
racontrbalanceisliability boole_d TRUE
numberofperformanceobligations farr_cds_num_of_pobs Number of Performance Obligations
alloceffctamountinsalesdoccrcy farr_corr_amt Allocation Effect
revncontrassetsimpairmentdate farr_cds_asset_impairment_date Early Termination Date
racontracthasassetsimpairment farr_cds_has_impair_of_assets Contract was Terminated Early
revnacctgcontractstatus farr_contract_status Contract Status
revnacctgcontractstatusname farr_cds_contr_status_text Contract Status Description
racontractstatuscriticality abap.int1
racontractcompletiondate farr_cds_contr_completion_date Completion Date
salesdocumentcurrency waers Currency
revnacctgsalesorganization farr_sales_org Sales Org.
racontracthasallocationeffect farr_cds_has_alloc_effect Has Allocation Effect
rarevnlbltyassetcalcisenabled farr_cds_revncalc_is_enabled Revenue Calculation is Allowed
rarevenuepostisenabled farr_cds_revnpost_is_enabled Revenue Post is Allowed
racontractpostingmode farr_posting_mode Posting Mode
racontractpostingmodename val_text Short Description
createdbyuserdescription vdm_userdescription Description
revnacctgcontractcreationdate farr_cds_created_on Created On
lastchangedbyuserdescription vdm_userdescription Description
racontractlastchangedate farr_last_change_on Changed on
racontractissoftdeleted farr_soft_deleted Soft Deleted
racontrmanualchgbusinessreason farr_business_change_reason Bus Chg Reason
revnacctgcontractcreatedbyuser fis_cc_erfnm Created By
racontractlastchangedbyusr fis_aufaenam Last Changed By
racontractisuniversal farr_universal_rev_rec_contr Universal Rev Contr
racontrisnotactvunivrevnrecgn boole_d TRUE

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 R_RAContrMngRevnContrTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FARR_MGN_1_D (
    MANDT,                           -- Client [mandt]
    REVENUEACCOUNTINGCONTRACT,       -- Revenue Contract [farr_cds_contract_id]
    SAPOBJECTNODETYPE,               -- abap.char
    REVNACCTGCONTRACTDESCRIPTION,    -- Description [farr_description]
    BUSINESSPARTNER,                 -- Busn. Partner [bu_partner]
    BUSINESSPARTNERNAME,             -- BusPartName [farr_cds_business_partner_name]
    CUSTOMER,                        -- Customer [kunnr]
    CUSTOMERNAME,                    -- Name of Customer [md_customer_name]
    ACCOUNTINGPRINCIPLE,             -- Accounting Principle [accounting_principle]
    COMPANYCODE,                     -- Company Code [bukrs]
    RACONTRACTLASTSAVEDDATETIME,     -- Time Stamp [timestampl]
    FISCALYEAR,                      -- Fiscal Year [fins_gjahr]
    FISCALPERIOD,                    -- Fiscal Period [fins_fiscalperiod]
    ISBUSINESSPURPOSECOMPLETED,      -- Blocked [farr_dpp_is_blocked]
    HASATTACHMENT,                   -- TRUE [boole_d]
    RACONTRACTHASCOMPOUNDPERFOBLGN,  -- TRUE [boole_d]
    RACONTRACTISMANUALLYALLOCATED,   -- Price Allocated Manually [farr_cds_manual_price_alloc]
    RACONTRHASMNLPRCALLOCCONFLICT,   -- Allocation Conflict [farr_cds_has_alloc_conflict]
    RAATTRIBUTEHASCONFLICT,          -- Attr conflict [farr_attr_conflict]
    PERFOBLGNHASSPRDGCONFLICT,       -- Spreading Conflict [farr_spread_conflict]
    PERFOBLGNHASMANUALSPREADING,     -- Spreading Changed Manually [farr_cds_manual_spreading_chg]
    TOTCONTRACTUALPRCINSLSDOCCRCY,   -- Contractual Price [farr_cds_contractual_price]
    RACONTRBALANCEISDFRRDREVN,       -- TRUE [boole_d]
    RACONTRBALANCEISLIABILITY,       -- TRUE [boole_d]
    NUMBEROFPERFORMANCEOBLIGATIONS,  -- Number of Performance Obligations [farr_cds_num_of_pobs]
    ALLOCEFFCTAMOUNTINSALESDOCCRCY,  -- Allocation Effect [farr_corr_amt]
    REVNCONTRASSETSIMPAIRMENTDATE,   -- Early Termination Date [farr_cds_asset_impairment_date]
    RACONTRACTHASASSETSIMPAIRMENT,   -- Contract was Terminated Early [farr_cds_has_impair_of_assets]
    REVNACCTGCONTRACTSTATUS,         -- Contract Status [farr_contract_status]
    REVNACCTGCONTRACTSTATUSNAME,     -- Contract Status Description [farr_cds_contr_status_text]
    RACONTRACTSTATUSCRITICALITY,     -- abap.int1
    RACONTRACTCOMPLETIONDATE,        -- Completion Date [farr_cds_contr_completion_date]
    SALESDOCUMENTCURRENCY,           -- Currency [waers]
    REVNACCTGSALESORGANIZATION,      -- Sales Org. [farr_sales_org]
    RACONTRACTHASALLOCATIONEFFECT,   -- Has Allocation Effect [farr_cds_has_alloc_effect]
    RAREVNLBLTYASSETCALCISENABLED,   -- Revenue Calculation is Allowed [farr_cds_revncalc_is_enabled]
    RAREVENUEPOSTISENABLED,          -- Revenue Post is Allowed [farr_cds_revnpost_is_enabled]
    RACONTRACTPOSTINGMODE,           -- Posting Mode [farr_posting_mode]
    RACONTRACTPOSTINGMODENAME,       -- Short Description [val_text]
    CREATEDBYUSERDESCRIPTION,        -- Description [vdm_userdescription]
    REVNACCTGCONTRACTCREATIONDATE,   -- Created On [farr_cds_created_on]
    LASTCHANGEDBYUSERDESCRIPTION,    -- Description [vdm_userdescription]
    RACONTRACTLASTCHANGEDATE,        -- Changed on [farr_last_change_on]
    RACONTRACTISSOFTDELETED,         -- Soft Deleted [farr_soft_deleted]
    RACONTRMANUALCHGBUSINESSREASON,  -- Bus Chg Reason [farr_business_change_reason]
    REVNACCTGCONTRACTCREATEDBYUSER,  -- Created By [fis_cc_erfnm]
    RACONTRACTLASTCHANGEDBYUSR,      -- Last Changed By [fis_aufaenam]
    RACONTRACTISUNIVERSAL,           -- Universal Rev Contr [farr_universal_rev_rec_contr]
    RACONTRISNOTACTVUNIVREVNRECGN,   -- TRUE [boole_d]
    PRIMARY KEY (MANDT, REVENUEACCOUNTINGCONTRACT)
);

Learn More