I_RAJOURNALENTRYITEM

CDS View
47 Fields 19 CDS Views

Revenue Accounting VDM Extending ACDOCA

I_RAJOURNALENTRYITEM is a CDS View in S/4HANA. Revenue Accounting VDM Extending ACDOCA. It contains 47 fields. 19 CDS views read from this table.

CDS Views using this table (19)

ViewTypeJoinVDMDescription
I_RAUnifiedPosting view_entity union_all COMPOSITE Revenue Accounting VDM Union of POSTING Table and ACDOCA
P_DrctCarryForwardAndDeltaRbl view_entity from COMPOSITE
P_DrctCarryForwardAndDeltaRbl view_entity union_all COMPOSITE
P_DrctCarryFwdAndDeltaPosting view_entity from COMPOSITE
P_DrctCarryFwdAndDeltaPosting view_entity union_all COMPOSITE
P_DrctCarryFwdDeltaPostgByQtr view_entity from COMPOSITE
P_DrctCarryFwdDeltaPostgByQtr view_entity union_all COMPOSITE
P_DrctCarryFwdDeltaPostgByYr view_entity from COMPOSITE
P_DrctCarryFwdDeltaPostgByYr view_entity union_all COMPOSITE
P_RABalMvtDirectPostgAmtPerd view_entity from COMPOSITE
P_RABalMvtDirectPostgAmtPerd view_entity union_all COMPOSITE
P_RABalMvtDirectPostgAmtYear view_entity from COMPOSITE
P_RABalMvtDirectPostgAmtYear view_entity union_all COMPOSITE
P_RABalMvtDirectPostingAmtQtr view_entity from COMPOSITE
P_RABalMvtDirectPostingAmtQtr view_entity union_all COMPOSITE
P_RADrctPostgLbltyAstForImprmt view_entity from COMPOSITE
P_RADrctPostgLbltyAstForImprmt view_entity inner COMPOSITE
P_RAJrnlEntrItmForCostCrrtn view_entity from COMPOSITE
P_RAPostingItemWthRecgdAmt view_entity union_all COMPOSITE

Fields (47)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 1
KEY AccountingPrinciple AccountingPrinciple 9
KEY CompanyCode CompanyCode 8
KEY ConditionType ConditionType 1
KEY DebitCreditCode DebitCreditCode 1
KEY FiscalPeriod FiscalPeriod 5
KEY FiscalYear FiscalYear 9
KEY GLAccountLineItem GLAccountLineItem 1
KEY PerformanceObligation PerformanceObligation 9
KEY RevenueAccountingContract RevenueAccountingContract 9
KEY RevnAcctgPostingCategory RevnAcctgPostingCategory 5
KEY RevnAcctgReconciliationKey RevnAcctgReconciliationKey 1
KEY SubLedgerAcctLineItemType SubLedgerAcctLineItemType 3
_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 9
AdditionalCurrency2 AdditionalCurrency2 9
BusinessArea BusinessArea 1
CompanyCodeCurrency CompanyCodeCurrency 9
ConditionIsForStatistics ConditionIsForStatistics 1
ControllingArea ControllingArea 1
CostCenter CostCenter 1
FiscalYearPeriod FiscalYearPeriod 1
FiscalYearVariant FiscalYearVariant 4
FunctionalArea FunctionalArea 1
GLAccount GLAccount 5
OrderID OrderID 1
ProfitCenter ProfitCenter 1
RevnAcctgPostgAmtInAddlCrcy1 RevnAcctgPostgAmtInAddlCrcy1 2
RevnAcctgPostgAmtInAddlCrcy2 RevnAcctgPostgAmtInAddlCrcy2 2
RevnAcctgPostgAmtInCoCodeCrcy RevnAcctgPostgAmtInCoCodeCrcy 2
RevnAcctgPostgAmtInSlsDocCrcy RevnAcctgPostgAmtInSlsDocCrcy 2
RevnAcctgRecnclnKeyStatus RevnAcctgRecnclnKeyStatus 1
SalesDocumentCurrency SalesDocumentCurrency 9
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 VDM Extending ACDOCA
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_RAJOURNALENTRYITEM (
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGPRINCIPLE,
    COMPANYCODE,
    CONDITIONTYPE,
    DEBITCREDITCODE,
    FISCALPERIOD,
    FISCALYEAR,
    GLACCOUNTLINEITEM,
    PERFORMANCEOBLIGATION,
    REVENUEACCOUNTINGCONTRACT,
    REVNACCTGPOSTINGCATEGORY,
    REVNACCTGRECONCILIATIONKEY,
    SUBLEDGERACCTLINEITEMTYPE,
    _ACCOUNTINGPRINCIPLE,
    _COMPANYCODE,
    _COMPANYCODECURRENCY,
    _CONTROLLINGAREA,
    _COSTCENTER,
    _CURRENCY,
    _CURRENTCOSTCENTER,
    _CURRENTPROFITCENTER,
    _PROFITCENTER,
    _REVENUEACCOUNTINGCONTRACT,
    _SEGMENT,
    _WBSELEMENT,
    ADDITIONALCURRENCY1,
    ADDITIONALCURRENCY2,
    BUSINESSAREA,
    COMPANYCODECURRENCY,
    CONDITIONISFORSTATISTICS,
    CONTROLLINGAREA,
    COSTCENTER,
    FISCALYEARPERIOD,
    FISCALYEARVARIANT,
    FUNCTIONALAREA,
    GLACCOUNT,
    ORDERID,
    PROFITCENTER,
    REVNACCTGPOSTGAMTINADDLCRCY1,
    REVNACCTGPOSTGAMTINADDLCRCY2,
    REVNACCTGPOSTGAMTINCOCODECRCY,
    REVNACCTGPOSTGAMTINSLSDOCCRCY,
    REVNACCTGRECNCLNKEYSTATUS,
    SALESDOCUMENTCURRENCY,
    SALESORDER,
    SEGMENT,
    WBSELEMENTEXTERNALID,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, ACCOUNTINGPRINCIPLE, COMPANYCODE, CONDITIONTYPE, DEBITCREDITCODE, FISCALPERIOD, FISCALYEAR, GLACCOUNTLINEITEM, PERFORMANCEOBLIGATION, REVENUEACCOUNTINGCONTRACT, REVNACCTGPOSTINGCATEGORY, REVNACCTGRECONCILIATIONKEY, SUBLEDGERACCTLINEITEMTYPE)
);

Learn More