I_StandardAcctgDocForChgDoc

DDL: I_STANDARDACCTGDOCFORCHGDOC Type: view COMPOSITE Package: ODATA_INSPECT_ITEMS_CHNGLOG
26 Fields 4 Data Sources

Accounting Document for binding to Change Document

I_StandardAcctgDocForChgDoc is a Composite CDS View that provides data about "Accounting Document for binding to Change Document" in SAP S/4HANA. It reads from 4 data sources (I_AcctgDocHdrForChgDoc, I_AcctgDocHdrForChgDoc, I_InspectOplAcctgDocumentItem, I_AcctgDocItmForChgDoc) and exposes 26 fields with key fields ChangeDocumentTableKey, DatabaseTable, AccountingDocumentItem, CompanyCode, FiscalYear. Part of development package ODATA_INSPECT_ITEMS_CHNGLOG.

Data Sources (4)

SourceAliasJoin Type
I_AcctgDocHdrForChgDoc Header from
I_AcctgDocHdrForChgDoc Header union_all
I_InspectOplAcctgDocumentItem Item inner
I_AcctgDocItmForChgDoc Item inner

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ISTDACCDOC4CD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Accounting Document for binding to Change Document view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
VDM.private false view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY ChangeDocumentTableKey Table Key
KEY DatabaseTable DatabaseTable Table Name
KEY AccountingDocumentItem AccountingDocumentItem Posting View Item
KEY CompanyCode I_AcctgDocHdrForChgDoc CompanyCode Receiver Company Code
KEY FiscalYear I_AcctgDocHdrForChgDoc FiscalYear G/L Fiscal Year
AccountingDocument I_AcctgDocHdrForChgDoc AccountingDocument Journal Entry
Ledger I_AcctgDocHdrForChgDoc Ledger Ledger
AccountingDocumentType I_AcctgDocItmForChgDoc AccountingDocumentType Journal Entry Type
GLAccount General Ledger
Customer I_AcctgDocItmForChgDoc Debtor Sold-to Party
Supplier I_AcctgDocItmForChgDoc Creditor Supplier
PostingKey Posting Key
AccountType FinancialAccountType Accounting Type(dtl)
KEY DatabaseTable I_AcctgDocItmForChgDoc DatabaseTable Table Name
KEY AccountingDocumentItem AccountingDocumentItem Posting View Item
KEY CompanyCode I_AcctgDocItmForChgDoc CompanyCode Receiver Company Code
KEY FiscalYear I_AcctgDocItmForChgDoc FiscalYear G/L Fiscal Year
AccountingDocument I_AcctgDocItmForChgDoc AccountingDocument Journal Entry
Ledger I_AcctgDocHdrForChgDoc Ledger Ledger
AccountingDocumentType AccountingDocumentType Journal Entry Type
GLAccount GLAccount General Ledger
Customer Customer Sold-to Party
Supplier Supplier Supplier
PostingKey PostingKey Posting Key
AccountType AccountType Accounting Type(dtl)
SpecialGLCode 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 I_StandardAcctgDocForChgDoc.
-- 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.

CREATE VIEW I_StandardAcctgDocForChgDoc AS
SELECT
  cast( ChangeDocumentTableKey as cdtabkey ) AS ChangeDocumentTableKey,
  DatabaseTable,
  AccountingDocumentItem,
  Header.CompanyCode AS CompanyCode,
  Header.FiscalYear AS FiscalYear,
  Header.AccountingDocument AS AccountingDocument,
  Header.Ledger AS Ledger,
  Item.AccountingDocumentType AS AccountingDocumentType,
  cast( '' as fis_glacct) AS GLAccount,
  Item.Debtor AS Customer,
  Item.Creditor AS Supplier,
  cast( '' as fis_bschl) AS PostingKey,
  FinancialAccountType AS AccountType,
  SpecialGLCode
FROM I_AcctgDocHdrForChgDoc AS Header
INNER JOIN I_InspectOplAcctgDocumentItem AS Item ON /* join condition not captured in parsed metadata */
INNER JOIN I_AcctgDocItmForChgDoc AS Item ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): I_AcctgDocHdrForChgDoc
;

Learn More