I_PrelimBillgDocItemAnalytics

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_PrelimBillgDocItemAnalytics.
-- 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: ISDPREBILDITMANA

CREATE VIEW I_PrelimBillgDocItemAnalytics AS
SELECT
  Item.PrelimBillingDocument AS PrelimBillingDocument,
  Item.PrelimBillingDocumentItem AS PrelimBillingDocumentItem,
  _PrelimBillingDocument.SDDocumentCategory AS SDDocumentCategory,
  _PrelimBillingDocument.BillingDocumentCategory AS BillingDocumentCategory,
  _PrelimBillingDocument.BillingDocumentType AS BillingDocumentType,
  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,
  _PrelimBillingDocument.LastChangeDate AS LastChangeDate,
  Item.CreatedByUser AS CreatedByUser,
  Item._CreatedByUser.UserDescription AS CreatedByUserName,
  Item.CreationDate AS CreationDate,
  cast( Item.CreationTime as creation_time ) AS CreationTime,
  _PrelimBillingDocument.SoldToParty AS SoldToParty,
  cast(_PrelimBillingDocument._SoldToParty.CustomerName as vdm_sold_to_name ) AS SoldToPartyName,
  _PrelimBillingDocument._SoldToParty.CustomerClassification AS SoldToPartyClassification,
  _PrelimBillingDocument.PayerParty AS PayerParty,
  cast(_PrelimBillingDocument._PayerParty.CustomerName as payer_name) AS PayerPartyName,
  _PrelimBillingDocument.PartnerCompany AS PartnerCompany,
  _PrelimBillingDocument.PurchaseOrderByCustomer AS PurchaseOrderByCustomer,
  _PrelimBillingDocument.CustomerGroup AS CustomerGroup,
  _PrelimBillingDocument.SalesDistrict AS SalesDistrict,
  _PrelimBillingDocument.Country AS Country,
  _PrelimBillingDocument.Region AS Region,
  _PrelimBillingDocument.CityCode AS CityCode,
  _PrelimBillingDocument.County AS County,
  _PrelimBillingDocument.CreditControlArea AS CreditControlArea,
  cast(_PrelimBillingDocument.CustomerRebateAgreement as customer_rebate_agreement) AS CustomerRebateAgreement,
  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,
  cast(Item.RetailPromotion as retail_promotion) AS RetailPromotion,
  Item.RebateBasisAmount AS RebateBasisAmount,
  Item.VolumeRebateGroup AS VolumeRebateGroup,
  cast(Item.ItemIsRelevantForCredit as credit_check_relevant_item) AS ItemIsRelevantForCredit,
  Item.CreditRelatedPrice AS CreditRelatedPrice,
  Item.SalesDeal AS SalesDeal,
  cast(Item._SalesDeal.SalesDealDescription as sales_deal_description) AS SalesDealDescription,
  cast(Item.SalesPromotion as sales_promotion) AS SalesPromotion,
  _PrelimBillingDocument.SalesOrganization AS SalesOrganization,
  _PrelimBillingDocument.DistributionChannel AS DistributionChannel,
  cast(Item.OrganizationDivision as organization_division preserving type) AS OrganizationDivision,
  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.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._Plant.PlantName AS PlantName,
  Item.StorageLocation AS StorageLocation,
  Item._StorageLocation.StorageLocationName AS StorageLocationName,
  _PrelimBillingDocument.BillingDocumentDate AS BillingDocumentDate,
  cast('' as exnum) AS ForeignTrade,
  cast('' as export_delivery_flag) AS IsExportDelivery,
  _PrelimBillingDocument.BillingDocCombinationCriteria AS BillingDocCombinationCriteria,
  cast(Item.BillingDocumentItemText as billing_document_item_desc ) AS BillingDocumentItemText,
  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,
  cast(Item.BillingPlanItem as billing_plan_item) AS BillingPlanItem,
  _PrelimBillingDocument.CustomerPriceGroup AS CustomerPriceGroup,
  _PrelimBillingDocument.PriceListType AS PriceListType,
  _PrelimBillingDocument.TaxDepartureCountry AS TaxDepartureCountry,
  _PrelimBillingDocument.VATRegistration AS VATRegistration,
  _PrelimBillingDocument.VATRegistrationOrigin AS VATRegistrationOrigin,
  _PrelimBillingDocument.VATRegistrationCountry AS VATRegistrationCountry,
  _PrelimBillingDocument.CustomerTaxClassification1 AS CustomerTaxClassification1,
  _PrelimBillingDocument.CustomerTaxClassification2 AS CustomerTaxClassification2,
  _PrelimBillingDocument.CustomerTaxClassification3 AS CustomerTaxClassification3,
  _PrelimBillingDocument.CustomerTaxClassification4 AS CustomerTaxClassification4,
  _PrelimBillingDocument.CustomerTaxClassification5 AS CustomerTaxClassification5,
  _PrelimBillingDocument.CustomerTaxClassification6 AS CustomerTaxClassification6,
  _PrelimBillingDocument.CustomerTaxClassification7 AS CustomerTaxClassification7,
  _PrelimBillingDocument.CustomerTaxClassification8 AS CustomerTaxClassification8,
  _PrelimBillingDocument.CustomerTaxClassification9 AS CustomerTaxClassification9,
  _PrelimBillingDocument.SDPricingProcedure AS SDPricingProcedure,
  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,
  _PrelimBillingDocument.ShippingCondition AS ShippingCondition,
  _PrelimBillingDocument.IncotermsVersion AS IncotermsVersion,
  _PrelimBillingDocument.IncotermsClassification AS IncotermsClassification,
  _PrelimBillingDocument.IncotermsTransferLocation AS IncotermsTransferLocation,
  _PrelimBillingDocument.IncotermsLocation1 AS IncotermsLocation1,
  _PrelimBillingDocument.IncotermsLocation2 AS IncotermsLocation2,
  Item.ShippingPoint AS ShippingPoint,
  _PrelimBillingDocument.ContractAccount AS ContractAccount,
  _PrelimBillingDocument.CustomerPaymentTerms AS CustomerPaymentTerms,
  _PrelimBillingDocument.PaymentMethod AS PaymentMethod,
  _PrelimBillingDocument._PaymentMethod.PaymentMethodName AS PaymentMethodName,
  _PrelimBillingDocument.PaymentReference AS PaymentReference,
  _PrelimBillingDocument.FixedValueDate AS FixedValueDate,
  _PrelimBillingDocument.AdditionalValueDays AS AdditionalValueDays,
  Item.EligibleAmountForCashDiscount AS EligibleAmountForCashDiscount,
  _PrelimBillingDocument.CompanyCode AS CompanyCode,
  _PrelimBillingDocument._CompanyCode.CompanyCodeName AS CompanyCodeName,
  _PrelimBillingDocument.CustomerAccountAssignmentGroup AS CustomerAccountAssignmentGroup,
  _PrelimBillingDocument.ExchangeRateType AS ExchangeRateType,
  cast(_PrelimBillingDocument.DocumentReferenceID as document_reference_id) AS DocumentReferenceID,
  cast(_PrelimBillingDocument.AssignmentReference as assignment_reference) AS AssignmentReference,
  _PrelimBillingDocument.DunningArea AS DunningArea,
  _PrelimBillingDocument.DunningBlockingReason AS DunningBlockingReason,
  _PrelimBillingDocument.DunningKey AS DunningKey,
  Item.BusinessArea AS BusinessArea,
  Item.ProfitCenter AS ProfitCenter,
  not used for current usages of THIS model. However AS However,
  where it is used !!! Item.ControllingArea AS ControllingArea,
  Item._ControllingArea.ControllingAreaName AS ControllingAreaName,
  Item.ProfitabilitySegment AS ProfitabilitySegment,
  Item.ProfitabilitySegment_2 AS ProfitabilitySegment_2,
  so better do not use it ! AS OrderID,
  Item.CostCenter AS CostCenter,
  Item.OriginSDDocument AS OriginSDDocument,
  cast(Item.OriginSDDocumentItem as origin_sd_document_item) AS OriginSDDocumentItem,
  Item.PriceDetnExchangeRateDate AS ExchangeRateDate,
  Item.ReferenceSDDocument AS ReferenceSDDocument,
  Item.ReferenceSDDocumentItem AS ReferenceSDDocumentItem,
  Item.ReferenceSDDocumentCategory AS ReferenceSDDocumentCategory,
  Item.SalesDocument AS SalesDocument,
  Item.SalesDocumentItem AS SalesDocumentItem,
  cast(Item.SalesSDDocumentCategory as sales_sd_doc_category preserving type ) AS SalesSDDocumentCategory,
  Item.HigherLevelItem AS HigherLevelItem,
  Item.BillingDocumentItemInPartSgmt AS BillingDocumentItemInPartSgmt,
  cast(_PrelimBillingDocument.OverallSDProcessStatus as overall_sd_process_status preserving type ) AS OverallSDProcessStatus,
  cast( _PrelimBillingDocument.BillingIssueType as billing_issue_type preserving type ) AS BillingIssueType,
  cast(_PrelimBillingDocument.OvrlItmGeneralIncompletionSts as itms_ovrl_incompletion_status preserving type ) AS OvrlItmGeneralIncompletionSts,
  cast(_PrelimBillingDocument.OverallPricingIncompletionSts as ovrl_pricing_incompletion_sts preserving type) AS OverallPricingIncompletionSts,
  _PrelimBillingDocument._SalesOrganization.SalesOrganizationCurrency AS StatisticsCurrency,
  Item.BaseUnit AS BaseUnit,
  Item._TransactionCurrency AS _TransactionCurrency,
  _PrelimBillingDocument._SDDocumentCategory AS _SDDocumentCategory,
  _PrelimBillingDocument._BillingDocumentCategory AS _BillingDocumentCategory,
  _PrelimBillingDocument._BillingDocumentType AS _BillingDocumentType,
  _PrelimBillingDocument._SalesOrganization AS _SalesOrganization,
  _PrelimBillingDocument._DistributionChannel AS _DistributionChannel,
  _PrelimBillingDocument._CustomerPriceGroup AS _CustomerPriceGroup,
  _PrelimBillingDocument._PriceListType AS _PriceListType,
  _PrelimBillingDocument._TaxDepartureCountry AS _TaxDepartureCountry,
  _PrelimBillingDocument._VATRegistrationOrigin AS _VATRegistrationOrigin,
  _PrelimBillingDocument._VATRegistrationCountry AS _VATRegistrationCountry,
  _PrelimBillingDocument._ShippingCondition AS _ShippingCondition,
  _PrelimBillingDocument._IncotermsClassification AS _IncotermsClassification,
  _PrelimBillingDocument._IncotermsVersion AS _IncotermsVersion,
  _PrelimBillingDocument._CustomerPaymentTerms AS _CustomerPaymentTerms,
  _PrelimBillingDocument._PaymentMethod AS _PaymentMethod,
  _PrelimBillingDocument._CompanyCode AS _CompanyCode,
  _PrelimBillingDocument._CustomerAccountAssgmtGroup AS _CustomerAccountAssgmtGroup,
  _PrelimBillingDocument._ExchangeRateType AS _ExchangeRateType,
  _PrelimBillingDocument._DunningArea AS _DunningArea,
  _PrelimBillingDocument._DunningBlockingReason AS _DunningBlockingReason,
  _PrelimBillingDocument._DunningKey AS _DunningKey,
  _PrelimBillingDocument._CustomerGroup AS _CustomerGroup,
  _PrelimBillingDocument._Country AS _Country,
  _PrelimBillingDocument._Region AS _Region,
  _PrelimBillingDocument._CityCode AS _CityCode,
  _PrelimBillingDocument._SalesDistrict AS _SalesDistrict,
  _PrelimBillingDocument._CreditControlArea AS _CreditControlArea,
  _PrelimBillingDocument._OverallSDProcessStatus AS _OverallSDProcessStatus,
  _PrelimBillingDocument._BillingIssueType AS _BillingIssueType,
  _PrelimBillingDocument._OvrlItmGeneralIncompletionSts AS _OvrlItmGeneralIncompletionSts,
  _PrelimBillingDocument._OverallPricingIncompletionSts AS _OverallPricingIncompletionSts,
  _PrelimBillingDocument._SoldToParty AS _SoldToParty,
  _PrelimBillingDocument._PayerParty AS _PayerParty,
  Item._SalesDocumentItemCategory AS _SalesDocumentItemCategory,
  Item._SalesDocumentItemType AS _SalesDocumentItemType,
  Item._CreatedByUser AS _CreatedByUser,
  Item._OrganizationDivision AS _OrganizationDivision,
  Item._Division AS _Division,
  Item._SalesOffice AS _SalesOffice,
  Item._Material AS _Material,
  Item._OriginallyRequestedMaterial AS _OriginallyRequestedMaterial,
  Item._PricingReferenceMaterial AS _PricingReferenceMaterial,
  Item._ProductHierarchyNode AS _ProductHierarchyNode,
  Item._MaterialGroup AS _MaterialGroup,
  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._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._ControllingArea AS _ControllingArea,
  so better do not use it ! AS sobetterdonotuseit_OrderID,
  Item._CostCenter AS _CostCenter,
  Item._ReferenceSDDocumentCategory AS _ReferenceSDDocumentCategory,
  Item._SalesSDDocumentCategory AS _SalesSDDocumentCategory,
  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._SalesDeal AS _SalesDeal,
  Item._ShippingPoint AS _ShippingPoint,
  Item._StatisticalValueControl AS _StatisticalValueControl
FROM I_PrelimBillingDocumentItem 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]
;