I_BillingDocExtdItemBasic

DDL: I_BILLINGDOCEXTDITEMBASIC Type: view BASIC

Billing Document Item Basic Extended

I_BillingDocExtdItemBasic is a Basic CDS View (Dimension) that provides data about "Billing Document Item Basic Extended" in SAP S/4HANA. It reads from 1 data source (vbrp). It has 112 associations to related views.

Data Sources (1)

SourceAliasJoin Type
vbrp vbrp from

Associations (112)

CardinalityTargetAliasCondition
[0..*] I_MaterialText _MaterialText $projection.Material = _MaterialText.Material
[0..*] I_ProductText _ProductText $projection.Product = _ProductText.Product
[0..*] I_MaterialText _OriginallyRequestedMatlText $projection.OriginallyRequestedMaterial = _OriginallyRequestedMatlText.Material
[0..*] I_MaterialText _PricingReferenceMaterialText $projection.PricingReferenceMaterial = _PricingReferenceMaterialText.Material
[0..*] I_MaterialText _MainItemPricingRefMatlText $projection.MainItemPricingRefMaterial = _MainItemPricingRefMatlText.Material
[0..*] I_MaterialGroupText _MaterialGroupText $projection.MaterialGroup = _MaterialGroupText.MaterialGroup
[0..*] I_ShippingPointText _ShippingPointText $projection.ShippingPoint = _ShippingPointText.ShippingPoint
[0..*] I_BusinessAreaText _BusinessAreaText $projection.BusinessArea = _BusinessAreaText.BusinessArea
[1..1] I_BillingDocumentBasic _BillingDocumentBasic $projection.BillingDocument = _BillingDocumentBasic.BillingDocument
[0..*] I_BillingDocItemPartnerBasic _PartnerBasic $projection.BillingDocument = _PartnerBasic.BillingDocument and $projection.BillingDocumentItem = _PartnerBasic.BillingDocumentItem
[0..*] I_BillingDocItemPrcgElmntBasic _PricingElementBasic $projection.BillingDocument = _PricingElementBasic.BillingDocument and $projection.BillingDocumentItem = _PricingElementBasic.BillingDocumentItem
[0..1] I_SalesDocumentItemCategory _SalesDocumentItemCategory $projection.SalesDocumentItemCategory = _SalesDocumentItemCategory.SalesDocumentItemCategory
[0..1] I_SalesDocumentItemType _SalesDocumentItemType $projection.SalesDocumentItemType = _SalesDocumentItemType.SalesDocumentItemType
[0..1] I_User _CreatedByUser $projection.CreatedByUser = _CreatedByUser.UserID
[0..1] I_LogicalSystem _ReferenceLogicalSystem $projection.ReferenceLogicalSystem = _ReferenceLogicalSystem.LogicalSystem
[0..1] I_Division _OrganizationDivision $projection.OrganizationDivision = _OrganizationDivision.Division
[0..1] I_Division _Division $projection.Division = _Division.Division
[0..1] I_SalesOffice _SalesOffice $projection.SalesOffice = _SalesOffice.SalesOffice
[0..1] I_Material _Material $projection.Material = _Material.Material
[0..1] I_Product _Product $projection.Product = _Product.Product
[0..1] I_Material _OriginallyRequestedMaterial $projection.OriginallyRequestedMaterial = _OriginallyRequestedMaterial.Material
[0..1] I_Material _PricingReferenceMaterial $projection.PricingReferenceMaterial = _PricingReferenceMaterial.Material
[0..1] I_Batch _Batch $projection.Plant = _Batch.Plant and $projection.Material = _Batch.Material and $projection.Batch = _Batch.Batch
[0..1] I_ProductHierarchyNode _ProductHierarchyNode $projection.ProductHierarchyNode = _ProductHierarchyNode.ProductHierarchyNode
[0..1] I_MaterialGroup _MaterialGroup $projection.MaterialGroup = _MaterialGroup.MaterialGroup
[0..1] I_ProductGroup_2 _ProductGroup $projection.ProductGroup = _ProductGroup.ProductGroup
[0..1] I_AdditionalMaterialGroup1 _AdditionalMaterialGroup1 $projection.AdditionalMaterialGroup1 = _AdditionalMaterialGroup1.AdditionalMaterialGroup1
[0..1] I_AdditionalMaterialGroup2 _AdditionalMaterialGroup2 $projection.AdditionalMaterialGroup2 = _AdditionalMaterialGroup2.AdditionalMaterialGroup2
[0..1] I_AdditionalMaterialGroup3 _AdditionalMaterialGroup3 $projection.AdditionalMaterialGroup3 = _AdditionalMaterialGroup3.AdditionalMaterialGroup3
[0..1] I_AdditionalMaterialGroup4 _AdditionalMaterialGroup4 $projection.AdditionalMaterialGroup4 = _AdditionalMaterialGroup4.AdditionalMaterialGroup4
[0..1] I_AdditionalMaterialGroup5 _AdditionalMaterialGroup5 $projection.AdditionalMaterialGroup5 = _AdditionalMaterialGroup5.AdditionalMaterialGroup5
[0..1] I_MaterialCommissionGroup _MaterialCommissionGroup $projection.MaterialCommissionGroup = _MaterialCommissionGroup.MaterialCommissionGroup
[0..1] I_Plant _Plant $projection.Plant = _Plant.Plant
[0..1] I_StorageLocation _StorageLocation $projection.Plant = _StorageLocation.Plant and $projection.StorageLocation = _StorageLocation.StorageLocation
[0..1] I_Region _PlantRegion $projection.DepartureCountry = _PlantRegion.Country and $projection.PlantRegion = _PlantRegion.Region
[0..1] I_UnitOfMeasure _BillingQuantityUnit $projection.BillingQuantityUnit = _BillingQuantityUnit.UnitOfMeasure
[0..1] I_UnitOfMeasure _BaseUnit $projection.BaseUnit = _BaseUnit.UnitOfMeasure
[0..1] I_UnitOfMeasure _ItemWeightUnit $projection.ItemWeightUnit = _ItemWeightUnit.UnitOfMeasure
[0..1] I_UnitOfMeasure _ItemVolumeUnit $projection.ItemVolumeUnit = _ItemVolumeUnit.UnitOfMeasure
[0..1] I_Country _BillToPartyCountry $projection.BillToPartyCountry = _BillToPartyCountry.Country
[0..1] I_Region _BillToPartyRegion $projection.BillToPartyCountry = _BillToPartyRegion.Country and $projection.BillToPartyRegion = _BillToPartyRegion.Region
[0..1] I_BillingPlanRule _BillingPlanRule $projection.BillingPlanRule = _BillingPlanRule.BillingPlanRule
[0..1] I_Currency _TransactionCurrency $projection.TransactionCurrency = _TransactionCurrency.Currency
[0..1] I_StatisticalValueControl _StatisticalValueControl $projection.StatisticalValueControl = _StatisticalValueControl.StatisticalValueControl
[0..1] I_MaterialPricingGroup _MaterialPricingGroup $projection.MaterialPricingGroup = _MaterialPricingGroup.MaterialPricingGroup
[0..1] I_Material _MainItemPricingRefMaterial $projection.MainItemPricingRefMaterial = _MainItemPricingRefMaterial.Material
[0..1] I_MaterialPricingGroup _MainItemMaterialPricingGroup $projection.MainItemMaterialPricingGroup = _MainItemMaterialPricingGroup.MaterialPricingGroup
[0..1] I_TimeSheetOvertimeCat _TimeSheetOvertimeCat $projection.TimeSheetOvertimeCategory = _TimeSheetOvertimeCat.TimeSheetOvertimeCategory
[0..1] I_Country _DepartureCountry $projection.DepartureCountry = _DepartureCountry.Country
[0..1] I_BusinessArea _BusinessArea $projection.BusinessArea = _BusinessArea.BusinessArea
[0..1] I_WBSElementBasicData _WBSElement $projection.WBSElementInternalID = _WBSElement.WBSElementInternalID
[0..1] I_WBSElementBasicData _WBSElementBasicData $projection.WBSElementInternalID_2 = _WBSElementBasicData.WBSElementInternalID
[0..1] I_ControllingArea _ControllingArea $projection.ControllingArea = _ControllingArea.ControllingArea
[0..1] I_MatlAccountAssignmentGroup _MatlAccountAssignmentGroup $projection.MatlAccountAssignmentGroup = _MatlAccountAssignmentGroup.MatlAccountAssignmentGroup
[0..1] I_CostCenter _CostCenter $projection.CostCenter = _CostCenter.CostCenter and $projection.ControllingArea = _CostCenter.ControllingArea and _CostCenter.ValidityEndDate >= $projection.CreationDate and _CostCenter.ValidityStartDate <= $projection.CreationDate
[0..*] I_CostCenter _CostCenter_2 $projection.CostCenter = _CostCenter_2.CostCenter and $projection.ControllingArea = _CostCenter_2.ControllingArea
[0..*] I_ProfitCenter _ProfitCenter $projection.ProfitCenter = _ProfitCenter.ProfitCenter and $projection.ControllingArea = _ProfitCenter.ControllingArea
[0..1] I_SalesDocumentItem _ReferenceSalesDocumentItem $projection.ReferenceSDDocument = _ReferenceSalesDocumentItem.SalesDocument and $projection.ReferenceSDDocumentItem = _ReferenceSalesDocumentItem.SalesDocumentItem and ( $projection.ReferenceSDDocumentCategory = 'C' or $projection.ReferenceSDDocumentCategory = 'G' or $projection.ReferenceSDDocumentCategory = 'H' or $projection.ReferenceSDDocumentCategory = 'I' or $projection.ReferenceSDDocumentCategory = 'K' or $projection.ReferenceSDDocumentCategory = 'L' or $projection.ReferenceSDDocumentCategory = ':' )
[0..1] I_DeliveryDocumentItem _ReferenceDeliveryDocumentItem $projection.ReferenceSDDocument = _ReferenceDeliveryDocumentItem.DeliveryDocument and $projection.ReferenceSDDocumentItem = _ReferenceDeliveryDocumentItem.DeliveryDocumentItem and ( $projection.ReferenceSDDocumentCategory = 'J' or $projection.ReferenceSDDocumentCategory = 'T' )
[0..1] I_BillingDocumentItemBasic _ReferenceBillingDocItemBasic $projection.ReferenceSDDocument = _ReferenceBillingDocItemBasic.BillingDocument and $projection.ReferenceSDDocumentItem = _ReferenceBillingDocItemBasic.BillingDocumentItem and ( $projection.ReferenceSDDocumentCategory = 'M' or $projection.ReferenceSDDocumentCategory = 'N' or $projection.ReferenceSDDocumentCategory = 'O' or $projection.ReferenceSDDocumentCategory = 'P' or $projection.ReferenceSDDocumentCategory = 'S' or $projection.ReferenceSDDocumentCategory = 'U' or $projection.ReferenceSDDocumentCategory = '3' or $projection.ReferenceSDDocumentCategory = '4' or $projection.ReferenceSDDocumentCategory = '5' or $projection.ReferenceSDDocumentCategory = '6' or $projection.ReferenceSDDocumentCategory = 'EBDR' or $projection.ReferenceSDDocumentCategory = 'PBD' )
[0..1] I_SDDocumentCategory _ReferenceSDDocumentCategory $projection.ReferenceSDDocumentCategory = _ReferenceSDDocumentCategory.SDDocumentCategory
[0..1] I_SalesDocument _SalesDocument $projection.SalesDocument = _SalesDocument.SalesDocument
[0..1] I_SalesDocumentItem _SalesDocumentItem $projection.SalesDocument = _SalesDocumentItem.SalesDocument and $projection.SalesDocumentItem = _SalesDocumentItem.SalesDocumentItem
[0..1] I_SDDocumentCategory _SalesSDDocumentCategory $projection.SalesSDDocumentCategory = _SalesSDDocumentCategory.SDDocumentCategory
[0..1] I_BillingDocumentItemBasic _HigherLevelItemBasic $projection.BillingDocument = _HigherLevelItemBasic.BillingDocument and $projection.HigherLevelItem = _HigherLevelItemBasic.BillingDocumentItem
[0..1] I_PrelimBillingDocument _PrelimBillingDocument $projection.PrelimBillingDocument = _PrelimBillingDocument.PrelimBillingDocument
[0..1] I_PrelimBillingDocumentItem _PrelimBillingDocumentItem $projection.PrelimBillingDocument = _PrelimBillingDocumentItem.PrelimBillingDocument and $projection.PrelimBillingDocumentItem = _PrelimBillingDocumentItem.PrelimBillingDocumentItem
[0..1] I_SalesGroup _SalesGroup $projection.SalesGroup = _SalesGroup.SalesGroup
[0..1] I_AdditionalCustomerGroup1 _AdditionalCustomerGroup1 $projection.AdditionalCustomerGroup1 = _AdditionalCustomerGroup1.AdditionalCustomerGroup1
[0..1] I_AdditionalCustomerGroup2 _AdditionalCustomerGroup2 $projection.AdditionalCustomerGroup2 = _AdditionalCustomerGroup2.AdditionalCustomerGroup2
[0..1] I_AdditionalCustomerGroup3 _AdditionalCustomerGroup3 $projection.AdditionalCustomerGroup3 = _AdditionalCustomerGroup3.AdditionalCustomerGroup3
[0..1] I_AdditionalCustomerGroup4 _AdditionalCustomerGroup4 $projection.AdditionalCustomerGroup4 = _AdditionalCustomerGroup4.AdditionalCustomerGroup4
[0..1] I_AdditionalCustomerGroup5 _AdditionalCustomerGroup5 $projection.AdditionalCustomerGroup5 = _AdditionalCustomerGroup5.AdditionalCustomerGroup5
[0..1] I_SDDocumentReason _SDDocumentReason $projection.SDDocumentReason = _SDDocumentReason.SDDocumentReason
[0..1] I_RetailPromotion _RetailPromotion $projection.RetailPromotion = _RetailPromotion.RetailPromotion
[0..1] I_SalesDeal _SalesDeal $projection.SalesDeal = _SalesDeal.SalesDeal
[0..1] I_SalesDistrict _SalesOrderSalesDistrict $projection.SalesOrderSalesDistrict = _SalesOrderSalesDistrict.SalesDistrict
[0..1] I_CustomerGroup _SalesOrderCustomerGroup $projection.SalesOrderCustomerGroup = _SalesOrderCustomerGroup.CustomerGroup
[0..1] I_CustomerPriceGroup _SalesOrderCustomerPriceGroup $projection.SalesOrderCustomerPriceGroup = _SalesOrderCustomerPriceGroup.CustomerPriceGroup
[0..1] I_PriceListType _SalesOrderPriceListType $projection.SalesOrderPriceListType = _SalesOrderPriceListType.PriceListType
[0..1] I_SalesOrganization _SalesOrderSalesOrganization $projection.SalesOrderSalesOrganization = _SalesOrderSalesOrganization.SalesOrganization
[0..1] I_DistributionChannel _SalesOrderDistributionChannel $projection.SalesOrderDistributionChannel = _SalesOrderDistributionChannel.DistributionChannel
[0..1] I_ShippingPoint _ShippingPoint $projection.ShippingPoint = _ShippingPoint.ShippingPoint
[0..1] I_ServiceDocumentType _ServiceDocumentType $projection.ServiceDocumentType = _ServiceDocumentType.ServiceDocumentType
[0..1] I_SDDocumentCategory _SDDocumentCategory $projection.SDDocumentCategory = _SDDocumentCategory.SDDocumentCategory
[0..1] I_BillingDocumentCategory _BillingDocumentCategory $projection.BillingDocumentCategory = _BillingDocumentCategory.BillingDocumentCategory
[0..1] I_BillingDocumentType _BillingDocumentType $projection.BillingDocumentType = _BillingDocumentType.BillingDocumentType
[0..1] I_SalesOrganization _SalesOrganization $projection.SalesOrganization = _SalesOrganization.SalesOrganization
[0..1] I_DistributionChannel _DistributionChannel $projection.DistributionChannel = _DistributionChannel.DistributionChannel
[0..1] I_CustomerPriceGroup _CustomerPriceGroup $projection.CustomerPriceGroup = _CustomerPriceGroup.CustomerPriceGroup
[0..1] I_CustomerGroup _CustomerGroup $projection.CustomerGroup = _CustomerGroup.CustomerGroup
[0..1] I_Country _Country $projection.Country = _Country.Country
[0..1] I_CityCode _CityCode $projection.CityCode = _CityCode.CityCode and $projection.Country = _CityCode.Country and $projection.Region = _CityCode.Region
[0..1] I_SalesDistrict _SalesDistrict $projection.SalesDistrict = _SalesDistrict.SalesDistrict
[0..1] I_Region _Region $projection.Region = _Region.Region and $projection.Country = _Region.Country
[0..1] I_CountyCode _County $projection.Country = _County.Country and $projection.Region = _County.Region and $projection.County = _County.County
[0..1] I_TaxingCounty _County_2 $projection.Country = _County_2.Country and $projection.Region = _County_2.Region and $projection.County = _County_2.TaxingCounty
[0..1] I_OverallSDProcessStatus _OverallSDProcessStatus $projection.OverallSDProcessStatus = _OverallSDProcessStatus.OverallSDProcessStatus
[0..1] I_OverallBillingStatus _OverallBillingStatus $projection.OverallBillingStatus = _OverallBillingStatus.OverallBillingStatus
[0..1] I_Customer _SoldToParty $projection.SoldToParty = _SoldToParty.Customer
[0..1] I_Customer _PayerParty $projection.PayerParty = _PayerParty.Customer
[0..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[0..1] I_Customer _ShipToParty $projection.ShipToParty = _ShipToParty.Customer
[0..1] I_Customer _BillToParty $projection.BillToParty = _BillToParty.Customer
[0..1] I_Employee _SalesEmployee $projection.SalesEmployee = _SalesEmployee.PersonnelNumber
[0..1] I_Employee _ResponsibleEmployee $projection.ResponsibleEmployee = _ResponsibleEmployee.PersonnelNumber
[0..1] I_PersonWorkAgreement_1 _SalesEmployee_2 $projection.SalesEmployee = _SalesEmployee_2.PersonWorkAgreement
[0..1] I_PersonWorkAgreement_1 _ResponsibleEmployee_2 $projection.ResponsibleEmployee = _ResponsibleEmployee_2.PersonWorkAgreement
[0..1] I_ServiceDocumentEnhcd _SolutionOrder $projection.BusinessSolutionOrder = _SolutionOrder.ServiceDocument and _SolutionOrder.ServiceObjectType = 'BUS2000172'
[1] I_ServiceDocumentItemEnhcd _SolutionOrderItem _SolutionOrderItem.ServiceObjectType = 'BUS2000172' and $projection.BusinessSolutionOrder = _SolutionOrderItem.ServiceDocument and $projection.BusinessSolutionOrderItem = _SolutionOrderItem.ServiceDocumentItem
[0..1] I_BillingDocumentBasic _CancelledBillingDocumentBasic $projection.CancelledBillingDocument = _CancelledBillingDocumentBasic.BillingDocument
[1] E_BillingDocumentItem _Extension $projection.BillingDocument = _Extension.BillingDocument and $projection.BillingDocumentItem = _Extension.BillingDocumentItem

Annotations (15)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
EndUserText.label Billing Document Item Basic Extended view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.sqlViewName ISDBILDOCITMEBAS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.representativeKey BillingDocumentItem view
Analytics.dataCategory #DIMENSION view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.modelingPattern:         #ANALYTICAL_DIMENSION
@ObjectModel.supportedCapabilities: [ #ANALYTICAL_DIMENSION,
                                      #CDS_MODELING_DATA_SOURCE,
                                      #CDS_MODELING_ASSOCIATION_TARGET,
                                      #SQL_DATA_SOURCE ]
@EndUserText.label: 'Billing Document Item Basic Extended'
@VDM.viewType: #BASIC
@AccessControl: {
  authorizationCheck: #CHECK
  //privilegedAssociations: [ '_CreatedByUser' ]

}
@AbapCatalog: {
  sqlViewName: 'ISDBILDOCITMEBAS',
  compiler.compareFilter: true,
  preserveKey: true
}
@ObjectModel.representativeKey: 'BillingDocumentItem'
@Analytics.dataCategory: #DIMENSION

//--[ GENERATED:012:GlBfhyJl7jY4t}SRJ6dMpW

@AccessControl.privilegedAssociations: ['_MaterialGroupText', '_MainItemPricingRefMatlText', '_PricingReferenceMaterialText', '_OriginallyRequestedMatlText', '_MaterialText', '_ProductText', '_CreatedByUser', '_ShippingPointText', '_BusinessAreaText']
// ]--GENERATED


@Metadata.allowExtensions: true
@Metadata.ignorePropagatedAnnotations:true

define view I_BillingDocExtdItemBasic
  as select from vbrp
  //Association


  //--[ GENERATED:012:GlBfhyJl7jY4t}SRJ6dMpW

  association [0..*] to I_MaterialText                 as _MaterialText                  on  $projection.Material = _MaterialText.Material
  association [0..*] to I_ProductText                  as _ProductText                   on  $projection.Product = _ProductText.Product
  association [0..*] to I_MaterialText                 as _OriginallyRequestedMatlText   on  $projection.OriginallyRequestedMaterial = _OriginallyRequestedMatlText.Material
  association [0..*] to I_MaterialText                 as _PricingReferenceMaterialText  on  $projection.PricingReferenceMaterial = _PricingReferenceMaterialText.Material
  association [0..*] to I_MaterialText                 as _MainItemPricingRefMatlText    on  $projection.MainItemPricingRefMaterial = _MainItemPricingRefMatlText.Material
  association [0..*] to I_MaterialGroupText            as _MaterialGroupText             on  $projection.MaterialGroup = _MaterialGroupText.MaterialGroup
  association [0..*] to I_ShippingPointText            as _ShippingPointText             on  $projection.ShippingPoint = _ShippingPointText.ShippingPoint
  //association [0..*] to I_Wbselementtext               as _WBSElementText                on  $projection.WBSElementInternalID = _WBSElementText.WBSElementObject

  association [0..*] to I_BusinessAreaText             as _BusinessAreaText              on  $projection.BusinessArea = _BusinessAreaText.BusinessArea
  // ]--GENERATED

  association [1..1] to I_BillingDocumentBasic         as _BillingDocumentBasic          on  $projection.BillingDocument = _BillingDocumentBasic.BillingDocument
  association [0..*] to I_BillingDocItemPartnerBasic   as _PartnerBasic                  on  $projection.BillingDocument     = _PartnerBasic.BillingDocument
                                                                                         and $projection.BillingDocumentItem = _PartnerBasic.BillingDocumentItem
  association [0..*] to I_BillingDocItemPrcgElmntBasic as _PricingElementBasic           on  $projection.BillingDocument     = _PricingElementBasic.BillingDocument
                                                                                         and $projection.BillingDocumentItem = _PricingElementBasic.BillingDocumentItem
  association [0..1] to I_SalesDocumentItemCategory    as _SalesDocumentItemCategory     on  $projection.SalesDocumentItemCategory = _SalesDocumentItemCategory.SalesDocumentItemCategory
  association [0..1] to I_SalesDocumentItemType        as _SalesDocumentItemType         on  $projection.SalesDocumentItemType = _SalesDocumentItemType.SalesDocumentItemType
  association [0..1] to I_User                         as _CreatedByUser                 on  $projection.CreatedByUser = _CreatedByUser.UserID
  association [0..1] to I_LogicalSystem                as _ReferenceLogicalSystem        on  $projection.ReferenceLogicalSystem = _ReferenceLogicalSystem.LogicalSystem
  association [0..1] to I_Division                     as _OrganizationDivision          on  $projection.OrganizationDivision = _OrganizationDivision.Division
  association [0..1] to I_Division                     as _Division                      on  $projection.Division = _Division.Division
  association [0..1] to I_SalesOffice                  as _SalesOffice                   on  $projection.SalesOffice = _SalesOffice.SalesOffice
  association [0..1] to I_Material                     as _Material                      on  $projection.Material = _Material.Material
  association [0..1] to I_Product                      as _Product                       on  $projection.Product = _Product.Product
  association [0..1] to I_Material                     as _OriginallyRequestedMaterial   on  $projection.OriginallyRequestedMaterial = _OriginallyRequestedMaterial.Material
  association [0..1] to I_Material                     as _PricingReferenceMaterial      on  $projection.PricingReferenceMaterial = _PricingReferenceMaterial.Material
  association [0..1] to I_Batch                        as _Batch                         on  $projection.Plant    = _Batch.Plant
                                                                                         and $projection.Material = _Batch.Material
                                                                                         and $projection.Batch    = _Batch.Batch
  association [0..1] to I_ProductHierarchyNode         as _ProductHierarchyNode          on  $projection.ProductHierarchyNode = _ProductHierarchyNode.ProductHierarchyNode
  association [0..1] to I_MaterialGroup                as _MaterialGroup                 on  $projection.MaterialGroup = _MaterialGroup.MaterialGroup
  association [0..1] to I_ProductGroup_2               as _ProductGroup                  on  $projection.ProductGroup = _ProductGroup.ProductGroup
  association [0..1] to I_AdditionalMaterialGroup1     as _AdditionalMaterialGroup1      on  $projection.AdditionalMaterialGroup1 = _AdditionalMaterialGroup1.AdditionalMaterialGroup1
  association [0..1] to I_AdditionalMaterialGroup2     as _AdditionalMaterialGroup2      on  $projection.AdditionalMaterialGroup2 = _AdditionalMaterialGroup2.AdditionalMaterialGroup2
  association [0..1] to I_AdditionalMaterialGroup3     as _AdditionalMaterialGroup3      on  $projection.AdditionalMaterialGroup3 = _AdditionalMaterialGroup3.AdditionalMaterialGroup3
  association [0..1] to I_AdditionalMaterialGroup4     as _AdditionalMaterialGroup4      on  $projection.AdditionalMaterialGroup4 = _AdditionalMaterialGroup4.AdditionalMaterialGroup4
  association [0..1] to I_AdditionalMaterialGroup5     as _AdditionalMaterialGroup5      on  $projection.AdditionalMaterialGroup5 = _AdditionalMaterialGroup5.AdditionalMaterialGroup5
  association [0..1] to I_MaterialCommissionGroup      as _MaterialCommissionGroup       on  $projection.MaterialCommissionGroup = _MaterialCommissionGroup.MaterialCommissionGroup
  association [0..1] to I_Plant                        as _Plant                         on  $projection.Plant = _Plant.Plant
  association [0..1] to I_StorageLocation              as _StorageLocation               on  $projection.Plant           = _StorageLocation.Plant
                                                                                         and $projection.StorageLocation = _StorageLocation.StorageLocation
  association [0..1] to I_Region                       as _PlantRegion                   on  $projection.DepartureCountry = _PlantRegion.Country
                                                                                         and $projection.PlantRegion      = _PlantRegion.Region
  association [0..1] to I_UnitOfMeasure                as _BillingQuantityUnit           on  $projection.BillingQuantityUnit = _BillingQuantityUnit.UnitOfMeasure
  association [0..1] to I_UnitOfMeasure                as _BaseUnit                      on  $projection.BaseUnit = _BaseUnit.UnitOfMeasure
  association [0..1] to I_UnitOfMeasure                as _ItemWeightUnit                on  $projection.ItemWeightUnit = _ItemWeightUnit.UnitOfMeasure
  association [0..1] to I_UnitOfMeasure                as _ItemVolumeUnit                on  $projection.ItemVolumeUnit = _ItemVolumeUnit.UnitOfMeasure
  association [0..1] to I_Country                      as _BillToPartyCountry            on  $projection.BillToPartyCountry = _BillToPartyCountry.Country
  association [0..1] to I_Region                       as _BillToPartyRegion             on  $projection.BillToPartyCountry = _BillToPartyRegion.Country
                                                                                         and $projection.BillToPartyRegion  = _BillToPartyRegion.Region
  association [0..1] to I_BillingPlanRule              as _BillingPlanRule               on  $projection.BillingPlanRule = _BillingPlanRule.BillingPlanRule
  association [0..1] to I_Currency                     as _TransactionCurrency           on  $projection.TransactionCurrency = _TransactionCurrency.Currency
  association [0..1] to I_StatisticalValueControl      as _StatisticalValueControl       on  $projection.StatisticalValueControl = _StatisticalValueControl.StatisticalValueControl
  association [0..1] to I_MaterialPricingGroup         as _MaterialPricingGroup          on  $projection.MaterialPricingGroup = _MaterialPricingGroup.MaterialPricingGroup
  association [0..1] to I_Material                     as _MainItemPricingRefMaterial    on  $projection.MainItemPricingRefMaterial = _MainItemPricingRefMaterial.Material
  association [0..1] to I_MaterialPricingGroup         as _MainItemMaterialPricingGroup  on  $projection.MainItemMaterialPricingGroup = _MainItemMaterialPricingGroup.MaterialPricingGroup
  association [0..1] to I_TimeSheetOvertimeCat         as _TimeSheetOvertimeCat          on  $projection.TimeSheetOvertimeCategory = _TimeSheetOvertimeCat.TimeSheetOvertimeCategory
  association [0..1] to I_Country                      as _DepartureCountry              on  $projection.DepartureCountry = _DepartureCountry.Country
  association [0..1] to I_BusinessArea                 as _BusinessArea                  on  $projection.BusinessArea = _BusinessArea.BusinessArea
  association [0..1] to I_WBSElementBasicData          as _WBSElement                    on  $projection.WBSElementInternalID = _WBSElement.WBSElementInternalID
  association [0..1] to I_WBSElementBasicData          as _WBSElementBasicData           on  $projection.WBSElementInternalID_2 = _WBSElementBasicData.WBSElementInternalID  
  association [0..1] to I_ControllingArea              as _ControllingArea               on  $projection.ControllingArea = _ControllingArea.ControllingArea
  association [0..1] to I_MatlAccountAssignmentGroup   as _MatlAccountAssignmentGroup    on  $projection.MatlAccountAssignmentGroup = _MatlAccountAssignmentGroup.MatlAccountAssignmentGroup
  association [0..1] to I_CostCenter                   as _CostCenter                    on  $projection.CostCenter        = _CostCenter.CostCenter
                                                                                         and $projection.ControllingArea   = _CostCenter.ControllingArea
                                                                                         and _CostCenter.ValidityEndDate   >= $projection.CreationDate
                                                                                         and _CostCenter.ValidityStartDate <= $projection.CreationDate
  association [0..*] to I_CostCenter                   as _CostCenter_2                  on  $projection.CostCenter        = _CostCenter_2.CostCenter
                                                                                         and $projection.ControllingArea   = _CostCenter_2.ControllingArea                                                                                                                                                                         
  association [0..*] to I_ProfitCenter                 as _ProfitCenter                  on  $projection.ProfitCenter    = _ProfitCenter.ProfitCenter
                                                                                         and $projection.ControllingArea = _ProfitCenter.ControllingArea                                                                                           
                                                                                         
  association [0..1] to I_SalesDocumentItem            as _ReferenceSalesDocumentItem    on  $projection.ReferenceSDDocument           = _ReferenceSalesDocumentItem.SalesDocument
                                                                                         and $projection.ReferenceSDDocumentItem       = _ReferenceSalesDocumentItem.SalesDocumentItem
                                                                                         and (
                                                                                            $projection.ReferenceSDDocumentCategory    = 'C' // Order

                                                                                            or $projection.ReferenceSDDocumentCategory = 'G' // Contract

                                                                                            or $projection.ReferenceSDDocumentCategory = 'H' // Returns

                                                                                            or $projection.ReferenceSDDocumentCategory = 'I' // Order wo Charge

                                                                                            or $projection.ReferenceSDDocumentCategory = 'K' // Credit Memo Request

                                                                                            or $projection.ReferenceSDDocumentCategory = 'L' // Debit Memo Request

                                                                                            or $projection.ReferenceSDDocumentCategory = ':' // Service Order

                                                                                          )
  association [0..1] to I_DeliveryDocumentItem         as _ReferenceDeliveryDocumentItem on  $projection.ReferenceSDDocument           = _ReferenceDeliveryDocumentItem.DeliveryDocument
                                                                                         and $projection.ReferenceSDDocumentItem       = _ReferenceDeliveryDocumentItem.DeliveryDocumentItem
                                                                                         and (
                                                                                            $projection.ReferenceSDDocumentCategory    = 'J' // Delivery

                                                                                            or $projection.ReferenceSDDocumentCategory = 'T' // Returns Delivery for Order

                                                                                          )
  association [0..1] to I_BillingDocumentItemBasic     as _ReferenceBillingDocItemBasic  on  $projection.ReferenceSDDocument           = _ReferenceBillingDocItemBasic.BillingDocument
                                                                                         and $projection.ReferenceSDDocumentItem       = _ReferenceBillingDocItemBasic.BillingDocumentItem
                                                                                         and (
                                                                                            $projection.ReferenceSDDocumentCategory    = 'M'    // Invoice

                                                                                            or $projection.ReferenceSDDocumentCategory = 'N'    // Invoice Canceled

                                                                                            or $projection.ReferenceSDDocumentCategory = 'O'    // Credit Memo

                                                                                            or $projection.ReferenceSDDocumentCategory = 'P'    // Debit Memo

                                                                                            or $projection.ReferenceSDDocumentCategory = 'S'    // Credit Memo Canceled

                                                                                            or $projection.ReferenceSDDocumentCategory = 'U'    // Pro Forma Invoice

                                                                                            or $projection.ReferenceSDDocumentCategory = '3'    // Invoice List

                                                                                            or $projection.ReferenceSDDocumentCategory = '4'    // Credit Memo List

                                                                                            or $projection.ReferenceSDDocumentCategory = '5'    // Intercompany Invoice

                                                                                            or $projection.ReferenceSDDocumentCategory = '6'    // Intercompany Credit Memo

                                                                                            or $projection.ReferenceSDDocumentCategory = 'EBDR' // External Billing Document Request

                                                                                            or $projection.ReferenceSDDocumentCategory = 'PBD'  // Preliminary Billing Document

                                                                                          )
  association [0..1] to I_SDDocumentCategory           as _ReferenceSDDocumentCategory   on  $projection.ReferenceSDDocumentCategory = _ReferenceSDDocumentCategory.SDDocumentCategory
  association [0..1] to I_SalesDocument                as _SalesDocument                 on  $projection.SalesDocument = _SalesDocument.SalesDocument
  association [0..1] to I_SalesDocumentItem            as _SalesDocumentItem             on  $projection.SalesDocument     = _SalesDocumentItem.SalesDocument
                                                                                         and $projection.SalesDocumentItem = _SalesDocumentItem.SalesDocumentItem
  association [0..1] to I_SDDocumentCategory           as _SalesSDDocumentCategory       on  $projection.SalesSDDocumentCategory = _SalesSDDocumentCategory.SDDocumentCategory
  association [0..1] to I_BillingDocumentItemBasic     as _HigherLevelItemBasic          on  $projection.BillingDocument = _HigherLevelItemBasic.BillingDocument
                                                                                         and $projection.HigherLevelItem = _HigherLevelItemBasic.BillingDocumentItem
  association [0..1] to I_PrelimBillingDocument        as _PrelimBillingDocument         on  $projection.PrelimBillingDocument = _PrelimBillingDocument.PrelimBillingDocument
  association [0..1] to I_PrelimBillingDocumentItem    as _PrelimBillingDocumentItem     on  $projection.PrelimBillingDocument     = _PrelimBillingDocumentItem.PrelimBillingDocument
                                                                                         and $projection.PrelimBillingDocumentItem = _PrelimBillingDocumentItem.PrelimBillingDocumentItem
  association [0..1] to I_SalesGroup                   as _SalesGroup                    on  $projection.SalesGroup = _SalesGroup.SalesGroup
  association [0..1] to I_AdditionalCustomerGroup1     as _AdditionalCustomerGroup1      on  $projection.AdditionalCustomerGroup1 = _AdditionalCustomerGroup1.AdditionalCustomerGroup1
  association [0..1] to I_AdditionalCustomerGroup2     as _AdditionalCustomerGroup2      on  $projection.AdditionalCustomerGroup2 = _AdditionalCustomerGroup2.AdditionalCustomerGroup2
  association [0..1] to I_AdditionalCustomerGroup3     as _AdditionalCustomerGroup3      on  $projection.AdditionalCustomerGroup3 = _AdditionalCustomerGroup3.AdditionalCustomerGroup3
  association [0..1] to I_AdditionalCustomerGroup4     as _AdditionalCustomerGroup4      on  $projection.AdditionalCustomerGroup4 = _AdditionalCustomerGroup4.AdditionalCustomerGroup4
  association [0..1] to I_AdditionalCustomerGroup5     as _AdditionalCustomerGroup5      on  $projection.AdditionalCustomerGroup5 = _AdditionalCustomerGroup5.AdditionalCustomerGroup5
  association [0..1] to I_SDDocumentReason             as _SDDocumentReason              on  $projection.SDDocumentReason = _SDDocumentReason.SDDocumentReason
  association [0..1] to I_RetailPromotion              as _RetailPromotion               on  $projection.RetailPromotion = _RetailPromotion.RetailPromotion
  association [0..1] to I_SalesDeal                    as _SalesDeal                     on  $projection.SalesDeal = _SalesDeal.SalesDeal
  association [0..1] to I_SalesDistrict                as _SalesOrderSalesDistrict       on  $projection.SalesOrderSalesDistrict = _SalesOrderSalesDistrict.SalesDistrict
  association [0..1] to I_CustomerGroup                as _SalesOrderCustomerGroup       on  $projection.SalesOrderCustomerGroup = _SalesOrderCustomerGroup.CustomerGroup
  association [0..1] to I_CustomerPriceGroup           as _SalesOrderCustomerPriceGroup  on  $projection.SalesOrderCustomerPriceGroup = _SalesOrderCustomerPriceGroup.CustomerPriceGroup
  association [0..1] to I_PriceListType                as _SalesOrderPriceListType       on  $projection.SalesOrderPriceListType = _SalesOrderPriceListType.PriceListType
  association [0..1] to I_SalesOrganization            as _SalesOrderSalesOrganization   on  $projection.SalesOrderSalesOrganization = _SalesOrderSalesOrganization.SalesOrganization
  association [0..1] to I_DistributionChannel          as _SalesOrderDistributionChannel on  $projection.SalesOrderDistributionChannel = _SalesOrderDistributionChannel.DistributionChannel
  association [0..1] to I_ShippingPoint                as _ShippingPoint                 on  $projection.ShippingPoint = _ShippingPoint.ShippingPoint
  association [0..1] to I_ServiceDocumentType          as _ServiceDocumentType           on  $projection.ServiceDocumentType = _ServiceDocumentType.ServiceDocumentType
  //Analytics fields

  association [0..1] to I_SDDocumentCategory           as _SDDocumentCategory            on  $projection.SDDocumentCategory = _SDDocumentCategory.SDDocumentCategory
  association [0..1] to I_BillingDocumentCategory      as _BillingDocumentCategory       on  $projection.BillingDocumentCategory = _BillingDocumentCategory.BillingDocumentCategory
  association [0..1] to I_BillingDocumentType          as _BillingDocumentType           on  $projection.BillingDocumentType = _BillingDocumentType.BillingDocumentType
  association [0..1] to I_SalesOrganization            as _SalesOrganization             on  $projection.SalesOrganization = _SalesOrganization.SalesOrganization
  association [0..1] to I_DistributionChannel          as _DistributionChannel           on  $projection.DistributionChannel = _DistributionChannel.DistributionChannel
  association [0..1] to I_CustomerPriceGroup           as _CustomerPriceGroup            on  $projection.CustomerPriceGroup = _CustomerPriceGroup.CustomerPriceGroup
  association [0..1] to I_CustomerGroup                as _CustomerGroup                 on  $projection.CustomerGroup = _CustomerGroup.CustomerGroup
  association [0..1] to I_Country                      as _Country                       on  $projection.Country = _Country.Country
  association [0..1] to I_CityCode                     as _CityCode                      on  $projection.CityCode = _CityCode.CityCode
                                                                                         and $projection.Country  = _CityCode.Country
                                                                                         and $projection.Region   = _CityCode.Region
  association [0..1] to I_SalesDistrict                as _SalesDistrict                 on  $projection.SalesDistrict = _SalesDistrict.SalesDistrict
  association [0..1] to I_Region                       as _Region                        on  $projection.Region  = _Region.Region
                                                                                         and $projection.Country = _Region.Country
  association [0..1] to I_CountyCode                   as _County                        on  $projection.Country = _County.Country
                                                                                         and $projection.Region  = _County.Region
                                                                                         and $projection.County  = _County.County
  association [0..1] to I_TaxingCounty                 as _County_2                      on  $projection.Country = _County_2.Country
                                                                                         and $projection.Region  = _County_2.Region
                                                                                         and $projection.County  = _County_2.TaxingCounty
  association [0..1] to I_OverallSDProcessStatus       as _OverallSDProcessStatus        on  $projection.OverallSDProcessStatus = _OverallSDProcessStatus.OverallSDProcessStatus
  association [0..1] to I_OverallBillingStatus         as _OverallBillingStatus          on  $projection.OverallBillingStatus = _OverallBillingStatus.OverallBillingStatus
  association [0..1] to I_Customer                     as _SoldToParty                   on  $projection.SoldToParty = _SoldToParty.Customer
  association [0..1] to I_Customer                     as _PayerParty                    on  $projection.PayerParty = _PayerParty.Customer
  association [0..1] to I_CompanyCode                  as _CompanyCode                   on  $projection.CompanyCode = _CompanyCode.CompanyCode
  association [0..1] to I_Customer                     as _ShipToParty                   on  $projection.ShipToParty = _ShipToParty.Customer
  association [0..1] to I_Customer                     as _BillToParty                   on  $projection.BillToParty = _BillToParty.Customer
  association [0..1] to I_Employee                     as _SalesEmployee                 on  $projection.SalesEmployee = _SalesEmployee.PersonnelNumber
  association [0..1] to I_Employee                     as _ResponsibleEmployee           on  $projection.ResponsibleEmployee = _ResponsibleEmployee.PersonnelNumber
  association [0..1] to I_PersonWorkAgreement_1        as _SalesEmployee_2               on  $projection.SalesEmployee = _SalesEmployee_2.PersonWorkAgreement
  association [0..1] to I_PersonWorkAgreement_1        as _ResponsibleEmployee_2         on  $projection.ResponsibleEmployee = _ResponsibleEmployee_2.PersonWorkAgreement
  
  association [0..1] to I_ServiceDocumentEnhcd         as _SolutionOrder                 on  $projection.BusinessSolutionOrder = _SolutionOrder.ServiceDocument
                                                                                             and _SolutionOrder.ServiceObjectType = 'BUS2000172' 
  association [1] to I_ServiceDocumentItemEnhcd        as _SolutionOrderItem             on  _SolutionOrderItem.ServiceObjectType = 'BUS2000172'
                                                                                             and $projection.BusinessSolutionOrder = _SolutionOrderItem.ServiceDocument
                                                                                             and $projection.BusinessSolutionOrderItem = _SolutionOrderItem.ServiceDocumentItem          
  association [0..1] to I_BillingDocumentBasic         as _CancelledBillingDocumentBasic on  $projection.CancelledBillingDocument = _CancelledBillingDocumentBasic.BillingDocument                                                                                                                                                                            
  //Extension Association

  association [1]    to E_BillingDocumentItem          as _Extension                     on  $projection.BillingDocument     = _Extension.BillingDocument
                                                                                         and $projection.BillingDocumentItem = _Extension.BillingDocumentItem
{
      //Key

      //--[ GENERATED:012:GlBfhyJl7jY4t}SRJ6dMpW

      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_BillingDocumentBasicStdVH',
                     element: 'BillingDocument' }
        }]
      // ]--GENERATED

      @ObjectModel.foreignKey.association: '_BillingDocumentBasic'
  key vbeln                                                  as BillingDocument,
      @ObjectModel.text.element:  ['BillingDocumentItemText']
  key posnr                                                  as BillingDocumentItem,

      @ObjectModel.foreignKey.association: '_SalesDocumentItemCategory'
      pstyv                                                  as SalesDocumentItemCategory,
      @ObjectModel.foreignKey.association: '_SalesDocumentItemType'
      posar                                                  as SalesDocumentItemType,
      shkzg                                                  as ReturnItemProcessingType,

      //Admin

      @Semantics.user.createdBy: true
      ernam                                                  as CreatedByUser,
      @Semantics.systemDate.createdAt: true
      erdat