FARR_MGN_2_D

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

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
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
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
dummy_contr_itm_incl_eew_ps CFD_DUMMY Dummy
pob_eew_dummy CFD_DUMMY Dummy
rep_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_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]
    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]
    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]
    DUMMY_CONTR_ITM_INCL_EEW_PS,     -- Dummy [CFD_DUMMY]
    POB_EEW_DUMMY,                   -- Dummy [CFD_DUMMY]
    REP_EEW_DUMMY,                   -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, PERFORMANCEOBLIGATION, REVENUEACCOUNTINGCONTRACT)
);

Learn More