I_CADocumentGLItem

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_CADocumentGLItem.
-- 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_CADocumentGLItem AS
SELECT
  opbel AS CADocumentNumber,
  opupk AS CAGLItemNumber,
  bukrs AS CompanyCode,
  cast(cast(gsber as abap.char(4)) as fis_rbusa preserving type ) AS BusinessArea,
  cast(cast(bupla as abap.char(4)) as farp_bupla preserving type ) AS BusinessPlace,
  cast(cast(segment as abap.char(10)) as fb_segment preserving type ) AS Segment,
  cast(cast(prctr as abap.char(10)) as fis_prctr preserving type ) AS ProfitCenter,
  cast(vbund as fis_rassc preserving type ) AS PartnerCompany,
  cast(hkont as fis_racct preserving type ) AS GLAccount,
  valut AS ValueDate,
  cast( abs( kursf ) as fis_absolute_exchangerate preserving type ) AS CAExchangeRate,
  cast( case when kursf < 0 then 'X' else ' ' end as fis_indirect_quotation preserving type ) AS ExchRateIsIndirectQuotation,
  _DocHeader.TransactionCurrency AS TransactionCurrency,
  _CompCode.Currency AS Currency,
  betrh AS CAAmountInLocalCurrency,
  betrw AS CAAmountInTransactionCurrency,
  betr2 AS CAAmountInSecondCurrency,
  betr3 AS CAAmountInThirdCurrency,
  kontt AS CAAccountAssignmentCategory,
  kontl AS CAAccountAssignment,
  kostl AS CostCenter,
  kdauf AS SalesOrder,
  kdpos AS SalesOrderItem,
  fikey AS CAReconciliationKey,
  intbu AS CAInternalPostingReasonCode,
  negbu AS CANegativePostingControlCode,
  pswsl AS CAGLPostingCurrency,
  cast(ldgrp as fagl_ldgrp preserving type ) AS LedgerGroup,
  cast(paobjnr as rkeobjnr_char ) AS ProfitabilitySegment_2,
  pasubnr AS ProfitabilitySegmentChanges,
  cast(fdlev as fdlev preserving type ) AS PlanningLevel,
  whgrp AS CARepetitionGroup,
  ktosl AS CATransactionKeyAccountDetn,
  kschl AS ConditionType,
  xeiph AS CAIsSeparateLineItemInGL,
  menge AS QuantityInBaseUnit,
  meins AS BaseUnit,
  cast(mwskz as fis_mwskz preserving type ) AS TaxCode,
  mwszkz AS CASupplementaryTaxCode,
  qssew AS CAWithholdingTaxSupplement,
  strkz AS CAOtherTaxCode,
  txgrp AS CAGroupingCodeForTaxItems,
  cast(txjcd as fis_txjcd preserving type ) AS TaxJurisdiction,
  txjco AS CAEnteredTaxJurisdictionCode,
  txcnt AS CATaxJurisdictionLevelCounter,
  txexk AS CATaxExceptionID,
  txdat AS CATaxDate,
  sbash AS CATaxBaseAmountInLocalCurrency,
  sbasw AS CATaxBaseAmount,
  ndtax AS CANonDeductibleTxAmtInDocCrcy,
  ndtxh AS CANonDeductibleTxAmtInLoclCrcy,
  xndtx AS CAContainsNonDeductibleInptTax,
  stprz AS CATaxRate,
  gricd AS GrossIncomeTaxActivityCode,
  gityp AS EmploymentTaxDistributionType,
  sctax AS CATaxPortionInLocalCurrency,
  sttax AS CATaxPortionInTransCurrency,
  xustpd AS CATaxIsCalculatedExternally,
  xdexr AS CAAltvExchangeRateForTaxItem,
  xdexr AS CATaxItemHasAltvExchangeRate,
  xdexr AS CAAltvExchangeRateSetCode,
  tax_country AS TaxCountry,
  taxc_factor AS TransToTaxCntryCrcyCnvrsnFctr,
  xcsha AS CAIsCashFlowItem,
  reacc AS CACashFlowAccount,
  rebuk AS CACashFlowCompanyCode,
  cast(hbkid as farp_hbkid preserving type ) AS HouseBank,
  cast(hktid as fac_hktid preserving type ) AS HouseBankAccount,
  squan AS QuantitySignCode,
  kukey AS BankStatementShortID,
  esnum AS BankStatementItem,
  ltype AS CashManagementLinkType,
  lnkid AS CashManagementLink,
  xintb AS CAItmIsCreatedByPostgInterface,
  xcopa AS CAProfitAnalysisUpdtIsDirect,
  invgr AS CAInvcgGroupingKey,
  aasta AS CACtrlFieldForAcctAssgmtDistr,
  fmtyp AS CAUpdateMethodForFundsMgmt,
  origfikrs AS OriginalFinancialMgmtArea,
  budgetyear AS OriglYearForFinMgmtAcctAssgmt,
  kblnr AS EarmarkedFunds,
  kblnr AS EarmarkedFundsDocument,
  _CompCode.ChartOfAccounts AS ChartOfAccounts,
  _CompCode.Country AS Country,
  _CompCode._Country.TaxCalculationProcedure AS TaxCalculationProcedure
FROM dfkkopk
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON BusinessArea = _BusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_CAAccountAssignmentCategory AS _AcctAssgmtCat ON CAAccountAssignmentCategory = _AcctAssgmtCat.CAAccountAssignmentCategory  -- association [0..1]
LEFT OUTER JOIN I_CAAcctAssgmtDistrCode AS _CAAcctAssgmtDistrCode ON CACtrlFieldForAcctAssgmtDistr = _CAAcctAssgmtDistrCode.CACtrlFieldForAcctAssgmtDistr  -- association [0..1]
LEFT OUTER JOIN I_CAAcctDetnTransKey AS _CAAcctDetnTransKey ON CATransactionKeyAccountDetn = _CAAcctDetnTransKey.CATransactionKeyAccountDetn  -- association [0..1]
LEFT OUTER JOIN I_CAAltvExchangeRateSetCode AS _CAAltvExchangeRateSetCode ON CAAltvExchangeRateSetCode = _CAAltvExchangeRateSetCode.CAAltvExchangeRateSetCode  -- association [0..1]
LEFT OUTER JOIN I_CADocumentHeader AS _DocHeader ON CADocumentNumber = _DocHeader.CADocumentNumber  -- association [1..1]
LEFT OUTER JOIN I_CAEuroConversionStatus AS _CAEuroConversionStatus ON CAStatusOfEuroConversion = _CAEuroConversionStatus.CAStatusOfEuroConversion  -- association [1..1]
LEFT OUTER JOIN I_CANonDcblInputTaxCode AS _CANonDcblInputTaxCode ON CAContainsNonDeductibleInptTax = _CANonDcblInputTaxCode.CAContainsNonDeductibleInptTax  -- association [0..1]
LEFT OUTER JOIN I_CAOtherTaxCode AS _OtherTaxCode ON CAOtherTaxCode = _OtherTaxCode.CAOtherTaxCode AND country = _OtherTaxCode.Country  -- association [0..1]
LEFT OUTER JOIN I_CAIntPostingReasonCode AS _CAIntPostingReasonCode ON CAInternalPostingReasonCode = _CAIntPostingReasonCode.CAInternalPostingReasonCode  -- association [0..1]
LEFT OUTER JOIN I_CANegativePostingCtrlCode AS _CANegativePostingCtrlCode ON CANegativePostingControlCode = _CANegativePostingCtrlCode.CANegativePostingControlCode  -- association [0..1]
LEFT OUTER JOIN I_CAWithholdingTaxSupplement AS _WhldgTaxSuplmnt ON CAWithholdingTaxSupplement = _WhldgTaxSuplmnt.CAWithholdingTaxSupplement AND country = _WhldgTaxSuplmnt.Country  -- association [0..1]
LEFT OUTER JOIN I_ChartOfAccounts AS _ChartOfAccounts ON chartofaccounts = _ChartOfAccounts.ChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompCode ON CompanyCode = _CompCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompCodeCashFlow ON CACashFlowCompanyCode = _CompCodeCashFlow.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Country AS _Country ON country = _Country.Country  -- association [0..1]
LEFT OUTER JOIN I_Country AS _TaxCountry ON TaxCountry = _TaxCountry.Country  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _GLPostingCurrency ON CAGLPostingCurrency = _GLPostingCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _GLAccount ON chartofaccounts = _GLAccount.ChartOfAccounts AND GLAccount = _GLAccount.GLAccount  -- association [1..1]
LEFT OUTER JOIN I_GLAccountInCompanyCode AS _GLAccountInCompanyCode ON GLAccount = _GLAccountInCompanyCode.GLAccount AND CompanyCode = _GLAccountInCompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _CashFlowAccount ON chartofaccounts = _CashFlowAccount.ChartOfAccounts AND CACashFlowAccount = _CashFlowAccount.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenter AS _ProfitCenter ON ProfitCenter = _ProfitCenter.ProfitCenter  -- association [0..*]
LEFT OUTER JOIN I_Partnercompany AS _PartnerCompany ON PartnerCompany = _PartnerCompany.PartnerCompany  -- association [0..1]
LEFT OUTER JOIN I_Segment AS _Segment ON Segment = _Segment.Segment  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnit ON BaseUnit = _BaseUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN E_CADocumentGLItem AS _Extension ON CADocumentNumber = _Extension.CADocumentNumber AND CAGLItemNumber = _Extension.CAGLItemNumber  -- association [1..1]
;