I_BillingDocItemAnalytics

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_BillingDocItemAnalytics.
-- 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_BillingDocItemAnalytics AS
SELECT
  cast(Item.BillingDocumentItem as billing_document_item) AS BillingDocumentItem,
  cast(Item.SalesDocumentItemCategory as sales_document_item_category preserving type ) AS SalesDocumentItemCategory,
  cast(Item.SalesDocumentItemType as sales_document_item_type preserving type ) AS SalesDocumentItemType,
  cast(Item.ReturnItemProcessingType as return_id_processing_type) AS ReturnItemProcessingType,
  Item._CreatedByUser.UserDescription AS CreatedByUserName,
  cast( Item.CreationTime as creation_time ) AS CreationTime,
  cast(Item._SoldToParty.CustomerName as vdm_sold_to_name) AS SoldToPartyName,
  Item._SoldToParty.CustomerClassification AS SoldToPartyClassification,
  cast(Item.ShipToParty as kunwe preserving type) AS ShipToParty,
  cast(Item._ShipToParty.CustomerName as ship_to_name) AS ShipToPartyName,
  cast(Item.BillToParty as kunre preserving type) AS BillToParty,
  cast(Item._BillToParty.CustomerName as bill_to_name ) AS BillToPartyName,
  cast(Item._PayerParty.CustomerName as payer_name) AS PayerPartyName,
  cast(Item._SalesEmployee_2.PersonFullName as sales_empl_name) AS SalesEmployeeName,
  cast(Item.ResponsibleEmployee as resp_empl preserving type) AS ResponsibleEmployee,
  cast(Item._ResponsibleEmployee_2.PersonFullName as resp_empl_name) AS ResponsibleEmployeeName,
  cast(Item.CustomerRebateAgreement as customer_rebate_agreement) AS CustomerRebateAgreement,
  cast(Item.RetailPromotion as retail_promotion) AS RetailPromotion,
  cast(Item.ItemIsRelevantForCredit as credit_check_relevant_item) AS ItemIsRelevantForCredit,
  cast(Item._SalesDeal.SalesDealDescription as sales_deal_description) AS SalesDealDescription,
  cast(Item.SalesPromotion as sales_promotion) AS SalesPromotion,
  cast(Item.OrganizationDivision as organization_division preserving type) AS OrganizationDivision,
  Product,
  Item._Plant.PlantName AS PlantName,
  Item._StorageLocation.StorageLocationName AS StorageLocationName,
  cast(_BillingDocument.BillingDocumentIsCancelled as billing_document_cancln_flag) AS BillingDocumentIsCancelled,
  cast(_BillingDocument.CancelledBillingDocument as canceled_billing_document) AS CancelledBillingDocument,
  cast('' as exnum) AS ForeignTrade,
  cast('' as export_delivery_flag) AS IsExportDelivery,
  cast(Item.BillingDocumentItemText as billing_document_item_desc ) AS BillingDocumentItemText,
  cast(Item.BillingPlanItem as billing_plan_item) AS BillingPlanItem,
  cast(Item.MainItemPricingRefMaterial as slsdoc_main_itm_prcg_ref_matl preserving type ) AS MainItemPricingRefMaterial,
  _BillingDocument._PaymentMethod.PaymentMethodName AS PaymentMethodName,
  _BillingDocument._CompanyCode.CompanyCodeName AS CompanyCodeName,
  cast(_BillingDocument.AccountingDocument as accounting_document_number ) AS AccountingDocument,
  cast(_BillingDocument.DocumentReferenceID as document_reference_id) AS DocumentReferenceID,
  cast(_BillingDocument.AssignmentReference as assignment_reference) AS AssignmentReference,
  cast( Item.WBSElement as sd_ps_psp_pnr preserving type ) AS WBSElement,
  Item._ControllingArea.ControllingAreaName AS ControllingAreaName,
  cast(Item.OriginSDDocumentItem as origin_sd_document_item) AS OriginSDDocumentItem,
  cast(Item.SalesSDDocumentCategory as sales_sd_doc_category preserving type ) AS SalesSDDocumentCategory,
  BusinessSolutionOrder,
  BusinessSolutionOrderItem,
  cast(Item.OverallSDProcessStatus as overall_sd_process_status preserving type ) AS OverallSDProcessStatus,
  cast(Item.OverallBillingStatus as overall_billing_status preserving type ) AS OverallBillingStatus,
  cast(_BillingDocument.AccountingTransferStatus as accounting_transfer_status preserving type ) AS AccountingTransferStatus,
  cast( _BillingDocument.BillingIssueType as billing_issue_type preserving type ) AS BillingIssueType,
  cast(_BillingDocument.OvrlItmGeneralIncompletionSts as itms_ovrl_incompletion_status preserving type ) AS OvrlItmGeneralIncompletionSts,
  cast(_BillingDocument.OverallPricingIncompletionSts as ovrl_pricing_incompletion_sts preserving type) AS OverallPricingIncompletionSts,
  CreditMemoNetamount,
  Item._SalesOrganization.SalesOrganizationCurrency AS StatisticsCurrency,
  does not exist yet Item._AdditionalMaterialGroup1 AS _AdditionalMaterialGroup1,
  Item._ProfitCenter AS 2021CE2111,
  Item.BillingDocument AS BillingDocument,
  Item.SDDocumentCategory AS SDDocumentCategory,
  Item.BillingDocumentCategory AS BillingDocumentCategory,
  Item.BillingDocumentType AS BillingDocumentType,
  Item.CreatedByUser AS CreatedByUser,
  Item.CreationDate AS CreationDate,
  Item.ReferenceLogicalSystem AS LogicalSystem,
  Item.SoldToParty AS SoldToParty,
  Item.PayerParty AS PayerParty,
  Item.CustomerGroup AS CustomerGroup,
  Item.SalesDistrict AS SalesDistrict,
  Item.SalesGroup AS SalesGroup,
  Item.AdditionalCustomerGroup1 AS AdditionalCustomerGroup1,
  Item.AdditionalCustomerGroup2 AS AdditionalCustomerGroup2,
  Item.AdditionalCustomerGroup3 AS AdditionalCustomerGroup3,
  Item.AdditionalCustomerGroup4 AS AdditionalCustomerGroup4,
  Item.AdditionalCustomerGroup5 AS AdditionalCustomerGroup5,
  Item.SDDocumentReason AS SDDocumentReason,
  Item.VolumeRebateGroup AS VolumeRebateGroup,
  Item.SalesDeal AS SalesDeal,
  Item.SalesOrganization AS SalesOrganization,
  Item.DistributionChannel AS DistributionChannel,
  Item.Division AS Division,
  Item.SalesOffice AS SalesOffice,
  Item.Material AS Material,
  Item.OriginallyRequestedMaterial AS OriginallyRequestedMaterial,
  Item.InternationalArticleNumber AS InternationalArticleNumber,
  Item.PricingReferenceMaterial AS PricingReferenceMaterial,
  Item.Batch AS Batch,
  Item.ProductHierarchyNode AS ProductHierarchyNode,
  Item.MaterialGroup AS MaterialGroup,
  Item.ProductGroup AS ProductGroup,
  Item.AdditionalMaterialGroup1 AS AdditionalMaterialGroup1,
  Item.AdditionalMaterialGroup2 AS AdditionalMaterialGroup2,
  Item.AdditionalMaterialGroup3 AS AdditionalMaterialGroup3,
  Item.AdditionalMaterialGroup4 AS AdditionalMaterialGroup4,
  Item.AdditionalMaterialGroup5 AS AdditionalMaterialGroup5,
  Item.MaterialCommissionGroup AS MaterialCommissionGroup,
  Item.Plant AS Plant,
  Item.StorageLocation AS StorageLocation,
  Item.BillingDocumentDate AS BillingDocumentDate,
  Item.ServicesRenderedDate AS ServicesRenderedDate,
  Item.BillingQuantity AS BillingQuantity,
  Item.BillingQuantityUnit AS BillingQuantityUnit,
  Item.BillingQuantityInBaseUnit AS BillingQuantityInBaseUnit,
  Item.MRPRequiredQuantityInBaseUnit AS MRPRequiredQuantityInBaseUnit,
  Item.BillingToBaseQuantityDnmntr AS BillingToBaseQuantityDnmntr,
  Item.BillingToBaseQuantityNmrtr AS BillingToBaseQuantityNmrtr,
  Item.ItemGrossWeight AS ItemGrossWeight,
  Item.ItemNetWeight AS ItemNetWeight,
  Item.ItemWeightUnit AS ItemWeightUnit,
  Item.ItemVolume AS ItemVolume,
  Item.ItemVolumeUnit AS ItemVolumeUnit,
  Item.BillToPartyCountry AS BillToPartyCountry,
  Item.BillToPartyRegion AS BillToPartyRegion,
  Item.BillingPlanRule AS BillingPlanRule,
  Item.BillingPlan AS BillingPlan,
  Item.CustomerPriceGroup AS CustomerPriceGroup,
  Item.GrossAmount AS ItemGrossAmountOfBillingDoc,
  Item.PricingDate AS PricingDate,
  Item.PriceDetnExchangeRate AS PriceDetnExchangeRate,
  Item.PricingScaleQuantityInBaseUnit AS PricingScaleQuantityInBaseUnit,
  Item.TaxAmount AS TaxAmount,
  Item.CostAmount AS CostAmount,
  Item.Subtotal1Amount AS Subtotal1Amount,
  Item.Subtotal2Amount AS Subtotal2Amount,
  Item.Subtotal3Amount AS Subtotal3Amount,
  Item.Subtotal4Amount AS Subtotal4Amount,
  Item.Subtotal5Amount AS Subtotal5Amount,
  Item.Subtotal6Amount AS Subtotal6Amount,
  Item.StatisticalValueControl AS StatisticalValueControl,
  Item.ShippingPoint AS ShippingPoint,
  Item.EligibleAmountForCashDiscount AS EligibleAmountForCashDiscount,
  Item.BusinessArea AS BusinessArea,
  Item.WBSElementInternalID AS WBSElementInternalID,
  Item.ControllingArea AS ControllingArea,
  Item.ProfitabilitySegment_2 AS ProfitabilitySegment,
  Item.ProfitabilitySegment_2 AS ProfitabilitySegment_2,
  Item.OrderID AS OrderID,
  Item.CostCenter AS CostCenter,
  Item.OriginSDDocument AS OriginSDDocument,
  Item.PriceDetnExchangeRateDate AS ExchangeRateDate,
  Item.ReferenceSDDocument AS ReferenceSDDocument,
  Item.ReferenceSDDocumentItem AS ReferenceSDDocumentItem,
  Item.ReferenceSDDocumentCategory AS ReferenceSDDocumentCategory,
  Item.SalesDocument AS SalesDocument,
  Item.SalesDocumentItem AS SalesDocumentItem,
  Item.HigherLevelItem AS HigherLevelItem,
  Item.BillingDocumentItemInPartSgmt AS BillingDocumentItemInPartSgmt,
  Item.BaseUnit AS BaseUnit,
  Item._TransactionCurrency AS _TransactionCurrency,
  Item._SDDocumentCategory AS _SDDocumentCategory,
  Item._BillingDocumentCategory AS _BillingDocumentCategory,
  Item._BillingDocumentType AS _BillingDocumentType,
  Item._SalesOrganization AS _SalesOrganization,
  Item._DistributionChannel AS _DistributionChannel,
  Item._CustomerPriceGroup AS _CustomerPriceGroup,
  Item._CustomerGroup AS _CustomerGroup,
  Item._SalesDistrict AS _SalesDistrict,
  Item._OverallSDProcessStatus AS _OverallSDProcessStatus,
  Item._OverallBillingStatus AS _OverallBillingStatus,
  Item._SoldToParty AS _SoldToParty,
  Item._ShipToParty AS _ShipToParty,
  Item._BillToParty AS _BillToParty,
  Item._PayerParty AS _PayerParty,
  Item._SalesDocumentItemCategory AS _SalesDocumentItemCategory,
  Item._SalesDocumentItemType AS _SalesDocumentItemType,
  Item._CreatedByUser AS _CreatedByUser,
  Item._ReferenceLogicalSystem AS _LogicalSystem,
  Item._OrganizationDivision AS _OrganizationDivision,
  Item._Division AS _Division,
  Item._SalesOffice AS _SalesOffice,
  Item._Material AS _Material,
  Item._Product AS _Product,
  Item._MaterialText AS _MaterialText,
  Item._ProductText AS _ProductText,
  Item._OriginallyRequestedMaterial AS _OriginallyRequestedMaterial,
  Item._OriginallyRequestedMatlText AS _OriginallyRequestedMatlText,
  Item._PricingReferenceMaterial AS _PricingReferenceMaterial,
  Item._PricingReferenceMaterialText AS _PricingReferenceMaterialText,
  Item._Batch AS _Batch,
  Item._ProductHierarchyNode AS _ProductHierarchyNode,
  Item._MaterialGroup AS _MaterialGroup,
  Item._ProductGroup AS _ProductGroup,
  Item._MaterialGroupText AS _MaterialGroupText,
  Item._AdditionalMaterialGroup2 AS _AdditionalMaterialGroup2,
  Item._AdditionalMaterialGroup3 AS _AdditionalMaterialGroup3,
  Item._AdditionalMaterialGroup4 AS _AdditionalMaterialGroup4,
  Item._AdditionalMaterialGroup5 AS _AdditionalMaterialGroup5,
  Item._MaterialCommissionGroup AS _MaterialCommissionGroup,
  Item._Plant AS _Plant,
  Item._StorageLocation AS _StorageLocation,
  Item._BillingQuantityUnit AS _BillingQuantityUnit,
  Item._BaseUnit AS _BaseUnit,
  Item._ItemWeightUnit AS _ItemWeightUnit,
  Item._ItemVolumeUnit AS _ItemVolumeUnit,
  Item._BillToPartyCountry AS _BillToPartyCountry,
  Item._BillToPartyRegion AS _BillToPartyRegion,
  Item._BillingPlanRule AS _BillingPlanRule,
  Item._BusinessArea AS _BusinessArea,
  Item._BusinessAreaText AS _BusinessAreaText,
  Item._WBSElement AS _WBSElement,
  Item._WBSElementBasicData AS _WBSElementBasicData,
  Item._ControllingArea AS _ControllingArea,
  Item._CostCenter AS _CostCenter,
  Item._ReferenceSDDocumentCategory AS _ReferenceSDDocumentCategory,
  Item._SalesSDDocumentCategory AS _SalesSDDocumentCategory,
  Item._SalesGroup AS _SalesGroup,
  Item._SalesDocument AS _SalesDocument,
  Item._SalesDocumentItem AS _SalesDocumentItem,
  Item._HigherLevelItem AS _HigherLevelItem,
  Item._AdditionalCustomerGroup1 AS _AdditionalCustomerGroup1,
  Item._AdditionalCustomerGroup2 AS _AdditionalCustomerGroup2,
  Item._AdditionalCustomerGroup3 AS _AdditionalCustomerGroup3,
  Item._AdditionalCustomerGroup4 AS _AdditionalCustomerGroup4,
  Item._AdditionalCustomerGroup5 AS _AdditionalCustomerGroup5,
  Item._MainItemPricingRefMaterial AS _MainItemPricingRefMaterial,
  Item._SDDocumentReason AS _SDDocumentReason,
  Item._SalesDeal AS _SalesDeal,
  Item._ShippingPoint AS _ShippingPoint,
  Item._ShippingPointText AS _ShippingPointText,
  Item._StatisticalValueControl AS _StatisticalValueControl,
  Item._SalesEmployee_2 AS _SalesEmployee_2,
  Item._ResponsibleEmployee_2 AS _ResponsibleEmployee_2,
  Item._SolutionOrder AS _SolutionOrder,
  Item._SolutionOrderItem AS _SolutionOrderItem,
  _BillingDocument.LastChangeDate AS LastChangeDate,
  _BillingDocument.Country AS Country,
  _BillingDocument.Region AS Region,
  _BillingDocument.CityCode AS CityCode,
  _BillingDocument.County AS County_2,
  _BillingDocument.CreditControlArea AS CreditControlArea,
  _BillingDocument.BillingDocCombinationCriteria AS BillingDocCombinationCriteria,
  _BillingDocument.ManualInvoiceMaintIsRelevant AS ManualInvoiceMaintIsRelevant,
  _BillingDocument.PriceListType AS PriceListType,
  _BillingDocument.TaxDepartureCountry AS TaxDepartureCountry,
  _BillingDocument.VATRegistration AS VATRegistration,
  _BillingDocument.VATRegistrationOrigin AS VATRegistrationOrigin,
  _BillingDocument.VATRegistrationCountry AS VATRegistrationCountry,
  _BillingDocument.CustomerTaxClassification1 AS CustomerTaxClassification1,
  _BillingDocument.CustomerTaxClassification2 AS CustomerTaxClassification2,
  _BillingDocument.CustomerTaxClassification3 AS CustomerTaxClassification3,
  _BillingDocument.CustomerTaxClassification4 AS CustomerTaxClassification4,
  _BillingDocument.CustomerTaxClassification5 AS CustomerTaxClassification5,
  _BillingDocument.CustomerTaxClassification6 AS CustomerTaxClassification6,
  _BillingDocument.CustomerTaxClassification7 AS CustomerTaxClassification7,
  _BillingDocument.CustomerTaxClassification8 AS CustomerTaxClassification8,
  _BillingDocument.CustomerTaxClassification9 AS CustomerTaxClassification9,
  _BillingDocument.SDPricingProcedure AS SDPricingProcedure,
  _BillingDocument.ShippingCondition AS ShippingCondition,
  _BillingDocument.IncotermsVersion AS IncotermsVersion,
  _BillingDocument.IncotermsClassification AS IncotermsClassification,
  _BillingDocument.IncotermsTransferLocation AS IncotermsTransferLocation,
  _BillingDocument.IncotermsLocation1 AS IncotermsLocation1,
  _BillingDocument.IncotermsLocation2 AS IncotermsLocation2,
  _BillingDocument.ContractAccount AS ContractAccount,
  _BillingDocument.CustomerPaymentTerms AS CustomerPaymentTerms,
  _BillingDocument.PaymentMethod AS PaymentMethod,
  _BillingDocument.PaymentReference AS PaymentReference,
  _BillingDocument.FixedValueDate AS FixedValueDate,
  _BillingDocument.AdditionalValueDays AS AdditionalValueDays,
  _BillingDocument.CompanyCode AS CompanyCode,
  _BillingDocument.FiscalYear AS FiscalYear,
  _BillingDocument.FiscalPeriod AS FiscalPeriod,
  _BillingDocument.CustomerAccountAssignmentGroup AS CustomerAccountAssignmentGroup,
  _BillingDocument.AccountingExchangeRateIsSet AS AccountingExchangeRateIsSet,
  _BillingDocument.AccountingExchangeRate AS AccountingExchangeRate,
  _BillingDocument.ExchangeRateType AS ExchangeRateType,
  _BillingDocument.DunningArea AS DunningArea,
  _BillingDocument.DunningBlockingReason AS DunningBlockingReason,
  _BillingDocument.DunningKey AS DunningKey,
  _BillingDocument.InternalFinancialDocument AS InternalFinancialDocument,
  _BillingDocument.AccountingPostingStatus AS AccountingPostingStatus,
  _BillingDocument.InvoiceListStatus AS InvoiceListStatus,
  _BillingDocument._PriceListType AS _PriceListType,
  _BillingDocument._TaxDepartureCountry AS _TaxDepartureCountry,
  _BillingDocument._VATRegistrationOrigin AS _VATRegistrationOrigin,
  _BillingDocument._VATRegistrationCountry AS _VATRegistrationCountry,
  _BillingDocument._ShippingCondition AS _ShippingCondition,
  _BillingDocument._IncotermsClassification AS _IncotermsClassification,
  _BillingDocument._IncotermsVersion AS _IncotermsVersion,
  _BillingDocument._CustomerPaymentTerms AS _CustomerPaymentTerms,
  _BillingDocument._PaymentMethod AS _PaymentMethod,
  _BillingDocument._CompanyCode AS _CompanyCode,
  _BillingDocument._FiscalYear AS _FiscalYear,
  _BillingDocument._CustomerAccountAssgmtGroup AS _CustomerAccountAssgmtGroup,
  _BillingDocument._ExchangeRateType AS _ExchangeRateType,
  _BillingDocument._DunningArea AS _DunningArea,
  _BillingDocument._DunningAreaText AS _DunningAreaText,
  _BillingDocument._DunningBlockingReason AS _DunningBlockingReason,
  _BillingDocument._DunningKey AS _DunningKey,
  _BillingDocument._Country AS _Country,
  _BillingDocument._Region AS _Region,
  _BillingDocument._CityCode AS _CityCode,
  _BillingDocument._County AS _County,
  _BillingDocument._CreditControlArea AS _CreditControlArea,
  _BillingDocument._CreditControlAreaText AS _CreditControlAreaText,
  _BillingDocument._AccountingPostingStatus AS _AccountingPostingStatus,
  _BillingDocument._AccountingTransferStatus AS _AccountingTransferStatus,
  _BillingDocument._BillingIssueType AS _BillingIssueType,
  _BillingDocument._InvoiceListStatus AS _InvoiceListStatus,
  _BillingDocument._OvrlItmGeneralIncompletionSts AS _OvrlItmGeneralIncompletionSts,
  _BillingDocument._OverallPricingIncompletionSts AS _OverallPricingIncompletionSts,
  _SalesDocumentItemCategory.PropagatePrftbltySgmt2BOM AS PropagatePrftbltySgmt2BOM,
  _SalesDocumentItemCategory.CostDeterminationIsRequired AS CostDeterminationIsRequired
FROM I_BillingDocExtdItem AS Item
LEFT OUTER JOIN I_Currency AS _StatisticsCurrency ON StatisticsCurrency = _StatisticsCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_MfgOrder AS _OrderID ON OrderID = _OrderID.ManufacturingOrder  -- association [0..1]
LEFT OUTER JOIN I_CustomerClassification AS _SoldToPartyClassification ON SoldToPartyClassification = _SoldToPartyClassification.CustomerClassification  -- association [0..1]
LEFT OUTER JOIN I_Globalcompany AS _GlobalCompany ON partnercompany = _GlobalCompany.Company  -- association [0..1]
LEFT OUTER JOIN I_TaxingCounty AS _County_2 ON country = _County_2.Country AND region = _County_2.Region AND County_2 = _County_2.TaxingCounty  -- association [0..1]
;