FARR_MGN_2_D

Transparent Table Application Table
94 Fields 2 CDS Views

Draft Table for R_RAPerfOblgnMngRevnContrTP

FARR_MGN_2_D is an SAP database table in S/4HANA. Draft Table for R_RAPerfOblgnMngRevnContrTP. It contains 94 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_RAPerfOblgnMngRevnContrDraft view_entity from EXTENSION Performance Obligation - Extn
R_RAPerfOblgnMngRevnContrDraft view_entity from BASIC Draft Query for Performance Obligation

Fields (94)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY performanceobligation farr_cds_pob_id Performance Obligation
KEY revenueaccountingcontract farr_cds_contract_id Revenue Contract
performanceobligationclass farr_cds_pob_name Performance Obligation Name
raperfoblgndistincttype farr_distinct Composition
salesdocumentcurrency waers Currency
contractualprcinslsdoccrcy farr_cds_contractual_price Contractual Price
ratotalinterestamtinslsdoccrcy farr_cds_total_interest_amount
sspriceinsalesdoccrcy farr_cds_standalone_price Standalone Selling Price
allocatedpriceinsalesdoccrcy farr_alloc_amt Allocated Amount
revnacctgsuspensiondate farr_suspension_date Suspension Date
perfoblgneffectivequantityunit farr_quantity_unit Unit of Measure
perfoblgneffectivequantity farr_cds_effective_quantity Effective Quantity
revnacctgperfoblgnstatus farr_cds_pob_status Perf. Oblig. Status
customer kunnr Customer
businesspartner bu_partner Busn. Partner
businesspartnername abap.char
companycode bukrs Company Code
companycodename butxt Company Name
perfoblgnfulfillmenttype farr_fulfill_type Fulfillment Type
perfoblgneventtype farr_event_type Event Type
perfoblgnstartdatetype farr_start_date_type Start Date Type
performanceobligationstartdate farr_start_date Start Date
performanceobligationenddate farr_end_date End Date
perfobligationduration farr_duration Duration
perfobligationdurationunit farr_duration_unit Duration Unit
perfobligationdeferralmethod farr_deferral_method Deferral Method
perfoblgnisexclfrompricealloc farr_cds_exclude_allocation Excluded from Allocation
raperfoblgnisresidual farr_cds_residual_pob Residual Allocation
raperfoblgninvoiceeffecttype farr_invoice_effect_type Invoice Effect
functionalarea fkber Functional Area
businessarea gsber Business Area
profitcenter prctr Profit Center
segment fb_segment Segment
costcenter kostl Cost Center
orderid aufnr Order
wbselementexternalid ps_posid_edit WBS Element
wbselementinternalid ps_s4_pspnr WBS Internal ID
salesorder farr_sales_order_num Sales Order
salesorderitem farr_order_item_num Sales Ord. Item
raperfoblgncompletiondate farr_cds_pob_completion_date Completion Date
perfoblgnisfullyfulfilled farr_cds_fully_fulfilled Is Fully Fulfilled
perfoblgnisfinallyinvoiced farr_final_invoice Final Invoice
perfoblgnissoftdeleted farr_soft_deleted Soft Deleted
raperfoblgnismanuallychanged farr_manual_changed Manual Changed
perfoblgnhasmanualspreading farr_cds_manual_spreading_chg Spreading Changed Manually
perfoblgnhassprdgconflict farr_spread_conflict Spreading Conflict
raattributehasconflict farr_attr_conflict Attr conflict
raperfoblgnfinalizationdate farr_finalization_date Finalizat. Date
revnacctgsuspensionreason farr_suspension_reason Suspension Reason
perfoblgncontractualquantity farr_cds_contractual_quantity Quantity
perfoblgncontractualqtyunit farr_quantity_unit Unit of Measure
perfoblgncreatedbyuser fis_cc_erfnm Created By
perfoblgncreationdate fis_cc_erfdt Created On
perfoblgnlastchangedbyusr fis_aufaenam Last Changed By
perfoblgnlastchangedate farr_last_change_on Changed on
rahigherlevelperfoblgn farr_hi_level_pob_id Higher-Level POB
rootperformanceobligationinbom farr_bom_pob_id Root POB in BOM
raperformanceobligationtype farr_cds_pob_type Performance Obligation Type
raperfoblgncategory farr_cds_pob_category Performance Obligation Category
performanceobligationrole farr_cds_pob_role Performance Obligation Role
raperfoblgnismanuallycreated farr_manual_created Manual Created
ratiounit farr_quantity_unit Unit of Measure
revnacctgsendercomponent farr_cds_rai_srcco Sender Component
sspricetolerancemethod char1 Single-Character Flag
sspricetoleranceamount farr_ssp_range_amount SSP Tolerance
sspricetolerancepercent farr_cds_ssp_range_percentage SSP Tolerance Percentage
revnacctgitmquantityunit farr_quantity_unit Unit of Measure
controllingarea kokrs CO Area
profitabilitysegment rkeobjnr_char Profitability Segment
createdbyuserdescription vdm_userdescription Description
raperfoblgnrevnfrmallocaccount farr_cds_rev_frm_alloc_account Recognizable Revenue Acct. from Alloc.
accountingprinciple accounting_principle Accounting Principle
raperfoblgniscostrecognizable farr_cds_cost_recognition Cost Recognition
perfoblgndeliveredquantity farr_cds_delivered_quantity Delivery Quantity
raitemdifferencetodeliveredqty farr_cds_diff_to_delivered_qty Difference to Delivered Quantity
rafulfillmentisvaluebased farr_cds_ful_based_on_value Fulfillments Based on Values
revnacctgsalesorganization farr_sales_org Sales Org.
perunitsspriceinslsdoccrcy farr_cds_unit_ssp SSP per Unit
operatingconcern erkrs Operating concern
rafulfillmenttypeistimebased boole_d TRUE
rafulfillmenttypeiseventbased boole_d TRUE
glaccountname txt20_skat Short Text
raunivrevnrecgnintegtype farr_urr_integration_type URR Integration Type
businesssolutionorder fco_solution_order_id Solution Order
businesssolutionorderitem fco_solution_order_item_id Solution Order Item
racontrisnotactvunivrevnrecgn boole_d TRUE
salesdocument vbeln_va Sales Document
salesdocumentitem posnr_va Item
servicedocument fco_srvdoc_id Service Document
servicedocumentitem fco_srvdoc_item_id Service Doc. Item
servicedocumenttype fco_srvdoc_type Service Doc. Type
wbselement ps_s4_posid WBS Element
wbsdescription ps_s4_post1 WBS Element Name

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_RAPerfOblgnMngRevnContrTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FARR_MGN_2_D (
    MANDT,                           -- Client [mandt]
    PERFORMANCEOBLIGATION,           -- Performance Obligation [farr_cds_pob_id]
    REVENUEACCOUNTINGCONTRACT,       -- Revenue Contract [farr_cds_contract_id]
    PERFORMANCEOBLIGATIONCLASS,      -- Performance Obligation Name [farr_cds_pob_name]
    RAPERFOBLGNDISTINCTTYPE,         -- Composition [farr_distinct]
    SALESDOCUMENTCURRENCY,           -- Currency [waers]
    CONTRACTUALPRCINSLSDOCCRCY,      -- Contractual Price [farr_cds_contractual_price]
    RATOTALINTERESTAMTINSLSDOCCRCY,  -- farr_cds_total_interest_amount
    SSPRICEINSALESDOCCRCY,           -- Standalone Selling Price [farr_cds_standalone_price]
    ALLOCATEDPRICEINSALESDOCCRCY,    -- Allocated Amount [farr_alloc_amt]
    REVNACCTGSUSPENSIONDATE,         -- Suspension Date [farr_suspension_date]
    PERFOBLGNEFFECTIVEQUANTITYUNIT,  -- Unit of Measure [farr_quantity_unit]
    PERFOBLGNEFFECTIVEQUANTITY,      -- Effective Quantity [farr_cds_effective_quantity]
    REVNACCTGPERFOBLGNSTATUS,        -- Perf. Oblig. Status [farr_cds_pob_status]
    CUSTOMER,                        -- Customer [kunnr]
    BUSINESSPARTNER,                 -- Busn. Partner [bu_partner]
    BUSINESSPARTNERNAME,             -- abap.char
    COMPANYCODE,                     -- Company Code [bukrs]
    COMPANYCODENAME,                 -- Company Name [butxt]
    PERFOBLGNFULFILLMENTTYPE,        -- Fulfillment Type [farr_fulfill_type]
    PERFOBLGNEVENTTYPE,              -- Event Type [farr_event_type]
    PERFOBLGNSTARTDATETYPE,          -- Start Date Type [farr_start_date_type]
    PERFORMANCEOBLIGATIONSTARTDATE,  -- Start Date [farr_start_date]
    PERFORMANCEOBLIGATIONENDDATE,    -- End Date [farr_end_date]
    PERFOBLIGATIONDURATION,          -- Duration [farr_duration]
    PERFOBLIGATIONDURATIONUNIT,      -- Duration Unit [farr_duration_unit]
    PERFOBLIGATIONDEFERRALMETHOD,    -- Deferral Method [farr_deferral_method]
    PERFOBLGNISEXCLFROMPRICEALLOC,   -- Excluded from Allocation [farr_cds_exclude_allocation]
    RAPERFOBLGNISRESIDUAL,           -- Residual Allocation [farr_cds_residual_pob]
    RAPERFOBLGNINVOICEEFFECTTYPE,    -- Invoice Effect [farr_invoice_effect_type]
    FUNCTIONALAREA,                  -- Functional Area [fkber]
    BUSINESSAREA,                    -- Business Area [gsber]
    PROFITCENTER,                    -- Profit Center [prctr]
    SEGMENT,                         -- Segment [fb_segment]
    COSTCENTER,                      -- Cost Center [kostl]
    ORDERID,                         -- Order [aufnr]
    WBSELEMENTEXTERNALID,            -- WBS Element [ps_posid_edit]
    WBSELEMENTINTERNALID,            -- WBS Internal ID [ps_s4_pspnr]
    SALESORDER,                      -- Sales Order [farr_sales_order_num]
    SALESORDERITEM,                  -- Sales Ord. Item [farr_order_item_num]
    RAPERFOBLGNCOMPLETIONDATE,       -- Completion Date [farr_cds_pob_completion_date]
    PERFOBLGNISFULLYFULFILLED,       -- Is Fully Fulfilled [farr_cds_fully_fulfilled]
    PERFOBLGNISFINALLYINVOICED,      -- Final Invoice [farr_final_invoice]
    PERFOBLGNISSOFTDELETED,          -- Soft Deleted [farr_soft_deleted]
    RAPERFOBLGNISMANUALLYCHANGED,    -- Manual Changed [farr_manual_changed]
    PERFOBLGNHASMANUALSPREADING,     -- Spreading Changed Manually [farr_cds_manual_spreading_chg]
    PERFOBLGNHASSPRDGCONFLICT,       -- Spreading Conflict [farr_spread_conflict]
    RAATTRIBUTEHASCONFLICT,          -- Attr conflict [farr_attr_conflict]
    RAPERFOBLGNFINALIZATIONDATE,     -- Finalizat. Date [farr_finalization_date]
    REVNACCTGSUSPENSIONREASON,       -- Suspension Reason [farr_suspension_reason]
    PERFOBLGNCONTRACTUALQUANTITY,    -- Quantity [farr_cds_contractual_quantity]
    PERFOBLGNCONTRACTUALQTYUNIT,     -- Unit of Measure [farr_quantity_unit]
    PERFOBLGNCREATEDBYUSER,          -- Created By [fis_cc_erfnm]
    PERFOBLGNCREATIONDATE,           -- Created On [fis_cc_erfdt]
    PERFOBLGNLASTCHANGEDBYUSR,       -- Last Changed By [fis_aufaenam]
    PERFOBLGNLASTCHANGEDATE,         -- Changed on [farr_last_change_on]
    RAHIGHERLEVELPERFOBLGN,          -- Higher-Level POB [farr_hi_level_pob_id]
    ROOTPERFORMANCEOBLIGATIONINBOM,  -- Root POB in BOM [farr_bom_pob_id]
    RAPERFORMANCEOBLIGATIONTYPE,     -- Performance Obligation Type [farr_cds_pob_type]
    RAPERFOBLGNCATEGORY,             -- Performance Obligation Category [farr_cds_pob_category]
    PERFORMANCEOBLIGATIONROLE,       -- Performance Obligation Role [farr_cds_pob_role]
    RAPERFOBLGNISMANUALLYCREATED,    -- Manual Created [farr_manual_created]
    RATIOUNIT,                       -- Unit of Measure [farr_quantity_unit]
    REVNACCTGSENDERCOMPONENT,        -- Sender Component [farr_cds_rai_srcco]
    SSPRICETOLERANCEMETHOD,          -- Single-Character Flag [char1]
    SSPRICETOLERANCEAMOUNT,          -- SSP Tolerance [farr_ssp_range_amount]
    SSPRICETOLERANCEPERCENT,         -- SSP Tolerance Percentage [farr_cds_ssp_range_percentage]
    REVNACCTGITMQUANTITYUNIT,        -- Unit of Measure [farr_quantity_unit]
    CONTROLLINGAREA,                 -- CO Area [kokrs]
    PROFITABILITYSEGMENT,            -- Profitability Segment [rkeobjnr_char]
    CREATEDBYUSERDESCRIPTION,        -- Description [vdm_userdescription]
    RAPERFOBLGNREVNFRMALLOCACCOUNT,  -- Recognizable Revenue Acct. from Alloc. [farr_cds_rev_frm_alloc_account]
    ACCOUNTINGPRINCIPLE,             -- Accounting Principle [accounting_principle]
    RAPERFOBLGNISCOSTRECOGNIZABLE,   -- Cost Recognition [farr_cds_cost_recognition]
    PERFOBLGNDELIVEREDQUANTITY,      -- Delivery Quantity [farr_cds_delivered_quantity]
    RAITEMDIFFERENCETODELIVEREDQTY,  -- Difference to Delivered Quantity [farr_cds_diff_to_delivered_qty]
    RAFULFILLMENTISVALUEBASED,       -- Fulfillments Based on Values [farr_cds_ful_based_on_value]
    REVNACCTGSALESORGANIZATION,      -- Sales Org. [farr_sales_org]
    PERUNITSSPRICEINSLSDOCCRCY,      -- SSP per Unit [farr_cds_unit_ssp]
    OPERATINGCONCERN,                -- Operating concern [erkrs]
    RAFULFILLMENTTYPEISTIMEBASED,    -- TRUE [boole_d]
    RAFULFILLMENTTYPEISEVENTBASED,   -- TRUE [boole_d]
    GLACCOUNTNAME,                   -- Short Text [txt20_skat]
    RAUNIVREVNRECGNINTEGTYPE,        -- URR Integration Type [farr_urr_integration_type]
    BUSINESSSOLUTIONORDER,           -- Solution Order [fco_solution_order_id]
    BUSINESSSOLUTIONORDERITEM,       -- Solution Order Item [fco_solution_order_item_id]
    RACONTRISNOTACTVUNIVREVNRECGN,   -- TRUE [boole_d]
    SALESDOCUMENT,                   -- Sales Document [vbeln_va]
    SALESDOCUMENTITEM,               -- Item [posnr_va]
    SERVICEDOCUMENT,                 -- Service Document [fco_srvdoc_id]
    SERVICEDOCUMENTITEM,             -- Service Doc. Item [fco_srvdoc_item_id]
    SERVICEDOCUMENTTYPE,             -- Service Doc. Type [fco_srvdoc_type]
    WBSELEMENT,                      -- WBS Element [ps_s4_posid]
    WBSDESCRIPTION,                  -- WBS Element Name [ps_s4_post1]
    PRIMARY KEY (MANDT, PERFORMANCEOBLIGATION, REVENUEACCOUNTINGCONTRACT)
);

Learn More