CAC_AUDIT_Z3_CA_DOCGLITEM

DDL: CAC_AUDIT_Z3_CA_DOCGLITEM SQL: CADOCGLITEM Type: view
20 Fields 1 Data Sources

Audit Z3 FICA - G/L Account Items

CAC_AUDIT_Z3_CA_DOCGLITEM is a CDS View that provides data about "Audit Z3 FICA - G/L Account Items" in SAP S/4HANA. It reads from 1 data source (I_CAExtractDocumentGLItem) and exposes 20 fields with key fields CompanyCode, FiscalYear, CADocumentNumber, CAExtractDocumentItem.

Data Sources (1)

SourceAliasJoin Type
I_CAExtractDocumentGLItem DocGLItem from

Parameters (2)

NameTypeDefault
P_PostingDateFrom budat_from_kk
P_PostingDateTo budat_to_kk

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CADOCGLITEM view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Audit Z3 FICA - G/L Account Items view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.buffering.status #NOT_ALLOWED view
AbapCatalog.preserveKey true view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_CAExtractDocumentGLItem CompanyCode Receiver Company Code
KEY FiscalYear I_CAExtractDocumentGLItem FiscalYear G/L Fiscal Year
KEY CADocumentNumber I_CAExtractDocumentGLItem CADocumentNumber Document Number
KEY CAExtractDocumentItem I_CAExtractDocumentGLItem CAExtractDocumentItem Item
BusinessArea I_CAExtractDocumentGLItem BusinessArea Business Area
GLAccount I_CAExtractDocumentGLItem GLAccount General Ledger
CAAmountInLocalCurrency I_CAExtractDocumentGLItem CAAmountInLocalCurrency Local Crcy Amt
CompanyCodeCurrency I_CAExtractDocumentGLItem CompanyCodeCurrency Local Currency
CAAmountInTransactionCurrency I_CAExtractDocumentGLItem CAAmountInTransactionCurrency Amount
TransactionCurrency I_CAExtractDocumentGLItem TransactionCurrency Transaction Currency
TaxCode I_CAExtractDocumentGLItem TaxCode Tax Code
CATaxRate I_CAExtractDocumentGLItem CATaxRate Tax rate
ValueDate I_CAExtractDocumentGLItem ValueDate Value Date
Segment I_CAExtractDocumentGLItem Segment Segment number
SystemClient System Client
CAPostingDate
_DocHeader I_CAExtractDocumentGLItem _DocHeader
_CompCode I_CAExtractDocumentGLItem _CompCode
_BusinessArea I_CAExtractDocumentGLItem _BusinessArea
_Segment I_CAExtractDocumentGLItem _Segment

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 CAC_AUDIT_Z3_CA_DOCGLITEM.
-- 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: CADOCGLITEM
-- Parameters: P_PostingDateFrom : budat_from_kk, P_PostingDateTo : budat_to_kk

CREATE VIEW CAC_AUDIT_Z3_CA_DOCGLITEM AS
SELECT
  DocGLItem.CompanyCode AS CompanyCode,
  DocGLItem.FiscalYear AS FiscalYear,
  DocGLItem.CADocumentNumber AS CADocumentNumber,
  DocGLItem.CAExtractDocumentItem AS CAExtractDocumentItem,
  DocGLItem.BusinessArea AS BusinessArea,
  DocGLItem.GLAccount AS GLAccount,
  DocGLItem.CAAmountInLocalCurrency AS CAAmountInLocalCurrency,
  DocGLItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  DocGLItem.CAAmountInTransactionCurrency AS CAAmountInTransactionCurrency,
  DocGLItem.TransactionCurrency AS TransactionCurrency,
  DocGLItem.TaxCode AS TaxCode,
  DocGLItem.CATaxRate AS CATaxRate,
  DocGLItem.ValueDate AS ValueDate,
  DocGLItem.Segment AS Segment,
  $session.client AS SystemClient,
  DocGLItem._DocHeader.CAPostingDate AS CAPostingDate,
  DocGLItem._DocHeader AS _DocHeader,
  DocGLItem._CompCode AS _CompCode,
  DocGLItem._BusinessArea AS _BusinessArea,
  DocGLItem._Segment AS _Segment
FROM I_CAExtractDocumentGLItem AS DocGLItem
;

Learn More