I_ClrgInfoRelationForAcctgDoc

DDL: I_CLRGINFORELATIONFORACCTGDOC Type: view BASIC
44 Fields 1 Data Sources 8 Associations

Clearing Information for Accounting

I_ClrgInfoRelationForAcctgDoc is a Basic CDS View (Dimension) that provides data about "Clearing Information for Accounting" in SAP S/4HANA. It reads from 1 data source (bse_clr) and exposes 44 fields with key fields ClearingInfoCompanyCode, ClearingAccountingDocument, ClearingFiscalYear, ClearingInformationIndex. It has 8 associations to related views.

Data Sources (1)

SourceAliasJoin Type
bse_clr bse_clr from

Associations (8)

CardinalityTargetAliasCondition
[1..1] I_CompanyCode _ClearingInfoCompanyCode $projection.ClearingInfoCompanyCode = _ClearingInfoCompanyCode.CompanyCode
[1..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[0..1] I_AccountingDocument _ClearingDocument $projection.ClearingAccountingDocument = _ClearingDocument.AccountingDocument and $projection.ClearingInfoCompanyCode = _ClearingDocument.CompanyCode and $projection.ClearingFiscalYear = _ClearingDocument.FiscalYear
[0..1] I_AccountingDocument _AccountingDocument $projection.AccountingDocument = _AccountingDocument.AccountingDocument and $projection.ClearingInfoCompanyCode = _AccountingDocument.CompanyCode and $projection.ClearingFiscalYear = _AccountingDocument.FiscalYear
[0..1] I_FiscalYearForCompanyCode _ClearingFiscalYear $projection.ClearingFiscalYear = _ClearingFiscalYear.FiscalYear and $projection.ClearingInfoCompanyCode = _ClearingFiscalYear.CompanyCode
[0..1] I_FiscalYearForCompanyCode _FiscalYear $projection.FiscalYear = _FiscalYear.FiscalYear and $projection.CompanyCode = _FiscalYear.CompanyCode
[0..1] I_Currency _Currency $projection.companycodecurrency = _Currency.Currency
[0..1] I_DebitCreditCode _DebitCreditCode $projection.DebitCreditCode = _DebitCreditCode.DebitCreditCode

Annotations (16)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.representativeKey ClearingAccountingDocument view
ObjectModel.compositionRoot true view
AbapCatalog.buffering.status #NOT_ALLOWED view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.sqlViewName ICLEARINGINFO view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Clearing Information for Accounting view
Metadata.allowExtensions true view
AbapCatalog.preserveKey true view

Fields (44)

KeyFieldSource TableSource FieldDescription
KEY ClearingInfoCompanyCode bukrs_clr Company Code
KEY ClearingAccountingDocument belnr_clr Document Number
KEY ClearingFiscalYear gjahr_clr Fiscal Year
KEY ClearingInformationIndex index_clr Clrg Info Seq. No.
ClearingItem agzei Clearing Item
DownPaymentItem agbuz Item
TransactionCurrency waers Transaction Currency
ClearingInformationType clrin Type of Clearing in Table AUSZ_CLR
CompanyCode bukrs Value
AccountingDocument belnr SD Document
FiscalYear gjahr Settlement Year
AccountingDocumentItem buzei Posting View Item
DebitCreditCode shkzg Returns
CompanyCodeCurrency _ClearingDocument CompanyCodeCurrency Local Currency
AdditionalCurrency1 _ClearingDocument AdditionalCurrency1 Local curr. 2
AdditionalCurrency2 _ClearingDocument AdditionalCurrency2 Local curr. 3
AmountInCompanyCodeCurrency dmbtr Loc. amount
AmountInAdditionalCurrency1 dmbe2 LC2 Amount
AmountInAdditionalCurrency2 dmbe3 LC3 Amount
AmountInTransactionCurrency wrbtr Gross Amount
DifferenceAmtInCoCodeCrcy difhw Difference
DiffAmtInAdditionalCurrency1 difh2 Difference
DiffAmtInAdditionalCurrency2 difh3 Difference
DifferenceAmtInTransCrcy diffw Difference
CashDiscountAmtInCoCodeCrcy sknto Discount Amt
CashDiscountAmtInAddlCrcy1 sknt2 CD Amt LC2
CashDiscountAmtInAddlCrcy2 sknt3 CD Amt LC3
CashDiscountAmount wskto CD Amount
ValuationDiffAmtInCoCodeCrcy bdiff Valuation Diff.
ValuationDiffAmtInAddlCrcy1 bdif2 Valuation Diff. 2
ValuationDiffAmtInAddlCrcy2 bdif3 Valuation Diff. 3
ExchRateDiffAmtInCoCodeCrcy rdiff Rounding Diff.
ExchRateDiffAmtInAddlCrcy1 rdif2 Diff.Realized 2
ExchRateDiffAmtInAddlCrcy2 rdif3 Diff.Realized 3
AccountType koart Account type
SpecialGLCode umskz Special G/L Ind
_ClearingInfoCompanyCode _ClearingInfoCompanyCode
_CompanyCode _CompanyCode
_ClearingDocument _ClearingDocument
_AccountingDocument _AccountingDocument
_ClearingFiscalYear _ClearingFiscalYear
_FiscalYear _FiscalYear
_Currency _Currency
_DebitCreditCode _DebitCreditCode

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_ClrgInfoRelationForAcctgDoc.
-- 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_ClrgInfoRelationForAcctgDoc AS
SELECT
  bukrs_clr AS ClearingInfoCompanyCode,
  belnr_clr AS ClearingAccountingDocument,
  gjahr_clr AS ClearingFiscalYear,
  index_clr AS ClearingInformationIndex,
  agzei AS ClearingItem,
  agbuz AS DownPaymentItem,
  waers AS TransactionCurrency,
  clrin AS ClearingInformationType,
  bukrs AS CompanyCode,
  belnr AS AccountingDocument,
  gjahr AS FiscalYear,
  buzei AS AccountingDocumentItem,
  shkzg AS DebitCreditCode,
  _ClearingDocument.CompanyCodeCurrency AS CompanyCodeCurrency,
  _ClearingDocument.AdditionalCurrency1 AS AdditionalCurrency1,
  _ClearingDocument.AdditionalCurrency2 AS AdditionalCurrency2,
  dmbtr AS AmountInCompanyCodeCurrency,
  dmbe2 AS AmountInAdditionalCurrency1,
  dmbe3 AS AmountInAdditionalCurrency2,
  wrbtr AS AmountInTransactionCurrency,
  difhw AS DifferenceAmtInCoCodeCrcy,
  difh2 AS DiffAmtInAdditionalCurrency1,
  difh3 AS DiffAmtInAdditionalCurrency2,
  diffw AS DifferenceAmtInTransCrcy,
  sknto AS CashDiscountAmtInCoCodeCrcy,
  sknt2 AS CashDiscountAmtInAddlCrcy1,
  sknt3 AS CashDiscountAmtInAddlCrcy2,
  wskto AS CashDiscountAmount,
  bdiff AS ValuationDiffAmtInCoCodeCrcy,
  bdif2 AS ValuationDiffAmtInAddlCrcy1,
  bdif3 AS ValuationDiffAmtInAddlCrcy2,
  rdiff AS ExchRateDiffAmtInCoCodeCrcy,
  rdif2 AS ExchRateDiffAmtInAddlCrcy1,
  rdif3 AS ExchRateDiffAmtInAddlCrcy2,
  koart AS AccountType,
  umskz AS SpecialGLCode
FROM bse_clr
LEFT OUTER JOIN I_CompanyCode AS _ClearingInfoCompanyCode ON ClearingInfoCompanyCode = _ClearingInfoCompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_AccountingDocument AS _ClearingDocument ON ClearingAccountingDocument = _ClearingDocument.AccountingDocument AND ClearingInfoCompanyCode = _ClearingDocument.CompanyCode AND ClearingFiscalYear = _ClearingDocument.FiscalYear  -- association [0..1]
LEFT OUTER JOIN I_AccountingDocument AS _AccountingDocument ON AccountingDocument = _AccountingDocument.AccountingDocument AND ClearingInfoCompanyCode = _AccountingDocument.CompanyCode AND ClearingFiscalYear = _AccountingDocument.FiscalYear  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearForCompanyCode AS _ClearingFiscalYear ON ClearingFiscalYear = _ClearingFiscalYear.FiscalYear AND ClearingInfoCompanyCode = _ClearingFiscalYear.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearForCompanyCode AS _FiscalYear ON FiscalYear = _FiscalYear.FiscalYear AND CompanyCode = _FiscalYear.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON companycodecurrency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_DebitCreditCode AS _DebitCreditCode ON DebitCreditCode = _DebitCreditCode.DebitCreditCode  -- association [0..1]
;

Learn More