I_SalesOrder

DDL: I_SALESORDER Type: view BASIC

Sales Order

I_SalesOrder is a Basic CDS View (Dimension) that provides data about "Sales Order" in SAP S/4HANA. It reads from 1 data source (I_SalesDocument) and exposes 236 fields with key field SalesOrder. It has 12 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_SalesDocument SalesDocument from

Associations (12)

CardinalityTargetAliasCondition
[0..*] I_BusinessAreaText _BusinessAreaText $projection.BusinessArea = _BusinessAreaText.BusinessArea
[0..*] I_BusinessAreaText _CostCenterBusinessAreaText $projection.CostCenterBusinessArea = _CostCenterBusinessAreaText.BusinessArea
[0..*] I_CreditControlAreaText _CreditControlAreaText $projection.CreditControlArea = _CreditControlAreaText.CreditControlArea
[0..*] I_SalesOrderItem _Item $projection.SalesOrder = _Item.SalesOrder
[0..1] I_SalesOrderType _SalesOrderType $projection.SalesOrderType = _SalesOrderType.SalesOrderType
[1..*] I_SalesOrderPartner _Partner $projection.SalesOrder = _Partner.SalesOrder
[0..*] I_SalesOrderPricingElement _PricingElement $projection.SalesOrder = _PricingElement.SalesOrder
[0..1] I_SalesOrderBillingPlan _BillingPlan $projection.SalesOrder = _BillingPlan.SalesOrder and $projection.BillingPlan = _BillingPlan.BillingPlan
[0..1] I_SalesOrderApprovalReason _SalesOrderApprovalReason $projection.SalesOrderApprovalReason = _SalesOrderApprovalReason.SalesOrderApprovalReason
[0..*] I_SalesOrderPrecdgProcFlow _PrecedingProcFlowDoc _PrecedingProcFlowDoc.SalesOrder = $projection.SalesOrder
[0..*] I_SalesOrderSubsqntProcFlow _SubsequentProcFlowDoc _SubsequentProcFlowDoc.SalesOrder = $projection.SalesOrder
[0..1] E_SalesDocumentBasic _Extension SalesDocument.SalesDocument = _Extension.SalesDocument

Annotations (18)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Sales Order view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName ISDSALESORDER view
AbapCatalog.compiler.compareFilter true view
ObjectModel.compositionRoot true view
ObjectModel.representativeKey SalesOrder view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
Metadata.ignorePropagatedAnnotations true view
Analytics.dataCategory #DIMENSION view
Metadata.allowExtensions true view
ObjectModel.sapObjectNodeType.name SalesOrder view
Analytics.dataExtraction.enabled true view

Fields (236)

KeyFieldSource TableSource FieldDescription
KEY SalesOrder
SalesOrderType
SalesOrderProcessingType SalesDocumentProcessingType
CreatedByUser CreatedByUser
LastChangedByUser LastChangedByUser
CreationDate CreationDate
CreationTime CreationTime
LastChangeDate LastChangeDate
LastChangeDateTime LastChangeDateTime
SenderBusinessSystemName SenderBusinessSystemName
ExternalDocumentID ExternalDocumentID
ExternalDocLastChangeDateTime ExternalDocLastChangeDateTime
SalesOrganization SalesOrganization
DistributionChannel DistributionChannel
OrganizationDivision OrganizationDivision
SalesGroup SalesGroup
SalesOffice SalesOffice
SoldToParty SoldToParty
CustomerGroup CustomerGroup
AdditionalCustomerGroup1 AdditionalCustomerGroup1
AdditionalCustomerGroup2 AdditionalCustomerGroup2
AdditionalCustomerGroup3 AdditionalCustomerGroup3
AdditionalCustomerGroup4 AdditionalCustomerGroup4
AdditionalCustomerGroup5 AdditionalCustomerGroup5
SlsDocIsRlvtForProofOfDeliv SlsDocIsRlvtForProofOfDeliv
CreditControlArea CreditControlArea
CustomerRebateAgreement CustomerRebateAgreement
SalesOrderDate SalesDocumentDate
ServicesRenderedDate ServicesRenderedDate
SDDocumentReason SDDocumentReason
PurchaseOrderByCustomer PurchaseOrderByCustomer
PurchaseOrderByShipToParty PurchaseOrderByShipToParty
SDDocumentCollectiveNumber SDDocumentCollectiveNumber
CustomerPurchaseOrderType CustomerPurchaseOrderType
CustomerPurchaseOrderDate CustomerPurchaseOrderDate
CustomerPurchaseOrderSuplmnt CustomerPurchaseOrderSuplmnt
SalesDistrict SalesDistrict
StatisticsCurrency StatisticsCurrency
ProductCatalog ProductCatalog
NextCreditCheckDate NextCreditCheckDate
LastCustomerContactDate LastCustomerContactDate
TotalNetAmount TotalNetAmount
TransactionCurrency TransactionCurrency
PricingDate PricingDate
PriceDetnExchangeRate PriceDetnExchangeRate
RetailPromotion RetailPromotion
SalesOrderCondition SalesDocumentCondition
SDPricingProcedure SDPricingProcedure
CustomerPriceGroup CustomerPriceGroup
PriceListType PriceListType
BillingPlan BillingPlan
CustomerTaxClassification1 CustomerTaxClassification1
CustomerTaxClassification2 CustomerTaxClassification2
CustomerTaxClassification3 CustomerTaxClassification3
CustomerTaxClassification4 CustomerTaxClassification4
CustomerTaxClassification5 CustomerTaxClassification5
CustomerTaxClassification6 CustomerTaxClassification6
CustomerTaxClassification7 CustomerTaxClassification7
CustomerTaxClassification8 CustomerTaxClassification8
CustomerTaxClassification9 CustomerTaxClassification9
TaxDepartureCountry TaxDepartureCountry
VATRegistrationCountry VATRegistrationCountry
RequestedDeliveryDate RequestedDeliveryDate
DeliveryDateTypeRule DeliveryDateTypeRule
ShippingType ShippingType
ShippingCondition ShippingCondition
ReceivingPoint ReceivingPoint
IncotermsClassification IncotermsClassification
IncotermsTransferLocation IncotermsTransferLocation
IncotermsLocation1 IncotermsLocation1
IncotermsLocation2 IncotermsLocation2
IncotermsVersion IncotermsVersion
CompleteDeliveryIsDefined CompleteDeliveryIsDefined
OrderCombinationIsAllowed OrderCombinationIsAllowed
DeliveryBlockReason DeliveryBlockReason
FashionCancelDate FashionCancelDate
SalesOrderApprovalReason SalesDocApprovalReason
BillingDocumentDate BillingDocumentDate
BillingCompanyCode BillingCompanyCode
HeaderBillingBlockReason HeaderBillingBlockReason
CustomerPaymentTerms CustomerPaymentTerms
PaymentMethod PaymentMethod
FixedValueDate FixedValueDate
FiscalYear FiscalYear
FiscalPeriod FiscalPeriod
ExchangeRateDate ExchangeRateDate
ExchangeRateType ExchangeRateType
AccountingExchangeRate AccountingExchangeRate
BusinessArea BusinessArea
CustomerAccountAssignmentGroup CustomerAccountAssignmentGroup
CostCenterBusinessArea CostCenterBusinessArea
CostCenter CostCenter
ControllingArea ControllingArea
OrderID OrderID
ControllingObject ControllingObject
AssignmentReference AssignmentReference
PaymentPlan PaymentPlan
ContractAccount ContractAccount
AdditionalValueDays AdditionalValueDays
CustomerCreditAccount CustomerCreditAccount
ReferenceSDDocument ReferenceSDDocument
ReferenceSDDocumentCategory ReferenceSDDocumentCategory
CorrespncExternalReference CorrespncExternalReference
AccountingDocExternalReference AccountingDocExternalReference
BusinessSolutionOrder BusinessSolutionOrder
OverallSDProcessStatus OverallSDProcessStatus
OverallPurchaseConfStatus OverallPurchaseConfStatus
OverallSDDocumentRejectionSts OverallSDDocumentRejectionSts
TotalBlockStatus TotalBlockStatus
OverallDelivConfStatus OverallDelivConfStatus
OverallTotalDeliveryStatus OverallTotalDeliveryStatus
OverallDeliveryStatus OverallDeliveryStatus
OverallDeliveryBlockStatus OverallDeliveryBlockStatus
OverallOrdReltdBillgStatus OverallOrdReltdBillgStatus
OverallBillingBlockStatus OverallBillingBlockStatus
OverallTotalSDDocRefStatus OverallTotalSDDocRefStatus
OverallSDDocReferenceStatus OverallSDDocReferenceStatus
TotalCreditCheckStatus TotalCreditCheckStatus
MaxDocValueCreditCheckStatus MaxDocValueCreditCheckStatus
PaymentTermCreditCheckStatus PaymentTermCreditCheckStatus
FinDocCreditCheckStatus FinDocCreditCheckStatus
ExprtInsurCreditCheckStatus ExprtInsurCreditCheckStatus
PaytAuthsnCreditCheckSts PaytAuthsnCreditCheckSts
CentralCreditCheckStatus CentralCreditCheckStatus
CentralCreditChkTechErrSts CentralCreditChkTechErrSts
HdrGeneralIncompletionStatus HdrGeneralIncompletionStatus
OverallPricingIncompletionSts OverallPricingIncompletionSts
HeaderDelivIncompletionStatus HeaderDelivIncompletionStatus
HeaderBillgIncompletionStatus HeaderBillgIncompletionStatus
OvrlItmGeneralIncompletionSts OvrlItmGeneralIncompletionSts
OvrlItmBillingIncompletionSts OvrlItmBillingIncompletionSts
OvrlItmDelivIncompletionSts OvrlItmDelivIncompletionSts
OverallChmlCmplncStatus OverallChmlCmplncStatus
OverallDangerousGoodsStatus OverallDangerousGoodsStatus
OverallSafetyDataSheetStatus OverallSafetyDataSheetStatus
SalesDocApprovalStatus SalesDocApprovalStatus
OverallTrdCmplncEmbargoSts OverallTrdCmplncEmbargoSts
OvrlTrdCmplncSnctndListChkSts OvrlTrdCmplncSnctndListChkSts
OvrlTrdCmplncLegalCtrlChkSts OvrlTrdCmplncLegalCtrlChkSts
SalesOrderDownPaymentStatus ContractDownPaymentStatus
OmniChnlSalesPromotionStatus OmniChnlSalesPromotionStatus
AlternativePricingDate AlternativePricingDate
IsEUTriangularDeal IsEUTriangularDeal
_Item _Item
_Partner _Partner
_StandardPartner _StandardPartner
_PricingElement _PricingElement
_BillingPlan _BillingPlan
_SDPricingProcedure _SDPricingProcedure
_CustomerPriceGroup _CustomerPriceGroup
_PriceListType _PriceListType
_SalesOrderType _SalesOrderType
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser
_SalesOrganization _SalesOrganization
_DistributionChannel _DistributionChannel
_OrganizationDivision _OrganizationDivision
_SalesGroup _SalesGroup
_SalesOffice _SalesOffice
_SoldToParty _SoldToParty
_CustomerGroup _CustomerGroup
_AdditionalCustomerGroup1 _AdditionalCustomerGroup1
_AdditionalCustomerGroup2 _AdditionalCustomerGroup2
_AdditionalCustomerGroup3 _AdditionalCustomerGroup3
_AdditionalCustomerGroup4 _AdditionalCustomerGroup4
_AdditionalCustomerGroup5 _AdditionalCustomerGroup5
_CreditControlArea _CreditControlArea
_SDDocumentReason _SDDocumentReason
_CustomerPurchaseOrderType _CustomerPurchaseOrderType
_SalesDistrict _SalesDistrict
_TransactionCurrency _TransactionCurrency
_StatisticsCurrency _StatisticsCurrency
_ShippingType _ShippingType
_ShippingCondition _ShippingCondition
_IncotermsClassification _IncotermsClassification
_IncotermsVersion _IncotermsVersion
_DeliveryBlockReason _DeliveryBlockReason
_DeliveryDateTypeRule _DeliveryDateTypeRule
_BillingCompanyCode _BillingCompanyCode
_HeaderBillingBlockReason _HeaderBillingBlockReason
_SalesOrderApprovalReason _SalesOrderApprovalReason
_CustomerPaymentTerms _CustomerPaymentTerms
_ExchangeRateType _ExchangeRateType
_BusinessArea _BusinessArea
_CustomerAccountAssgmtGroup _CustomerAccountAssgmtGroup
_CostCenterBusinessArea _CostCenterBusinessArea
_CostCenter _CostCenter
_ControllingArea _ControllingArea
_ControllingObject _ControllingObject
_CustomerCreditAccount _CustomerCreditAccount
_ReferenceSDDocumentCategory _ReferenceSDDocumentCategory
_SolutionOrder _SolutionOrder
_OverallSDProcessStatus _OverallSDProcessStatus
_OverallPurchaseConfStatus _OverallPurchaseConfStatus
_OverallSDDocumentRejectionSts _OverallSDDocumentRejectionSts
_TotalBlockStatus _TotalBlockStatus
_OverallDelivConfStatus _OverallDelivConfStatus
_OverallTotalDeliveryStatus _OverallTotalDeliveryStatus
_OverallDeliveryStatus _OverallDeliveryStatus
_OverallDeliveryBlockStatus _OverallDeliveryBlockStatus
_OverallOrdReltdBillgStatus _OverallOrdReltdBillgStatus
_OverallBillingBlockStatus _OverallBillingBlockStatus
_OverallTotalSDDocRefStatus _OverallTotalSDDocRefStatus
_OverallSDDocReferenceStatus _OverallSDDocReferenceStatus
_TotalCreditCheckStatus _TotalCreditCheckStatus
_MaxDocValueCreditCheckStatus _MaxDocValueCreditCheckStatus
_PaymentTermCreditCheckStatus _PaymentTermCreditCheckStatus
_FinDocCreditCheckStatus _FinDocCreditCheckStatus
_ExprtInsurCreditCheckStatus _ExprtInsurCreditCheckStatus
_PaytAuthsnCreditCheckSts _PaytAuthsnCreditCheckSts
_CentralCreditCheckStatus _CentralCreditCheckStatus
_CentralCreditChkTechErrSts _CentralCreditChkTechErrSts
_HdrGeneralIncompletionStatus _HdrGeneralIncompletionStatus
_OverallPricingIncompletionSts _OverallPricingIncompletionSts
_HeaderDelivIncompletionStatus _HeaderDelivIncompletionStatus
_HeaderBillgIncompletionStatus _HeaderBillgIncompletionStatus
_OvrlItmGeneralIncompletionSts _OvrlItmGeneralIncompletionSts
_OvrlItmBillingIncompletionSts _OvrlItmBillingIncompletionSts
_OvrlItmDelivIncompletionSts _OvrlItmDelivIncompletionSts
_OverallChmlCmplncStatus _OverallChmlCmplncStatus
_OverallDangerousGoodsStatus _OverallDangerousGoodsStatus
_OvrlSftyDataSheetSts _OvrlSftyDataSheetSts
_SalesDocApprovalStatus _SalesDocApprovalStatus
_OvrlTradeCmplncEmbargoStatus _OvrlTradeCmplncEmbargoStatus
_OvTrdCmplncSnctndListChkSts _OvTrdCmplncSnctndListChkSts
_OvrlTrdCmplncLegalCtrlChkSts _OvrlTrdCmplncLegalCtrlChkSts
_OmniChnlSalesPromotionStatus _OmniChnlSalesPromotionStatus
_DownPaymentStatus _DownPaymentStatus
_EngagementProjectItem _EngagementProjectItem
_BusinessAreaText _BusinessAreaText
_CostCenterBusinessAreaText _CostCenterBusinessAreaText
_CreditControlAreaText _CreditControlAreaText
_TaxDepartureCountry _TaxDepartureCountry
_VATRegistrationCountry _VATRegistrationCountry
_PrecedingProcFlowDoc _PrecedingProcFlowDoc
_SubsequentProcFlowDoc _SubsequentProcFlowDoc
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Sales Order'
@VDM: {
  viewType: #BASIC,
  lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #('TRANSACTIONAL_DATA'),
  privilegedAssociations: [ '_CreatedByUser', '_LastChangedByUser', '_BusinessAreaText','_CostCenterBusinessAreaText','_CreditControlAreaText' ]
}
@AbapCatalog: {
  preserveKey: true,
  sqlViewName: 'ISDSALESORDER',
  compiler.compareFilter: true
}
@ObjectModel: {
   compositionRoot:   true,
   representativeKey: 'SalesOrder',
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #B,
     sizeCategory:   #L
   },
   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: 'SalesOrder'       

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

define view I_SalesOrder
  as select from I_SalesDocument as SalesDocument
  //Associations


  //--[ GENERATED:012:E6ExH29r7kY4iE3VJ}6T4m

  association [0..*] to I_BusinessAreaText          as _BusinessAreaText           on  $projection.BusinessArea = _BusinessAreaText.BusinessArea
  association [0..*] to I_BusinessAreaText          as _CostCenterBusinessAreaText on  $projection.CostCenterBusinessArea = _CostCenterBusinessAreaText.BusinessArea
  association [0..*] to I_CreditControlAreaText     as _CreditControlAreaText      on  $projection.CreditControlArea = _CreditControlAreaText.CreditControlArea
  // ]--GENERATED

  association [0..*] to I_SalesOrderItem            as _Item                       on  $projection.SalesOrder = _Item.SalesOrder
  association [0..1] to I_SalesOrderType            as _SalesOrderType             on  $projection.SalesOrderType = _SalesOrderType.SalesOrderType
  association [1..*] to I_SalesOrderPartner         as _Partner                    on  $projection.SalesOrder = _Partner.SalesOrder
  association [0..*] to I_SalesOrderPricingElement  as _PricingElement             on  $projection.SalesOrder = _PricingElement.SalesOrder

  association [0..1] to I_SalesOrderBillingPlan     as _BillingPlan                on  $projection.SalesOrder  = _BillingPlan.SalesOrder
                                                                                   and $projection.BillingPlan = _BillingPlan.BillingPlan

  association [0..1] to I_SalesOrderApprovalReason  as _SalesOrderApprovalReason   on  $projection.SalesOrderApprovalReason = _SalesOrderApprovalReason.SalesOrderApprovalReason

  association [0..*] to I_SalesOrderPrecdgProcFlow  as _PrecedingProcFlowDoc       on  _PrecedingProcFlowDoc.SalesOrder = $projection.SalesOrder

  association [0..*] to I_SalesOrderSubsqntProcFlow as _SubsequentProcFlowDoc      on  _SubsequentProcFlowDoc.SalesOrder = $projection.SalesOrder

  //Extensibility

  association [0..1] to E_SalesDocumentBasic        as _Extension                  on  SalesDocument.SalesDocument = _Extension.SalesDocument

{
      //Key

  key cast(SalesDocument as vdm_sales_order preserving type)        as SalesOrder,

      //Category

      @ObjectModel.foreignKey.association: '_SalesOrderType'
      cast( SalesDocumentType as sales_order_type preserving type ) as SalesOrderType,
      SalesDocumentProcessingType                                   as SalesOrderProcessingType,

      //Admin

      CreatedByUser,
      LastChangedByUser,
      @Semantics.systemDate.createdAt: true
      CreationDate,
      @Semantics.systemTime.createdAt: true
      CreationTime,
      @Semantics.systemDate.lastChangedAt: true
      LastChangeDate,
      @Semantics.systemDateTime.lastChangedAt: true
      LastChangeDateTime,
      SenderBusinessSystemName,
      ExternalDocumentID,
      ExternalDocLastChangeDateTime,

      // Organization

      @ObjectModel.foreignKey.association: '_SalesOrganization'
      SalesOrganization,
      @ObjectModel.foreignKey.association: '_DistributionChannel'
      DistributionChannel,
      @ObjectModel.foreignKey.association: '_OrganizationDivision'
      OrganizationDivision,
      @ObjectModel.foreignKey.association: '_SalesGroup'
      SalesGroup,
      @ObjectModel.foreignKey.association: '_SalesOffice'
      SalesOffice,

      //Sales

      //--[ GENERATED:012:E6ExH29r7kY4iE3VJ}6T4m

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

      @ObjectModel.foreignKey.association: '_SoldToParty'
      SoldToParty,
      @ObjectModel.foreignKey.association: '_CustomerGroup'
      CustomerGroup,
      @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,
      SlsDocIsRlvtForProofOfDeliv,
      //--[ GENERATED:012:E6ExH29r7kY4iE3VJ}6T4m

      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_CreditControlAreaStdVH',
                     element: 'CreditControlArea' }
        }]
      @ObjectModel.text.association: '_CreditControlAreaText'
      // ]--GENERATED

      @ObjectModel.foreignKey.association: '_CreditControlArea'
      CreditControlArea,
      CustomerRebateAgreement,
      SalesDocumentDate                                             as SalesOrderDate,
      ServicesRenderedDate,
      @ObjectModel.foreignKey.association: '_SDDocumentReason'
      SDDocumentReason,
      PurchaseOrderByCustomer,
      PurchaseOrderByShipToParty,
      SDDocumentCollectiveNumber,
      @ObjectModel.foreignKey.association: '_CustomerPurchaseOrderType'
      CustomerPurchaseOrderType,
      CustomerPurchaseOrderDate,
      CustomerPurchaseOrderSuplmnt,
      @ObjectModel.foreignKey.association: '_SalesDistrict'
      SalesDistrict,
      @Semantics.currencyCode: true
      @ObjectModel.foreignKey.association: '_StatisticsCurrency'
      StatisticsCurrency,
      ProductCatalog,
      NextCreditCheckDate,
      LastCustomerContactDate,

      //Pricing

      @DefaultAggregation: #SUM
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      TotalNetAmount,
      @Semantics.currencyCode: true
      @ObjectModel.foreignKey.association: '_TransactionCurrency'
      TransactionCurrency,
      PricingDate,
      PriceDetnExchangeRate,
      RetailPromotion,
      SalesDocumentCondition                                        as SalesOrderCondition,
      @Analytics.internalName: #LOCAL
      @ObjectModel.foreignKey.association: '_SDPricingProcedure'
      SDPricingProcedure,
      @Analytics.internalName: #LOCAL
      @ObjectModel.foreignKey.association: '_CustomerPriceGroup'
      CustomerPriceGroup,
      @Analytics.internalName: #LOCAL
      @ObjectModel.foreignKey.association: '_PriceListType'
      PriceListType,

      BillingPlan,

      CustomerTaxClassification1,
      CustomerTaxClassification2,
      CustomerTaxClassification3,
      CustomerTaxClassification4,
      CustomerTaxClassification5,
      CustomerTaxClassification6,
      CustomerTaxClassification7,
      CustomerTaxClassification8,
      CustomerTaxClassification9,

      @Analytics.internalName: #LOCAL
      @ObjectModel.foreignKey.association: '_TaxDepartureCountry'
      TaxDepartureCountry,
      @Analytics.internalName: #LOCAL
      @ObjectModel.foreignKey.association: '_VATRegistrationCountry'
      VATRegistrationCountry,

      //Shipping

      RequestedDeliveryDate,
      @Analytics.internalName: #LOCAL
      @ObjectModel.foreignKey.association: '_DeliveryDateTypeRule'
      DeliveryDateTypeRule,
      @ObjectModel.foreignKey.association: '_ShippingType'
      ShippingType,
      @ObjectModel.foreignKey.association: '_ShippingCondition'
      ShippingCondition,
      ReceivingPoint,
      @ObjectModel.foreignKey.association: '_IncotermsClassification'
      IncotermsClassification,
      IncotermsTransferLocation,
      IncotermsLocation1,
      IncotermsLocation2,
      @ObjectModel.foreignKey.association: '_IncotermsVersion'
      IncotermsVersion,
      CompleteDeliveryIsDefined,
      OrderCombinationIsAllowed,
      @ObjectModel.foreignKey.association: '_DeliveryBlockReason'
      DeliveryBlockReason,

      //Fashion

      FashionCancelDate,

      //Approval Management

      @Analytics.internalName: #LOCAL
      @ObjectModel.foreignKey.association: '_SalesOrderApprovalReason'
      SalesDocApprovalReason                                        as SalesOrderApprovalReason,

      //Billing

      BillingDocumentDate,
      //--[ GENERATED:012:E6ExH29r7kY4iE3VJ}6T4m

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

      @ObjectModel.foreignKey.association: '_BillingCompanyCode'
      BillingCompanyCode,
      @ObjectModel.foreignKey.association: '_HeaderBillingBlockReason'
      HeaderBillingBlockReason,

      //Payment

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

      //Accounting

      FiscalYear,
      FiscalPeriod,
      ExchangeRateDate,
      @ObjectModel.foreignKey.association: '_ExchangeRateType'
      ExchangeRateType,
      AccountingExchangeRate,
      //--[ GENERATED:012:E6ExH29r7kY4iE3VJ}6T4m

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

      @ObjectModel.foreignKey.association: '_BusinessArea'
      BusinessArea,
      @ObjectModel.foreignKey.association: '_CustomerAccountAssgmtGroup'
      CustomerAccountAssignmentGroup,
      //--[ GENERATED:012:E6ExH29r7kY4iE3VJ}6T4m

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

      @ObjectModel.foreignKey.association: '_CostCenterBusinessArea'
      CostCenterBusinessArea,
      CostCenter,
      //--[ GENERATED:012:E6ExH29r7kY4iE3VJ}6T4m

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

      @ObjectModel.foreignKey.association: '_ControllingArea'
      ControllingArea,
      OrderID,
      //--[ GENERATED:012:E6ExH29r7kY4iE3VJ}6T4m

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

      @ObjectModel.foreignKey.association: '_ControllingObject'
      ControllingObject,
      AssignmentReference,
      PaymentPlan,
      ContractAccount,
      AdditionalValueDays,

      //Credit Block

      @Analytics.internalName: #LOCAL
      @ObjectModel.foreignKey.association: '_CustomerCreditAccount'
      CustomerCreditAccount,

      //Reference

      ReferenceSDDocument,
      @ObjectModel.foreignKey.association: '_ReferenceSDDocumentCategory'
      ReferenceSDDocumentCategory,
      CorrespncExternalReference,
      @Analytics.internalName: #LOCAL
      AccountingDocExternalReference,

      @Analytics.internalName: #LOCAL
      @Consumption.valueHelpDefinition: [
       { entity:  { name:    'I_BusinessSolutionOrderStdVH',
                    element: 'BusinessSolutionOrder' }
       }]
      @ObjectModel.foreignKey.association: '_SolutionOrder'
      BusinessSolutionOrder,

      //Status

      @ObjectModel.foreignKey.association: '_OverallSDProcessStatus'
      OverallSDProcessStatus,
      @ObjectModel.foreignKey.association: '_OverallPurchaseConfStatus'
      OverallPurchaseConfStatus,
      @ObjectModel.foreignKey.association: '_OverallSDDocumentRejectionSts'
      OverallSDDocumentRejectionSts,
      @ObjectModel.foreignKey.association: '_TotalBlockStatus'
      TotalBlockStatus,
      @ObjectModel.foreignKey.association: '_OverallDelivConfStatus'
      OverallDelivConfStatus,
      @ObjectModel.foreignKey.association: '_OverallTotalDeliveryStatus'
      OverallTotalDeliveryStatus,
      @ObjectModel.foreignKey.association: '_OverallDeliveryStatus'
      OverallDeliveryStatus,
      @ObjectModel.foreignKey.association: '_OverallDeliveryBlockStatus'
      OverallDeliveryBlockStatus,
      @ObjectModel.foreignKey.association: '_OverallOrdReltdBillgStatus'
      OverallOrdReltdBillgStatus,
      @ObjectModel.foreignKey.association: '_OverallBillingBlockStatus'
      OverallBillingBlockStatus,
      @ObjectModel.foreignKey.association: '_OverallTotalSDDocRefStatus'
      OverallTotalSDDocRefStatus,
      @ObjectModel.foreignKey.association: '_OverallSDDocReferenceStatus'
      OverallSDDocReferenceStatus,
      @ObjectModel.foreignKey.association: '_TotalCreditCheckStatus'
      TotalCreditCheckStatus,
      @ObjectModel.foreignKey.association: '_MaxDocValueCreditCheckStatus'
      MaxDocValueCreditCheckStatus,
      @ObjectModel.foreignKey.association: '_PaymentTermCreditCheckStatus'
      PaymentTermCreditCheckStatus,
      @ObjectModel.foreignKey.association: '_FinDocCreditCheckStatus'
      FinDocCreditCheckStatus,
      @ObjectModel.foreignKey.association: '_ExprtInsurCreditCheckStatus'
      ExprtInsurCreditCheckStatus,
      @ObjectModel.foreignKey.association: '_PaytAuthsnCreditCheckSts'
      PaytAuthsnCreditCheckSts,
      @ObjectModel.foreignKey.association: '_CentralCreditCheckStatus'
      CentralCreditCheckStatus,
      @ObjectModel.foreignKey.association: '_CentralCreditChkTechErrSts'
      CentralCreditChkTechErrSts,
      @ObjectModel.foreignKey.association: '_HdrGeneralIncompletionStatus'
      HdrGeneralIncompletionStatus,
      @ObjectModel.foreignKey.association: '_OverallPricingIncompletionSts'
      OverallPricingIncompletionSts,
      @ObjectModel.foreignKey.association: '_HeaderDelivIncompletionStatus'
      HeaderDelivIncompletionStatus,
      @ObjectModel.foreignKey.association: '_HeaderBillgIncompletionStatus'
      HeaderBillgIncompletionStatus,
      @ObjectModel.foreignKey.association: '_OvrlItmGeneralIncompletionSts'
      OvrlItmGeneralIncompletionSts,
      @ObjectModel.foreignKey.association: '_OvrlItmBillingIncompletionSts'
      OvrlItmBillingIncompletionSts,
      @ObjectModel.foreignKey.association: '_OvrlItmDelivIncompletionSts'
      OvrlItmDelivIncompletionSts,
      @Analytics.internalName: #LOCAL
      @ObjectModel.foreignKey.association: '_OverallChmlCmplncStatus'
      OverallChmlCmplncStatus,
      @Analytics.internalName: #LOCAL
      @ObjectModel.foreignKey.association: '_OverallDangerousGoodsStatus'
      OverallDangerousGoodsStatus,
      @Analytics.internalName: #LOCAL
      @ObjectModel.foreignKey.association: '_OvrlSftyDataSheetSts'
      OverallSafetyDataSheetStatus,
      @ObjectModel.foreignKey.association: '_SalesDocApprovalStatus'
      SalesDocApprovalStatus,
      @Analytics.internalName: #LOCAL
      @ObjectModel.foreignKey.association: '_OvrlTradeCmplncEmbargoStatus'
      OverallTrdCmplncEmbargoSts,
      @Analytics.internalName: #LOCAL
      @ObjectModel.foreignKey.association: '_OvTrdCmplncSnctndListChkSts'
      OvrlTrdCmplncSnctndListChkSts,
      @Analytics.internalName: #LOCAL
      @ObjectModel.foreignKey.association: '_OvrlTrdCmplncLegalCtrlChkSts'
      OvrlTrdCmplncLegalCtrlChkSts,
      @ObjectModel.foreignKey.association: '_DownPaymentStatus'
      ContractDownPaymentStatus                                     as SalesOrderDownPaymentStatus,
      @ObjectModel.foreignKey.association: '_OmniChnlSalesPromotionStatus'
      OmniChnlSalesPromotionStatus,
      AlternativePricingDate,
      IsEUTriangularDeal,

      //Associations

      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
      _Item,
      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
      _Partner,
      _StandardPartner,
      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
      _PricingElement,
      _BillingPlan,
      _SDPricingProcedure,
      _CustomerPriceGroup,
      _PriceListType,
      _SalesOrderType,
      _CreatedByUser,
      _LastChangedByUser,
      _SalesOrganization,
      _DistributionChannel,
      _OrganizationDivision,
      _SalesGroup,
      _SalesOffice,
      _SoldToParty,
      _CustomerGroup,
      _AdditionalCustomerGroup1,
      _AdditionalCustomerGroup2,
      _AdditionalCustomerGroup3,
      _AdditionalCustomerGroup4,
      _AdditionalCustomerGroup5,
      _CreditControlArea,
      _SDDocumentReason,
      _CustomerPurchaseOrderType,
      _SalesDistrict,
      _TransactionCurrency,
      _StatisticsCurrency,
      _ShippingType,
      _ShippingCondition,
      _IncotermsClassification,
      _IncotermsVersion,
      _DeliveryBlockReason,
      _DeliveryDateTypeRule,
      _BillingCompanyCode,
      _HeaderBillingBlockReason,
      _SalesOrderApprovalReason,
      _CustomerPaymentTerms,
      _ExchangeRateType,
      _BusinessArea,
      _CustomerAccountAssgmtGroup,
      _CostCenterBusinessArea,
      _CostCenter,
      _ControllingArea,
      _ControllingObject,
      _CustomerCreditAccount,
      _ReferenceSDDocumentCategory,
      _SolutionOrder,
      //Status

      _OverallSDProcessStatus,
      _OverallPurchaseConfStatus,
      _OverallSDDocumentRejectionSts,
      _TotalBlockStatus,
      _OverallDelivConfStatus,
      _OverallTotalDeliveryStatus,
      _OverallDeliveryStatus,
      _OverallDeliveryBlockStatus,
      _OverallOrdReltdBillgStatus,
      _OverallBillingBlockStatus,
      _OverallTotalSDDocRefStatus,
      _OverallSDDocReferenceStatus,
      _TotalCreditCheckStatus,
      _MaxDocValueCreditCheckStatus,
      _PaymentTermCreditCheckStatus,
      _FinDocCreditCheckStatus,
      _ExprtInsurCreditCheckStatus,
      _PaytAuthsnCreditCheckSts,
      _CentralCreditCheckStatus,
      _CentralCreditChkTechErrSts,
      _HdrGeneralIncompletionStatus,
      _OverallPricingIncompletionSts,
      _HeaderDelivIncompletionStatus,
      _HeaderBillgIncompletionStatus,
      _OvrlItmGeneralIncompletionSts,
      _OvrlItmBillingIncompletionSts,
      _OvrlItmDelivIncompletionSts,
      _OverallChmlCmplncStatus,
      _OverallDangerousGoodsStatus,
      _OvrlSftyDataSheetSts,
      _SalesDocApprovalStatus,
      _OvrlTradeCmplncEmbargoStatus,
      _OvTrdCmplncSnctndListChkSts,
      _OvrlTrdCmplncLegalCtrlChkSts,
      _OmniChnlSalesPromotionStatus,
      _DownPaymentStatus,
      _EngagementProjectItem,
      //--[ GENERATED:012:E6ExH29r7kY4iE3VJ}6T4m

      @Consumption.hidden: true
      _BusinessAreaText,
      @Consumption.hidden: true
      _CostCenterBusinessAreaText,
      @Consumption.hidden: true
      _CreditControlAreaText,
      // ]--GENERATED

      _TaxDepartureCountry,
      _VATRegistrationCountry,
      _PrecedingProcFlowDoc,
      _SubsequentProcFlowDoc
}
where
  SalesDocument.SDDocumentCategory = 'C';
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SALESDOCUMENT"
],
"ASSOCIATED":
[
"E_SALESDOCUMENTBASIC",
"I_ADDITIONALCUSTOMERGROUP1",
"I_ADDITIONALCUSTOMERGROUP2",
"I_ADDITIONALCUSTOMERGROUP3",
"I_ADDITIONALCUSTOMERGROUP4",
"I_ADDITIONALCUSTOMERGROUP5",
"I_BILLINGBLOCKREASON",
"I_BUSINESSAREA",
"I_BUSINESSAREATEXT",
"I_CENTRALCREDITCHECKSTATUS",
"I_CENTRALCREDITCHKTECHERRSTS",
"I_COMPANYCODE",
"I_CONTRACTDOWNPAYMENTSTATUS",
"I_CONTROLLINGAREA",
"I_CONTROLLINGOBJECT",
"I_COSTCENTER",
"I_COUNTRY",
"I_CREDITCONTROLAREA",
"I_CREDITCONTROLAREATEXT",
"I_CURRENCY",
"I_CUSTOMER",
"I_CUSTOMERACCOUNTASSGMTGROUP",
"I_CUSTOMERGROUP",
"I_CUSTOMERPAYMENTTERMS",
"I_CUSTOMERPRICEGROUP",
"I_CUSTOMERPURCHASEORDERTYPE",
"I_DELIVERYBLOCKREASON",
"I_DELIVERYDATETYPERULE",
"I_DISTRIBUTIONCHANNEL",
"I_DIVISION",
"I_ENGAGEMENTPROJECTITEM",
"I_EXCHANGERATETYPE",
"I_EXPRTINSURCREDITCHECKSTATUS",
"I_FINDOCCREDITCHECKSTATUS",
"I_HDRBILLGINCOMPLETIONSTATUS",
"I_HDRDELIVINCOMPLETIONSTATUS",
"I_HDRGENINCOMPLETIONSTATUS",
"I_INCOTERMSCLASSIFICATION",
"I_INCOTERMSVERSION",
"I_MAXDOCVALUECREDITCHECKSTS",
"I_OMNICHNLSALESPROMOTIONSTATUS",
"I_OVERALLBILLINGBLOCKSTATUS",
"I_OVERALLCHMLCMPLNCSTATUS",
"I_OVERALLDANGEROUSGOODSSTATUS",
"I_OVERALLDELIVCONFSTATUS",
"I_OVERALLDELIVERYBLOCKSTATUS",
"I_OVERALLDELIVERYSTATUS",
"I_OVERALLORDRELTDBILLGSTATUS",
"I_OVERALLPRCINCOMPLETIONSTS",
"I_OVERALLPURCHASECONFSTATUS",
"I_OVERALLSDDOCREFERENCESTATUS",
"I_OVERALLSDDOCUMENTRJCNSTATUS",
"I_OVERALLSDPROCESSSTATUS",
"I_OVERALLTOTALDELIVERYSTATUS",
"I_OVERALLTOTALSDDOCREFSTATUS",
"I_OVRLITMBILLGINCOMPLTNSTS",
"I_OVRLITMDELIVINCOMPLETIONSTS",
"I_OVRLITMGENINCOMPLETIONSTS",
"I_OVRLSFTYDATASHEETSTS",
"I_OVRLTRADECMPLNCEMBARGOSTATUS",
"I_OVRLTRDCMPLNCLEGALCTRLCHKSTS",
"I_OVTRDCMPLNCSNCTNDLISTCHKSTS",
"I_PAYMENTTERMCREDITCHECKSTS",
"I_PAYTAUTHSNCREDITCHECKSTS",
"I_PRICELISTTYPE",
"I_SALESDISTRICT",
"I_SALESDOCAPPROVALSTATUS",
"I_SALESDOCUMENTSTANDARDPARTNER",
"I_SALESGROUP",
"I_SALESOFFICE",
"I_SALESORDERAPPROVALREASON",
"I_SALESORDERBILLINGPLAN",
"I_SALESORDERITEM",
"I_SALESORDERPARTNER",
"I_SALESORDERPRECDGPROCFLOW",
"I_SALESORDERPRICINGELEMENT",
"I_SALESORDERSUBSQNTPROCFLOW",
"I_SALESORDERTYPE",
"I_SALESORGANIZATION",
"I_SDDOCUMENTCATEGORY",
"I_SDDOCUMENTREASON",
"I_SERVICEDOCUMENTENHCD",
"I_SHIPPINGCONDITION",
"I_SHIPPINGTYPE",
"I_SLSPRICINGPROCEDURE",
"I_TOTALBLOCKSTATUS",
"I_TOTALCREDITCHECKSTATUS",
"I_USER"
],
"BASE":
[
"I_SALESDOCUMENT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/