I_BillingDocExtdItem

DDL: I_BILLINGDOCEXTDITEM Type: view BASIC

Billing Document Item Extended

I_BillingDocExtdItem is a Basic CDS View (Dimension) that provides data about "Billing Document Item Extended" in SAP S/4HANA. It reads from 1 data source (I_BillingDocExtdItemBasic) and exposes 289 fields with key fields BillingDocument, BillingDocumentItem.

Data Sources (1)

SourceAliasJoin Type
I_BillingDocExtdItemBasic I_BillingDocExtdItemBasic from

Annotations (15)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.representativeKey BillingDocumentItem view
EndUserText.label Billing Document Item Extended view
Analytics.dataCategory #DIMENSION view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.sqlViewName ISDBILDOCEXITM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
Analytics.internalName #LOCAL view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view

Fields (289)

KeyFieldSource TableSource FieldDescription
KEY BillingDocument BillingDocument
KEY BillingDocumentItem BillingDocumentItem
SalesDocumentItemCategory SalesDocumentItemCategory
SalesDocumentItemType SalesDocumentItemType
ReturnItemProcessingType ReturnItemProcessingType
CreatedByUser CreatedByUser
CreationDate CreationDate
CreationTime CreationTime
ReferenceLogicalSystem ReferenceLogicalSystem
OrganizationDivision OrganizationDivision
Division Division
SalesOffice SalesOffice
Material Material
Product Product
OriginallyRequestedMaterial OriginallyRequestedMaterial
InternationalArticleNumber InternationalArticleNumber
PricingReferenceMaterial PricingReferenceMaterial
Batch Batch
ProductHierarchyNode ProductHierarchyNode
MaterialGroup MaterialGroup
ProductGroup ProductGroup
AdditionalMaterialGroup1 AdditionalMaterialGroup1
AdditionalMaterialGroup2 AdditionalMaterialGroup2
AdditionalMaterialGroup3 AdditionalMaterialGroup3
AdditionalMaterialGroup4 AdditionalMaterialGroup4
AdditionalMaterialGroup5 AdditionalMaterialGroup5
ProductConfiguration ProductConfiguration
MaterialCommissionGroup MaterialCommissionGroup
Plant Plant
StorageLocation StorageLocation
ReplacementPartType ReplacementPartType
MaterialGroupHierarchy1 MaterialGroupHierarchy1
MaterialGroupHierarchy2 MaterialGroupHierarchy2
PlantRegion PlantRegion
PlantCounty PlantCounty
PlantCity PlantCity
BOMExplosion BOMExplosion
MaterialDeterminationType MaterialDeterminationType
BillingDocumentItemText BillingDocumentItemText
ServicesRenderedDate ServicesRenderedDate
BillingQuantity BillingQuantity
BillingQuantityUnit BillingQuantityUnit
BillingQuantityInBaseUnit BillingQuantityInBaseUnit
BaseUnit BaseUnit
MRPRequiredQuantityInBaseUnit MRPRequiredQuantityInBaseUnit
BillingToBaseQuantityDnmntr BillingToBaseQuantityDnmntr
BillingToBaseQuantityNmrtr BillingToBaseQuantityNmrtr
ItemGrossWeight ItemGrossWeight
ItemNetWeight ItemNetWeight
ItemWeightUnit ItemWeightUnit
ItemVolume ItemVolume
ItemVolumeUnit ItemVolumeUnit
BillToPartyCountry BillToPartyCountry
BillToPartyRegion BillToPartyRegion
BillingPlanRule BillingPlanRule
BillingPlan BillingPlan
BillingPlanItem BillingPlanItem
NetAmount NetAmount
TransactionCurrency TransactionCurrency
GrossAmount GrossAmount
PricingDate PricingDate
PriceDetnExchangeRate PriceDetnExchangeRate
PricingScaleQuantityInBaseUnit PricingScaleQuantityInBaseUnit
TaxAmount TaxAmount
CostAmount CostAmount
Subtotal1Amount Subtotal1Amount
Subtotal2Amount Subtotal2Amount
Subtotal3Amount Subtotal3Amount
Subtotal4Amount Subtotal4Amount
Subtotal5Amount Subtotal5Amount
Subtotal6Amount Subtotal6Amount
StatisticalValueControl StatisticalValueControl
CashDiscountIsDeductible CashDiscountIsDeductible
CustomerConditionGroup1 CustomerConditionGroup1
CustomerConditionGroup2 CustomerConditionGroup2
CustomerConditionGroup3 CustomerConditionGroup3
CustomerConditionGroup4 CustomerConditionGroup4
CustomerConditionGroup5 CustomerConditionGroup5
ManualPriceChangeType ManualPriceChangeType
MaterialPricingGroup MaterialPricingGroup
StatisticsExchangeRate StatisticsExchangeRate
MainItemPricingRefMaterial MainItemPricingRefMaterial
MainItemMaterialPricingGroup MainItemMaterialPricingGroup
TimeSheetOvertimeCategory TimeSheetOvertimeCategory
DepartureCountry DepartureCountry
TaxJurisdiction TaxJurisdiction
ProductTaxClassification1 ProductTaxClassification1
ProductTaxClassification2 ProductTaxClassification2
ProductTaxClassification3 ProductTaxClassification3
ProductTaxClassification4 ProductTaxClassification4
ProductTaxClassification5 ProductTaxClassification5
ProductTaxClassification6 ProductTaxClassification6
ProductTaxClassification7 ProductTaxClassification7
ProductTaxClassification8 ProductTaxClassification8
ProductTaxClassification9 ProductTaxClassification9
ZeroVATRsn ZeroVATRsn
TaxCode TaxCode
TaxRateValidityStartDate TaxRateValidityStartDate
EligibleAmountForCashDiscount EligibleAmountForCashDiscount
BusinessArea BusinessArea
ProfitCenter ProfitCenter
WBSElement WBSElementInternalID
WBSElementInternalID WBSElementInternalID_2
ControllingArea ControllingArea
ProfitabilitySegment ProfitabilitySegment
ProfitabilitySegment_2 ProfitabilitySegment_2
OrderID OrderID
CostCenter CostCenter
OriginSDDocument OriginSDDocument
OriginSDDocumentItem OriginSDDocumentItem
PriceDetnExchangeRateDate PriceDetnExchangeRateDate
MatlAccountAssignmentGroup MatlAccountAssignmentGroup
ReferenceSDDocument ReferenceSDDocument
ReferenceSDDocumentItem ReferenceSDDocumentItem
ReferenceSDDocumentCategory ReferenceSDDocumentCategory
SalesDocument SalesDocument
SalesDocumentItem SalesDocumentItem
SalesSDDocumentCategory SalesSDDocumentCategory
HigherLevelItem HigherLevelItem
BillingDocumentItemInPartSgmt BillingDocumentItemInPartSgmt
ExternalReferenceDocument ExternalReferenceDocument
ExternalReferenceDocumentItem ExternalReferenceDocumentItem
BillingDocExtReferenceDocItem BillingDocExtReferenceDocItem
PrelimBillingDocument PrelimBillingDocument
PrelimBillingDocumentItem PrelimBillingDocumentItem
SalesGroup SalesGroup
AdditionalCustomerGroup1 AdditionalCustomerGroup1
AdditionalCustomerGroup2 AdditionalCustomerGroup2
AdditionalCustomerGroup3 AdditionalCustomerGroup3
AdditionalCustomerGroup4 AdditionalCustomerGroup4
AdditionalCustomerGroup5 AdditionalCustomerGroup5
SDDocumentReason SDDocumentReason
RetailPromotion RetailPromotion
RebateBasisAmount RebateBasisAmount
VolumeRebateGroup VolumeRebateGroup
ItemIsRelevantForCredit ItemIsRelevantForCredit
CreditRelatedPrice CreditRelatedPrice
SalesDeal SalesDeal
SalesPromotion SalesPromotion
SalesOrderSalesDistrict SalesOrderSalesDistrict
SalesOrderCustomerGroup SalesOrderCustomerGroup
SalesOrderCustomerPriceGroup SalesOrderCustomerPriceGroup
SalesOrderPriceListType SalesOrderPriceListType
SalesOrderSalesOrganization SalesOrderSalesOrganization
SalesOrderDistributionChannel SalesOrderDistributionChannel
SalesDocIsCreatedFromReference SalesDocIsCreatedFromReference
ShippingPoint ShippingPoint
ServiceDocumentType ServiceDocumentType
ServiceDocument ServiceDocument
ServiceDocumentItem ServiceDocumentItem
BusinessSolutionOrder BusinessSolutionOrder
BusinessSolutionOrderItem BusinessSolutionOrderItem
HigherLevelItemUsage HigherLevelItemUsage
SDDocumentCategory SDDocumentCategory
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
BillingDocumentDate BillingDocumentDate
CompanyCode CompanyCode
County County
CustomerRebateAgreement CustomerRebateAgreement
BillingDocumentCategory BillingDocumentCategory
PricingDocument PricingDocument
CancelledBillingDocument CancelledBillingDocument
BillingDocumentIsTemporary BillingDocumentIsTemporary
ShipToParty ShipToParty
BillToParty BillToParty
SalesEmployee SalesEmployee
ResponsibleEmployee ResponsibleEmployee
_BillingDocument _BillingDocument
_Partner _Partner
_PricingElement _PricingElement
_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
_HigherLevelItem _HigherLevelItem
_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
_BusinessAreaText _BusinessAreaText
_MaterialGroupText _MaterialGroupText
_ShippingPointText _ShippingPointText
_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.representativeKey: 'BillingDocumentItem'
@EndUserText.label: 'Billing Document Item Extended'
@Analytics.dataCategory: #DIMENSION
@VDM.viewType: #BASIC
@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #('TRANSACTIONAL_DATA')
  //privilegedAssociations: [ '_CreatedByUser' ]

}
@AbapCatalog: {
  sqlViewName: 'ISDBILDOCEXITM',
  compiler.compareFilter: true,
  preserveKey: true
}

//--[ GENERATED:012:GlBfhyJl7kY4uNsXH4jYtm

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


@Analytics.internalName: #LOCAL 
@Metadata.allowExtensions: true
@Metadata.ignorePropagatedAnnotations:true

define view I_BillingDocExtdItem
as select from I_BillingDocExtdItemBasic

  association[1..1] to I_BillingDocument              as _BillingDocument          on  $projection.BillingDocument               = _BillingDocument.BillingDocument
  association[0..*] to I_BillingDocItemPartner        as _Partner                  on  $projection.BillingDocument               = _Partner.BillingDocument
                                                                                  and  $projection.BillingDocumentItem           = _Partner.BillingDocumentItem
  association[0..*] to I_BillingDocumentItemPrcgElmnt as _PricingElement           on  $projection.BillingDocument               = _PricingElement.BillingDocument
                                                                                  and  $projection.BillingDocumentItem           = _PricingElement.BillingDocumentItem
  association[0..1] to I_BillingDocumentItem          as _HigherLevelItem          on  $projection.BillingDocument               = _HigherLevelItem.BillingDocument
                                                                                  and  $projection.HigherLevelItem               = _HigherLevelItem.BillingDocumentItem

  association[0..1] to I_WBSElementBasicData          as _WBSElementBasicData      on  $projection.WBSElementInternalID          = _WBSElementBasicData.WBSElementInternalID  

  //Extension Association

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

{
  //Key

  @Consumption.valueHelpDefinition: [ 
        { entity:  { name:    'I_BillingDocumentBasicStdVH',
                     element: 'BillingDocument' }
        }]
  @ObjectModel.foreignKey.association: '_BillingDocument'
  key BillingDocument,
  @ObjectModel.text.element:  ['BillingDocumentItemText'] 
  key BillingDocumentItem,
  
  //Category

      @ObjectModel.foreignKey.association: '_SalesDocumentItemCategory'
      SalesDocumentItemCategory,
      @ObjectModel.foreignKey.association: '_SalesDocumentItemType'
      SalesDocumentItemType,
      ReturnItemProcessingType,

      //Admin

      @Semantics.user.createdBy: true
      CreatedByUser,
      @Semantics.systemDate.createdAt: true
      CreationDate,
      @Semantics.systemTime.createdAt
      CreationTime,
      @ObjectModel.foreignKey.association: '_ReferenceLogicalSystem'
      ReferenceLogicalSystem,

      //Organization

      @ObjectModel.foreignKey.association: '_OrganizationDivision'
      OrganizationDivision,
      @ObjectModel.foreignKey.association: '_Division'
      Division,
      @ObjectModel.foreignKey.association: '_SalesOffice'
      SalesOffice,

      //Product

      @Consumption.valueHelpDefinition: [ 
        { entity:  { name:    'I_MaterialStdVH',
                     element: 'Material' }
        }]
      @ObjectModel.text.association: '_MaterialText'
      @ObjectModel.foreignKey.association: '_Material'
      @VDM.lifecycle: { status: #DEPRECATED, successor: 'Product' }
      Material,
      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_ProductStdVH',
                     element: 'Product' }
        }]
      @ObjectModel.text.association: '_ProductText'
      @ObjectModel.foreignKey.association: '_Product'
      Product,            
      @Consumption.valueHelpDefinition: [ 
        { entity:  { name:    'I_MaterialStdVH',
                     element: 'Material' }
        }]
      @ObjectModel.text.association: '_OriginallyRequestedMatlText'
      @ObjectModel.foreignKey.association: '_OriginallyRequestedMaterial'
      OriginallyRequestedMaterial,
      InternationalArticleNumber,
      @Consumption.valueHelpDefinition: [ 
        { entity:  { name:    'I_MaterialStdVH',
                     element: 'Material' }
        }]
      @ObjectModel.text.association: '_PricingReferenceMaterialText'
      @ObjectModel.foreignKey.association: '_PricingReferenceMaterial'
      PricingReferenceMaterial,
      @Consumption.valueHelpDefinition: [ 
        { entity:  { name:    'I_BatchStdVH',
                     element: 'Batch' },
          additionalBinding: [{ localElement: 'Plant',
                                element: 'Plant' },
                              { localElement: 'Material',
                                element: 'Material' }]
        }]
      @ObjectModel.foreignKey.association: '_Batch'
      Batch,
      @ObjectModel.foreignKey.association: '_ProductHierarchyNode'
      ProductHierarchyNode,
      @Consumption.valueHelpDefinition: [ 
        { entity:  { name:    'I_MaterialGroup',
                     element: 'MaterialGroup' }
        }]
      @ObjectModel.text.association: '_MaterialGroupText'
      @ObjectModel.foreignKey.association: '_MaterialGroup'
      @VDM.lifecycle: { status: #DEPRECATED, successor: 'ProductGroup' }
      MaterialGroup,
      @ObjectModel.foreignKey.association: '_ProductGroup'
      ProductGroup,            
      @ObjectModel.foreignKey.association: '_AdditionalMaterialGroup1'
      AdditionalMaterialGroup1,
      @ObjectModel.foreignKey.association: '_AdditionalMaterialGroup2'
      AdditionalMaterialGroup2,
      @ObjectModel.foreignKey.association: '_AdditionalMaterialGroup3'
      AdditionalMaterialGroup3,
      @ObjectModel.foreignKey.association: '_AdditionalMaterialGroup4'
      AdditionalMaterialGroup4,
      @ObjectModel.foreignKey.association: '_AdditionalMaterialGroup5'
      AdditionalMaterialGroup5,
      ProductConfiguration,
      @ObjectModel.foreignKey.association: '_MaterialCommissionGroup'      
      MaterialCommissionGroup,
      @ObjectModel.foreignKey.association: '_Plant'
      Plant,
      @ObjectModel.foreignKey.association: '_StorageLocation'
      StorageLocation,
      ReplacementPartType,
      MaterialGroupHierarchy1,
      MaterialGroupHierarchy2,
      @ObjectModel.foreignKey.association: '_PlantRegion'
      PlantRegion,
      PlantCounty,
      PlantCity,
      BOMExplosion,
      MaterialDeterminationType,

      //Billing

      @Semantics.text: true
      BillingDocumentItemText,
      ServicesRenderedDate,

      @Semantics.quantity.unitOfMeasure: 'BillingQuantityUnit'
      BillingQuantity,
      @Semantics.unitOfMeasure: true
      @ObjectModel.foreignKey.association: '_BillingQuantityUnit'
      BillingQuantityUnit,

      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      BillingQuantityInBaseUnit,
      @Semantics.unitOfMeasure: true
      @ObjectModel.foreignKey.association: '_BaseUnit'
      BaseUnit,

      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      MRPRequiredQuantityInBaseUnit,
      BillingToBaseQuantityDnmntr,
      BillingToBaseQuantityNmrtr,

      @Semantics.quantity.unitOfMeasure: 'ItemWeightUnit'
      ItemGrossWeight,

      @Semantics.quantity.unitOfMeasure: 'ItemWeightUnit'
      ItemNetWeight,
      @Semantics.unitOfMeasure: true
      @ObjectModel.foreignKey.association: '_ItemWeightUnit'
      ItemWeightUnit,

      @Semantics.quantity.unitOfMeasure: 'ItemVolumeUnit'
      ItemVolume,
      @Semantics.unitOfMeasure: true
      @ObjectModel.foreignKey.association: '_ItemVolumeUnit'
      ItemVolumeUnit,
      @ObjectModel.foreignKey.association: '_BillToPartyCountry'
      BillToPartyCountry,
      @ObjectModel.foreignKey.association: '_BillToPartyRegion'
      BillToPartyRegion,
      @ObjectModel.foreignKey.association: '_BillingPlanRule'
      BillingPlanRule,
      BillingPlan,
      BillingPlanItem,

      //Pricing


      @Semantics.amount.currencyCode: 'TransactionCurrency'
      NetAmount,
      @Semantics.currencyCode: true
      @ObjectModel.foreignKey.association: '_TransactionCurrency'
      TransactionCurrency,

      @Semantics.amount.currencyCode: 'TransactionCurrency'
      GrossAmount,
      PricingDate,
      PriceDetnExchangeRate,

      @Semantics.quantity.unitOfMeasure: 'BaseUnit' 
      PricingScaleQuantityInBaseUnit,

      @Semantics.amount.currencyCode: 'TransactionCurrency'
      TaxAmount,

      @Semantics.amount.currencyCode: 'TransactionCurrency'
      CostAmount,

      @Semantics.amount.currencyCode: 'TransactionCurrency'
      Subtotal1Amount,

      @Semantics.amount.currencyCode: 'TransactionCurrency'
      Subtotal2Amount,

      @Semantics.amount.currencyCode: 'TransactionCurrency'
      Subtotal3Amount,

      @Semantics.amount.currencyCode: 'TransactionCurrency'
      Subtotal4Amount,

      @Semantics.amount.currencyCode: 'TransactionCurrency'
      Subtotal5Amount,

      @Semantics.amount.currencyCode: 'TransactionCurrency'
      Subtotal6Amount,
      @ObjectModel.foreignKey.association: '_StatisticalValueControl'
      StatisticalValueControl,
      CashDiscountIsDeductible,
      CustomerConditionGroup1,
      CustomerConditionGroup2,
      CustomerConditionGroup3,
      CustomerConditionGroup4,
      CustomerConditionGroup5,
      ManualPriceChangeType,
      @ObjectModel.foreignKey.association: '_MaterialPricingGroup'
      MaterialPricingGroup,
      StatisticsExchangeRate,
      @Consumption.valueHelpDefinition: [ 
        { entity:  { name:    'I_MaterialStdVH',
                     element: 'Material' }
        }]
      @ObjectModel.text.association: '_MainItemPricingRefMatlText'
      @ObjectModel.foreignKey.association: '_MainItemPricingRefMaterial'
      MainItemPricingRefMaterial,
      @ObjectModel.foreignKey.association: '_MainItemMaterialPricingGroup'
      MainItemMaterialPricingGroup,
      @ObjectModel.foreignKey.association: '_TimeSheetOvertimeCat'
      TimeSheetOvertimeCategory,  

      //Tax

      @ObjectModel.foreignKey.association: '_DepartureCountry'
      DepartureCountry,
      TaxJurisdiction,
      ProductTaxClassification1,
      ProductTaxClassification2,
      ProductTaxClassification3,
      ProductTaxClassification4,
      ProductTaxClassification5,
      ProductTaxClassification6,
      ProductTaxClassification7,
      ProductTaxClassification8,
      ProductTaxClassification9,
      ZeroVATRsn,
      TaxCode,
      TaxRateValidityStartDate,

      //Payment


      @Semantics.amount.currencyCode: 'TransactionCurrency'
      EligibleAmountForCashDiscount,

      //Accounting

      @Consumption.valueHelpDefinition: [ 
        { entity:  { name:    'I_BusinessAreaStdVH',
                     element: 'BusinessArea' }
        }]
      @ObjectModel.text.association: '_BusinessAreaText'
      @ObjectModel.foreignKey.association: '_BusinessArea'
      BusinessArea,
      @ObjectModel.foreignKey.association: '_ProfitCenter'      
      ProfitCenter,
      //--[ GENERATED:012:GlBfhyJl7jY4t}SRJ6dMpW

      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_WBSElementStdVH',
                     element: 'WBSElementInternalID' }
        }]
      @ObjectModel.text.association: '_WBSElement'
      // ]--GENERATED

      @ObjectModel.foreignKey.association: '_WBSElement'
      @VDM.lifecycle: { status: #DEPRECATED, successor: 'WBSElementInternalID' }                  
      WBSElementInternalID  as WBSElement,      
      @ObjectModel.foreignKey.association: '_WBSElementBasicData'
      WBSElementInternalID_2  as WBSElementInternalID,      
      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_ControllingAreaStdVH',
                     element: 'ControllingArea' }
        }]      
      @ObjectModel.foreignKey.association: '_ControllingArea'
      ControllingArea, 
      @VDM.lifecycle: { status: #DEPRECATED, successor: 'ProfitabilitySegment_2' }      
      ProfitabilitySegment,                                                  
      ProfitabilitySegment_2, 
      
      OrderID,
      @ObjectModel.foreignKey.association: '_CostCenter_2'      
      CostCenter,
      OriginSDDocument,
      OriginSDDocumentItem,
      PriceDetnExchangeRateDate,

      @ObjectModel.foreignKey.association: '_MatlAccountAssignmentGroup'
      MatlAccountAssignmentGroup,

      //Reference

      ReferenceSDDocument,
      ReferenceSDDocumentItem,
      @ObjectModel.foreignKey.association: '_ReferenceSDDocumentCategory'
      ReferenceSDDocumentCategory,
      @Consumption.valueHelpDefinition: [ 
        { entity:  { name:    'I_SalesDocumentStdVH',
                     element: 'SalesDocument' }
        }]
      @ObjectModel.foreignKey.association: '_SalesDocument'
      SalesDocument,
      @Consumption.valueHelpDefinition: [ 
        { entity:  { name:    'I_SalesDocumentItemStdVH',
                     element: 'SalesDocumentItem' },
          additionalBinding: [{ localElement: 'SalesDocument',
                                element: 'SalesDocument' }]
        }]
      @ObjectModel.foreignKey.association: '_SalesDocumentItem'
      SalesDocumentItem,
      @ObjectModel.foreignKey.association: '_SalesSDDocumentCategory'
      SalesSDDocumentCategory,
      @Consumption.valueHelpDefinition: [ 
        { entity:  { name:    'I_BillingDocumentItemStdVH',
                     element: 'BillingDocumentItem' },
          additionalBinding: [{ localElement: 'BillingDocument',
                                element: 'BillingDocument' }]
        }]
      @ObjectModel.foreignKey.association: '_HigherLevelItem'      
      HigherLevelItem,      
      BillingDocumentItemInPartSgmt,
      ExternalReferenceDocument,
      @VDM.lifecycle: { status: #DEPRECATED, successor: 'BillingDocExtReferenceDocItem' }                  
      ExternalReferenceDocumentItem,
      BillingDocExtReferenceDocItem,     
      @ObjectModel.foreignKey.association: '_PrelimBillingDocument'
      PrelimBillingDocument,
      @ObjectModel.foreignKey.association: '_PrelimBillingDocumentItem'
      PrelimBillingDocumentItem,
      
      //Sales

      @ObjectModel.foreignKey.association: '_SalesGroup'
      SalesGroup,
      @ObjectModel.foreignKey.association: '_AdditionalCustomerGroup1'
      AdditionalCustomerGroup1,
      @ObjectModel.foreignKey.association: '_AdditionalCustomerGroup2'
      AdditionalCustomerGroup2,
      @ObjectModel.foreignKey.association: '_AdditionalCustomerGroup3'
      AdditionalCustomerGroup3,
      @ObjectModel.foreignKey.association: '_AdditionalCustomerGroup4'
      AdditionalCustomerGroup4,
      @ObjectModel.foreignKey.association: '_AdditionalCustomerGroup5'
      AdditionalCustomerGroup5,
      @ObjectModel.foreignKey.association: '_SDDocumentReason'
      SDDocumentReason,
      @Consumption.valueHelpDefinition: [ 
        { entity:  { name:    'I_RetailPromotionStdVH',
                     element: 'RetailPromotion' }
        }]
      @ObjectModel.foreignKey.association: '_RetailPromotion'
      RetailPromotion,

      @Semantics.amount.currencyCode: 'TransactionCurrency'  
      RebateBasisAmount,
      VolumeRebateGroup,
      ItemIsRelevantForCredit,

      @Semantics.amount.currencyCode: 'TransactionCurrency'
      CreditRelatedPrice,
      @Consumption.valueHelpDefinition: [ 
        { entity:  { name:    'I_SalesDealStdVH',
                     element: 'SalesDeal' }
        }]
      @ObjectModel.foreignKey.association: '_SalesDeal'
      SalesDeal,
      SalesPromotion,
      @ObjectModel.foreignKey.association: '_SalesOrderSalesDistrict'
      SalesOrderSalesDistrict,
      @ObjectModel.foreignKey.association: '_SalesOrderCustomerGroup'
      SalesOrderCustomerGroup,
      @ObjectModel.foreignKey.association: '_SalesOrderCustomerPriceGroup'
      SalesOrderCustomerPriceGroup,
      @ObjectModel.foreignKey.association: '_SalesOrderPriceListType'
      SalesOrderPriceListType,
      @ObjectModel.foreignKey.association: '_SalesOrderSalesOrganization'
      SalesOrderSalesOrganization,
      @ObjectModel.foreignKey.association: '_SalesOrderDistributionChannel'
      SalesOrderDistributionChannel,
      SalesDocIsCreatedFromReference,

      //Shipping

      @Consumption.valueHelpDefinition: [ 
        { entity:  { name:    'I_ShippingPointStdVH',
                     element: 'ShippingPoint' }
        }]
      @ObjectModel.text.association: '_ShippingPointText'
      @ObjectModel.foreignKey.association: '_ShippingPoint'
      ShippingPoint,
      
      //CRM

      @ObjectModel.foreignKey.association: '_ServiceDocumentType'
      ServiceDocumentType,
      ServiceDocument,
      ServiceDocumentItem,      
      
      //Solution Order

      @Analytics.internalName: #LOCAL
      @ObjectModel.foreignKey.association: '_SolutionOrder'
      BusinessSolutionOrder,
      @Analytics.internalName: #LOCAL
      @ObjectModel.foreignKey.association: '_SolutionOrderItem'
      BusinessSolutionOrderItem,

      //Other fields

      HigherLevelItemUsage,

      //Added Analytics fields

      @ObjectModel.foreignKey.association: '_SDDocumentCategory'
      SDDocumentCategory,
      @ObjectModel.foreignKey.association: '_BillingDocumentType'
      BillingDocumentType,
      @ObjectModel.foreignKey.association: '_SalesOrganization'
      SalesOrganization,
      @ObjectModel.foreignKey.association: '_DistributionChannel'
      DistributionChannel,
      @ObjectModel.foreignKey.association: '_CustomerPriceGroup'
      CustomerPriceGroup,
      @ObjectModel.foreignKey.association: '_CustomerGroup'
      CustomerGroup,
      @ObjectModel.foreignKey.association: '_Country'
      Country,
      @ObjectModel.foreignKey.association: '_Region'
      Region,
      @ObjectModel.foreignKey.association: '_CityCode'
      CityCode,
      @ObjectModel.foreignKey.association: '_SalesDistrict'
      SalesDistrict,
      @ObjectModel.foreignKey.association: '_OverallSDProcessStatus'
      OverallSDProcessStatus,
      @ObjectModel.foreignKey.association: '_OverallBillingStatus'
      OverallBillingStatus,
      //sales

      //--[ GENERATED:012:GlBfhyFV7jY4{YyEh3zJr0

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

      @ObjectModel.foreignKey.association: '_SoldToParty'
      SoldToParty,
      //payment

      //--[ GENERATED:012:GlBfhyFV7jY4{YyEh3zJr0

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

      @ObjectModel.foreignKey.association: '_PayerParty'
      PayerParty,
      BillingDocumentDate,
      @ObjectModel.foreignKey.association: '_CompanyCode'
      CompanyCode,
      @ObjectModel.foreignKey.association: '_County_2'
      County,
      CustomerRebateAgreement,
      BillingDocumentCategory,
      PricingDocument,
      CancelledBillingDocument,
      BillingDocumentIsTemporary,
      //ship-to

      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_Customer_VH',
                     element: 'Customer' }
        }]

      @ObjectModel.foreignKey.association: '_ShipToParty'
      ShipToParty,
      //bill-to

      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_Customer_VH',
                     element: 'Customer' }
        }]

      @ObjectModel.foreignKey.association: '_BillToParty'
      BillToParty,
      @ObjectModel.foreignKey.association: '_SalesEmployee_2'
      SalesEmployee,
      @ObjectModel.foreignKey.association: '_ResponsibleEmployee_2'
      ResponsibleEmployee, 
      
      //association

      @ObjectModel.association.type: [#TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT]
      _BillingDocument,
      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]      
      _Partner,
      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]      
      _PricingElement,
      _SalesDocumentItemCategory,
      _SalesDocumentItemType,
      _CreatedByUser,
      _ReferenceLogicalSystem,
      _OrganizationDivision,
      _Division,
      _SalesOffice,
      _Material,
      @VDM.lifecycle: { status: #DEPRECATED, successor: '_Product' }      
      _Product,
      _OriginallyRequestedMaterial,
      _PricingReferenceMaterial,
      _Batch,      
      _ProductHierarchyNode,
      @VDM.lifecycle: { status: #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,      
      @VDM.lifecycle: { status: #DEPRECATED, successor: '_WBSElementBasicData' }      
      _WBSElement,
      _WBSElementBasicData,            
      _ControllingArea,
      _MatlAccountAssignmentGroup,      
      @VDM.lifecycle: { status: #DEPRECATED, successor: '_CostCenter_2' }      
      _CostCenter,
      _CostCenter_2,      
      _ReferenceSalesDocumentItem,
      _ReferenceDeliveryDocumentItem,
      _ReferenceBillingDocItemBasic,
      _ReferenceSDDocumentCategory,
      _SalesDocument,
      _SalesDocumentItem,
      _SalesSDDocumentCategory,
      _HigherLevelItem,
      _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,
      @VDM.lifecycle: { status: #DEPRECATED, successor: '_County_2' }  
      _County,
      _County_2,
      _ShipToParty,
      _BillToParty,
      @VDM.lifecycle: { status: #DEPRECATED, successor: '_SalesEmployee_2' }  
      _SalesEmployee,
      _SalesEmployee_2,
      @VDM.lifecycle: { status: #DEPRECATED, successor: '_ResponsibleEmployee_2' }  
      _ResponsibleEmployee,
      _ResponsibleEmployee_2,
      _SolutionOrder,
      _SolutionOrderItem,
      //--[ GENERATED:012:GlBfhyJl7kY4uNsXH4jYtm

      @Consumption.hidden: true
      _BusinessAreaText,
//      @Consumption.hidden: true

//      _WBSElementText,

      @Consumption.hidden: true
      _MaterialGroupText,
      @Consumption.hidden: true
      _ShippingPointText,
      @Consumption.hidden: true
      @VDM.lifecycle: { status: #DEPRECATED, successor: '_ProductText' }      
      _MaterialText,
      @Consumption.hidden: true
      _ProductText,
      @Consumption.hidden: true
      _PricingReferenceMaterialText,      
      @Consumption.hidden: true
      _MainItemPricingRefMatlText,
      @Consumption.hidden: true
      _OriginallyRequestedMatlText
      // ]--GENERATED


}
where
     SDDocumentCategory = 'M' // Invoice

  or SDDocumentCategory = 'N' // Invoice Canceled

  or SDDocumentCategory = 'O' // Credit Memo

  or SDDocumentCategory = 'P' // Debit Memo

  or SDDocumentCategory = 'S' // Credit Memo Canceled

  or SDDocumentCategory = 'U' // Pro Forma Invoice

  or SDDocumentCategory = '5' // Intercompany Invoice

  or SDDocumentCategory = '6' // Intercompany Credit Memo