C_BillgDocItmPrcgElmntBscDEX_1

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_BillgDocItmPrcgElmntBscDEX_1.
-- 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: CSDBDOCITMPECDX1

CREATE VIEW C_BillgDocItmPrcgElmntBscDEX_1 AS
SELECT
  PrcgElmnt.PricingDocument AS PricingDocument,
  PrcgElmnt.PricingDocumentItem AS PricingDocumentItem,
  PricingProcedureStep,
  PricingProcedureCounter,
  BDoc.BillingDocument AS BillingDocument,
  BItm.BillingDocumentItem AS BillingDocumentItem,
  ConditionApplication,
  ConditionType,
  ConditionCategory,
  ConditionClass,
  BDoc.BillingDocumentCategory AS BillingDocumentCategory,
  BDoc.BillingDocumentType AS BillingDocumentType,
  BDoc.SDDocumentCategory AS SDDocumentCategory,
  BItm.SalesDocumentItemCategory AS SalesDocumentItemCategory,
  BItm.SalesDocumentItemType AS SalesDocumentItemType,
  BItm.ReturnItemProcessingType AS ReturnItemProcessingType,
  BDoc.LastChangeDate AS LastChangeDate,
  BItm.CreationDate AS CreationDate,
  BItm.CreationTime AS CreationTime,
  BDoc.SalesOrganization AS SalesOrganization,
  BDoc.DistributionChannel AS DistributionChannel,
  BItm.OrganizationDivision AS OrganizationDivision,
  BItm.SalesOffice AS SalesOffice,
  BItm.SalesGroup AS SalesGroup,
  BDoc.SoldToParty AS SoldToParty,
  BDoc.PayerParty AS PayerParty,
  BItm.BillToParty AS BillToParty,
  BItm.ShipToParty AS ShipToParty,
  BItm.SalesEmployee AS SalesEmployee,
  BItm.ResponsibleEmployee AS ResponsibleEmployee,
  BItm.Material AS Material,
  BItm.Product AS Product,
  BItm.Division AS Division,
  BItm.InternationalArticleNumber AS InternationalArticleNumber,
  BItm.OriginallyRequestedMaterial AS OriginallyRequestedMaterial,
  BItm.MaterialGroup AS MaterialGroup,
  BItm.ProductGroup AS ProductGroup,
  BItm.AdditionalMaterialGroup1 AS AdditionalMaterialGroup1,
  BItm.AdditionalMaterialGroup2 AS AdditionalMaterialGroup2,
  BItm.AdditionalMaterialGroup3 AS AdditionalMaterialGroup3,
  BItm.AdditionalMaterialGroup4 AS AdditionalMaterialGroup4,
  BItm.AdditionalMaterialGroup5 AS AdditionalMaterialGroup5,
  BItm.MaterialCommissionGroup AS MaterialCommissionGroup,
  ConditionIsForStatistics,
  ConditionOrigin,
  ConditionAmount,
  PrcgElmnt.TransactionCurrency AS TransactionCurrency,
  ConditionInactiveReason,
  ConditionIsForConfiguration,
  VariantCondition,
  BDoc.ExchangeRateType AS ExchangeRateType,
  BItm.PricingDate AS PricingDate,
  BItm.PriceDetnExchangeRate AS PriceDetnExchangeRate,
  BItm.PriceDetnExchangeRateDate AS PriceDetnExchangeRateDate,
  BItm.StatisticalValueControl AS StatisticalValueControl,
  BDoc.BillingDocumentDate AS BillingDocumentDate,
  BDoc.BillingDocumentIsCancelled AS BillingDocumentIsCancelled,
  BDoc.BillingDocumentIsTemporary AS BillingDocumentIsTemporary,
  BItm.BillingQuantityUnit AS BillingQuantityUnit,
  BItm.BillingQuantity AS BillingQuantity,
  BItm.ServicesRenderedDate AS ServicesRenderedDate,
  BItm.BillingPlanRule AS BillingPlanRule,
  BDoc.CompanyCode AS CompanyCode,
  BDoc.AccountingExchangeRate AS AccountingExchangeRate,
  BDoc.StatisticsCurrency AS StatisticsCurrency,
  BDoc.FiscalYear AS FiscalYear,
  BDoc.FiscalPeriod AS FiscalPeriod,
  BDoc._CompanyCode.Currency AS Currency,
  BDoc._CompanyCode.FiscalYearVariant AS FiscalYearVariant,
  BItm.ControllingArea AS ControllingArea,
  BItm.CostCenter AS CostCenter,
  BItm.StatisticsExchangeRate AS StatisticsExchangeRate,
  BDoc.CustomerGroup AS CustomerGroup,
  BDoc.SalesDistrict AS SalesDistrict,
  BItm.AdditionalCustomerGroup1 AS AdditionalCustomerGroup1,
  BItm.AdditionalCustomerGroup2 AS AdditionalCustomerGroup2,
  BItm.AdditionalCustomerGroup3 AS AdditionalCustomerGroup3,
  BItm.AdditionalCustomerGroup4 AS AdditionalCustomerGroup4,
  BItm.AdditionalCustomerGroup5 AS AdditionalCustomerGroup5,
  BDoc.OverallBillingStatus AS OverallBillingStatus,
  BItm.ReferenceSDDocument AS ReferenceSDDocument,
  BItm.ReferenceSDDocumentItem AS ReferenceSDDocumentItem,
  BItm.ReferenceSDDocumentCategory AS ReferenceSDDocumentCategory,
  BItm.SalesDocument AS SalesDocument,
  BItm.SalesDocumentItem AS SalesDocumentItem
FROM I_PricingElement AS PrcgElmnt
INNER JOIN I_BillingDocumentBasic AS BDoc ON /* join condition not captured in parsed metadata */
INNER JOIN I_BillingDocExtdItemBasic AS BItm ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN E_BillingDocumentItem AS _ExtensionItem ON BillingDocument = _ExtensionItem.BillingDocument AND BillingDocumentItem = _ExtensionItem.BillingDocumentItem  -- association [0..1]
LEFT OUTER JOIN E_BillingDocument AS _ExtensionHeader ON BillingDocument = _ExtensionHeader.BillingDocument  -- association [0..1]
;