I_BillingDocumentItemBasic

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_BillingDocumentItemBasic.
-- 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_BillingDocumentItemBasic AS
SELECT
  cast (BillingDocumentItem.Product as matnr preserving type ) AS Material,
  cast (BillingDocumentItem.ProductGroup as matkl preserving type ) AS MaterialGroup,
  cast (BillingDocumentItem.WBSElementInternalID as ps_psp_pnr preserving type ) AS WBSElement,
  cast ( case when BillingDocumentItem.ProfitabilitySegment_2 > '9999999999' then '9999999999' else lpad( BillingDocumentItem.ProfitabilitySegment_2, 10, '0' ) end as rkeobjnr_numc ) AS ProfitabilitySegment,
  cast ( BillingDocumentItem.BillingDocExtReferenceDocItem as ext_reference_document_item preserving type ) AS ExternalReferenceDocumentItem,
  BillingDocumentItem.BillingDocument AS BillingDocument,
  BillingDocumentItem.BillingDocumentItem AS BillingDocumentItem,
  BillingDocumentItem.SalesDocumentItemCategory AS SalesDocumentItemCategory,
  BillingDocumentItem.SalesDocumentItemType AS SalesDocumentItemType,
  BillingDocumentItem.ReturnItemProcessingType AS ReturnItemProcessingType,
  BillingDocumentItem.CreatedByUser AS CreatedByUser,
  BillingDocumentItem.CreationDate AS CreationDate,
  BillingDocumentItem.CreationTime AS CreationTime,
  BillingDocumentItem.ReferenceLogicalSystem AS ReferenceLogicalSystem,
  BillingDocumentItem.OrganizationDivision AS OrganizationDivision,
  BillingDocumentItem.Division AS Division,
  BillingDocumentItem.SalesOffice AS SalesOffice,
  BillingDocumentItem.Product AS Product,
  BillingDocumentItem.OriginallyRequestedMaterial AS OriginallyRequestedMaterial,
  BillingDocumentItem.InternationalArticleNumber AS InternationalArticleNumber,
  BillingDocumentItem.PricingReferenceMaterial AS PricingReferenceMaterial,
  BillingDocumentItem.Batch AS Batch,
  BillingDocumentItem.ProductHierarchyNode AS ProductHierarchyNode,
  BillingDocumentItem.ProductGroup AS ProductGroup,
  BillingDocumentItem.AdditionalMaterialGroup1 AS AdditionalMaterialGroup1,
  BillingDocumentItem.AdditionalMaterialGroup2 AS AdditionalMaterialGroup2,
  BillingDocumentItem.AdditionalMaterialGroup3 AS AdditionalMaterialGroup3,
  BillingDocumentItem.AdditionalMaterialGroup4 AS AdditionalMaterialGroup4,
  BillingDocumentItem.AdditionalMaterialGroup5 AS AdditionalMaterialGroup5,
  BillingDocumentItem.ProductConfiguration AS ProductConfiguration,
  BillingDocumentItem.MaterialCommissionGroup AS MaterialCommissionGroup,
  BillingDocumentItem.Plant AS Plant,
  BillingDocumentItem.StorageLocation AS StorageLocation,
  BillingDocumentItem.ReplacementPartType AS ReplacementPartType,
  BillingDocumentItem.MaterialGroupHierarchy1 AS MaterialGroupHierarchy1,
  BillingDocumentItem.MaterialGroupHierarchy2 AS MaterialGroupHierarchy2,
  BillingDocumentItem.PlantRegion AS PlantRegion,
  BillingDocumentItem.PlantCounty AS PlantCounty,
  BillingDocumentItem.PlantCity AS PlantCity,
  BillingDocumentItem.TransitPlant AS TransitPlant,
  BillingDocumentItem.ValueChainCategory AS ValueChainCategory,
  BillingDocumentItem.BOMExplosion AS BOMExplosion,
  BillingDocumentItem.MaterialDeterminationType AS MaterialDeterminationType,
  BillingDocumentItem.BillingDocumentItemText AS BillingDocumentItemText,
  BillingDocumentItem.ServicesRenderedDate AS ServicesRenderedDate,
  BillingDocumentItem.BillingQuantity AS BillingQuantity,
  BillingDocumentItem.BillingQuantityUnit AS BillingQuantityUnit,
  BillingDocumentItem.BillingQuantityInBaseUnit AS BillingQuantityInBaseUnit,
  BillingDocumentItem.BaseUnit AS BaseUnit,
  BillingDocumentItem.MRPRequiredQuantityInBaseUnit AS MRPRequiredQuantityInBaseUnit,
  BillingDocumentItem.BillingToBaseQuantityDnmntr AS BillingToBaseQuantityDnmntr,
  BillingDocumentItem.BillingToBaseQuantityNmrtr AS BillingToBaseQuantityNmrtr,
  BillingDocumentItem.ItemGrossWeight AS ItemGrossWeight,
  BillingDocumentItem.ItemNetWeight AS ItemNetWeight,
  BillingDocumentItem.ItemWeightUnit AS ItemWeightUnit,
  BillingDocumentItem.ItemVolume AS ItemVolume,
  BillingDocumentItem.ItemVolumeUnit AS ItemVolumeUnit,
  BillingDocumentItem.BillToPartyCountry AS BillToPartyCountry,
  BillingDocumentItem.BillToPartyRegion AS BillToPartyRegion,
  BillingDocumentItem.BillingPlanRule AS BillingPlanRule,
  BillingDocumentItem.BillingPlan AS BillingPlan,
  BillingDocumentItem.BillingPlanItem AS BillingPlanItem,
  BillingDocumentItem.DocumentBillingStatus AS DocumentBillingStatus,
  BillingDocumentItem.NetAmount AS NetAmount,
  BillingDocumentItem.TransactionCurrency AS TransactionCurrency,
  BillingDocumentItem.GrossAmount AS GrossAmount,
  BillingDocumentItem.PricingDate AS PricingDate,
  BillingDocumentItem.PriceDetnExchangeRate AS PriceDetnExchangeRate,
  BillingDocumentItem.PricingScaleQuantityInBaseUnit AS PricingScaleQuantityInBaseUnit,
  BillingDocumentItem.TaxAmount AS TaxAmount,
  BillingDocumentItem.CostAmount AS CostAmount,
  BillingDocumentItem.Subtotal1Amount AS Subtotal1Amount,
  BillingDocumentItem.Subtotal2Amount AS Subtotal2Amount,
  BillingDocumentItem.Subtotal3Amount AS Subtotal3Amount,
  BillingDocumentItem.Subtotal4Amount AS Subtotal4Amount,
  BillingDocumentItem.Subtotal5Amount AS Subtotal5Amount,
  BillingDocumentItem.Subtotal6Amount AS Subtotal6Amount,
  BillingDocumentItem.StatisticalValueControl AS StatisticalValueControl,
  BillingDocumentItem.CashDiscountIsDeductible AS CashDiscountIsDeductible,
  BillingDocumentItem.CustomerConditionGroup1 AS CustomerConditionGroup1,
  BillingDocumentItem.CustomerConditionGroup2 AS CustomerConditionGroup2,
  BillingDocumentItem.CustomerConditionGroup3 AS CustomerConditionGroup3,
  BillingDocumentItem.CustomerConditionGroup4 AS CustomerConditionGroup4,
  BillingDocumentItem.CustomerConditionGroup5 AS CustomerConditionGroup5,
  BillingDocumentItem.ManualPriceChangeType AS ManualPriceChangeType,
  BillingDocumentItem.MaterialPricingGroup AS MaterialPricingGroup,
  BillingDocumentItem.StatisticsExchangeRate AS StatisticsExchangeRate,
  BillingDocumentItem.MainItemPricingRefMaterial AS MainItemPricingRefMaterial,
  BillingDocumentItem.MainItemMaterialPricingGroup AS MainItemMaterialPricingGroup,
  BillingDocumentItem.TimeSheetOvertimeCategory AS TimeSheetOvertimeCategory,
  BillingDocumentItem.PricingRelevance AS PricingRelevance,
  BillingDocumentItem.DepartureCountry AS DepartureCountry,
  BillingDocumentItem.TaxJurisdiction AS TaxJurisdiction,
  BillingDocumentItem.ProductTaxClassification1 AS ProductTaxClassification1,
  BillingDocumentItem.ProductTaxClassification2 AS ProductTaxClassification2,
  BillingDocumentItem.ProductTaxClassification3 AS ProductTaxClassification3,
  BillingDocumentItem.ProductTaxClassification4 AS ProductTaxClassification4,
  BillingDocumentItem.ProductTaxClassification5 AS ProductTaxClassification5,
  BillingDocumentItem.ProductTaxClassification6 AS ProductTaxClassification6,
  BillingDocumentItem.ProductTaxClassification7 AS ProductTaxClassification7,
  BillingDocumentItem.ProductTaxClassification8 AS ProductTaxClassification8,
  BillingDocumentItem.ProductTaxClassification9 AS ProductTaxClassification9,
  BillingDocumentItem.ZeroVATRsn AS ZeroVATRsn,
  BillingDocumentItem.TaxCode AS TaxCode,
  BillingDocumentItem.TaxRateValidityStartDate AS TaxRateValidityStartDate,
  BillingDocumentItem.CountryOfOrigin AS CountryOfOrigin,
  BillingDocumentItem.RegionOfOrigin AS RegionOfOrigin,
  BillingDocumentItem.CommodityCode AS CommodityCode,
  BillingDocumentItem.EligibleAmountForCashDiscount AS EligibleAmountForCashDiscount,
  BillingDocumentItem.BusinessArea AS BusinessArea,
  BillingDocumentItem.ProfitCenter AS ProfitCenter,
  BillingDocumentItem.WBSElementInternalID AS WBSElementInternalID,
  BillingDocumentItem.ProviderContract AS ProviderContract,
  BillingDocumentItem.ProviderContractItem AS ProviderContractItem,
  BillingDocumentItem.BillingPerformancePeriodStrDte AS BillingPerformancePeriodStrDte,
  BillingDocumentItem.BillingPerformancePeriodEndDte AS BillingPerformancePeriodEndDte,
  BillingDocumentItem.ControllingArea AS ControllingArea,
  BillingDocumentItem.ProfitabilitySegment_2 AS ProfitabilitySegment_2,
  BillingDocumentItem.OrderID AS OrderID,
  BillingDocumentItem.CostCenter AS CostCenter,
  BillingDocumentItem.OriginSDDocument AS OriginSDDocument,
  BillingDocumentItem.OriginSDDocumentItem AS OriginSDDocumentItem,
  BillingDocumentItem.PriceDetnExchangeRateDate AS PriceDetnExchangeRateDate,
  BillingDocumentItem.MatlAccountAssignmentGroup AS MatlAccountAssignmentGroup,
  BillingDocumentItem.ReferenceSDDocument AS ReferenceSDDocument,
  BillingDocumentItem.ReferenceSDDocumentItem AS ReferenceSDDocumentItem,
  BillingDocumentItem.ReferenceSDDocumentCategory AS ReferenceSDDocumentCategory,
  BillingDocumentItem.SalesDocument AS SalesDocument,
  BillingDocumentItem.SalesDocumentItem AS SalesDocumentItem,
  BillingDocumentItem.SalesSDDocumentCategory AS SalesSDDocumentCategory,
  BillingDocumentItem.HigherLevelItem AS HigherLevelItem,
  BillingDocumentItem.HigherLvlItmOfBatSpltItm AS HigherLvlItmOfBatSpltItm,
  BillingDocumentItem.BillingDocumentItemInPartSgmt AS BillingDocumentItemInPartSgmt,
  BillingDocumentItem.ExternalReferenceDocument AS ExternalReferenceDocument,
  BillingDocumentItem.BillingDocExtReferenceDocItem AS BillingDocExtReferenceDocItem,
  BillingDocumentItem.PrelimBillingDocument AS PrelimBillingDocument,
  BillingDocumentItem.PrelimBillingDocumentItem AS PrelimBillingDocumentItem,
  BillingDocumentItem.SalesGroup AS SalesGroup,
  BillingDocumentItem.AdditionalCustomerGroup1 AS AdditionalCustomerGroup1,
  BillingDocumentItem.AdditionalCustomerGroup2 AS AdditionalCustomerGroup2,
  BillingDocumentItem.AdditionalCustomerGroup3 AS AdditionalCustomerGroup3,
  BillingDocumentItem.AdditionalCustomerGroup4 AS AdditionalCustomerGroup4,
  BillingDocumentItem.AdditionalCustomerGroup5 AS AdditionalCustomerGroup5,
  BillingDocumentItem.SDDocumentReason AS SDDocumentReason,
  BillingDocumentItem.RetailPromotion AS RetailPromotion,
  BillingDocumentItem.RebateBasisAmount AS RebateBasisAmount,
  BillingDocumentItem.VolumeRebateGroup AS VolumeRebateGroup,
  BillingDocumentItem.ItemIsRelevantForCredit AS ItemIsRelevantForCredit,
  BillingDocumentItem.CreditRelatedPrice AS CreditRelatedPrice,
  BillingDocumentItem.SalesDeal AS SalesDeal,
  BillingDocumentItem.SalesPromotion AS SalesPromotion,
  BillingDocumentItem.SalesOrderSalesDistrict AS SalesOrderSalesDistrict,
  BillingDocumentItem.SalesOrderCustomerGroup AS SalesOrderCustomerGroup,
  BillingDocumentItem.SalesOrderCustomerPriceGroup AS SalesOrderCustomerPriceGroup,
  BillingDocumentItem.SalesOrderPriceListType AS SalesOrderPriceListType,
  BillingDocumentItem.SalesOrderSalesOrganization AS SalesOrderSalesOrganization,
  BillingDocumentItem.SalesOrderDistributionChannel AS SalesOrderDistributionChannel,
  BillingDocumentItem.SalesDocIsCreatedFromReference AS SalesDocIsCreatedFromReference,
  BillingDocumentItem.ShippingPoint AS ShippingPoint,
  BillingDocumentItem.ServiceDocumentType AS ServiceDocumentType,
  BillingDocumentItem.ServiceDocument AS ServiceDocument,
  BillingDocumentItem.ServiceDocumentItem AS ServiceDocumentItem,
  BillingDocumentItem.BusinessSolutionOrder AS BusinessSolutionOrder,
  BillingDocumentItem.BusinessSolutionOrderItem AS BusinessSolutionOrderItem,
  BillingDocumentItem.HigherLevelItemUsage AS HigherLevelItemUsage,
  BillingDocumentItem.BillingDocumentIsTemporary AS BillingDocumentIsTemporary,
  BillingDocumentItem.SDDocumentCategory AS SDDocumentCategory,
  BillingDocumentItem.BillingDocumentType AS BillingDocumentType,
  BillingDocumentItem.SalesOrganization AS SalesOrganization,
  BillingDocumentItem.DistributionChannel AS DistributionChannel,
  BillingDocumentItem.CustomerPriceGroup AS CustomerPriceGroup,
  BillingDocumentItem.CustomerGroup AS CustomerGroup,
  BillingDocumentItem.Country AS Country,
  BillingDocumentItem.Region AS Region,
  BillingDocumentItem.CityCode AS CityCode,
  BillingDocumentItem.SalesDistrict AS SalesDistrict,
  BillingDocumentItem.OverallSDProcessStatus AS OverallSDProcessStatus,
  BillingDocumentItem.OverallBillingStatus AS OverallBillingStatus,
  BillingDocumentItem.SoldToParty AS SoldToParty,
  BillingDocumentItem.PayerParty AS PayerParty,
  BillingDocumentItem.BillingDocumentDate AS BillingDocumentDate,
  BillingDocumentItem.CompanyCode AS CompanyCode,
  BillingDocumentItem.County AS County,
  BillingDocumentItem.CustomerRebateAgreement AS CustomerRebateAgreement,
  BillingDocumentItem.BillingDocumentCategory AS BillingDocumentCategory,
  BillingDocumentItem.PricingDocument AS PricingDocument,
  BillingDocumentItem.CancelledBillingDocument AS CancelledBillingDocument,
  BillingDocumentItem.ShipToParty AS ShipToParty,
  BillingDocumentItem.BillToParty AS BillToParty,
  BillingDocumentItem.SalesEmployee AS SalesEmployee,
  BillingDocumentItem.ResponsibleEmployee AS ResponsibleEmployee
FROM P_BillingDocumentItemBasic AS BillingDocumentItem
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON Material = _MaterialText.Material  -- association [0..*]
LEFT OUTER JOIN I_ProductText AS _ProductText ON Product = _ProductText.Product  -- association [0..*]
LEFT OUTER JOIN I_MaterialText AS _OriginallyRequestedMatlText ON OriginallyRequestedMaterial = _OriginallyRequestedMatlText.Material  -- association [0..*]
LEFT OUTER JOIN I_MaterialText AS _PricingReferenceMaterialText ON PricingReferenceMaterial = _PricingReferenceMaterialText.Material  -- association [0..*]
LEFT OUTER JOIN I_MaterialText AS _MainItemPricingRefMatlText ON MainItemPricingRefMaterial = _MainItemPricingRefMatlText.Material  -- association [0..*]
LEFT OUTER JOIN I_MaterialGroupText AS _MaterialGroupText ON MaterialGroup = _MaterialGroupText.MaterialGroup  -- association [0..*]
LEFT OUTER JOIN I_ShippingPointText AS _ShippingPointText ON ShippingPoint = _ShippingPointText.ShippingPoint  -- association [0..*]
LEFT OUTER JOIN I_WBSElementText AS _WBSElementText ON WBSElement = _WBSElementText.WBSElementObject  -- association [0..*]
LEFT OUTER JOIN I_BusinessAreaText AS _BusinessAreaText ON BusinessArea = _BusinessAreaText.BusinessArea  -- association [0..*]
LEFT OUTER JOIN I_BillingDocumentBasic AS _BillingDocumentBasic ON BillingDocument = _BillingDocumentBasic.BillingDocument  -- association [1..1]
LEFT OUTER JOIN I_BillingDocItemPartnerBasic AS _PartnerBasic ON BillingDocument = _PartnerBasic.BillingDocument AND BillingDocumentItem = _PartnerBasic.BillingDocumentItem  -- association [0..*]
LEFT OUTER JOIN I_BillingDocItemPrcgElmntBasic AS _PricingElementBasic ON BillingDocument = _PricingElementBasic.BillingDocument AND BillingDocumentItem = _PricingElementBasic.BillingDocumentItem  -- association [0..*]
LEFT OUTER JOIN I_SalesDocumentItemCategory AS _SalesDocumentItemCategory ON SalesDocumentItemCategory = _SalesDocumentItemCategory.SalesDocumentItemCategory  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentItemType AS _SalesDocumentItemType ON SalesDocumentItemType = _SalesDocumentItemType.SalesDocumentItemType  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_LogicalSystem AS _ReferenceLogicalSystem ON ReferenceLogicalSystem = _ReferenceLogicalSystem.LogicalSystem  -- association [0..1]
LEFT OUTER JOIN I_Division AS _OrganizationDivision ON OrganizationDivision = _OrganizationDivision.Division  -- association [0..1]
LEFT OUTER JOIN I_Division AS _Division ON Division = _Division.Division  -- association [0..1]
LEFT OUTER JOIN I_SalesOffice AS _SalesOffice ON SalesOffice = _SalesOffice.SalesOffice  -- association [0..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product  -- association [0..1]
LEFT OUTER JOIN I_Material AS _OriginallyRequestedMaterial ON OriginallyRequestedMaterial = _OriginallyRequestedMaterial.Material  -- association [0..1]
LEFT OUTER JOIN I_Material AS _PricingReferenceMaterial ON PricingReferenceMaterial = _PricingReferenceMaterial.Material  -- association [0..1]
LEFT OUTER JOIN I_Batch AS _Batch ON Plant = _Batch.Plant AND Material = _Batch.Material AND Batch = _Batch.Batch  -- association [0..1]
LEFT OUTER JOIN I_ProductHierarchyNode AS _ProductHierarchyNode ON ProductHierarchyNode = _ProductHierarchyNode.ProductHierarchyNode  -- association [0..1]
LEFT OUTER JOIN I_MaterialGroup AS _MaterialGroup ON MaterialGroup = _MaterialGroup.MaterialGroup  -- association [0..1]
LEFT OUTER JOIN I_ProductGroup_2 AS _ProductGroup ON ProductGroup = _ProductGroup.ProductGroup  -- association [0..1]
LEFT OUTER JOIN I_AdditionalMaterialGroup1 AS _AdditionalMaterialGroup1 ON AdditionalMaterialGroup1 = _AdditionalMaterialGroup1.AdditionalMaterialGroup1  -- association [0..1]
LEFT OUTER JOIN I_AdditionalMaterialGroup2 AS _AdditionalMaterialGroup2 ON AdditionalMaterialGroup2 = _AdditionalMaterialGroup2.AdditionalMaterialGroup2  -- association [0..1]
LEFT OUTER JOIN I_AdditionalMaterialGroup3 AS _AdditionalMaterialGroup3 ON AdditionalMaterialGroup3 = _AdditionalMaterialGroup3.AdditionalMaterialGroup3  -- association [0..1]
LEFT OUTER JOIN I_AdditionalMaterialGroup4 AS _AdditionalMaterialGroup4 ON AdditionalMaterialGroup4 = _AdditionalMaterialGroup4.AdditionalMaterialGroup4  -- association [0..1]
LEFT OUTER JOIN I_AdditionalMaterialGroup5 AS _AdditionalMaterialGroup5 ON AdditionalMaterialGroup5 = _AdditionalMaterialGroup5.AdditionalMaterialGroup5  -- association [0..1]
LEFT OUTER JOIN I_MaterialCommissionGroup AS _MaterialCommissionGroup ON MaterialCommissionGroup = _MaterialCommissionGroup.MaterialCommissionGroup  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS _StorageLocation ON Plant = _StorageLocation.Plant AND StorageLocation = _StorageLocation.StorageLocation  -- association [0..1]
LEFT OUTER JOIN I_Region AS _PlantRegion ON DepartureCountry = _PlantRegion.Country AND PlantRegion = _PlantRegion.Region  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _TransitPlant ON TransitPlant = _TransitPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_ValueChainCategory AS _ValueChainCategory ON ValueChainCategory = _ValueChainCategory.ValueChainCategory  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BillingQuantityUnit ON BillingQuantityUnit = _BillingQuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnit ON BaseUnit = _BaseUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ItemWeightUnit ON ItemWeightUnit = _ItemWeightUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ItemVolumeUnit ON ItemVolumeUnit = _ItemVolumeUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_Country AS _BillToPartyCountry ON BillToPartyCountry = _BillToPartyCountry.Country  -- association [0..1]
LEFT OUTER JOIN I_Region AS _BillToPartyRegion ON BillToPartyCountry = _BillToPartyRegion.Country AND BillToPartyRegion = _BillToPartyRegion.Region  -- association [0..1]
LEFT OUTER JOIN I_BillingPlanRule AS _BillingPlanRule ON BillingPlanRule = _BillingPlanRule.BillingPlanRule  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_StatisticalValueControl AS _StatisticalValueControl ON StatisticalValueControl = _StatisticalValueControl.StatisticalValueControl  -- association [0..1]
LEFT OUTER JOIN I_MaterialPricingGroup AS _MaterialPricingGroup ON MaterialPricingGroup = _MaterialPricingGroup.MaterialPricingGroup  -- association [0..1]
LEFT OUTER JOIN I_Material AS _MainItemPricingRefMaterial ON MainItemPricingRefMaterial = _MainItemPricingRefMaterial.Material  -- association [0..1]
LEFT OUTER JOIN I_MaterialPricingGroup AS _MainItemMaterialPricingGroup ON MainItemMaterialPricingGroup = _MainItemMaterialPricingGroup.MaterialPricingGroup  -- association [0..1]
LEFT OUTER JOIN I_TimeSheetOvertimeCat AS _TimeSheetOvertimeCat ON TimeSheetOvertimeCategory = _TimeSheetOvertimeCat.TimeSheetOvertimeCategory  -- association [0..1]
LEFT OUTER JOIN I_PricingRelevance AS _PricingRelevance ON PricingRelevance = _PricingRelevance.PricingRelevance  -- association [0..1]
LEFT OUTER JOIN I_Country AS _DepartureCountry ON DepartureCountry = _DepartureCountry.Country  -- association [0..1]
LEFT OUTER JOIN I_Country AS _CountryOfOrigin ON CountryOfOrigin = _CountryOfOrigin.Country  -- association [0..1]
LEFT OUTER JOIN I_Region AS _RegionOfOrigin ON CountryOfOrigin = _RegionOfOrigin.Country AND RegionOfOrigin = _RegionOfOrigin.Region  -- association [0..1]
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON BusinessArea = _BusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_WBSElement AS _WBSElement ON WBSElement = _WBSElement.WBSElement  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicData ON WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_MatlAccountAssignmentGroup AS _MatlAccountAssignmentGroup ON MatlAccountAssignmentGroup = _MatlAccountAssignmentGroup.MatlAccountAssignmentGroup  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON CostCenter = _CostCenter.CostCenter AND ControllingArea = _CostCenter.ControllingArea AND _CostCenter.ValidityEndDate >= CreationDate AND _CostCenter.ValidityStartDate <= CreationDate  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _CostCenter_2 ON CostCenter = _CostCenter_2.CostCenter AND ControllingArea = _CostCenter_2.ControllingArea  -- association [0..*]
LEFT OUTER JOIN I_ProfitCenter AS _ProfitCenter ON ProfitCenter = _ProfitCenter.ProfitCenter AND ControllingArea = _ProfitCenter.ControllingArea  -- association [0..*]
LEFT OUTER JOIN I_SalesDocumentItem AS _ReferenceSalesDocumentItem ON ReferenceSDDocument = _ReferenceSalesDocumentItem.SalesDocument AND ReferenceSDDocumentItem = _ReferenceSalesDocumentItem.SalesDocumentItem AND ( ReferenceSDDocumentCategory = 'C' OR ReferenceSDDocumentCategory = 'G' OR ReferenceSDDocumentCategory = 'H' OR ReferenceSDDocumentCategory = 'I' OR ReferenceSDDocumentCategory = 'K' OR ReferenceSDDocumentCategory = 'L' OR ReferenceSDDocumentCategory = ':' )  -- association [0..1]
LEFT OUTER JOIN I_DeliveryDocumentItem AS _ReferenceDeliveryDocumentItem ON ReferenceSDDocument = _ReferenceDeliveryDocumentItem.DeliveryDocument AND ReferenceSDDocumentItem = _ReferenceDeliveryDocumentItem.DeliveryDocumentItem AND ( ReferenceSDDocumentCategory = 'J' OR ReferenceSDDocumentCategory = 'T' )  -- association [0..1]
LEFT OUTER JOIN I_BillingDocumentItemBasic AS _ReferenceBillingDocItemBasic ON ReferenceSDDocument = _ReferenceBillingDocItemBasic.BillingDocument AND ReferenceSDDocumentItem = _ReferenceBillingDocItemBasic.BillingDocumentItem AND ( ReferenceSDDocumentCategory = 'M' OR ReferenceSDDocumentCategory = 'N' OR ReferenceSDDocumentCategory = 'O' OR ReferenceSDDocumentCategory = 'P' OR ReferenceSDDocumentCategory = 'S' OR ReferenceSDDocumentCategory = 'U' OR ReferenceSDDocumentCategory = '3' OR ReferenceSDDocumentCategory = '4' OR ReferenceSDDocumentCategory = '5' OR ReferenceSDDocumentCategory = '6' OR ReferenceSDDocumentCategory = 'EBDR' OR ReferenceSDDocumentCategory = 'PBD' )  -- association [0..1]
LEFT OUTER JOIN I_SDDocumentCategory AS _ReferenceSDDocumentCategory ON ReferenceSDDocumentCategory = _ReferenceSDDocumentCategory.SDDocumentCategory  -- association [0..1]
LEFT OUTER JOIN I_SalesDocument AS _SalesDocument ON SalesDocument = _SalesDocument.SalesDocument  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentItem AS _SalesDocumentItem ON SalesDocument = _SalesDocumentItem.SalesDocument AND SalesDocumentItem = _SalesDocumentItem.SalesDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_SDDocumentCategory AS _SalesSDDocumentCategory ON SalesSDDocumentCategory = _SalesSDDocumentCategory.SDDocumentCategory  -- association [0..1]
LEFT OUTER JOIN I_BillingDocumentItemBasic AS _HigherLevelItemBasic ON BillingDocument = _HigherLevelItemBasic.BillingDocument AND HigherLevelItem = _HigherLevelItemBasic.BillingDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_BillingDocumentItemBasic AS _HigherLvlItmOfBatSpltItmBasic ON BillingDocument = _HigherLvlItmOfBatSpltItmBasic.BillingDocument AND HigherLvlItmOfBatSpltItm = _HigherLvlItmOfBatSpltItmBasic.BillingDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_PrelimBillingDocument AS _PrelimBillingDocument ON PrelimBillingDocument = _PrelimBillingDocument.PrelimBillingDocument  -- association [0..1]
LEFT OUTER JOIN I_PrelimBillingDocumentItem AS _PrelimBillingDocumentItem ON PrelimBillingDocument = _PrelimBillingDocumentItem.PrelimBillingDocument AND PrelimBillingDocumentItem = _PrelimBillingDocumentItem.PrelimBillingDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_SalesGroup AS _SalesGroup ON SalesGroup = _SalesGroup.SalesGroup  -- association [0..1]
LEFT OUTER JOIN I_AdditionalCustomerGroup1 AS _AdditionalCustomerGroup1 ON AdditionalCustomerGroup1 = _AdditionalCustomerGroup1.AdditionalCustomerGroup1  -- association [0..1]
LEFT OUTER JOIN I_AdditionalCustomerGroup2 AS _AdditionalCustomerGroup2 ON AdditionalCustomerGroup2 = _AdditionalCustomerGroup2.AdditionalCustomerGroup2  -- association [0..1]
LEFT OUTER JOIN I_AdditionalCustomerGroup3 AS _AdditionalCustomerGroup3 ON AdditionalCustomerGroup3 = _AdditionalCustomerGroup3.AdditionalCustomerGroup3  -- association [0..1]
LEFT OUTER JOIN I_AdditionalCustomerGroup4 AS _AdditionalCustomerGroup4 ON AdditionalCustomerGroup4 = _AdditionalCustomerGroup4.AdditionalCustomerGroup4  -- association [0..1]
LEFT OUTER JOIN I_AdditionalCustomerGroup5 AS _AdditionalCustomerGroup5 ON AdditionalCustomerGroup5 = _AdditionalCustomerGroup5.AdditionalCustomerGroup5  -- association [0..1]
LEFT OUTER JOIN I_SDDocumentReason AS _SDDocumentReason ON SDDocumentReason = _SDDocumentReason.SDDocumentReason  -- association [0..1]
LEFT OUTER JOIN I_RetailPromotion AS _RetailPromotion ON RetailPromotion = _RetailPromotion.RetailPromotion  -- association [0..1]
LEFT OUTER JOIN I_SalesDeal AS _SalesDeal ON SalesDeal = _SalesDeal.SalesDeal  -- association [0..1]
LEFT OUTER JOIN I_SalesDistrict AS _SalesOrderSalesDistrict ON SalesOrderSalesDistrict = _SalesOrderSalesDistrict.SalesDistrict  -- association [0..1]
LEFT OUTER JOIN I_CustomerGroup AS _SalesOrderCustomerGroup ON SalesOrderCustomerGroup = _SalesOrderCustomerGroup.CustomerGroup  -- association [0..1]
LEFT OUTER JOIN I_CustomerPriceGroup AS _SalesOrderCustomerPriceGroup ON SalesOrderCustomerPriceGroup = _SalesOrderCustomerPriceGroup.CustomerPriceGroup  -- association [0..1]
LEFT OUTER JOIN I_PriceListType AS _SalesOrderPriceListType ON SalesOrderPriceListType = _SalesOrderPriceListType.PriceListType  -- association [0..1]
LEFT OUTER JOIN I_SalesOrganization AS _SalesOrderSalesOrganization ON SalesOrderSalesOrganization = _SalesOrderSalesOrganization.SalesOrganization  -- association [0..1]
LEFT OUTER JOIN I_DistributionChannel AS _SalesOrderDistributionChannel ON SalesOrderDistributionChannel = _SalesOrderDistributionChannel.DistributionChannel  -- association [0..1]
LEFT OUTER JOIN I_ShippingPoint AS _ShippingPoint ON ShippingPoint = _ShippingPoint.ShippingPoint  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocumentType AS _ServiceDocumentType ON ServiceDocumentType = _ServiceDocumentType.ServiceDocumentType  -- association [0..1]
LEFT OUTER JOIN I_ProviderContract AS _ProviderContract ON ProviderContract = _ProviderContract.ProviderContract  -- association [0..1]
LEFT OUTER JOIN I_ProviderContractItem AS _ProviderContractItem ON ProviderContract = _ProviderContractItem.ProviderContract AND ProviderContractItem = _ProviderContractItem.ProviderContractItem  -- association [0..1]
LEFT OUTER JOIN I_SDDocumentCategory AS _SDDocumentCategory ON SDDocumentCategory = _SDDocumentCategory.SDDocumentCategory  -- association [0..1]
LEFT OUTER JOIN I_BillingDocumentCategory AS _BillingDocumentCategory ON BillingDocumentCategory = _BillingDocumentCategory.BillingDocumentCategory  -- association [0..1]
LEFT OUTER JOIN I_BillingDocumentType AS _BillingDocumentType ON BillingDocumentType = _BillingDocumentType.BillingDocumentType  -- association [0..1]
LEFT OUTER JOIN I_SalesOrganization AS _SalesOrganization ON SalesOrganization = _SalesOrganization.SalesOrganization  -- association [0..1]
LEFT OUTER JOIN I_DistributionChannel AS _DistributionChannel ON DistributionChannel = _DistributionChannel.DistributionChannel  -- association [0..1]
LEFT OUTER JOIN I_CustomerPriceGroup AS _CustomerPriceGroup ON CustomerPriceGroup = _CustomerPriceGroup.CustomerPriceGroup  -- association [0..1]
LEFT OUTER JOIN I_CustomerGroup AS _CustomerGroup ON CustomerGroup = _CustomerGroup.CustomerGroup  -- association [0..1]
LEFT OUTER JOIN I_Country AS _Country ON Country = _Country.Country  -- association [0..1]
LEFT OUTER JOIN I_CityCode AS _CityCode ON CityCode = _CityCode.CityCode AND Country = _CityCode.Country AND Region = _CityCode.Region  -- association [0..1]
LEFT OUTER JOIN I_SalesDistrict AS _SalesDistrict ON SalesDistrict = _SalesDistrict.SalesDistrict  -- association [0..1]
LEFT OUTER JOIN I_Region AS _Region ON Region = _Region.Region AND Country = _Region.Country  -- association [0..1]
LEFT OUTER JOIN I_TaxingCounty AS _County ON Country = _County.Country AND Region = _County.Region AND County = _County.TaxingCounty  -- association [0..1]
LEFT OUTER JOIN I_BillingDocumentBasic AS _CancelledBillingDocumentBasic ON CancelledBillingDocument = _CancelledBillingDocumentBasic.BillingDocument  -- association [0..1]
LEFT OUTER JOIN I_OverallSDProcessStatus AS _OverallSDProcessStatus ON OverallSDProcessStatus = _OverallSDProcessStatus.OverallSDProcessStatus  -- association [0..1]
LEFT OUTER JOIN I_OverallBillingStatus AS _OverallBillingStatus ON OverallBillingStatus = _OverallBillingStatus.OverallBillingStatus  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _SoldToParty ON SoldToParty = _SoldToParty.Customer  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _PayerParty ON PayerParty = _PayerParty.Customer  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _ShipToParty ON ShipToParty = _ShipToParty.Customer  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _BillToParty ON BillToParty = _BillToParty.Customer  -- association [0..1]
LEFT OUTER JOIN I_PersonWorkAgreement_1 AS _SalesEmployee ON SalesEmployee = _SalesEmployee.PersonWorkAgreement  -- association [0..1]
LEFT OUTER JOIN I_PersonWorkAgreement_1 AS _ResponsibleEmployee ON ResponsibleEmployee = _ResponsibleEmployee.PersonWorkAgreement  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocumentEnhcd AS _SolutionOrder ON _SolutionOrder.ServiceObjectType = 'BUS2000172' AND BusinessSolutionOrder = _SolutionOrder.ServiceDocument  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocumentItemEnhcd AS _SolutionOrderItem ON _SolutionOrderItem.ServiceObjectType = 'BUS2000172' AND BusinessSolutionOrder = _SolutionOrderItem.ServiceDocument AND BusinessSolutionOrderItem = _SolutionOrderItem.ServiceDocumentItem  -- association [0..1]
LEFT OUTER JOIN E_BillingDocumentItem AS _Extension ON BillingDocument = _Extension.BillingDocument AND BillingDocumentItem = _Extension.BillingDocumentItem  -- association [1]
;