I_BillingDocExtdItemBasic
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)
| Source | Alias | Join Type |
|---|---|---|
| vbrp | vbrp | from |
Associations (112)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [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)
| Name | Value | Level | Field |
|---|---|---|---|
| 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
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA