I_RecurringAcctgDocForChgDoc

DDL: I_RECURRINGACCTGDOCFORCHGDOC Type: view COMPOSITE
37 Fields 6 Data Sources

Recurring Accounting Document for binding to Change Document

I_RecurringAcctgDocForChgDoc is a Composite CDS View that provides data about "Recurring Accounting Document for binding to Change Document" in SAP S/4HANA. It reads from 6 data sources and exposes 37 fields with key fields ChangeDocumentTableKey, DatabaseTable, AccountingDocumentItem, DatabaseTable, DatabaseTable.

Data Sources (6)

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

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IRACCDOC4CD 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 Recurring 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 (37)

KeyFieldSource TableSource FieldDescription
KEY ChangeDocumentTableKey Table Key
KEY DatabaseTable DatabaseTable Table Name
KEY AccountingDocumentItem AccountingDocumentItem Posting View Item
AccountingDocument I_RecrrgAcctgDocHdrForChgDoc AccountingDocument Journal Entry
CompanyCode I_RecrrgAcctgDocHdrForChgDoc CompanyCode Receiver Company Code
FiscalYear I_RecrrgAcctgDocHdrForChgDoc FiscalYear G/L Fiscal Year
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 Table Name
AccountingDocument I_RecrrgAcctgDocHdrForChgDoc AccountingDocument Journal Entry
CompanyCode I_RecrrgAcctgDocHdrForChgDoc CompanyCode Receiver Company Code
FiscalYear I_RecrrgAcctgDocHdrForChgDoc FiscalYear G/L Fiscal Year
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
AccountingDocument I_AcctgDocItmForChgDoc AccountingDocument Journal Entry
CompanyCode I_AcctgDocItmForChgDoc CompanyCode Receiver Company Code
FiscalYear I_AcctgDocItmForChgDoc FiscalYear G/L Fiscal Year
Ledger
AccountingDocumentType I_RecrrgAcctgDocHdrForChgDoc AccountingDocumentType Journal Entry Type
GLAccount I_AcctgDocItmForChgDoc GLAccount General Ledger
Customer I_AcctgDocItmForChgDoc Customer Sold-to Party
Supplier I_AcctgDocItmForChgDoc Supplier Supplier
PostingKey I_AcctgDocItmForChgDoc PostingKey Posting Key
AccountType I_AcctgDocItmForChgDoc AccountType Accounting Type(dtl)
SpecialGLCode I_AcctgDocItmForChgDoc 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_RecurringAcctgDocForChgDoc.
-- 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_RecurringAcctgDocForChgDoc AS
SELECT
  cast( ChangeDocumentTableKey as cdtabkey ) AS ChangeDocumentTableKey,
  DatabaseTable,
  AccountingDocumentItem,
  Header.AccountingDocument AS AccountingDocument,
  Header.CompanyCode AS CompanyCode,
  Header.FiscalYear AS FiscalYear,
  cast( '' as fins_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,
  Item.SpecialGLCode AS SpecialGLCode
FROM I_RecrrgAcctgDocHdrForChgDoc 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_RecrrgAcctgDocHdrForChgDoc
;

Learn More