P_OnceParkedAcctgDocChgDoc

DDL: P_ONCEPARKEDACCTGDOCCHGDOC SQL: POACCDOCCD Type: view COMPOSITE Package: ODATA_INSPECT_ITEMS_CHNGLOG
32 Fields 2 Data Sources

Once Parked Accounting Documents Change Log

P_OnceParkedAcctgDocChgDoc is a Composite CDS View that provides data about "Once Parked Accounting Documents Change Log" in SAP S/4HANA. It reads from 2 data sources (I_StandardAcctgDocForChgDoc, I_ParkedAccountingDocChgDoc) 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_StandardAcctgDocForChgDoc AccountingDoc inner
I_ParkedAccountingDocChgDoc ParkedAccountingDoc inner

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName POACCDOCCD 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 ChangeDocItem ChangeDocObjectClass Change Doc. Object
KEY ChangeDocObject ChangeDocItem ChangeDocObject Object Value
KEY ChangeDocument ChangeDocItem ChangeDocument Document Number
KEY DatabaseTable ChangeDocItem DatabaseTable Table Name
KEY ChangeDocTableKey ChangeDocItem ChangeDocTableKey
KEY ChangeDocDatabaseTableField ChangeDocItem ChangeDocDatabaseTableField
KEY ChangeDocItemChangeType ChangeDocItem ChangeDocItemChangeType
KEY AccountingDocumentItem I_StandardAcctgDocForChgDoc AccountingDocumentItem Posting View Item
ChangeDocNewCurrency ChangeDocItem ChangeDocNewCurrency
ChangeDocNewFieldValue ChangeDocItem ChangeDocNewFieldValue
ChangeDocNewUnit ChangeDocItem ChangeDocNewUnit
ChangeDocPreviousCurrency ChangeDocItem ChangeDocPreviousCurrency
ChangeDocPreviousFieldValue ChangeDocItem ChangeDocPreviousFieldValue
ChangeDocPreviousUnit ChangeDocItem ChangeDocPreviousUnit
CompanyCode I_StandardAcctgDocForChgDoc CompanyCode Receiver Company Code
AccountingDocument I_StandardAcctgDocForChgDoc AccountingDocument Journal Entry
FiscalYear I_StandardAcctgDocForChgDoc FiscalYear G/L Fiscal Year
AccountingDocumentType I_StandardAcctgDocForChgDoc AccountingDocumentType Journal Entry Type
Ledger I_StandardAcctgDocForChgDoc Ledger Ledger
ChangeDocLanguage
CreationTime
CreationDate
CreatedByUser
ChangeDocChangeType
ChangeTransactionCode
GLAccount I_StandardAcctgDocForChgDoc GLAccount General Ledger
Customer I_StandardAcctgDocForChgDoc Customer Sold-to Party
Supplier I_StandardAcctgDocForChgDoc Supplier Supplier
AccountType I_StandardAcctgDocForChgDoc AccountType Accounting Type(dtl)
PostingKey I_StandardAcctgDocForChgDoc PostingKey Posting Key
SpecialGLCode I_StandardAcctgDocForChgDoc 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_OnceParkedAcctgDocChgDoc.
-- 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: POACCDOCCD

CREATE VIEW P_OnceParkedAcctgDocChgDoc AS
SELECT
  cast( 'O' 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
INNER JOIN I_StandardAcctgDocForChgDoc AS AccountingDoc ON /* join condition not captured in parsed metadata */
INNER JOIN I_ParkedAccountingDocChgDoc AS ParkedAccountingDoc ON /* join condition not captured in parsed metadata */
;

Learn More