FARR_MGN_1_D

Transparent Table Application Table
56 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 56 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 (56)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY revenueaccountingcontract FARR_CDS_CONTRACT_ID Revenue Contract
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
racontractiscreatedbycontrmgr FARR_RAR_VERSION_CODE RAR version code
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
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID UUID
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Draft - Operation Code
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Field Changes
contr_eew_dummy CFD_DUMMY Dummy

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]
    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]
    RACONTRACTISCREATEDBYCONTRMGR,   -- RAR version code [FARR_RAR_VERSION_CODE]
    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]
    DRAFTENTITYCREATIONDATETIME,     -- Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,   -- Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,     -- UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,        -- Draft - Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                 -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,               -- Field Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    CONTR_EEW_DUMMY,                 -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, REVENUEACCOUNTINGCONTRACT)
);

Learn More