P_RAPOSTINGITEMWTHRECGDAMT

CDS View
49 Fields 2 CDS Views

Posting Item - Cube

P_RAPOSTINGITEMWTHRECGDAMT is a CDS View in S/4HANA. Posting Item - Cube. It contains 49 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_RAPostingItemCube view from COMPOSITE Posting Item - Cube
I_RAPostingItemCube_2 view_entity from COMPOSITE Posting Item - Cube

Fields (49)

KeyField CDS FieldsUsed in Views
KEY AccountingPrinciple AccountingPrinciple 2
KEY CompanyCode CompanyCode 2
KEY ConditionType ConditionType 2
KEY DebitCreditCode DebitCreditCode 2
KEY PerformanceObligation PerformanceObligation 2
KEY RevenueAccountingContract RevenueAccountingContract 2
KEY RevnAcctgPostingCategory RevnAcctgPostingCategory 2
KEY RevnAcctgReconciliationKey RevnAcctgReconciliationKey 2
_AccountingPrinciple _AccountingPrinciple 2
_BusinessArea _BusinessArea 2
_CompanyCode _CompanyCode 2
_CompanyCodeCurrency _CompanyCodeCurrency 2
_ControllingArea _ControllingArea 2
_CostCenter _CostCenter 2
_Currency _Currency 2
_CurrentCostCenter _CurrentCostCenter 2
_CurrentProfitCenter _CurrentProfitCenter 2
_DebitCreditCode _DebitCreditCode 2
_FiscalYear _FiscalYear 2
_FunctionalArea _FunctionalArea 2
_GLAccountInCompanyCode _GLAccountInCompanyCode 2
_Order _Order 2
_ProfitCenter _ProfitCenter 2
_RAPerformanceObligation _RAPerformanceObligation 2
_RAPostingCategory _RAPostingCategory 2
_RAReconciliationKeyStatus _RAReconciliationKeyStatus 2
_RevenueAccountingContract _RevenueAccountingContract 2
_RevnAcctgReconciliationKey _RevnAcctgReconciliationKey 2
_SalesOrder _SalesOrder 2
_Segment _Segment 2
_WBSElement _WBSElement 2
AdditionalCurrency1 AdditionalCurrency1 2
AdditionalCurrency2 AdditionalCurrency2 2
BusinessArea BusinessArea 2
CompanyCodeCurrency CompanyCodeCurrency 2
ConditionIsForStatistics ConditionIsForStatistics 2
ControllingArea ControllingArea 2
CostCenter CostCenter 2
FiscalYear FiscalYear 2
FiscalYearPeriod FiscalYearPeriod 2
FunctionalArea FunctionalArea 2
GLAccount GLAccount 2
OrderID OrderID 2
ProfitCenter ProfitCenter 2
RevnAcctgRecnclnKeyStatus RevnAcctgRecnclnKeyStatus 2
SalesDocumentCurrency SalesDocumentCurrency 2
SalesOrder SalesOrder 2
Segment Segment 2
WBSElementExternalID WBSElementExternalID 2

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.

-- Posting Item - Cube
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_RAPOSTINGITEMWTHRECGDAMT (
    ACCOUNTINGPRINCIPLE,
    COMPANYCODE,
    CONDITIONTYPE,
    DEBITCREDITCODE,
    PERFORMANCEOBLIGATION,
    REVENUEACCOUNTINGCONTRACT,
    REVNACCTGPOSTINGCATEGORY,
    REVNACCTGRECONCILIATIONKEY,
    _ACCOUNTINGPRINCIPLE,
    _BUSINESSAREA,
    _COMPANYCODE,
    _COMPANYCODECURRENCY,
    _CONTROLLINGAREA,
    _COSTCENTER,
    _CURRENCY,
    _CURRENTCOSTCENTER,
    _CURRENTPROFITCENTER,
    _DEBITCREDITCODE,
    _FISCALYEAR,
    _FUNCTIONALAREA,
    _GLACCOUNTINCOMPANYCODE,
    _ORDER,
    _PROFITCENTER,
    _RAPERFORMANCEOBLIGATION,
    _RAPOSTINGCATEGORY,
    _RARECONCILIATIONKEYSTATUS,
    _REVENUEACCOUNTINGCONTRACT,
    _REVNACCTGRECONCILIATIONKEY,
    _SALESORDER,
    _SEGMENT,
    _WBSELEMENT,
    ADDITIONALCURRENCY1,
    ADDITIONALCURRENCY2,
    BUSINESSAREA,
    COMPANYCODECURRENCY,
    CONDITIONISFORSTATISTICS,
    CONTROLLINGAREA,
    COSTCENTER,
    FISCALYEAR,
    FISCALYEARPERIOD,
    FUNCTIONALAREA,
    GLACCOUNT,
    ORDERID,
    PROFITCENTER,
    REVNACCTGRECNCLNKEYSTATUS,
    SALESDOCUMENTCURRENCY,
    SALESORDER,
    SEGMENT,
    WBSELEMENTEXTERNALID,
    PRIMARY KEY (ACCOUNTINGPRINCIPLE, COMPANYCODE, CONDITIONTYPE, DEBITCREDITCODE, PERFORMANCEOBLIGATION, REVENUEACCOUNTINGCONTRACT, REVNACCTGPOSTINGCATEGORY, REVNACCTGRECONCILIATIONKEY)
);

Learn More