I_SALESORDERITEM

CDS View

Sales Order Item

I_SALESORDERITEM is a CDS View in S/4HANA. Sales Order Item. It contains 122 fields. 32 CDS views read from this table.

CDS Views using this table (32)

ViewTypeJoinVDMDescription
A_SalesOrderItem view from COMPOSITE Sales Order Item
A_SalesOrderItemSimulation view from COMPOSITE Sales Order Item Simulation (API)
C_BusSolnOrdDelivDteSitn1 view inner CONSUMPTION Trigger CDS view deliv date change
C_MM_SalesOrderItemValueHelp view from CONSUMPTION Sales Order Item Value Help
C_PrecdgSalesOrderItem view from CONSUMPTION
C_Purordmaintainsoivalhelp view from CONSUMPTION Sales Order Item Value Help
C_PurOrdRefDocPC view left_outer CONSUMPTION Reference Documents PO Creation - Purchase Contract Items
C_RFDYSalesOrderItem view from CONSUMPTION Release for Delivery Sales Order Item
C_Salesorderitemfs view from CONSUMPTION Sales Order Item
C_SalesOrderItmWrkflwInbox view from CONSUMPTION Sales Order Workflow Inbox Items
C_SubsqntSalesOrderItem view from CONSUMPTION
I_CustProjSlsOrdItem view from COMPOSITE Sales Order Item for Customer Project
I_EngmntProjFcstCube_2 view left_outer COMPOSITE Forecast Info for Engmnt Project - Cube
I_EntProjProfnlSrvcBillgElmnt view_entity inner COMPOSITE Billing Elements of Projects
I_MM_SalesOrderItemVH view from BASIC Purchasing Sales Order Item Value Help
I_MyProjectBillingElements view inner COMPOSITE Project Billing Elements by UserID
I_ProjectBillingElmntDueDate view_entity inner COMPOSITE Billing Due Date of Billing Element
I_SalesOrderItemImport view from BASIC Sales Order Item for Import
I_SalesOrderItemStdVH view from COMPOSITE Sales Order Item
P_ConvertedSalesQuotation view from COMPOSITE
P_ConvertedSalesQuotationAmt view from COMPOSITE
P_ConvertedSalesQuotations view from COMPOSITE
P_EngmntProjSlsOrdItmDet view left_outer COMPOSITE
P_EngmtProjActlPlnSlsOrd view inner COMPOSITE
P_MyProjectBillingElements2 view_entity inner COMPOSITE Project Billing Elements by UserID (2)
P_PrjBlgElmBllbleRevnAmt view_entity inner COMPOSITE Billable Revenue Amt for Billing Elmnt
P_PrjBlgElmPlndRevnAmt view_entity inner COMPOSITE Planned Revenue Amount for Billing Elmnt
P_ProjBillgElmntSalesDets view_entity from COMPOSITE Project Billing Elements
P_PurOrdMaintainRefDocumentAll view left_outer CONSUMPTION
P_ReleasedSalesContract view from COMPOSITE
P_SalesContractReleasedAmount view from CONSUMPTION Sales Contract Released Amount
R_SalesOrderItemTP view_entity from TRANSACTIONAL Sales Order Item - TP

Fields (122)

KeyField CDS FieldsUsed in Views
KEY BillingPlan BillingPlan 4
KEY SalesOrder SalesOrder 11
KEY SalesOrderItem SalesOrderItem 11
KEY WBSElementInternalID BillingWBSElementInternalID,WBSElementInternalID 5
_BillingBlockStatus _BillingBlockStatus 1
_BusinessArea _BusinessArea 1
_ChmlCmplncStatus _ChmlCmplncStatus 1
_CustomerGroup _CustomerGroup 1
_CustomerPaymentTerms _CustomerPaymentTerms 1
_CustomerPriceGroup _CustomerPriceGroup 1
_DangerousGoodsStatus _DangerousGoodsStatus 1
_DeliveryBlockStatus _DeliveryBlockStatus 1
_DeliveryDateTypeRule _DeliveryDateTypeRule 1
_DeliveryPriority _DeliveryPriority 1
_DeliveryStatus _DeliveryStatus 1
_HigherLevelItem _HigherLevelItem 1
_IncotermsClassification _IncotermsClassification 1
_IncotermsVersion _IncotermsVersion 1
_ItemBillingBlockReason _ItemBillingBlockReason 2
_ItemCategory _ItemCategory 1
_ItemDownPaymentStatus _ItemDownPaymentStatus 1
_ItemGeneralIncompletionStatus _ItemGeneralIncompletionStatus 1
_ItemVolumeUnit _ItemVolumeUnit 1
_ItemWeightUnit _ItemWeightUnit 1
_MatlAccountAssignmentGroup _MatlAccountAssignmentGroup 1
_OrderQuantityUnit _OrderQuantityUnit 1
_OrderRelatedBillingStatus _OrderRelatedBillingStatus 1
_OvrlTrdCmplncLegalCtrlChkSts _OvrlTrdCmplncLegalCtrlChkSts 1
_PartialDeliveryItem _PartialDeliveryItem 1
_Plant _Plant 1
_Product _Product 1
_ProductGroup _ProductGroup 1
_ProfitCenter _ProfitCenter 1
_RequestedQuantityUnit _RequestedQuantityUnit 1
_Route _Route 1
_SafetyDataSheetStatus _SafetyDataSheetStatus 1
_SalesDocumentRjcnReason _SalesDocumentRjcnReason 2
_SalesOrder _SalesOrder 1
_SDDocumentRejectionStatus _SDDocumentRejectionStatus 2
_SDProcessStatus _SDProcessStatus 4
_ShippingPoint _ShippingPoint 1
_ShippingType _ShippingType 1
_StorageLocation _StorageLocation 1
_TransactionCurrency _TransactionCurrency 3
_TrdCmplncEmbargoSts _TrdCmplncEmbargoSts 1
_TrdCmplncSnctndListChkSts _TrdCmplncSnctndListChkSts 1
_WBSElementBasicData_2 _WBSElementBasicData_2 1
Batch Batch 1
BillingBlockStatus BillingBlockStatus 2
BillingDocumentDate BillingDocumentDate 1
BusinessArea BusinessArea 1
CappedNetAmount CappedNetAmount 2
CappedNetAmtAlertThldInPct CappedNetAmtAlertThldInPct 1
ChmlCmplncStatus ChmlCmplncStatus 1
ConfdDelivQtyInOrderQtyUnit ConfdDelivQtyInOrderQtyUnit 1
ControllingArea ControllingArea 1
CreatedByUser CreatedByUser,SalesOrderCreatedByUser 2
CustomerGroup CustomerGroup 1
CustomerPaymentTerms CustomerPaymentTerms 1
CustomerPriceGroup CustomerPriceGroup 1
DangerousGoodsStatus DangerousGoodsStatus 1
DeliveryBlockStatus DeliveryBlockStatus 1
DeliveryDateQuantityIsFixed DeliveryDateQuantityIsFixed 1
DeliveryDateTypeRule DeliveryDateTypeRule 1
DeliveryGroup DeliveryGroup 1
DeliveryPriority DeliveryPriority 1
DeliveryStatus DeliveryStatus 2
Division Division 1
FiscalPeriod FiscalPeriod 1
FiscalYear FiscalYear 1
FixedValueDate FixedValueDate 1
HigherLevelItem HigherLevelItem 1
IncotermsClassification IncotermsClassification 1
IncotermsLocation1 IncotermsLocation1 1
IncotermsLocation2 IncotermsLocation2 1
IncotermsVersion IncotermsVersion 1
InternationalArticleNumber InternationalArticleNumber 1
ItemBillingBlockReason BillingBlockReason,ItemBillingBlockReason 3
ItemGeneralIncompletionStatus ItemGeneralIncompletionStatus 1
ItemGrossWeight ItemGrossWeight 1
ItemNetWeight ItemNetWeight 1
ItemVolume ItemVolume 1
ItemVolumeUnit ItemVolumeUnit 1
ItemWeightUnit ItemWeightUnit 1
Material EngagementProjectResource,Material 2
MaterialByCustomer MaterialByCustomer 2
MatlAccountAssignmentGroup MatlAccountAssignmentGroup 1
MaxNmbrOfPartialDelivery MaxNmbrOfPartialDelivery 1
NetAmount NetAmount,RevenueAsSoldAmount 5
OrderCombinationIsAllowed OrderCombinationIsAllowed 1
OrderQuantityUnit OrderQuantityUnit 1
OrderRelatedBillingStatus OrderRelatedBillingStatus 1
OvrlTrdCmplncLegalCtrlChkSts OvrlTrdCmplncLegalCtrlChkSts 1
PartialDeliveryIsAllowed PartialDeliveryIsAllowed 1
Plant Plant,ProductionPlant 3
PricingDate PricingDate 1
Product Product 2
ProductConfiguration ProductConfiguration 1
ProductGroup ProductGroup 1
ProfitCenter ProfitCenter 1
PurchaseOrderByCustomer PurchaseOrderByCustomer 2
ReceivingPoint ReceivingPoint 1
RequestedQuantity RequestedQuantity 3
RequestedQuantityUnit RequestedQuantityUnit 3
Route Route 1
SafetyDataSheetStatus SafetyDataSheetStatus 1
SalesDocumentRjcnReason SalesDocumentRjcnReason 2
SalesOrderItemCategory SalesOrderItemCategory 2
SalesOrderItemText SalesOrderItemText,WBSElementDescription 7
SDDocumentRejectionStatus SDDocumentRejectionStatus 2
SDProcessStatus SDProcessStatus 4
ServicesRenderedDate ServicesRenderedDate 1
ShippingPoint ShippingPoint 1
ShippingType ShippingType 1
SlsOrderItemDownPaymentStatus SlsOrderItemDownPaymentStatus 1
StorageLocation StorageLocation 1
TaxAmount TaxAmount 1
TransactionCurrency SalesDocumentCurrency,TransactionCurrency 10
TrdCmplncEmbargoSts TrdCmplncEmbargoSts 1
TrdCmplncSnctndListChkSts TrdCmplncSnctndListChkSts 1
UnderlyingPurchaseOrderItem UnderlyingPurchaseOrderItem 1
WBSElement WBSElement 1
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Sales Order Item'
@VDM: {
  viewType: #BASIC,  
  lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #('TRANSACTIONAL_DATA'),
  privilegedAssociations: [ '_CreatedByUser', '_BusinessAreaText','_MaterialText','_ProductText','_OrigMaterialText','_ShippingPointText' ]
}
@AbapCatalog: {
  sqlViewName:            'ISDSLSORDERITEM',
  preserveKey: true,
  compiler.compareFilter: true
}
@ObjectModel: {
  representativeKey: 'SalesOrderItem',
  usageType: {
    dataClass:      #TRANSACTIONAL,
    serviceQuality: #B,
    sizeCategory:   #XL
  },
  supportedCapabilities: [ #ANALYTICAL_DIMENSION, #CDS_MODELING_ASSOCIATION_TARGET, #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #EXTRACTION_DATA_SOURCE ],
  modelingPattern: [ #ANALYTICAL_DIMENSION ]
}
@Metadata.ignorePropagatedAnnotations: true
@Analytics.dataCategory: #DIMENSION
@Metadata.allowExtensions: true
@ObjectModel.sapObjectNodeType.name: 'SalesOrderItem'  

@Analytics: {
    dataExtraction: {
        enabled: true,
        delta.changeDataCapture: {
            mapping:[
                {
                    table: 'vbap', role: #MAIN,
                    viewElement: ['SalesOrder', 'SalesOrderItem'],
                    tableElement: ['vbeln', 'posnr']
                },
                {
                    table: 'vbak', role: #LEFT_OUTER_TO_ONE_JOIN,
                    viewElement: ['SalesOrder'],
                    tableElement: ['vbeln']},
                {
                    table: 'vbkd', role: #LEFT_OUTER_TO_ONE_JOIN,
                    viewElement: ['SalesOrder', 'SalesOrderItem'],
                    tableElement: ['vbeln', 'posnr']
                },   
                {
                    table: 'veda', role: #LEFT_OUTER_TO_ONE_JOIN,
                    viewElement: ['SalesOrder', 'SalesOrderItem'],
                    tableElement: ['vbeln', 'vposn']
                }       
            ]
        }
    }
 }

define view I_SalesOrderItem
  as select from I_SalesDocumentItem as SalesDocumentItem


  //--[ GENERATED:012:GFBfhxvv7jY4otz}RhcFP0

  association [0..*] to I_BusinessAreaText             as _BusinessAreaText  on  $projection.BusinessArea = _BusinessAreaText.BusinessArea
  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 _OrigMaterialText  on  $projection.OriginallyRequestedMaterial = _OrigMaterialText.Material
  association [0..*] to I_ShippingPointText            as _ShippingPointText on  $projection.ShippingPoint = _ShippingPointText.ShippingPoint
  // ]--GENERATED

  association [1..1] to I_SalesOrder                   as _SalesOrder        on  $projection.SalesOrder = _SalesOrder.SalesOrder
  association [0..*] to I_SalesOrderScheduleLine       as _ScheduleLine      on  $projection.SalesOrder     = _ScheduleLine.SalesOrder
                                                                             and $projection.SalesOrderItem = _ScheduleLine.SalesOrderItem
  association [0..*] to I_SalesOrderItemPartner        as _Partner           on  $projection.SalesOrder     = _Partner.SalesOrder
                                                                             and $projection.SalesOrderItem = _Partner.SalesOrderItem
  association [0..*] to I_SalesOrderItemPricingElement as _PricingElement    on  $projection.SalesOrder     = _PricingElement.SalesOrder
                                                                             and $projection.SalesOrderItem = _PricingElement.SalesOrderItem
  association [0..1] to I_SalesOrderItem               as _HigherLevelItem   on  $projection.SalesOrder      = _HigherLevelItem.SalesOrder
                                                                             and $projection.HigherLevelItem = _HigherLevelItem.SalesOrderItem
  association [0..1] to I_SalesOrderItemBillingPlan    as _ItemBillingPlan   on  $projection.SalesOrder     = _ItemBillingPlan.SalesOrder
                                                                             and $projection.SalesOrderItem = _ItemBillingPlan.SalesOrderItem 
                                                                             and $projection.BillingPlan    = _ItemBillingPlan.BillingPlan 
    
  association [0..*] to I_SalesOrderItmPrecdgProcFlow     as _PrecedingProcFlowDocItem  on  _PrecedingProcFlowDocItem.SalesOrder     = $projection.SalesOrder
                                                                                        and _PrecedingProcFlowDocItem.SalesOrderItem = $projection.SalesOrderItem
                                                                                          
   
  association [0..*] to I_SalesOrderItmSubsqntProcFlow    as _SubsequentProcFlowDocItem on  _SubsequentProcFlowDocItem.SalesOrder     = $projection.SalesOrder
                                                                                        and _SubsequentProcFlowDocItem.SalesOrderItem = $projection.SalesOrderItem
                                                                                                                                                                                                                                     
                                                                             
  //Extensibility

  association [0..1] to E_SalesDocumentItemBasic       as _Extension         on  SalesDocumentItem.SalesDocument     = _Extension.SalesDocument
                                                                             and SalesDocumentItem.SalesDocumentItem = _Extension.SalesDocumentItem

{
      //Key

      @ObjectModel.foreignKey.association: '_SalesOrder'
  key cast(SalesDocument as vdm_sales_order preserving type)      as SalesOrder,
      @ObjectModel.text.element: 'SalesOrderItemText'
  key cast(SalesDocumentItem as sales_order_item preserving type) as SalesOrderItem,
      SalesDocumentItemUUID                                       as SalesOrderItemUUID,

      // Category

      @ObjectModel.foreignKey.association: '_ItemCategory'
      SalesDocumentItemCategory                                   as SalesOrderItemCategory,
      SalesDocumentItemType                                       as SalesOrderItemType,
      IsReturnsItem,

      //Admin

      CreatedByUser,
      @Semantics.systemDate.createdAt: true
      CreationDate,
      CreationTime,
      @Semantics.systemDate.lastChangedAt: true
      LastChangeDate,

      //Org

      @ObjectModel.foreignKey.association: '_Division'
      Division,

      //Product

      //--[ GENERATED:012:GFBfhxvv7jY4otz}RhcFP0

      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_MaterialStdVH',
                     element: 'Material' }
        }]
      @ObjectModel.text.association: '_MaterialText'
      // ]--GENERATED

      @ObjectModel.foreignKey.association: '_Material'
      @VDM.lifecycle.status: #DEPRECATED
      @VDM.lifecycle.successor: 'Product'
      @API.element.releaseState: #DEPRECATED
      @API.element.successor: 'Product'
      Material,
      //--[ GENERATED:012:GFBfhxvv7jY4otz}RhcFP0


      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_ProductStdVH',
                     element: 'Product' }
        }]
      @ObjectModel.text.association: '_ProductText'
      @Analytics.internalName: #LOCAL
      @ObjectModel.foreignKey.association: '_Product'
      Product,

      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_ProductStdVH',
                     element: 'Product' }
        }]
      @ObjectModel.text.association: '_OrigMaterialText'
      // ]--GENERATED

      @ObjectModel.foreignKey.association: '_OriginallyRequestedMaterial'
      OriginallyRequestedMaterial,
      MaterialByCustomer,
      InternationalArticleNumber,
      //--[ GENERATED:012:GFBfhxvv7jY4otz}RhcFP0

      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_BatchStdVH',
                     element: 'Batch' },
          additionalBinding: [{ localElement: 'Plant',
                                element: 'Plant' },
                              { localElement: 'Material',
                                element: 'Material' }]
        }]
      // ]--GENERATED

      @ObjectModel.foreignKey.association: '_Batch'
      Batch,
      @ObjectModel.foreignKey.association: '_ProductHierarchyNode'
      ProductHierarchyNode,
      ProductCatalog,
      @ObjectModel.foreignKey.association: '_MaterialSubstitutionReason'
      MaterialSubstitutionReason,
      @ObjectModel.foreignKey.association: '_MaterialGroup'
      @VDM.lifecycle.status: #DEPRECATED
      @VDM.lifecycle.successor: 'ProductGroup'
      MaterialGroup,
      @ObjectModel.foreignKey.association: '_ProductGroup'
      @Analytics.internalName: #LOCAL
      ProductGroup,
      @ObjectModel.foreignKey.association: '_MaterialPricingGroup'
      MaterialPricingGroup,
      @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,
      @ObjectModel.foreignKey.association: '_Plant'
      Plant,      
      @ObjectModel.foreignKey.association: '_OriginalPlant'
      OriginalPlant,
      @ObjectModel.foreignKey.association: '_StorageLocation'
      StorageLocation,
      DeliveryGroup,
      ProductConfiguration,
      BOMExplosionDate,

      //Sales

      @Semantics.text: true
      SalesDocumentItemText                                       as SalesOrderItemText,
      PurchaseOrderByCustomer,
      PurchaseOrderByShipToParty,
      @Analytics.internalName: #LOCAL
      CustomerPurchaseOrderDate,
      UnderlyingPurchaseOrderItem,
      ExternalItemID,
      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
      OrderQuantity,
      @Semantics.unitOfMeasure: true
      @ObjectModel.foreignKey.association: '_OrderQuantityUnit'
      OrderQuantityUnit,
      OrderToBaseQuantityDnmntr,
      OrderToBaseQuantityNmrtr,
      @Semantics.quantity.unitOfMeasure: 'TargetQuantityUnit'
      TargetQuantity,
      @Semantics.unitOfMeasure: true
      @ObjectModel.foreignKey.association: '_TargetQuantityUnit'
      TargetQuantityUnit,
      TargetToBaseQuantityDnmntr,
      TargetToBaseQuantityNmrtr,
      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
      ConfdDelivQtyInOrderQtyUnit,
      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
      TargetDelivQtyInOrderQtyUnit,
      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      ConfdDeliveryQtyInBaseUnit,
      @Semantics.unitOfMeasure: true
      @ObjectModel.foreignKey.association: '_BaseUnit'
      BaseUnit,
      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
      CommittedDelivQtyInOrdQtyUnit,
      CommittedDelivCreationDate,
      CommittedDeliveryDate,
      @Semantics.quantity.unitOfMeasure: 'RequestedQuantityUnit'
      RequestedQuantity,
      @Semantics.unitOfMeasure: true
      @ObjectModel.foreignKey.association: '_RequestedQuantityUnit'
      RequestedQuantityUnit,
      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      RequestedQuantityInBaseUnit,

      @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,

      ServicesRenderedDate,
      @ObjectModel.foreignKey.association: '_SalesDistrict'
      SalesDistrict,
      //--[ GENERATED:012:GFBfhxvv7jY4otz}RhcFP0

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

      @ObjectModel.foreignKey.association: '_SalesDeal'
      SalesDeal,
      SalesPromotion,
      RetailPromotion,
      @ObjectModel.foreignKey.association: '_CustomerGroup'
      CustomerGroup,
      @ObjectModel.foreignKey.association: '_SalesDocumentRjcnReason'
      SalesDocumentRjcnReason,
      RequirementSegment,

      SlsDocIsRlvtForProofOfDeliv,

      // Pricing

      @DefaultAggregation: #SUM
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      NetAmount,
      @Semantics.currencyCode: true
      @ObjectModel.foreignKey.association: '_TransactionCurrency'
      TransactionCurrency,
      PricingDate,
      PricingReferenceMaterial,
      ExchangeRateDate,
      PriceDetnExchangeRate,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      NetPriceAmount,
      @Semantics.quantity.unitOfMeasure: 'NetPriceQuantityUnit'
      NetPriceQuantity,
      @Semantics.unitOfMeasure: true
      @ObjectModel.foreignKey.association: '_NetPriceQuantityUnit'
      NetPriceQuantityUnit,

      @ObjectModel.foreignKey.association: '_StatisticalValueControl'
      StatisticalValueControl,
      
      SalesDocumentItemProcgCode,

      @Semantics.amount.currencyCode: 'TransactionCurrency'
      TaxAmount,
      ProductTaxClassification1,
      ProductTaxClassification2,
      ProductTaxClassification3,
      ProductTaxClassification4,
      ProductTaxClassification5,
      ProductTaxClassification6,
      ProductTaxClassification7,
      ProductTaxClassification8,
      ProductTaxClassification9,
      @Analytics.internalName: #LOCAL
      @ObjectModel.foreignKey.association: '_MatlAccountAssignmentGroup'
      MatlAccountAssignmentGroup,
      @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,
      SalesDocumentCondition                                      as SalesOrderCondition,
      @Analytics.internalName: #LOCAL
      @ObjectModel.foreignKey.association: '_CustomerPriceGroup'
      CustomerPriceGroup,

      //Shipping

      //--[ GENERATED:012:GFBfhxvv7jY4otz}RhcFP0

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

      @ObjectModel.foreignKey.association: '_ShippingPoint'
      ShippingPoint,
      @ObjectModel.foreignKey.association: '_ShippingType'
      ShippingType,
      InventorySpecialStockType,
      @ObjectModel.foreignKey.association: '_DeliveryPriority'
      DeliveryPriority,
      @ObjectModel.foreignKey.association: '_Route'
      Route,
      DeliveryDateQuantityIsFixed,
      DeliveryDateTypeRule,
      @Analytics.internalName: #LOCAL
      @ObjectModel.foreignKey.association: '_PartialDeliveryItem'
      PartialDeliveryIsAllowed,
      MaxNmbrOfPartialDelivery,
      UnlimitedOverdeliveryIsAllowed,
      OverdelivTolrtdLmtRatioInPct,
      UnderdelivTolrtdLmtRatioInPct,
      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      MinDeliveryQtyInBaseUnit,
      OpenDeliveryLeadingUnitCode,
      ItemIsDeliveryRelevant,
      ReceivingPoint,
      
      //Incoterms

      @ObjectModel.foreignKey.association: '_IncotermsVersion'
      IncotermsVersion,
      @ObjectModel.foreignKey.association: '_IncotermsClassification'
      IncotermsClassification,
      IncotermsTransferLocation,
      IncotermsLocation1,
      IncotermsLocation2,
      SalesDocumentItem.OrderCombinationIsAllowed,

      //Payment

      @ObjectModel.foreignKey.association: '_CustomerPaymentTerms'
      CustomerPaymentTerms,
      PaymentMethod,
      FixedValueDate,
      AdditionalValueDays,

      //Fashion

      ProductSeasonYear,
      ProductSeason,
      ProductCollection,
      ProductTheme,
      FashionCancelDate,
      ProductCharacteristic1,
      ProductCharacteristic2,
      ProductCharacteristic3,
      ShippingGroupNumber,
      ShippingGroupRule,

      //Billing

      BillingDocumentDate,
      @ObjectModel.foreignKey.association: '_ItemIsBillingRelevant'
      ItemIsBillingRelevant,
      @ObjectModel.foreignKey.association: '_ItemBillingBlockReason'
      ItemBillingBlockReason,
      BillingPlan,

      //Accounting

      FiscalYear,
      FiscalPeriod,
      @ObjectModel.foreignKey.association: '_CustomerAccountAssgmtGroup'
      CustomerAccountAssignmentGroup,
      //--[ GENERATED:012:GFBfhxvv7jY4otz}RhcFP0

      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_BusinessAreaStdVH',
                     element: 'BusinessArea' }
        }]
      @ObjectModel.text.association: '_BusinessAreaText'
      // ]--GENERATED

      @ObjectModel.foreignKey.association: '_BusinessArea'
      BusinessArea,
      @Analytics.internalName: #LOCAL
      ControllingArea,
      @Analytics.internalName: #LOCAL
      ProfitCenter,
      @Analytics.internalName: #LOCAL
      @ObjectModel.foreignKey.association: '_WBSElementBasicData'
      @API.element.releaseState: #DEPRECATED
      @API.element.successor: 'WBSElementInternalID'
      WBSElement,
      @Analytics.internalName: #LOCAL
      @ObjectModel.foreignKey.association: '_WBSElementBasicData_2'
      WBSElementInternalID,
      OrderID,
      ControllingObject,
      @API.element.releaseState: #DECOMMISSIONED
      @API.element.successor: 'ProfitabilitySegment_2'
      ProfitabilitySegment,
      ProfitabilitySegment_2,
      OriginSDDocument,
      OriginSDDocumentItem,
      AccountingExchangeRate,
      ContractAccount,

      //Reference

      @ObjectModel.foreignKey.association: '_ReferenceSDDocument'
      ReferenceSDDocument,
      @ObjectModel.foreignKey.association: '_ReferenceSDDocumentItem'
      ReferenceSDDocumentItem,
      @ObjectModel.foreignKey.association: '_ReferenceSDDocumentCategory'
      ReferenceSDDocumentCategory,
      @ObjectModel.foreignKey.association: '_HigherLevelItem'
      @Analytics.internalName: #LOCAL
      HigherLevelItem,
      HigherLevelItemUsage,

      //Status

      @ObjectModel.foreignKey.association: '_SDProcessStatus'
      SDProcessStatus,
      @ObjectModel.foreignKey.association: '_DeliveryConfirmationStatus'
      DeliveryConfirmationStatus,
      @ObjectModel.foreignKey.association: '_PurchaseConfirmationStatus'
      PurchaseConfirmationStatus,
      @ObjectModel.foreignKey.association: '_TotalDeliveryStatus'
      TotalDeliveryStatus,
      @ObjectModel.foreignKey.association: '_DeliveryStatus'
      DeliveryStatus,
      @ObjectModel.foreignKey.association: '_DeliveryBlockStatus'
      DeliveryBlockStatus,
      @ObjectModel.foreignKey.association: '_OrderRelatedBillingStatus'
      OrderRelatedBillingStatus,
      @ObjectModel.foreignKey.association: '_BillingBlockStatus'
      BillingBlockStatus,
      @ObjectModel.foreignKey.association: '_ItemGeneralIncompletionStatus'
      ItemGeneralIncompletionStatus,
      @ObjectModel.foreignKey.association: '_ItemBillingIncompletionStatus'
      ItemBillingIncompletionStatus,
      @ObjectModel.foreignKey.association: '_PricingIncompletionStatus'
      PricingIncompletionStatus,
      @ObjectModel.foreignKey.association: '_ItemDelivIncompletionSts'
      ItemDeliveryIncompletionStatus,
      @ObjectModel.foreignKey.association: '_SDDocReferenceStatus'
      SDDocReferenceStatus,
      @ObjectModel.foreignKey.association: '_SDDocumentRejectionStatus'
      SDDocumentRejectionStatus,
      @ObjectModel.foreignKey.association: '_TotalSDDocReferenceStatus'
      TotalSDDocReferenceStatus,
      @ObjectModel.foreignKey.association: '_ChmlCmplncStatus'
      ChmlCmplncStatus,
      @ObjectModel.foreignKey.association: '_DangerousGoodsStatus'
      DangerousGoodsStatus,
      @ObjectModel.foreignKey.association: '_SafetyDataSheetStatus'
      SafetyDataSheetStatus,
      @ObjectModel.foreignKey.association: '_ItemDownPaymentStatus'
      ContractItemDownPaymentStatus         as SlsOrderItemDownPaymentStatus,
      @ObjectModel.foreignKey.association: '_TrdCmplncEmbargoSts'
      TrdCmplncEmbargoSts,
      @ObjectModel.foreignKey.association: '_TrdCmplncSnctndListChkSts'
      TrdCmplncSnctndListChkSts,
      @ObjectModel.foreignKey.association: '_OvrlTrdCmplncLegalCtrlChkSts'            
      OvrlTrdCmplncLegalCtrlChkSts,
      @ObjectModel.foreignKey.association: '_AltvBsdConfSubstitutionSts'
      AltvBsdConfSubstitutionStatus,
      
      OmniChannelSalesPromotion, 
      OmniChannelSalesPromotionRule,
      
      @ObjectModel.foreignKey.association: '_ConsumptionPosting'
      ConsumptionPosting,

      //PBS

      @Semantics.amount.currencyCode: 'TransactionCurrency'
      CappedNetAmount,
      CappedNetAmtAlertThldInPct,
      //this field is relevant only for PBS scenario

      @Semantics.amount.currencyCode: 'TransactionCurrency'
      SalesDocumentItem.TotalStandAloneSellingPrice,

      //Association

      @ObjectModel.association.type: [#TO_COMPOSITION_PARENT,
                                      #TO_COMPOSITION_ROOT]
      _SalesOrder,
      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
      _ScheduleLine,
      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
      _Partner,
      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
      _PricingElement,
      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
      _ItemBillingPlan,
      _ItemCategory,
      _CreatedByUser,
      _Division,
      _Material,
      _Product,
      _OriginallyRequestedMaterial,
      _MaterialPlant,
      _Batch,
      _ProductHierarchyNode,
      _MaterialSubstitutionReason,
      _MaterialGroup,
      _ProductGroup,
      _MaterialPricingGroup,
      _AdditionalMaterialGroup1,
      _AdditionalMaterialGroup2,
      _AdditionalMaterialGroup3,
      _AdditionalMaterialGroup4,
      _AdditionalMaterialGroup5,
      _MatlAccountAssignmentGroup,
      _Plant,
      _OriginalPlant,
      _StorageLocation,
      _OrderQuantityUnit,
      _BaseUnit,
      _TargetQuantityUnit,
      _RequestedQuantityUnit,
      _ItemWeightUnit,
      _ItemVolumeUnit,
      _SalesDistrict,
      _SalesDeal,
      _CustomerGroup,
      _CustomerPriceGroup,
      _SalesDocumentRjcnReason,
      _TransactionCurrency,
      _NetPriceQuantityUnit,
      _StatisticalValueControl,
      _ShippingPoint,
      _ShippingType,
      _DeliveryPriority,
      _DeliveryDateTypeRule,
      _PartialDeliveryItem,
      _Route,
      _IncotermsClassification,
      _IncotermsVersion,
      _ItemIsBillingRelevant,
      _ItemBillingBlockReason,
      _CustomerPaymentTerms,
      //PaymentMethod,

      _CustomerAccountAssgmtGroup,
      _BusinessArea,
      @Consumption.filter.businessDate.at: true
      _ProfitCenter,
      
      @VDM.lifecycle.status: #DEPRECATED
      @VDM.lifecycle.successor: '_WBSElementBasicData_2'   
      @API.element.releaseState: #DEPRECATED
      @API.element.successor: '_WBSElementBasicData_2'
      _WBSElementBasicData,
      _WBSElementBasicData_2,
      _ReferenceSDDocument,
      _ReferenceSDDocumentItem,
      _ReferenceSDDocumentCategory,
      _HigherLevelItem,
      _SDProcessStatus,
      _DeliveryConfirmationStatus,
      _PurchaseConfirmationStatus,
      _TotalDeliveryStatus,
      _DeliveryStatus,
      _DeliveryBlockStatus,
      _ContractItemDownPaymentStatus                 as _ItemDownPaymentStatus,
      _OrderRelatedBillingStatus,
      _BillingBlockStatus,
      _ItemGeneralIncompletionStatus,
      _ItemBillingIncompletionStatus,
      _PricingIncompletionStatus,
      _ItemDelivIncompletionSts,
      _SDDocReferenceStatus,
      _SDDocumentRejectionStatus,
      _TotalSDDocReferenceStatus,
      _ChmlCmplncStatus,
      _DangerousGoodsStatus,
      _SafetyDataSheetStatus,
      _OvrlTrdCmplncLegalCtrlChkSts,
      _AltvBsdConfSubstitutionSts,                                                  
      _TrdCmplncSnctndListChkSts,
      _TrdCmplncEmbargoSts,
      
      @VDM.lifecycle.status: #DEPRECATED
      @VDM.lifecycle.successor: '_ItemBillingPlan'       
      @API.element.releaseState: #DEPRECATED
      @API.element.successor: '_ItemBillingPlan'
      _BillingPlan,
      _PrecedingProcFlowDocItem,
      _SubsequentProcFlowDocItem,
      
      
      _ConsumptionPosting,
      //--[ GENERATED:012:GFBfhxvv7jY4otz}RhcFP0

      @Consumption.hidden: true
      _BusinessAreaText,
      @Consumption.hidden: true
      _MaterialText,
      @Consumption.hidden: true
      _ProductText,
      @Consumption.hidden: true
      _OrigMaterialText,
      @Consumption.hidden: true
      _ShippingPointText
      // ]--GENERATED


}
where
  SalesDocumentItem.SDDocumentCategory = 'C';
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SALESDOCUMENTITEM"
],
"ASSOCIATED":
[
"E_SALESDOCUMENTITEMBASIC",
"I_ADDITIONALMATERIALGROUP1",
"I_ADDITIONALMATERIALGROUP2",
"I_ADDITIONALMATERIALGROUP3",
"I_ADDITIONALMATERIALGROUP4",
"I_ADDITIONALMATERIALGROUP5",
"I_ALTVBSDCONFSUBSTITUTIONSTS",
"I_BATCH",
"I_BILLINGBLOCKREASON",
"I_BILLINGBLOCKSTATUS",
"I_BILLINGRELEVANCECODE",
"I_BUSINESSAREA",
"I_BUSINESSAREATEXT",
"I_CHMLCMPLNCSTATUS",
"I_CONSUMPTIONPOSTING",
"I_CONTRACTDOWNPAYMENTSTATUS",
"I_CURRENCY",
"I_CUSTOMERACCOUNTASSGMTGROUP",
"I_CUSTOMERGROUP",
"I_CUSTOMERPAYMENTTERMS",
"I_CUSTOMERPRICEGROUP",
"I_DANGEROUSGOODSSTATUS",
"I_DELIVERYBLOCKSTATUS",
"I_DELIVERYCONFIRMATIONSTATUS",
"I_DELIVERYDATETYPERULE",
"I_DELIVERYPRIORITY",
"I_DELIVERYSTATUS",
"I_DIVISION",
"I_INCOTERMSCLASSIFICATION",
"I_INCOTERMSVERSION",
"I_ITEMBILLINGINCOMPLETIONSTS",
"I_ITEMDELIVINCOMPLETIONSTS",
"I_ITEMGENINCOMPLETIONSTATUS",
"I_MATERIAL",
"I_MATERIALGROUP",
"I_MATERIALPLANT",
"I_MATERIALPRICINGGROUP",
"I_MATERIALSUBSTITUTIONREASON",
"I_MATERIALTEXT",
"I_MATLACCOUNTASSIGNMENTGROUP",
"I_ORDERRELATEDBILLINGSTATUS",
"I_OVRLTRDCMPLNCLEGALCTRLCHKSTS",
"I_PARTIALDELIVERYITEM",
"I_PLANT",
"I_PRICINGINCOMPLETIONSTATUS",
"I_PRODUCT",
"I_PRODUCTGROUP_2",
"I_PRODUCTHIERARCHYNODE",
"I_PRODUCTTEXT",
"I_PROFITCENTER",
"I_PURCHASECONFIRMATIONSTATUS",
"I_ROUTE",
"I_SAFETYDATASHEETSTATUS",
"I_SALESDEAL",
"I_SALESDISTRICT",
"I_SALESDOCUMENT",
"I_SALESDOCUMENTITEM",
"I_SALESDOCUMENTITEMCATEGORY",
"I_SALESDOCUMENTRJCNREASON",
"I_SALESORDER",
"I_SALESORDERITEMBILLINGPLAN",
"I_SALESORDERITEMPARTNER",
"I_SALESORDERITEMPRICINGELEMENT",
"I_SALESORDERITMPRECDGPROCFLOW",
"I_SALESORDERITMSUBSQNTPROCFLOW",
"I_SALESORDERSCHEDULELINE",
"I_SDDOCREFERENCESTATUS",
"I_SDDOCUMENTCATEGORY",
"I_SDDOCUMENTREJECTIONSTATUS",
"I_SDPROCESSSTATUS",
"I_SHIPPINGPOINT",
"I_SHIPPINGPOINTTEXT",
"I_SHIPPINGTYPE",
"I_SLSDOCITEMBILLINGPLAN",
"I_STATISTICALVALUECONTROL",
"I_STORAGELOCATION",
"I_TOTALDELIVERYSTATUS",
"I_TOTALSDDOCREFERENCESTATUS",
"I_TRDCMPLNCCHECKSTATUS",
"I_UNITOFMEASURE",
"I_USER",
"I_WBSELEMENTBASICDATA"
],
"BASE":
[
"I_SALESDOCUMENTITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/