I_BILLINGDOCEXTDITEMBASIC
Billing Document Item Basic Extended
I_BILLINGDOCEXTDITEMBASIC is a CDS View in S/4HANA. Billing Document Item Basic Extended. It contains 76 fields. 11 CDS views read from this table.
CDS Views using this table (11)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_BillgDocItmPrcgElmntBscDEX | view | inner | CONSUMPTION | Data Extraction for Billing Doc Item Pricing Element Basic |
| C_BillgDocItmPrcgElmntBscDEX_1 | view | inner | CONSUMPTION | Data Extraction for Billing Doc Item Pricing Element Basic |
| C_BillingDocItemBasicDEX_1 | view | from | CONSUMPTION | Data Extraction for Billing Doc Item Basic |
| C_BillingDocumentItemBasicDEX | view | from | CONSUMPTION | Billing Document Item Basic Extraction Data |
| I_BillingDocExtdItem | view | from | BASIC | Billing Document Item Extended |
| P_ProfitMarginByMonth | view | from | COMPOSITE | |
| P_SalesVolume | view | from | COMPOSITE | |
| P_SI_SalesVolumeActualData | view | from | COMPOSITE | |
| P_SI4_TrainingData01 | view | from | COMPOSITE | |
| P_SPP_PredictionData01 | view | from | COMPOSITE | |
| P_SPP_TrainingData01 | view | from | COMPOSITE |
Fields (76)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | BillingDocument | BillingDocument,SDDocument | 2 |
| KEY | BillingDocumentItem | BillingDocumentItem,SDDocumentItem | 4 |
| _DistributionChannel | _DistributionChannel | 1 | |
| _OrganizationDivision | _OrganizationDivision | 1 | |
| _ProductHierarchyNode | _ProductHierarchyNode | 1 | |
| _SalesGroup | _SalesGroup | 1 | |
| _SalesOffice | _SalesOffice | 1 | |
| _SalesOrganization | _SalesOrganization | 1 | |
| _SoldToParty | _SoldToParty | 1 | |
| _TransactionCurrency | _TransactionCurrency | 1 | |
| AdditionalCustomerGroup1 | AdditionalCustomerGroup1 | 3 | |
| AdditionalCustomerGroup2 | AdditionalCustomerGroup2 | 3 | |
| AdditionalCustomerGroup3 | AdditionalCustomerGroup3 | 3 | |
| AdditionalCustomerGroup4 | AdditionalCustomerGroup4 | 3 | |
| AdditionalCustomerGroup5 | AdditionalCustomerGroup5 | 3 | |
| AdditionalMaterialGroup1 | AdditionalMaterialGroup1 | 3 | |
| AdditionalMaterialGroup2 | AdditionalMaterialGroup2 | 3 | |
| AdditionalMaterialGroup3 | AdditionalMaterialGroup3 | 3 | |
| AdditionalMaterialGroup4 | AdditionalMaterialGroup4 | 3 | |
| AdditionalMaterialGroup5 | AdditionalMaterialGroup5 | 3 | |
| BillingDocumentDate | BillingDocumentDate | 1 | |
| BillingDocumentType | BillingDocumentType | 1 | |
| BillingPlanRule | BillingPlanRule | 2 | |
| BillingQuantity | BillingQuantity | 2 | |
| BillingQuantityUnit | BillingQuantityUnit | 2 | |
| BillToParty | BillToParty | 2 | |
| BillToPartyCountry | BillToPartyCountry | 1 | |
| BillToPartyRegion | BillToPartyRegion | 1 | |
| BusinessArea | BusinessArea | 1 | |
| CompanyCode | CompanyCode | 1 | |
| ControllingArea | ControllingArea | 3 | |
| CostCenter | CostCenter | 3 | |
| Country | Country | 1 | |
| CreationDate | CreationDate | 2 | |
| CreationTime | CreationTime | 2 | |
| CustomerGroup | CustomerGroup | 1 | |
| DistributionChannel | DistributionChannel | 2 | |
| Division | Division,OrganizationDivision | 3 | |
| InternationalArticleNumber | InternationalArticleNumber | 2 | |
| Material | Material | 3 | |
| MaterialCommissionGroup | MaterialCommissionGroup | 2 | |
| MaterialGroup | MaterialGroup | 3 | |
| OrganizationDivision | OrganizationDivision | 3 | |
| OriginallyRequestedMaterial | OriginallyRequestedMaterial | 2 | |
| OverallBillingStatus | OverallBillingStatus | 2 | |
| OverallSDProcessStatus | OverallSDProcessStatus | 2 | |
| Plant | Plant | 1 | |
| PriceDetnExchangeRate | PriceDetnExchangeRate | 2 | |
| PriceDetnExchangeRateDate | PriceDetnExchangeRateDate | 2 | |
| PricingDate | PricingDate | 2 | |
| Product | Product | 3 | |
| ProductGroup | ProductGroup | 3 | |
| ProductHierarchyNode | ProductHierarchyNode | 1 | |
| ProfitCenter | ProfitCenter | 1 | |
| ReferenceSDDocument | ReferenceSDDocument | 2 | |
| ReferenceSDDocumentCategory | ReferenceSDDocumentCategory | 2 | |
| ReferenceSDDocumentItem | ReferenceSDDocumentItem | 2 | |
| Region | Region | 1 | |
| ResponsibleEmployee | ResponsibleEmployee | 1 | |
| ReturnItemProcessingType | ReturnItemProcessingType | 2 | |
| SalesDistrict | SalesDistrict | 1 | |
| SalesDocument | SalesDocument | 2 | |
| SalesDocumentItem | SalesDocumentItem | 2 | |
| SalesDocumentItemCategory | SalesDocumentItemCategory | 2 | |
| SalesDocumentItemType | SalesDocumentItemType | 2 | |
| SalesEmployee | SalesEmployee | 1 | |
| SalesGroup | SalesGroup | 4 | |
| SalesOffice | SalesOffice | 4 | |
| SalesOrganization | SalesOrganization | 2 | |
| SDDocumentCategory | SDDocumentCategory | 1 | |
| ServicesRenderedDate | ServicesRenderedDate | 2 | |
| ShipToParty | ShipToParty | 2 | |
| SoldToParty | Customer,SoldToParty | 2 | |
| StatisticalValueControl | StatisticalValueControl | 2 | |
| StatisticsExchangeRate | StatisticsExchangeRate | 2 | |
| TransactionCurrency | TransactionCurrency | 2 |
@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