P_RecurringAcctgDocChgDoc

DDL: P_RECURRINGACCTGDOCCHGDOC SQL: PRACCDOCCD Type: view COMPOSITE Package: ODATA_INSPECT_ITEMS_CHNGLOG
32 Fields 2 Data Sources

Recurring Accounting Documents Change Log

P_RecurringAcctgDocChgDoc is a Composite CDS View that provides data about "Recurring Accounting Documents Change Log" in SAP S/4HANA. It reads from 2 data sources (I_RecurringAcctgDocForChgDoc, R_ChangeDocumentItem) and exposes 32 fields with key fields InspectItemDocumentType, ChangeDocObjectClass, ChangeDocObject, ChangeDocument, DatabaseTable. Part of development package ODATA_INSPECT_ITEMS_CHNGLOG.

Data Sources (2)

SourceAliasJoin Type
I_RecurringAcctgDocForChgDoc AccountingDoc inner
R_ChangeDocumentItem ChangeDocItem from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PRACCDOCCD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY InspectItemDocumentType
KEY ChangeDocObjectClass R_ChangeDocumentItem ChangeDocObjectClass Change Doc. Object
KEY ChangeDocObject R_ChangeDocumentItem ChangeDocObject Object Value
KEY ChangeDocument R_ChangeDocumentItem ChangeDocument Document Number
KEY DatabaseTable R_ChangeDocumentItem DatabaseTable Table Name
KEY ChangeDocTableKey R_ChangeDocumentItem ChangeDocTableKey
KEY ChangeDocDatabaseTableField R_ChangeDocumentItem ChangeDocDatabaseTableField
KEY ChangeDocItemChangeType R_ChangeDocumentItem ChangeDocItemChangeType
KEY AccountingDocumentItem I_RecurringAcctgDocForChgDoc AccountingDocumentItem Posting View Item
ChangeDocNewCurrency R_ChangeDocumentItem ChangeDocNewCurrency
ChangeDocNewFieldValue R_ChangeDocumentItem ChangeDocNewFieldValue
ChangeDocNewUnit R_ChangeDocumentItem ChangeDocNewUnit
ChangeDocPreviousCurrency R_ChangeDocumentItem ChangeDocPreviousCurrency
ChangeDocPreviousFieldValue R_ChangeDocumentItem ChangeDocPreviousFieldValue
ChangeDocPreviousUnit R_ChangeDocumentItem ChangeDocPreviousUnit
CompanyCode I_RecurringAcctgDocForChgDoc CompanyCode Receiver Company Code
AccountingDocument I_RecurringAcctgDocForChgDoc AccountingDocument Journal Entry
FiscalYear I_RecurringAcctgDocForChgDoc FiscalYear G/L Fiscal Year
AccountingDocumentType I_RecurringAcctgDocForChgDoc AccountingDocumentType Journal Entry Type
Ledger I_RecurringAcctgDocForChgDoc Ledger Ledger
ChangeDocLanguage
CreationTime
CreationDate
CreatedByUser
ChangeDocChangeType
ChangeTransactionCode
GLAccount I_RecurringAcctgDocForChgDoc GLAccount General Ledger
Customer I_RecurringAcctgDocForChgDoc Customer Sold-to Party
Supplier I_RecurringAcctgDocForChgDoc Supplier Supplier
AccountType I_RecurringAcctgDocForChgDoc AccountType Accounting Type(dtl)
PostingKey I_RecurringAcctgDocForChgDoc PostingKey Posting Key
SpecialGLCode I_RecurringAcctgDocForChgDoc SpecialGLCode Special G/L Ind

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_RecurringAcctgDocChgDoc.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: PRACCDOCCD

CREATE VIEW P_RecurringAcctgDocChgDoc AS
SELECT
  cast( 'R' as farp_inspect_item_doc_type ) AS InspectItemDocumentType,
  ChangeDocItem.ChangeDocObjectClass AS ChangeDocObjectClass,
  ChangeDocItem.ChangeDocObject AS ChangeDocObject,
  ChangeDocItem.ChangeDocument AS ChangeDocument,
  ChangeDocItem.DatabaseTable AS DatabaseTable,
  ChangeDocItem.ChangeDocTableKey AS ChangeDocTableKey,
  ChangeDocItem.ChangeDocDatabaseTableField AS ChangeDocDatabaseTableField,
  ChangeDocItem.ChangeDocItemChangeType AS ChangeDocItemChangeType,
  AccountingDoc.AccountingDocumentItem AS AccountingDocumentItem,
  ChangeDocItem.ChangeDocNewCurrency AS ChangeDocNewCurrency,
  ChangeDocItem.ChangeDocNewFieldValue AS ChangeDocNewFieldValue,
  ChangeDocItem.ChangeDocNewUnit AS ChangeDocNewUnit,
  ChangeDocItem.ChangeDocPreviousCurrency AS ChangeDocPreviousCurrency,
  ChangeDocItem.ChangeDocPreviousFieldValue AS ChangeDocPreviousFieldValue,
  ChangeDocItem.ChangeDocPreviousUnit AS ChangeDocPreviousUnit,
  AccountingDoc.CompanyCode AS CompanyCode,
  AccountingDoc.AccountingDocument AS AccountingDocument,
  AccountingDoc.FiscalYear AS FiscalYear,
  AccountingDoc.AccountingDocumentType AS AccountingDocumentType,
  AccountingDoc.Ledger AS Ledger,
  ChangeDocItem._ChangeDocument.ChangeDocLanguage AS ChangeDocLanguage,
  ChangeDocItem._ChangeDocument.CreationTime AS CreationTime,
  ChangeDocItem._ChangeDocument.CreationDate AS CreationDate,
  ChangeDocItem._ChangeDocument.CreatedByUser AS CreatedByUser,
  ChangeDocItem._ChangeDocument.ChangeDocChangeType AS ChangeDocChangeType,
  ChangeDocItem._ChangeDocument.ChangeTransactionCode AS ChangeTransactionCode,
  AccountingDoc.GLAccount AS GLAccount,
  AccountingDoc.Customer AS Customer,
  AccountingDoc.Supplier AS Supplier,
  AccountingDoc.AccountType AS AccountType,
  AccountingDoc.PostingKey AS PostingKey,
  AccountingDoc.SpecialGLCode AS SpecialGLCode
FROM R_ChangeDocumentItem AS ChangeDocItem
INNER JOIN I_RecurringAcctgDocForChgDoc AS AccountingDoc ON /* join condition not captured in parsed metadata */
;

Learn More