C_BillingDocumentItem_F0797

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_BillingDocumentItem_F0797.
-- 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: CBDOCITEMF0797

CREATE VIEW C_BillingDocumentItem_F0797 AS
SELECT
  Item.BillingDocument AS BillingDocument,
  Item.BillingDocumentItem AS BillingDocumentItem,
  cast (Item.Material as productnumber preserving type) AS Material,
  Item.BillingDocumentItemText AS BillingDocumentItemText,
  Item.BillingQuantity AS BillingQuantity,
  Item.BillingQuantityUnit AS BillingQuantityUnit,
  Item.NetAmount AS ItemNetAmountOfBillingDoc,
  Item.TaxAmount AS TaxAmount,
  Item.GrossAmount AS ItemGrossAmountOfBillingDoc,
  Item.TransactionCurrency AS TransactionCurrency,
  Item.ReferenceSDDocumentCategory AS ReferenceSDDocumentCategory,
  Item.ReferenceSDDocument AS ReferenceSDDocument,
  Item.ReferenceSDDocumentItem AS ReferenceSDDocumentItem,
  Item.SalesDocumentItemCategory AS SalesDocumentItemCategory,
  Item.SalesDocument AS SalesDocument,
  Item.SalesDocumentItem AS SalesDocumentItem,
  Item.Plant AS Plant,
  Item.Division AS Division,
  Item.StorageLocation AS StorageLocation,
  Item.ProductConfiguration AS ProductConfiguration,
  Item.TransitPlant AS TransitPlant,
  Item.PricingDate AS PricingDate,
  Item.StatisticalValueControl AS StatisticalValueControl,
  Item.ReturnItemProcessingType AS ReturnItemProcessingType,
  cast (Item.MaterialGroup as productgroup preserving type) AS MaterialGroup,
  Item.ServicesRenderedDate AS ServicesRenderedDate,
  _BillingDocument.PricingDocument AS PricingDocument,
  Item.BusinessArea AS BusinessArea,
  _WBSElementBasicData.WBSElementExternalID AS WBSElementExternalID,
  Item.MatlAccountAssignmentGroup AS MatlAccountAssignmentGroup,
  Item.DepartureCountry AS DepartureCountry,
  Item.TaxJurisdiction AS TaxJurisdiction,
  Item.ProductTaxClassification1 AS ProductTaxClassification1,
  Item.ProductTaxClassification2 AS ProductTaxClassification2,
  Item.ProductTaxClassification3 AS ProductTaxClassification3,
  Item.ProductTaxClassification4 AS ProductTaxClassification4,
  Item.ProductTaxClassification5 AS ProductTaxClassification5,
  Item.ProductTaxClassification6 AS ProductTaxClassification6,
  Item.ProductTaxClassification7 AS ProductTaxClassification7,
  Item.ProductTaxClassification8 AS ProductTaxClassification8,
  Item.ProductTaxClassification9 AS ProductTaxClassification9,
  Item.BillToPartyCountry AS BillToPartyCountry,
  Item.BillToPartyRegion AS BillToPartyRegion,
  Item.OrganizationDivision AS OrganizationDivision,
  Item.ServiceDocumentType AS ServiceDocumentType,
  Item.ServiceDocument AS ServiceDocument,
  Item.ServiceDocumentItem AS ServiceDocumentItem,
  Item.BusinessSolutionOrder AS BusinessSolutionOrder,
  Item.BusinessSolutionOrderItem AS BusinessSolutionOrderItem,
  Item.SalesGroup AS SalesGroup,
  Item.SalesOffice AS SalesOffice,
  Item.RetailPromotion AS RetailPromotion,
  Item.SDDocumentReason AS SDDocumentReason,
  Item.SalesSDDocumentCategory AS SalesSDDocumentCategory,
  Item.VolumeRebateGroup AS VolumeRebateGroup,
  Item.SalesOrderSalesDistrict AS SalesOrderSalesDistrict,
  Item.Batch AS Batch,
  Item.InternationalArticleNumber AS InternationalArticleNumber,
  Item.BillingPlanRule AS BillingPlanRule,
  Item.BillingQuantityInBaseUnit AS BillingQuantityInBaseUnit,
  Item.ItemWeightUnit AS ItemWeightUnit,
  Item.ItemNetWeight AS ItemNetWeight,
  Item.ItemGrossWeight AS ItemGrossWeight,
  Item.ItemVolumeUnit AS ItemVolumeUnit,
  Item.ItemVolume AS ItemVolume,
  Item.ZeroVATRsn AS ZeroVATRsn,
  Item.SalesOrderCustomerGroup AS SalesOrderCustomerGroup,
  Item.SalesDeal AS SalesDeal,
  Item.SalesPromotion AS SalesPromotion,
  Item.SalesOrderCustomerPriceGroup AS SalesOrderCustomerPriceGroup,
  Item.MaterialPricingGroup AS MaterialPricingGroup,
  Item.AdditionalCustomerGroup1 AS AdditionalCustomerGroup1,
  Item.AdditionalCustomerGroup2 AS AdditionalCustomerGroup2,
  Item.AdditionalCustomerGroup3 AS AdditionalCustomerGroup3,
  Item.AdditionalCustomerGroup4 AS AdditionalCustomerGroup4,
  Item.AdditionalCustomerGroup5 AS AdditionalCustomerGroup5,
  Item.OriginallyRequestedMaterial AS OriginallyRequestedMaterial,
  Item.BaseUnit AS BaseUnit,
  Item.ManualPriceChangeType AS ManualPriceChangeType,
  Item.AdditionalMaterialGroup1 AS AdditionalMaterialGroup1,
  Item.AdditionalMaterialGroup2 AS AdditionalMaterialGroup2,
  Item.AdditionalMaterialGroup3 AS AdditionalMaterialGroup3,
  Item.AdditionalMaterialGroup4 AS AdditionalMaterialGroup4,
  Item.AdditionalMaterialGroup5 AS AdditionalMaterialGroup5,
  Item.SalesOrderPriceListType AS SalesOrderPriceListType,
  Item.PricingReferenceMaterial AS PricingReferenceMaterial,
  Item.ProductHierarchyNode AS ProductHierarchyNode,
  Item.MaterialCommissionGroup AS MaterialCommissionGroup,
  Item.EligibleAmountForCashDiscount AS EligibleAmountForCashDiscount,
  Item.BillingToBaseQuantityDnmntr AS BillingToBaseQuantityDnmntr,
  Item.BillingToBaseQuantityNmrtr AS BillingToBaseQuantityNmrtr,
  Item.SalesOrderSalesOrganization AS SalesOrderSalesOrganization,
  Item.SalesOrderDistributionChannel AS SalesOrderDistributionChannel,
  Item.PlantCounty AS PlantCounty,
  Item.PlantCity AS PlantCity,
  Item.PlantRegion AS PlantRegion,
  Item.CostCenter AS CostCenter,
  Item.ProfitCenter AS ProfitCenter,
  Item.OrderID AS OrderID,
  Item.ControllingArea AS ControllingArea,
  Item.CreationDate AS CreationDate,
  Item.HigherLevelItem AS HigherLevelItem,
  Item.ProviderContract AS ProviderContract,
  cast(Item.ProviderContract as subscription_billing_doc preserving type) AS SubscrpnBillgSubscription,
  Item.ProviderContractItem AS ProviderContractItem,
  Item.BillingPerformancePeriodStrDte AS BillingPerformancePeriodStrDte,
  Item.BillingPerformancePeriodEndDte AS BillingPerformancePeriodEndDte,
  Item._HigherLevelItem AS _HigherLevelItem,
  Item._SalesSDDocumentCategory AS _SalesSDDocumentCategory,
  Item._BillingPlanRule AS _BillingPlanRule,
  Item._MaterialPricingGroup AS _MaterialPricingGroup,
  Item._ProductHierarchyNode AS _ProductHierarchyNode,
  Item._MatlAccountAssignmentGroup AS _MatlAccountAssignmentGroup,
  Item._SalesOrderSalesOrganization AS _SalesOrderSalesOrganization,
  Item._SalesOrderDistributionChannel AS _SalesOrderDistributionChannel,
  Item._SalesOrderSalesDistrict AS _SalesOrderSalesDistrict,
  Item._SalesOrderCustomerGroup AS _SalesOrderCustomerGroup,
  Item._SalesOrderCustomerPriceGroup AS _SalesOrderCustomerPriceGroup,
  Item._SalesOrderPriceListType AS _SalesOrderPriceListType,
  Item._OriginallyRequestedMaterial AS _OriginallyRequestedMaterial,
  Item._SDDocumentReason AS _SDDocumentReason,
  Item._PlantRegion AS _PlantRegion,
  Item._RetailPromotion AS _RetailPromotion,
  Item._SalesDeal AS _SalesDeal,
  Item._MaterialCommissionGroup AS _MaterialCommissionGroup,
  Item._AdditionalCustomerGroup1 AS _AdditionalCustomerGroup1,
  Item._AdditionalCustomerGroup2 AS _AdditionalCustomerGroup2,
  Item._AdditionalCustomerGroup3 AS _AdditionalCustomerGroup3,
  Item._AdditionalCustomerGroup4 AS _AdditionalCustomerGroup4,
  Item._AdditionalCustomerGroup5 AS _AdditionalCustomerGroup5,
  Item._AdditionalMaterialGroup1 AS _AdditionalMaterialGroup1,
  Item._AdditionalMaterialGroup2 AS _AdditionalMaterialGroup2,
  Item._AdditionalMaterialGroup3 AS _AdditionalMaterialGroup3,
  Item._AdditionalMaterialGroup4 AS _AdditionalMaterialGroup4,
  Item._AdditionalMaterialGroup5 AS _AdditionalMaterialGroup5,
  Item._PricingReferenceMaterial AS _PricingReferenceMaterial,
  Item._Material AS _Material,
  Item._ReferenceSDDocumentCategory AS _ReferenceSDDocumentCategory,
  Item._SalesDocumentItemCategory AS _SalesDocumentItemCategory,
  Item._Plant AS _Plant,
  Item._TransitPlant AS _TransitPlant,
  Item._Division AS _Division,
  Item._StorageLocation AS _StorageLocation,
  Item._StatisticalValueControl AS _StatisticalValueControl,
  Item._DepartureCountry AS _DepartureCountry,
  Item._ProfitCenter AS _ProfitCenter,
  Item._BillToPartyCountry AS _BillToPartyCountry,
  Item._BillToPartyRegion AS _BillToPartyRegion,
  Item._OrganizationDivision AS _OrganizationDivision,
  Item._ServiceDocumentType AS _ServiceDocumentType,
  Item._SalesGroup AS _SalesGroup,
  Item._SalesOffice AS _SalesOffice,
  Item._CostCenter AS _CostCenter,
  Item._CostCenter_2 AS _CostCenter_2,
  Item._ControllingArea AS _ControllingArea,
  Item._ProviderContract AS _ProviderContract,
  Item._ProviderContractItem AS _ProviderContractItem
FROM I_BillingDocumentItem AS Item
LEFT OUTER JOIN C_PricingElement AS _PricingElement ON pricingdocument = _PricingElement.PricingDocument AND BillingDocumentItem = _PricingElement.PricingDocumentItem  -- association [0..*]
LEFT OUTER JOIN C_BillingDocument_F0797 AS _BillingDocument ON BillingDocument = _BillingDocument.BillingDocument  -- association [1]
LEFT OUTER JOIN I_WBSElementByExternalID AS _WBSElementExternalID ON wbselementexternalid = _WBSElementExternalID.WBSElementExternalID  -- association [0..1]
LEFT OUTER JOIN E_BillingDocumentItem AS _Extension ON BillingDocument = _Extension.BillingDocument AND BillingDocumentItem = _Extension.BillingDocumentItem  -- association [1]
;