P_RAREVNAMTPERRECNCLNKEYGRP

CDS View

P_RAREVNAMTPERRECNCLNKEYGRP is a CDS View in S/4HANA. It contains 7 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_RACatchUpNonDistinct view_entity from COMPOSITE RA Catch-up of Non-Distinct Perf Oblgn
P_RAHighLvlRevnAmtPerKeyGroup view_entity from COMPOSITE
P_RARevnExplItemBase view_entity from COMPOSITE
P_RARevnExplItemBase view_entity union_all COMPOSITE
P_RATotRevnUpToRecnclnKeyGrp view_entity from COMPOSITE

Fields (7)

KeyField CDS FieldsUsed in Views
KEY FiscalYearPeriod FiscalYearPeriod 2
KEY PerformanceObligation PerformanceObligation 2
KEY RecnclnKeyGroupId RecnclnKeyGroupId,RevnAcctgReconciliationKey 3
CompanyCode CompanyCode 1
RelatedChgTypeItemKeyGroupId RelatedChgTypeItemKeyGroupId 1
RevenueAccountingContract RevenueAccountingContract 3
SalesDocumentCurrency SalesDocumentCurrency 3

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_RAREVNAMTPERRECNCLNKEYGRP (
    FISCALYEARPERIOD,
    PERFORMANCEOBLIGATION,
    RECNCLNKEYGROUPID,
    COMPANYCODE,
    RELATEDCHGTYPEITEMKEYGROUPID,
    REVENUEACCOUNTINGCONTRACT,
    SALESDOCUMENTCURRENCY,
    PRIMARY KEY (FISCALYEARPERIOD, PERFORMANCEOBLIGATION, RECNCLNKEYGROUPID)
);