I_REVENUEACCOUNTINGPOSTING

CDS View
43 Fields 16 CDS Views

Revenue Accounting Posting

I_REVENUEACCOUNTINGPOSTING is a CDS View in S/4HANA. Revenue Accounting Posting. It contains 43 fields. 16 CDS views read from this table.

CDS Views using this table (16)

ViewTypeJoinVDMDescription
I_RAUnifiedPosting view_entity from COMPOSITE Revenue Accounting VDM Union of POSTING Table and ACDOCA
P_CarryForwardAndDeltaPosting view_entity from COMPOSITE
P_CarryForwardAndDeltaPosting view_entity union_all COMPOSITE
P_CarryForwardAndDeltaRbl view_entity from COMPOSITE
P_CarryForwardAndDeltaRbl view_entity union_all COMPOSITE
P_CarryFwdAndDeltaPostgByQtr view_entity from COMPOSITE
P_CarryFwdAndDeltaPostgByQtr view_entity union_all COMPOSITE
P_CarryFwdAndDeltaPostgByYr view_entity from COMPOSITE
P_CarryFwdAndDeltaPostgByYr view_entity union_all COMPOSITE
P_RACarryForwardPostingQtrA view_entity from COMPOSITE
P_RACarryForwardPostingQtrA view_entity union_all COMPOSITE
P_RACBRContrBalAtPerfOblgLevel view_entity from COMPOSITE
P_RAContractPostedRevenue view from COMPOSITE
P_RADeltaRevenueAmountSelected view_entity from COMPOSITE
P_RAPostedDeltaAmountSelected view_entity from COMPOSITE
P_RAPostingItemWthRecgdAmt view_entity from COMPOSITE

Fields (43)

KeyField CDS FieldsUsed in Views
KEY AccountingPrinciple AccountingPrinciple 9
KEY CompanyCode CompanyCode 9
KEY ConditionType ConditionType 2
KEY DebitCreditCode DebitCreditCode 2
KEY FiscalPeriod FiscalPeriod 4
KEY FiscalYear FiscalYear 9
KEY PerformanceObligation PerformanceObligation 8
KEY RevenueAccountingContract RevenueAccountingContract 10
KEY RevnAcctgPostingCategory RevnAcctgPostingCategory 7
KEY RevnAcctgPostingItemUUID RevnAcctgPostingItemUUID 2
KEY RevnAcctgReconciliationKey RevnAcctgReconciliationKey 2
_AccountingPrinciple _AccountingPrinciple 1
_CompanyCode _CompanyCode 1
_CompanyCodeCurrency _CompanyCodeCurrency 1
_ControllingArea _ControllingArea 1
_CostCenter _CostCenter 1
_Currency _Currency 1
_CurrentCostCenter _CurrentCostCenter 1
_CurrentProfitCenter _CurrentProfitCenter 1
_ProfitCenter _ProfitCenter 1
_RevenueAccountingContract _RevenueAccountingContract 3
_Segment _Segment 1
_WBSElement _WBSElement 1
AdditionalCurrency1 AdditionalCurrency1 6
AdditionalCurrency2 AdditionalCurrency2 6
BusinessArea BusinessArea 1
CompanyCodeCurrency CompanyCodeCurrency 6
ConditionIsForStatistics ConditionIsForStatistics 1
ControllingArea ControllingArea 1
CostCenter CostCenter 1
FiscalYearPeriod FiscalYearPeriod 1
FunctionalArea FunctionalArea 1
GLAccount GLAccount 5
OrderID OrderID 1
ProfitCenter ProfitCenter 1
RevnAcctgPostgAmtInAddlCrcy1 RevnAcctgPostgAmtInAddlCrcy1 1
RevnAcctgPostgAmtInAddlCrcy2 RevnAcctgPostgAmtInAddlCrcy2 1
RevnAcctgPostgAmtInCoCodeCrcy RevnAcctgPostgAmtInCoCodeCrcy 1
RevnAcctgPostgAmtInSlsDocCrcy RevnAcctgPostgAmtInSlsDocCrcy 1
SalesDocumentCurrency SalesDocumentCurrency 7
SalesOrder SalesOrder 1
Segment Segment 1
WBSElementExternalID WBSElementExternalID 1

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.

-- Revenue Accounting Posting
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_REVENUEACCOUNTINGPOSTING (
    ACCOUNTINGPRINCIPLE,
    COMPANYCODE,
    CONDITIONTYPE,
    DEBITCREDITCODE,
    FISCALPERIOD,
    FISCALYEAR,
    PERFORMANCEOBLIGATION,
    REVENUEACCOUNTINGCONTRACT,
    REVNACCTGPOSTINGCATEGORY,
    REVNACCTGPOSTINGITEMUUID,
    REVNACCTGRECONCILIATIONKEY,
    _ACCOUNTINGPRINCIPLE,
    _COMPANYCODE,
    _COMPANYCODECURRENCY,
    _CONTROLLINGAREA,
    _COSTCENTER,
    _CURRENCY,
    _CURRENTCOSTCENTER,
    _CURRENTPROFITCENTER,
    _PROFITCENTER,
    _REVENUEACCOUNTINGCONTRACT,
    _SEGMENT,
    _WBSELEMENT,
    ADDITIONALCURRENCY1,
    ADDITIONALCURRENCY2,
    BUSINESSAREA,
    COMPANYCODECURRENCY,
    CONDITIONISFORSTATISTICS,
    CONTROLLINGAREA,
    COSTCENTER,
    FISCALYEARPERIOD,
    FUNCTIONALAREA,
    GLACCOUNT,
    ORDERID,
    PROFITCENTER,
    REVNACCTGPOSTGAMTINADDLCRCY1,
    REVNACCTGPOSTGAMTINADDLCRCY2,
    REVNACCTGPOSTGAMTINCOCODECRCY,
    REVNACCTGPOSTGAMTINSLSDOCCRCY,
    SALESDOCUMENTCURRENCY,
    SALESORDER,
    SEGMENT,
    WBSELEMENTEXTERNALID,
    PRIMARY KEY (ACCOUNTINGPRINCIPLE, COMPANYCODE, CONDITIONTYPE, DEBITCREDITCODE, FISCALPERIOD, FISCALYEAR, PERFORMANCEOBLIGATION, REVENUEACCOUNTINGCONTRACT, REVNACCTGPOSTINGCATEGORY, REVNACCTGPOSTINGITEMUUID, REVNACCTGRECONCILIATIONKEY)
);

Learn More