I_OIL_LgclInvtryAdjmtDocItem

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_OIL_LgclInvtryAdjmtDocItem.
-- 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_OIL_LgclInvtryAdjmtDocItem AS
SELECT
  upenum AS LgclInvtryAdjmtDocumentNumber,
  mjahr AS LgclInvtryAdjmtDocumentYear,
  segnum AS LgclInvtryAdjmtDocItemNumber,
  item_type AS LgclInvtryAdjmtItmType,
  bukrs AS CompanyCode,
  exgtyp AS ExchangeAgreementType,
  exgnum AS ExchangeAgreement,
  werks AS Plant,
  matnr AS Material,
  meins AS UnitOfMeasure,
  menge AS TransacUnitOfMeasureQuantity,
  skmeins AS StockKeepingUnitOfMeasure,
  skmenge AS StockKeepingQuantity,
  bldat AS DocumentDate,
  budat AS PostingDate,
  waers AS Currency,
  pymt AS LgclInvtryAdjmtPaymentAmount,
  zterm AS PaymentTerms,
  zlspr AS PaymentBlockKey,
  cvind AS LgclInvtryAdjCustSuppPosIn,
  vkorg AS SalesOrganization,
  ekorg AS PurchasingOrganization,
  taxcd AS TaxCode,
  sgtxt AS ItemTextLgclInvtryAdjmt,
  negadj AS NgtvAdjmtIndForAdjmt,
  subprod AS ExchangeProductNumber,
  oicycle AS InvoiceCycle,
  oid_extbol AS LadingExternalBill,
  lia_dmbtr AS QtyAdjmtValLocAmount,
  matpst AS MaterialPostingRule,
  ktosl AS FeeAccountingProcessKey,
  _CompanyCode._Country.TaxCalculationProcedure AS TaxCalculationProcedure
FROM oia08
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON _CompanyCode.CompanyCode = CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_ExchangeAgreementType AS _ExchangeAgreementType ON _ExchangeAgreementType.ExchangeAgreementType = ExchangeAgreementType  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _Plant ON _Plant.Plant = Plant  -- association [1..1]
LEFT OUTER JOIN I_Material AS _StockIdentifyingMaterial ON _StockIdentifyingMaterial.Material = Material  -- association [1..1]
LEFT OUTER JOIN I_Material AS _Material ON _Material.Material = Material  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON _UnitOfMeasure.UnitOfMeasure = UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _StockKeepingUnit ON _StockKeepingUnit.UnitOfMeasure = StockKeepingUnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _Currency ON _Currency.Currency = Currency  -- association [1..1]
LEFT OUTER JOIN I_OIL_PaymentBlockingReasonVH AS _PaymentBlockingReason ON _PaymentBlockingReason.PaymentBlockKey = PaymentBlockKey  -- association [1..1]
LEFT OUTER JOIN I_OIL_FeeAcctgProcStringVH AS _FeeAcctgProcStringVH ON _FeeAcctgProcStringVH.FeeAccountingProcessKey = FeeAccountingProcessKey AND _FeeAcctgProcStringVH.EXGApplUseSalesAndPurchasing = 'M'  -- association [1..1]
LEFT OUTER JOIN I_SalesOrganization AS _SalesOrganization ON _SalesOrganization.SalesOrganization = SalesOrganization  -- association [1..1]
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganization ON _PurchasingOrganization.PurchasingOrganization = PurchasingOrganization  -- association [1..1]
LEFT OUTER JOIN I_Material AS _DerivedProduct ON _DerivedProduct.Material = ExchangeProductNumber  -- association [1..1]
LEFT OUTER JOIN I_OIL_CustSuplrPostingIndVH AS _CustSuplrPostingIndVH ON _CustSuplrPostingIndVH.LgclInvtryAdjCustSuppPosIn = LgclInvtryAdjCustSuppPosIn  -- association [1..1]
LEFT OUTER JOIN I_OIL_ExchAgrmtMatlPostgRuleVH AS _ExchAgrmtMatlPostgRuleVH ON _ExchAgrmtMatlPostgRuleVH.MaterialPostingRule = MaterialPostingRule  -- association [1..1]
LEFT OUTER JOIN I_OIL_InvoiceCycleVH AS _InvoiceCycleVH ON _InvoiceCycleVH.InvoiceCycle = InvoiceCycle  -- association [1..1]
LEFT OUTER JOIN I_OIL_BalanceAdjustmentTypeVH AS _BalanceAdjustmentTypeVH ON _BalanceAdjustmentTypeVH.LgclInvtryAdjmtItmType = LgclInvtryAdjmtItmType  -- association [1..1]
LEFT OUTER JOIN I_TaxCode AS _TaxCode ON _TaxCode.TaxCode = TaxCode AND _TaxCode.TaxCalculationProcedure = TaxCalculationProcedure  -- association [1..1]
;