P_RAPOSTINGITEMWTHRECGDAMT

CDS View
52 Fields 2 CDS Views

P_RAPOSTINGITEMWTHRECGDAMT is a CDS View in S/4HANA. It contains 52 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 (52)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 1
KEY AccountingPrinciple AccountingPrinciple 2
KEY CompanyCode CompanyCode 2
KEY ConditionType ConditionType 2
KEY DebitCreditCode DebitCreditCode 2
KEY GLAccountLineItem GLAccountLineItem 1
KEY PerformanceObligation PerformanceObligation 2
KEY RevenueAccountingContract RevenueAccountingContract 2
KEY RevnAcctgPostingCategory RevnAcctgPostingCategory 2
KEY RevnAcctgPostingItemUUID RevnAcctgPostingItemUUID 1
KEY RevnAcctgReconciliationKey RevnAcctgReconciliationKey 2
_AccountingPrinciple _AccountingPrinciple 2
_BusinessArea _BusinessArea 1
_CompanyCode _CompanyCode 2
_CompanyCodeCurrency _CompanyCodeCurrency 2
_ControllingArea _ControllingArea 2
_CostCenter _CostCenter 2
_Currency _Currency 2
_CurrentCostCenter _CurrentCostCenter 2
_CurrentProfitCenter _CurrentProfitCenter 2
_DebitCreditCode _DebitCreditCode 1
_FiscalYear _FiscalYear 1
_FunctionalArea _FunctionalArea 1
_GLAccountInCompanyCode _GLAccountInCompanyCode 1
_Order _Order 1
_ProfitCenter _ProfitCenter 2
_RAPerformanceObligation _RAPerformanceObligation 1
_RAPostingCategory _RAPostingCategory 1
_RAReconciliationKeyStatus _RAReconciliationKeyStatus 1
_RevenueAccountingContract _RevenueAccountingContract 2
_RevnAcctgReconciliationKey _RevnAcctgReconciliationKey 1
_SalesOrder _SalesOrder 1
_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 1
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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_RAPOSTINGITEMWTHRECGDAMT (
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGPRINCIPLE,
    COMPANYCODE,
    CONDITIONTYPE,
    DEBITCREDITCODE,
    GLACCOUNTLINEITEM,
    PERFORMANCEOBLIGATION,
    REVENUEACCOUNTINGCONTRACT,
    REVNACCTGPOSTINGCATEGORY,
    REVNACCTGPOSTINGITEMUUID,
    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 (ACCOUNTINGDOCUMENT, ACCOUNTINGPRINCIPLE, COMPANYCODE, CONDITIONTYPE, DEBITCREDITCODE, GLACCOUNTLINEITEM, PERFORMANCEOBLIGATION, REVENUEACCOUNTINGCONTRACT, REVNACCTGPOSTINGCATEGORY, REVNACCTGPOSTINGITEMUUID, REVNACCTGRECONCILIATIONKEY)
);

Learn More