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) and exposes 291 fields with key fields BillingDocument, BillingDocumentItem. 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 |
Fields (291)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | BillingDocument | vbeln | ||
| KEY | BillingDocumentItem | posnr | ||
| SalesDocumentItemCategory | pstyv | |||
| SalesDocumentItemType | posar | |||
| ReturnItemProcessingType | shkzg | |||
| CreatedByUser | ernam | |||
| CreationDate | erdat | |||
| CreationTime | erzet | |||
| ReferenceLogicalSystem | logsys | |||
| OrganizationDivision | spara | |||
| Division | spart | |||
| SalesOffice | vkbur | |||
| Material | matnr | |||
| Product | ||||
| OriginallyRequestedMaterial | matwa | |||
| InternationalArticleNumber | ean11 | |||
| PricingReferenceMaterial | pmatn | |||
| Batch | charg | |||
| ProductHierarchyNode | prodh | |||
| MaterialGroup | matkl | |||
| ProductGroup | ||||
| AdditionalMaterialGroup1 | mvgr1 | |||
| AdditionalMaterialGroup2 | mvgr2 | |||
| AdditionalMaterialGroup3 | mvgr3 | |||
| AdditionalMaterialGroup4 | mvgr4 | |||
| AdditionalMaterialGroup5 | mvgr5 | |||
| ProductConfiguration | cuobj | |||
| MaterialCommissionGroup | provg | |||
| Plant | werks | |||
| StorageLocation | lgort | |||
| ReplacementPartType | atpkz | |||
| MaterialGroupHierarchy1 | wgru1 | |||
| MaterialGroupHierarchy2 | wgru2 | |||
| PlantRegion | wkreg | |||
| PlantCounty | wkcou | |||
| PlantCity | wkcty | |||
| BOMExplosion | sernr | |||
| MaterialDeterminationType | prosa | |||
| BillingDocumentItemText | arktx | |||
| ServicesRenderedDate | fbuda | |||
| BillingQuantity | fkimg | |||
| BillingQuantityUnit | vrkme | |||
| BillingQuantityInBaseUnit | fklmg | |||
| BaseUnit | meins | |||
| MRPRequiredQuantityInBaseUnit | lmeng | |||
| BillingToBaseQuantityDnmntr | umvkn | |||
| BillingToBaseQuantityNmrtr | umvkz | |||
| ItemGrossWeight | brgew | |||
| ItemNetWeight | ntgew | |||
| ItemWeightUnit | gewei | |||
| ItemVolume | volum | |||
| ItemVolumeUnit | voleh | |||
| BillToPartyCountry | lland_auft | |||
| BillToPartyRegion | regio_auft | |||
| BillingPlanRule | fareg | |||
| BillingPlan | fplnr | |||
| BillingPlanItem | fpltr | |||
| DocumentBillingStatus | fksaa | |||
| NetAmount | netwr | |||
| TransactionCurrency | waerk | |||
| GrossAmount | brtwr | |||
| PricingDate | prsdt | |||
| PriceDetnExchangeRate | ||||
| PricingScaleQuantityInBaseUnit | smeng | |||
| TaxAmount | mwsbp | |||
| CostAmount | wavwr | |||
| Subtotal1Amount | kzwi1 | |||
| Subtotal2Amount | kzwi2 | |||
| Subtotal3Amount | kzwi3 | |||
| Subtotal4Amount | kzwi4 | |||
| Subtotal5Amount | kzwi5 | |||
| Subtotal6Amount | kzwi6 | |||
| StatisticalValueControl | kowrr | |||
| CashDiscountIsDeductible | sktof | |||
| CustomerConditionGroup1 | kdkg1 | |||
| CustomerConditionGroup2 | kdkg2 | |||
| CustomerConditionGroup3 | kdkg3 | |||
| CustomerConditionGroup4 | kdkg4 | |||
| CustomerConditionGroup5 | kdkg5 | |||
| ManualPriceChangeType | mprok | |||
| MaterialPricingGroup | kondm | |||
| StatisticsExchangeRate | ||||
| MainItemPricingRefMaterial | upmat | |||
| MainItemMaterialPricingGroup | ukonm | |||
| TimeSheetOvertimeCategory | cats_overtime_category | |||
| DepartureCountry | aland | |||
| TaxJurisdiction | txjcd | |||
| ProductTaxClassification1 | taxm1 | |||
| ProductTaxClassification2 | taxm2 | |||
| ProductTaxClassification3 | taxm3 | |||
| ProductTaxClassification4 | taxm4 | |||
| ProductTaxClassification5 | taxm5 | |||
| ProductTaxClassification6 | taxm6 | |||
| ProductTaxClassification7 | taxm7 | |||
| ProductTaxClassification8 | taxm8 | |||
| ProductTaxClassification9 | taxm9 | |||
| ZeroVATRsn | j_1arfz | |||
| TaxCode | mwsk1 | |||
| TaxRateValidityStartDate | txdat_from | |||
| EligibleAmountForCashDiscount | skfbp | |||
| BusinessArea | gsber | |||
| ProfitCenter | prctr | |||
| WBSElementInternalID | ps_psp_pnr | |||
| WBSElementInternalID_2 | ||||
| ControllingArea | kokrs | |||
| ProfitabilitySegment | ||||
| ProfitabilitySegment_2 | ||||
| OrderID | aufnr | |||
| CostCenter | kostl | |||
| OriginSDDocument | vbelv | |||
| OriginSDDocumentItem | posnv | |||
| PriceDetnExchangeRateDate | kursk_dat | |||
| MatlAccountAssignmentGroup | ktgrm | |||
| ReferenceSDDocument | vgbel | |||
| ReferenceSDDocumentItem | vgpos | |||
| ReferenceSDDocumentCategory | vgtyp | |||
| SalesDocument | aubel | |||
| SalesDocumentItem | aupos | |||
| SalesSDDocumentCategory | autyp | |||
| HigherLevelItem | uepos | |||
| BillingDocumentItemInPartSgmt | pospa | |||
| ExternalReferenceDocument | ||||
| ExternalReferenceDocumentItem | ||||
| BillingDocExtReferenceDocItem | ||||
| PrelimBillingDocument | pbd_id | |||
| PrelimBillingDocumentItem | pbd_item_id | |||
| SalesGroup | vkgrp | |||
| AdditionalCustomerGroup1 | kvgr1 | |||
| AdditionalCustomerGroup2 | kvgr2 | |||
| AdditionalCustomerGroup3 | kvgr3 | |||
| AdditionalCustomerGroup4 | kvgr4 | |||
| AdditionalCustomerGroup5 | kvgr5 | |||
| SDDocumentReason | augru_auft | |||
| RetailPromotion | aktnr | |||
| RebateBasisAmount | bonba | |||
| VolumeRebateGroup | bonus | |||
| ItemIsRelevantForCredit | cmpnt | |||
| CreditRelatedPrice | cmpre | |||
| SalesDeal | knuma_ag | |||
| SalesPromotion | knuma_pi | |||
| SalesOrderSalesDistrict | bzirk_auft | |||
| SalesOrderCustomerGroup | kdgrp_auft | |||
| SalesOrderCustomerPriceGroup | konda_auft | |||
| SalesOrderPriceListType | pltyp_auft | |||
| SalesOrderSalesOrganization | vkorg_auft | |||
| SalesOrderDistributionChannel | vtweg_auft | |||
| SalesDocIsCreatedFromReference | auref | |||
| ShippingPoint | vstel | |||
| ServiceDocumentType | service_doc_type | |||
| ServiceDocument | service_doc_id | |||
| ServiceDocumentItem | service_doc_item_id | |||
| BusinessSolutionOrder | solution_order_id | |||
| BusinessSolutionOrderItem | solution_order_item_id | |||
| HigherLevelItemUsage | uepvw | |||
| SDDocumentCategory | vbtyp_ana | |||
| BillingDocumentType | fkart_ana | |||
| SalesOrganization | vkorg_ana | |||
| DistributionChannel | vtweg_ana | |||
| CustomerPriceGroup | konda_ana | |||
| CustomerGroup | kdgrp_ana | |||
| Country | land1_ana | |||
| Region | regio_ana | |||
| CityCode | cityc_ana | |||
| SalesDistrict | bzirk_ana | |||
| OverallSDProcessStatus | gbstk_ana | |||
| OverallBillingStatus | vf_status_ana | |||
| SoldToParty | kunag_ana | |||
| PayerParty | kunrg_ana | |||
| BillingDocumentDate | fkdat_ana | |||
| CompanyCode | bukrs_ana | |||
| County | counc_ana | |||
| CustomerRebateAgreement | knuma_ana | |||
| BillingDocumentCategory | fktyp_ana | |||
| PricingDocument | knumv_ana | |||
| CancelledBillingDocument | sfakn_ana | |||
| BillingDocumentIsTemporary | draft | |||
| ShipToParty | kunwe_ana | |||
| BillToParty | kunre_ana | |||
| SalesEmployee | perve_ana | |||
| ResponsibleEmployee | perzm_ana | |||
| _BillingDocumentBasic | _BillingDocumentBasic | |||
| _PartnerBasic | _PartnerBasic | |||
| _PricingElementBasic | _PricingElementBasic | |||
| _SalesDocumentItemCategory | _SalesDocumentItemCategory | |||
| _SalesDocumentItemType | _SalesDocumentItemType | |||
| _CreatedByUser | _CreatedByUser | |||
| _ReferenceLogicalSystem | _ReferenceLogicalSystem | |||
| _OrganizationDivision | _OrganizationDivision | |||
| _Division | _Division | |||
| _SalesOffice | _SalesOffice | |||
| _Material | _Material | |||
| _Product | _Product | |||
| _OriginallyRequestedMaterial | _OriginallyRequestedMaterial | |||
| _PricingReferenceMaterial | _PricingReferenceMaterial | |||
| _Batch | _Batch | |||
| _ProductHierarchyNode | _ProductHierarchyNode | |||
| _MaterialGroup | _MaterialGroup | |||
| _ProductGroup | _ProductGroup | |||
| _AdditionalMaterialGroup1 | _AdditionalMaterialGroup1 | |||
| _AdditionalMaterialGroup2 | _AdditionalMaterialGroup2 | |||
| _AdditionalMaterialGroup3 | _AdditionalMaterialGroup3 | |||
| _AdditionalMaterialGroup4 | _AdditionalMaterialGroup4 | |||
| _AdditionalMaterialGroup5 | _AdditionalMaterialGroup5 | |||
| _MaterialCommissionGroup | _MaterialCommissionGroup | |||
| _Plant | _Plant | |||
| _StorageLocation | _StorageLocation | |||
| _PlantRegion | _PlantRegion | |||
| _BillingQuantityUnit | _BillingQuantityUnit | |||
| _BaseUnit | _BaseUnit | |||
| _ItemWeightUnit | _ItemWeightUnit | |||
| _ItemVolumeUnit | _ItemVolumeUnit | |||
| _BillToPartyCountry | _BillToPartyCountry | |||
| _BillToPartyRegion | _BillToPartyRegion | |||
| _BillingPlanRule | _BillingPlanRule | |||
| _TransactionCurrency | _TransactionCurrency | |||
| _StatisticalValueControl | _StatisticalValueControl | |||
| _MaterialPricingGroup | _MaterialPricingGroup | |||
| _MainItemPricingRefMaterial | _MainItemPricingRefMaterial | |||
| _MainItemMaterialPricingGroup | _MainItemMaterialPricingGroup | |||
| _TimeSheetOvertimeCat | _TimeSheetOvertimeCat | |||
| _DepartureCountry | _DepartureCountry | |||
| _BusinessArea | _BusinessArea | |||
| _ProfitCenter | _ProfitCenter | |||
| _WBSElement | _WBSElement | |||
| _WBSElementBasicData | _WBSElementBasicData | |||
| _ControllingArea | _ControllingArea | |||
| _MatlAccountAssignmentGroup | _MatlAccountAssignmentGroup | |||
| _CostCenter | _CostCenter | |||
| _CostCenter_2 | _CostCenter_2 | |||
| _ReferenceSalesDocumentItem | _ReferenceSalesDocumentItem | |||
| _ReferenceDeliveryDocumentItem | _ReferenceDeliveryDocumentItem | |||
| _ReferenceBillingDocItemBasic | _ReferenceBillingDocItemBasic | |||
| _ReferenceSDDocumentCategory | _ReferenceSDDocumentCategory | |||
| _SalesDocument | _SalesDocument | |||
| _SalesDocumentItem | _SalesDocumentItem | |||
| _SalesSDDocumentCategory | _SalesSDDocumentCategory | |||
| _HigherLevelItemBasic | _HigherLevelItemBasic | |||
| _PrelimBillingDocument | _PrelimBillingDocument | |||
| _PrelimBillingDocumentItem | _PrelimBillingDocumentItem | |||
| _SalesGroup | _SalesGroup | |||
| _AdditionalCustomerGroup1 | _AdditionalCustomerGroup1 | |||
| _AdditionalCustomerGroup2 | _AdditionalCustomerGroup2 | |||
| _AdditionalCustomerGroup3 | _AdditionalCustomerGroup3 | |||
| _AdditionalCustomerGroup4 | _AdditionalCustomerGroup4 | |||
| _AdditionalCustomerGroup5 | _AdditionalCustomerGroup5 | |||
| _SDDocumentReason | _SDDocumentReason | |||
| _RetailPromotion | _RetailPromotion | |||
| _SalesDeal | _SalesDeal | |||
| _SalesOrderSalesDistrict | _SalesOrderSalesDistrict | |||
| _SalesOrderCustomerGroup | _SalesOrderCustomerGroup | |||
| _SalesOrderCustomerPriceGroup | _SalesOrderCustomerPriceGroup | |||
| _SalesOrderPriceListType | _SalesOrderPriceListType | |||
| _SalesOrderSalesOrganization | _SalesOrderSalesOrganization | |||
| _SalesOrderDistributionChannel | _SalesOrderDistributionChannel | |||
| _ShippingPoint | _ShippingPoint | |||
| _ServiceDocumentType | _ServiceDocumentType | |||
| _SDDocumentCategory | _SDDocumentCategory | |||
| _BillingDocumentCategory | _BillingDocumentCategory | |||
| _BillingDocumentType | _BillingDocumentType | |||
| _SalesOrganization | _SalesOrganization | |||
| _DistributionChannel | _DistributionChannel | |||
| _CustomerPriceGroup | _CustomerPriceGroup | |||
| _CustomerGroup | _CustomerGroup | |||
| _Country | _Country | |||
| _Region | _Region | |||
| _CityCode | _CityCode | |||
| _SalesDistrict | _SalesDistrict | |||
| _OverallSDProcessStatus | _OverallSDProcessStatus | |||
| _OverallBillingStatus | _OverallBillingStatus | |||
| _SoldToParty | _SoldToParty | |||
| _PayerParty | _PayerParty | |||
| _CompanyCode | _CompanyCode | |||
| _County | _County | |||
| _County_2 | _County_2 | |||
| _ShipToParty | _ShipToParty | |||
| _BillToParty | _BillToParty | |||
| _SalesEmployee | _SalesEmployee | |||
| _SalesEmployee_2 | _SalesEmployee_2 | |||
| _ResponsibleEmployee | _ResponsibleEmployee | |||
| _ResponsibleEmployee_2 | _ResponsibleEmployee_2 | |||
| _SolutionOrder | _SolutionOrder | |||
| _SolutionOrderItem | _SolutionOrderItem | |||
| _CancelledBillingDocumentBasic | _CancelledBillingDocumentBasic | |||
| _MaterialGroupText | _MaterialGroupText | |||
| _ShippingPointText | _ShippingPointText | |||
| _BusinessAreaText | _BusinessAreaText | |||
| _MaterialText | _MaterialText | |||
| _ProductText | _ProductText | |||
| _PricingReferenceMaterialText | _PricingReferenceMaterialText | |||
| _MainItemPricingRefMatlText | _MainItemPricingRefMatlText | |||
| _OriginallyRequestedMatlText | _OriginallyRequestedMatlText |
@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 as CreationDate,
@Semantics.systemTime.createdAt
erzet as CreationTime,
@ObjectModel.foreignKey.association: '_ReferenceLogicalSystem'
logsys as ReferenceLogicalSystem,
//Organization
@ObjectModel.foreignKey.association: '_OrganizationDivision'
spara as OrganizationDivision,
@ObjectModel.foreignKey.association: '_Division'
spart as Division,
@ObjectModel.foreignKey.association: '_SalesOffice'
vkbur as SalesOffice,
//Product
//--[ GENERATED:012:GlBfhyJl7jY4t}SRJ6dMpW
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_MaterialStdVH',
element: 'Material' }
}]
@ObjectModel.text.association: '_MaterialText'
// ]--GENERATED
@ObjectModel.foreignKey.association: '_Material'
@API.element: { releaseState: #DEPRECATED, successor: 'Product' }
matnr as Material,
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_ProductStdVH',
element: 'Product' }
}]
@ObjectModel.text.association: '_ProductText'
@ObjectModel.foreignKey.association: '_Product'
cast (matnr as productnumber preserving type) as Product,
//--[ GENERATED:012:GlBfhyJl7jY4t}SRJ6dMpW
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_MaterialStdVH',
element: 'Material' }
}]
@ObjectModel.text.association: '_OriginallyRequestedMatlText'
// ]--GENERATED
@ObjectModel.foreignKey.association: '_OriginallyRequestedMaterial'
matwa as OriginallyRequestedMaterial,
ean11 as InternationalArticleNumber,
//--[ GENERATED:012:GlBfhyJl7jY4t}SRJ6dMpW
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_MaterialStdVH',
element: 'Material' }
}]
@ObjectModel.text.association: '_PricingReferenceMaterialText'
// ]--GENERATED
@ObjectModel.foreignKey.association: '_PricingReferenceMaterial'
pmatn as PricingReferenceMaterial,
//--[ GENERATED:012:GlBfhyJl7jY4t}SRJ6dMpW
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_BatchStdVH',
element: 'Batch' },
additionalBinding: [{ localElement: 'Plant',
element: 'Plant' },
{ localElement: 'Material',
element: 'Material' }]
}]
// ]--GENERATED
@ObjectModel.foreignKey.association: '_Batch'
charg as Batch,
@ObjectModel.foreignKey.association: '_ProductHierarchyNode'
prodh as ProductHierarchyNode,
//--[ GENERATED:012:GlBfhyJl7jY4t}SRJ6dMpW
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_MaterialGroup',
element: 'MaterialGroup' }
}]
@ObjectModel.text.association: '_MaterialGroupText'
// ]--GENERATED
@ObjectModel.foreignKey.association: '_MaterialGroup'
@API.element: { releaseState: #DEPRECATED, successor: 'ProductGroup' }
matkl as MaterialGroup,
@ObjectModel.foreignKey.association: '_ProductGroup'
cast (matkl as productgroup preserving type ) as ProductGroup,
@ObjectModel.foreignKey.association: '_AdditionalMaterialGroup1'
mvgr1 as AdditionalMaterialGroup1,
@ObjectModel.foreignKey.association: '_AdditionalMaterialGroup2'
mvgr2 as AdditionalMaterialGroup2,
@ObjectModel.foreignKey.association: '_AdditionalMaterialGroup3'
mvgr3 as AdditionalMaterialGroup3,
@ObjectModel.foreignKey.association: '_AdditionalMaterialGroup4'
mvgr4 as AdditionalMaterialGroup4,
@ObjectModel.foreignKey.association: '_AdditionalMaterialGroup5'
mvgr5 as AdditionalMaterialGroup5,
cuobj as ProductConfiguration,
@ObjectModel.foreignKey.association: '_MaterialCommissionGroup'
provg as MaterialCommissionGroup,
@ObjectModel.foreignKey.association: '_Plant'
werks as Plant,
@ObjectModel.foreignKey.association: '_StorageLocation'
lgort as StorageLocation,
atpkz as ReplacementPartType,
wgru1 as MaterialGroupHierarchy1,
wgru2 as MaterialGroupHierarchy2,
@ObjectModel.foreignKey.association: '_PlantRegion'
wkreg as PlantRegion,
wkcou as PlantCounty,
wkcty as PlantCity,
sernr as BOMExplosion,
prosa as MaterialDeterminationType,
//Billing
@Semantics.text: true
arktx as BillingDocumentItemText,
fbuda as ServicesRenderedDate,
@Semantics.quantity.unitOfMeasure: 'BillingQuantityUnit'
fkimg as BillingQuantity,
@Semantics.unitOfMeasure: true
@ObjectModel.foreignKey.association: '_BillingQuantityUnit'
vrkme as BillingQuantityUnit,
@Semantics.quantity.unitOfMeasure: 'BaseUnit'
fklmg as BillingQuantityInBaseUnit,
@Semantics.unitOfMeasure: true
@ObjectModel.foreignKey.association: '_BaseUnit'
meins as BaseUnit,
@Semantics.quantity.unitOfMeasure: 'BaseUnit'
lmeng as MRPRequiredQuantityInBaseUnit,
umvkn as BillingToBaseQuantityDnmntr,
umvkz as BillingToBaseQuantityNmrtr,
@Semantics.quantity.unitOfMeasure: 'ItemWeightUnit'
brgew as ItemGrossWeight,
@Semantics.quantity.unitOfMeasure: 'ItemWeightUnit'
ntgew as ItemNetWeight,
@Semantics.unitOfMeasure: true
@ObjectModel.foreignKey.association: '_ItemWeightUnit'
gewei as ItemWeightUnit,
@Semantics.quantity.unitOfMeasure: 'ItemVolumeUnit'
volum as ItemVolume,
@Semantics.unitOfMeasure: true
@ObjectModel.foreignKey.association: '_ItemVolumeUnit'
voleh as ItemVolumeUnit,
@ObjectModel.foreignKey.association: '_BillToPartyCountry'
lland_auft as BillToPartyCountry,
@ObjectModel.foreignKey.association: '_BillToPartyRegion'
regio_auft as BillToPartyRegion,
@ObjectModel.foreignKey.association: '_BillingPlanRule'
fareg as BillingPlanRule,
fplnr as BillingPlan,
fpltr as BillingPlanItem,
//Status
// foreign key association has to be defined (in next release (?)), target: I_DocBillingStatus
fksaa as DocumentBillingStatus,
//Pricing
@Semantics.amount.currencyCode: 'TransactionCurrency'
netwr as NetAmount,
@Semantics.currencyCode: true
@ObjectModel.foreignKey.association: '_TransactionCurrency'
waerk as TransactionCurrency,
@Semantics.amount.currencyCode: 'TransactionCurrency'
brtwr as GrossAmount,
prsdt as PricingDate,
cast(kursk as kursk_not_converted preserving type ) as PriceDetnExchangeRate,
@Semantics.quantity.unitOfMeasure: 'BaseUnit'
smeng as PricingScaleQuantityInBaseUnit,
@Semantics.amount.currencyCode: 'TransactionCurrency'
mwsbp as TaxAmount,
@Semantics.amount.currencyCode: 'TransactionCurrency'
wavwr as CostAmount,
@Semantics.amount.currencyCode: 'TransactionCurrency'
kzwi1 as Subtotal1Amount,
@Semantics.amount.currencyCode: 'TransactionCurrency'
kzwi2 as Subtotal2Amount,
@Semantics.amount.currencyCode: 'TransactionCurrency'
kzwi3 as Subtotal3Amount,
@Semantics.amount.currencyCode: 'TransactionCurrency'
kzwi4 as Subtotal4Amount,
@Semantics.amount.currencyCode: 'TransactionCurrency'
kzwi5 as Subtotal5Amount,
@Semantics.amount.currencyCode: 'TransactionCurrency'
kzwi6 as Subtotal6Amount,
@ObjectModel.foreignKey.association: '_StatisticalValueControl'
kowrr as StatisticalValueControl,
sktof as CashDiscountIsDeductible,
kdkg1 as CustomerConditionGroup1,
kdkg2 as CustomerConditionGroup2,
kdkg3 as CustomerConditionGroup3,
kdkg4 as CustomerConditionGroup4,
kdkg5 as CustomerConditionGroup5,
mprok as ManualPriceChangeType,
@ObjectModel.foreignKey.association: '_MaterialPricingGroup'
kondm as MaterialPricingGroup,
cast(stcur as stcur_ap_not_converted preserving type ) as StatisticsExchangeRate,
//--[ GENERATED:012:GlBfhyJl7jY4t}SRJ6dMpW
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_MaterialStdVH',
element: 'Material' }
}]
@ObjectModel.text.association: '_MainItemPricingRefMatlText'
// ]--GENERATED
@ObjectModel.foreignKey.association: '_MainItemPricingRefMaterial'
upmat as MainItemPricingRefMaterial,
@ObjectModel.foreignKey.association: '_MainItemMaterialPricingGroup'
ukonm as MainItemMaterialPricingGroup,
@ObjectModel.foreignKey.association: '_TimeSheetOvertimeCat'
cats_overtime_category as TimeSheetOvertimeCategory,
// Tax
@ObjectModel.foreignKey.association: '_DepartureCountry'
aland as DepartureCountry,
txjcd as TaxJurisdiction,
taxm1 as ProductTaxClassification1,
taxm2 as ProductTaxClassification2,
taxm3 as ProductTaxClassification3,
taxm4 as ProductTaxClassification4,
taxm5 as ProductTaxClassification5,
taxm6 as ProductTaxClassification6,
taxm7 as ProductTaxClassification7,
taxm8 as ProductTaxClassification8,
taxm9 as ProductTaxClassification9,
j_1arfz as ZeroVATRsn,
mwsk1 as TaxCode,
txdat_from as TaxRateValidityStartDate,
//Payment
@Semantics.amount.currencyCode: 'TransactionCurrency'
skfbp as EligibleAmountForCashDiscount,
//Accounting
//--[ GENERATED:012:GlBfhyJl7jY4t}SRJ6dMpW
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_BusinessAreaStdVH',
element: 'BusinessArea' }
}]
@ObjectModel.text.association: '_BusinessAreaText'
// ]--GENERATED
@ObjectModel.foreignKey.association: '_BusinessArea'
gsber as BusinessArea,
@ObjectModel.foreignKey.association: '_ProfitCenter'
prctr as ProfitCenter,
//--[ GENERATED:012:GlBfhyJl7jY4t}SRJ6dMpW
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_WBSElementStdVH',
element: 'WBSElementInternalID' }
}]
@ObjectModel.text.association: '_WBSElement'
// ]--GENERATED
@ObjectModel.foreignKey.association: '_WBSElement'
@API.element: { releaseState: #DEPRECATED, successor: 'WBSElementInternalID_2' }
ps_psp_pnr as WBSElementInternalID,
@ObjectModel.foreignKey.association: '_WBSElementBasicData'
cast( ps_psp_pnr as ps_s4_pspnr preserving type ) as WBSElementInternalID_2,
//--[ GENERATED:012:GlBfhyJl7jY4t}SRJ6dMpW
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_ControllingAreaStdVH',
element: 'ControllingArea' }
}]
// ]--GENERATED
@ObjectModel.foreignKey.association: '_ControllingArea'
kokrs as ControllingArea,
@API.element: { releaseState: #DECOMMISSIONED, successor: 'ProfitabilitySegment_2' }
cast( case when paobjnr > '9999999999' then '9999999999' else lpad( paobjnr, 10, '0' ) end as rkeobjnr_numc ) as ProfitabilitySegment,
cast(paobjnr as rkeobjnr_char ) as ProfitabilitySegment_2,
aufnr as OrderID,
@ObjectModel.foreignKey.association: '_CostCenter_2'
kostl as CostCenter,
vbelv as OriginSDDocument,
posnv as OriginSDDocumentItem,
kursk_dat as PriceDetnExchangeRateDate,
@ObjectModel.foreignKey.association: '_MatlAccountAssignmentGroup'
ktgrm as MatlAccountAssignmentGroup,
//Reference
vgbel as ReferenceSDDocument,
vgpos as ReferenceSDDocumentItem,
@ObjectModel.foreignKey.association: '_ReferenceSDDocumentCategory'
vgtyp as ReferenceSDDocumentCategory,
//--[ GENERATED:012:GlBfhyJl7jY4t}SRJ6dMpW
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_SalesDocumentStdVH',
element: 'SalesDocument' }
}]
// ]--GENERATED
@ObjectModel.foreignKey.association: '_SalesDocument'
aubel as SalesDocument,
//--[ GENERATED:012:GlBfhyJl7jY4t}SRJ6dMpW
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_SalesDocumentItemStdVH',
element: 'SalesDocumentItem' },
additionalBinding: [{ localElement: 'SalesDocument',
element: 'SalesDocument' }]
}]
// ]--GENERATED
@ObjectModel.foreignKey.association: '_SalesDocumentItem'
aupos as SalesDocumentItem,
@ObjectModel.foreignKey.association: '_SalesSDDocumentCategory'
autyp as SalesSDDocumentCategory,
//--[ GENERATED:012:GlBfhyJl7jY4t}SRJ6dMpW
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_BillgDocItmBscStdVH',
element: 'BillingDocumentItem' },
additionalBinding: [{ localElement: 'BillingDocument',
element: 'BillingDocument' }]
}]
// ]--GENERATED
@ObjectModel.foreignKey.association: '_HigherLevelItemBasic'
uepos as HigherLevelItem,
pospa as BillingDocumentItemInPartSgmt,
cast( vgbel_ex as ext_reference_document preserving type ) as ExternalReferenceDocument,
@API.element: { releaseState: #DEPRECATED, successor: 'BillingDocExtReferenceDocItem' }
cast( vgpos_ex as ext_reference_document_item preserving type ) as ExternalReferenceDocumentItem,
cast( vgpos_ex as billingdocextreferencedocitem preserving type ) as BillingDocExtReferenceDocItem,
@ObjectModel.foreignKey.association: '_PrelimBillingDocument'
pbd_id as PrelimBillingDocument,
@ObjectModel.foreignKey.association: '_PrelimBillingDocumentItem'
pbd_item_id as PrelimBillingDocumentItem,
//Sales
@ObjectModel.foreignKey.association: '_SalesGroup'
vkgrp as SalesGroup,
@ObjectModel.foreignKey.association: '_AdditionalCustomerGroup1'
kvgr1 as AdditionalCustomerGroup1,
@ObjectModel.foreignKey.association: '_AdditionalCustomerGroup2'
kvgr2 as AdditionalCustomerGroup2,
@ObjectModel.foreignKey.association: '_AdditionalCustomerGroup3'
kvgr3 as AdditionalCustomerGroup3,
@ObjectModel.foreignKey.association: '_AdditionalCustomerGroup4'
kvgr4 as AdditionalCustomerGroup4,
@ObjectModel.foreignKey.association: '_AdditionalCustomerGroup5'
kvgr5 as AdditionalCustomerGroup5,
@ObjectModel.foreignKey.association: '_SDDocumentReason'
augru_auft as SDDocumentReason,
//--[ GENERATED:012:GlBfhyJl7jY4t}SRJ6dMpW
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_RetailPromotionStdVH',
element: 'RetailPromotion' }
}]
// ]--GENERATED
@ObjectModel.foreignKey.association: '_RetailPromotion'
aktnr as RetailPromotion,
@Semantics.amount.currencyCode: 'TransactionCurrency'
bonba as RebateBasisAmount,
bonus as VolumeRebateGroup,
cmpnt as ItemIsRelevantForCredit,
@Semantics.amount.currencyCode: 'TransactionCurrency'
cmpre as CreditRelatedPrice,
//--[ GENERATED:012:GlBfhyJl7jY4t}SRJ6dMpW
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_SalesDealStdVH',
element: 'SalesDeal' }
}]
// ]--GENERATED
@ObjectModel.foreignKey.association: '_SalesDeal'
knuma_ag as SalesDeal,
knuma_pi as SalesPromotion,
@ObjectModel.foreignKey.association: '_SalesOrderSalesDistrict'
bzirk_auft as SalesOrderSalesDistrict,
@ObjectModel.foreignKey.association: '_SalesOrderCustomerGroup'
kdgrp_auft as SalesOrderCustomerGroup,
@ObjectModel.foreignKey.association: '_SalesOrderCustomerPriceGroup'
konda_auft as SalesOrderCustomerPriceGroup,
@ObjectModel.foreignKey.association: '_SalesOrderPriceListType'
pltyp_auft as SalesOrderPriceListType,
@ObjectModel.foreignKey.association: '_SalesOrderSalesOrganization'
vkorg_auft as SalesOrderSalesOrganization,
@ObjectModel.foreignKey.association: '_SalesOrderDistributionChannel'
vtweg_auft as SalesOrderDistributionChannel,
auref as SalesDocIsCreatedFromReference,
//Shipping
//--[ GENERATED:012:GlBfhyJl7jY4t}SRJ6dMpW
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_ShippingPointStdVH',
element: 'ShippingPoint' }
}]
@ObjectModel.text.association: '_ShippingPointText'
// ]--GENERATED
@ObjectModel.foreignKey.association: '_ShippingPoint'
vstel as ShippingPoint,
// CRM
@ObjectModel.foreignKey.association: '_ServiceDocumentType'
service_doc_type as ServiceDocumentType,
service_doc_id as ServiceDocument,
service_doc_item_id as ServiceDocumentItem,
@Analytics.internalName: #LOCAL
@ObjectModel.foreignKey.association: '_SolutionOrder'
solution_order_id as BusinessSolutionOrder,
@Analytics.internalName: #LOCAL
@ObjectModel.foreignKey.association: '_SolutionOrderItem'
solution_order_item_id as BusinessSolutionOrderItem,
//Other fields
uepvw as HigherLevelItemUsage,
//Added Analytics fields
@ObjectModel.foreignKey.association: '_SDDocumentCategory'
vbtyp_ana as SDDocumentCategory,
@ObjectModel.foreignKey.association: '_BillingDocumentType'
fkart_ana as BillingDocumentType,
@ObjectModel.foreignKey.association: '_SalesOrganization'
vkorg_ana as SalesOrganization,
@ObjectModel.foreignKey.association: '_DistributionChannel'
vtweg_ana as DistributionChannel,
@ObjectModel.foreignKey.association: '_CustomerPriceGroup'
konda_ana as CustomerPriceGroup,
@ObjectModel.foreignKey.association: '_CustomerGroup'
kdgrp_ana as CustomerGroup,
@ObjectModel.foreignKey.association: '_Country'
land1_ana as Country,
@ObjectModel.foreignKey.association: '_Region'
regio_ana as Region,
@ObjectModel.foreignKey.association: '_CityCode'
cityc_ana as CityCode,
@ObjectModel.foreignKey.association: '_SalesDistrict'
bzirk_ana as SalesDistrict,
@ObjectModel.foreignKey.association: '_OverallSDProcessStatus'
gbstk_ana as OverallSDProcessStatus,
@ObjectModel.foreignKey.association: '_OverallBillingStatus'
vf_status_ana as OverallBillingStatus,
//sales
//--[ GENERATED:012:GlBfhyFV7jY4{YyEh3zJr0
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_Customer_VH',
element: 'Customer' }
}]
// ]--GENERATED
@ObjectModel.foreignKey.association: '_SoldToParty'
kunag_ana as SoldToParty,
//payment
//--[ GENERATED:012:GlBfhyFV7jY4{YyEh3zJr0
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_Customer_VH',
element: 'Customer' }
}]
// ]--GENERATED
@ObjectModel.foreignKey.association: '_PayerParty'
kunrg_ana as PayerParty,
fkdat_ana as BillingDocumentDate,
@ObjectModel.foreignKey.association: '_CompanyCode'
bukrs_ana as CompanyCode,
@ObjectModel.foreignKey.association: '_County_2'
counc_ana as County,
knuma_ana as CustomerRebateAgreement,
fktyp_ana as BillingDocumentCategory,
knumv_ana as PricingDocument,
@ObjectModel.foreignKey.association: '_CancelledBillingDocumentBasic'
sfakn_ana as CancelledBillingDocument,
draft as BillingDocumentIsTemporary,
//ship-to
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_Customer_VH',
element: 'Customer' }
}]
@ObjectModel.foreignKey.association: '_ShipToParty'
kunwe_ana as ShipToParty,
//bill-to
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_Customer_VH',
element: 'Customer' }
}]
@ObjectModel.foreignKey.association: '_BillToParty'
kunre_ana as BillToParty,
@ObjectModel.foreignKey.association: '_SalesEmployee_2'
perve_ana as SalesEmployee,
@ObjectModel.foreignKey.association: '_ResponsibleEmployee_2'
perzm_ana as ResponsibleEmployee,
//association
@ObjectModel.association.type: [#TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT]
_BillingDocumentBasic,
@ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
_PartnerBasic,
@ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
_PricingElementBasic,
_SalesDocumentItemCategory,
_SalesDocumentItemType,
_CreatedByUser,
_ReferenceLogicalSystem,
_OrganizationDivision,
_Division,
_SalesOffice,
@API.element: { releaseState: #DEPRECATED, successor: '_Product' }
_Material,
_Product,
_OriginallyRequestedMaterial,
_PricingReferenceMaterial,
_Batch,
_ProductHierarchyNode,
@API.element: { releaseState: #DEPRECATED, successor: '_ProductGroup' }
_MaterialGroup,
_ProductGroup,
_AdditionalMaterialGroup1,
_AdditionalMaterialGroup2,
_AdditionalMaterialGroup3,
_AdditionalMaterialGroup4,
_AdditionalMaterialGroup5,
_MaterialCommissionGroup,
_Plant,
_StorageLocation,
_PlantRegion,
_BillingQuantityUnit,
_BaseUnit,
_ItemWeightUnit,
_ItemVolumeUnit,
_BillToPartyCountry,
_BillToPartyRegion,
_BillingPlanRule,
_TransactionCurrency,
_StatisticalValueControl,
_MaterialPricingGroup,
_MainItemPricingRefMaterial,
_MainItemMaterialPricingGroup,
_TimeSheetOvertimeCat,
_DepartureCountry,
_BusinessArea,
_ProfitCenter,
@API.element: { releaseState: #DEPRECATED, successor: '_WBSElementBasicData' }
_WBSElement,
_WBSElementBasicData,
_ControllingArea,
_MatlAccountAssignmentGroup,
@API.element: { releaseState: #DEPRECATED, successor: '_CostCenter_2' }
_CostCenter,
_CostCenter_2,
_ReferenceSalesDocumentItem,
_ReferenceDeliveryDocumentItem,
_ReferenceBillingDocItemBasic,
_ReferenceSDDocumentCategory,
_SalesDocument,
_SalesDocumentItem,
_SalesSDDocumentCategory,
_HigherLevelItemBasic,
_PrelimBillingDocument,
_PrelimBillingDocumentItem,
_SalesGroup,
_AdditionalCustomerGroup1,
_AdditionalCustomerGroup2,
_AdditionalCustomerGroup3,
_AdditionalCustomerGroup4,
_AdditionalCustomerGroup5,
_SDDocumentReason,
_RetailPromotion,
_SalesDeal,
_SalesOrderSalesDistrict,
_SalesOrderCustomerGroup,
_SalesOrderCustomerPriceGroup,
_SalesOrderPriceListType,
_SalesOrderSalesOrganization,
_SalesOrderDistributionChannel,
_ShippingPoint,
_ServiceDocumentType,
//Analytics
_SDDocumentCategory,
_BillingDocumentCategory,
_BillingDocumentType,
_SalesOrganization,
_DistributionChannel,
_CustomerPriceGroup,
_CustomerGroup,
_Country,
_Region,
_CityCode,
_SalesDistrict,
_OverallSDProcessStatus,
_OverallBillingStatus,
_SoldToParty,
_PayerParty,
_CompanyCode,
@API.element: { releaseState: #DEPRECATED, successor: '_County_2' }
_County,
_County_2,
_ShipToParty,
_BillToParty,
@API.element.releaseState: #DEPRECATED
@API.element.successor: '_SalesEmployee_2'
_SalesEmployee,
_SalesEmployee_2,
@API.element.releaseState: #DEPRECATED
@API.element.successor: '_ResponsibleEmployee_2'
_ResponsibleEmployee,
_ResponsibleEmployee_2,
_SolutionOrder,
_SolutionOrderItem,
_CancelledBillingDocumentBasic,
//--[ GENERATED:012:GlBfhyJl7jY4t}SRJ6dMpW
@Consumption.hidden: true
_MaterialGroupText,
@Consumption.hidden: true
_ShippingPointText,
@Consumption.hidden: true
_BusinessAreaText,
//@Consumption.hidden: true
//_WBSElementText,
@Consumption.hidden: true
@API.element: { releaseState: #DEPRECATED, successor: '_ProductText' }
_MaterialText,
@Consumption.hidden: true
_ProductText,
@Consumption.hidden: true
_PricingReferenceMaterialText,
@Consumption.hidden: true
_MainItemPricingRefMatlText,
@Consumption.hidden: true
_OriginallyRequestedMatlText
// ]--GENERATED
}
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