C_SuplrBillgDocItemOutputForm

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 C_SuplrBillgDocItemOutputForm.
-- 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 C_SuplrBillgDocItemOutputForm AS
SELECT
  SuplrBillgDoc,
  SuplrBillgDocItem,
  SuplrBillgDocCurrency,
  PricingDocument AS SupplierPricingDocument,
  Product,
  ProductGroup,
  Plant,
  InventoryValuationType,
  PricingDate,
  TaxCode AS SupplierTaxCode,
  TaxJurisdiction,
  SettlmtQuantity,
  SettlmtQuantityUnit,
  NetPriceAmount,
  NetPriceQuantity,
  NetPriceQuantityUnit,
  SettlmtToBaseQuantityNmrtr,
  SettlmtToBaseQuantityDnmntr,
  SettlmtToNetPriceQtyNmrtr,
  SettlmtToNetPriceQtyDnmntr,
  BaseUnit,
  ItemNetWeight,
  ItemGrossWeight,
  ItemWeightUnit,
  ItemVolume,
  ItemVolumeUnit,
  ProductPurchasePointsQtyUnit,
  ProductPurchasePointsQty,
  SuplrBillgDocItemGrossAmount AS SupplierItemGrossAmount,
  SuplrBillgDocItemNetAmount AS SupplierItemNetAmount,
  SuplrBillgDocItemTaxAmount AS SupplierItemTaxAmount,
  SuplrBillgDocSubtotal1Amount AS SupplierSubtotal1Amount,
  SuplrBillgDocSubtotal2Amount AS SupplierSubtotal2Amount,
  SuplrBillgDocSubtotal3Amount AS SupplierSubtotal3Amount,
  SuplrBillgDocSubtotal4Amount AS SupplierSubtotal4Amount,
  SuplrBillgDocSubtotal5Amount AS SupplierSubtotal5Amount,
  SuplrBillgDocSubtotal6Amount AS SupplierSubtotal6Amount,
  SuplrBillgDocRebateBasisAmount AS SupplierRebateBasisAmount,
  SuplrBillgDocEffctvItemAmount AS SupplierEffectiveItemAmount,
  SuplrItmEligibleAmtForCshDisc,
  NonDeductibleInputTaxAmount,
  SuplrBillgDocItmStstclPrpty AS SettlmtItmStatisticalPrpty,
  CashDiscountIsDeductible,
  CreatedByUser,
  CreationDate,
  CreationTime,
  SettlmtSourceDoc,
  SettlmtSourceDocItem,
  SettlmtSourceDocCat,
  SettlmtSourceDocFiscalYear,
  SuplrBillgDocItmActyReason AS SettlmtItemActivityReason,
  SuplrBillgDocItemText,
  SupplierProductID,
  PriorSupplier,
  BusinessArea AS SuplrSettlmtBusinessArea,
  ControllingArea AS SuplrSettlmtControllingArea,
  CostCenter AS SuplrSettlmtCostCenter,
  ProfitCenter AS SuplrSettlmtProfitCenter,
  WBSElementInternalID AS SuplrSettlmtWBSElmntInternalID,
  SupplierBillingDocumentOrder AS SettlmtMgmtOrder,
  IncotermsVersion,
  IncotermsClassification,
  IncotermsTransferLocation,
  IncotermsLocation1,
  IncotermsLocation2,
  Batch,
  PrcDetnIsIncmplt,
  SettlmtPrecdgDoc,
  SettlmtPrecdgDocItem,
  SettlmtPrecdgDocCat,
  SettlmtPrecdgDocFiscalYear,
  SuplrBillgDocItmCat,
  SettlmtItemReltdCndnContr,
  SettlmtItemReltdTrdgContr,
  SettlmtItemReltdTrdgContrItem,
  SuplrBillgDocItemStatus,
  SuplrBillgDocItmReversed AS SuplrBillgDocItmCancld,
  ServicesRenderedDate,
  CompanyCode AS SuplrSettlmtCompanyCode,
  GLAccount,
  SettlementFiscalYear,
  HigherLevelItem,
  LowerLevelItemExists,
  ItemDistributionStatus,
  SettlmtRefDocType,
  SettlmtRefDoc,
  SettlmtRefDocFiscalYear,
  SettlmtRefDocLogicalSyst,
  SettlmtRefDocItem,
  SettlmtRefDocCat,
  ItemIntrastatRelevance,
  SettlmtAddlRefDocType,
  SettlmtAddlRefDoc,
  SettlmtAddlRefDocFiscalYear,
  SettlmtAddlRefDocLogicalSyst,
  SettlmtAddlRefDocItem,
  SettlmtAddlRefDocCat,
  CustomerSettlmtRecipient,
  SupplierSubrange,
  ProductHierarchy,
  SalesSpcfcProductGroup1,
  SalesSpcfcProductGroup2,
  SalesSpcfcProductGroup3,
  SalesSpcfcProductGroup4,
  SalesSpcfcProductGroup5
FROM R_SuplrBillgDocItem
LEFT OUTER JOIN C_SuplrBillgDocOutputForm AS _SuplrBillgDoc ON SuplrBillgDoc = _SuplrBillgDoc.SuplrBillgDoc  -- association [1..1]
LEFT OUTER JOIN I_SuplrBillgDocItmPlainLongTxt AS _SuplrBillgDocItmPlainLongTxt ON SuplrBillgDoc = _SuplrBillgDocItmPlainLongTxt.SuplrBillgDoc AND SuplrBillgDocItem = _SuplrBillgDocItmPlainLongTxt.SuplrBillgDocItem  -- association [0..*]
LEFT OUTER JOIN I_SuplrBillgDocItemPartner AS _SuplrBillgDocItemPartner ON SuplrBillgDoc = _SuplrBillgDocItemPartner.SuplrBillgDoc AND SuplrBillgDocItem = _SuplrBillgDocItemPartner.SuplrBillgDocItem  -- association [0..*]
LEFT OUTER JOIN I_SettlmtItmStatisticalPrpty AS _SettlmtItmStatisticalPrpty ON SettlmtItmStatisticalPrpty = _SettlmtItmStatisticalPrpty.SettlmtItmStatisticalPrpty  -- association [0..1]
LEFT OUTER JOIN I_SettlmtActivityReasonCode AS _SettlmtItemActivityReason ON SettlmtItemActivityReason = _SettlmtItemActivityReason.SettlmtActivityReason  -- association [0..1]
LEFT OUTER JOIN I_SuplrBillgDocItmPrcgElmnt AS _SuplrBillgDocItmPrcgElmnt ON SuplrBillgDoc = _SuplrBillgDocItmPrcgElmnt.SuplrBillgDoc AND SuplrBillgDocItem = _SuplrBillgDocItmPrcgElmnt.SuplrBillgDocItem  -- association [0..*]
LEFT OUTER JOIN I_SettlmtMgmtDocItemCancld AS _SuplrBillgDocItmCancld ON SuplrBillgDocItmCancld = _SuplrBillgDocItmCancld.SettlmtMgmtDocItemCancld  -- association [0..1]
LEFT OUTER JOIN C_SuplrBillgDocItemOutputForm AS _HigherLevelItem ON SuplrBillgDoc = _HigherLevelItem.SuplrBillgDoc AND HigherLevelItem = _HigherLevelItem.SuplrBillgDocItem  -- association [0..1]
LEFT OUTER JOIN I_BusinessArea AS _SuplrSettlmtBusinessArea ON SuplrSettlmtBusinessArea = _SuplrSettlmtBusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _SuplrSettlmtControllingArea ON SuplrSettlmtControllingArea = _SuplrSettlmtControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _SuplrSettlmtCostCenter ON SuplrSettlmtCostCenter = _SuplrSettlmtCostCenter.CostCenter AND SuplrSettlmtControllingArea = _SuplrSettlmtCostCenter.ControllingArea AND _SuplrSettlmtCostCenter.ValidityEndDate >= CreationDate AND _SuplrSettlmtCostCenter.ValidityStartDate <= CreationDate  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenter AS _SuplrSettlmtProfitCenter ON SuplrSettlmtProfitCenter = _SuplrSettlmtProfitCenter.ProfitCenter AND SuplrSettlmtControllingArea = _SuplrSettlmtProfitCenter.ControllingArea AND _SuplrSettlmtProfitCenter.ValidityEndDate >= CreationDate AND _SuplrSettlmtProfitCenter.ValidityStartDate <= CreationDate  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _SuplrSettlmtWBSElmntBasicData ON SuplrSettlmtWBSElmntInternalID = _SuplrSettlmtWBSElmntBasicData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_InternalOrder AS _SettlmtMgmtOrder ON SettlmtMgmtOrder = _SettlmtMgmtOrder.InternalOrder  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _SuplrSettlmtCompanyCode ON SuplrSettlmtCompanyCode = _SuplrSettlmtCompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_ConditionContract AS _SettlmtItemReltdCndnContr ON SettlmtItemReltdCndnContr = _SettlmtItemReltdCndnContr.ConditionContract  -- association [0..1]
LEFT OUTER JOIN E_SettlmtMgmtDocItem AS _Extension ON SuplrBillgDoc = _Extension.SettlmtMgmtDoc AND SuplrBillgDocItem = _Extension.SettlmtMgmtDocItem  -- association [1..1]
;