I_SalesOrderImport

@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Sales Order Header for Import'
@VDM: {
  viewType: #BASIC
}
@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@AbapCatalog: {
  sqlViewName: 'ISDSOIMPORT',
  preserveKey: true,
  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 ],
   modelingPattern: [ #ANALYTICAL_DIMENSION ]
}
@Analytics: {
  dataCategory: #DIMENSION,
  internalName:#LOCAL
}
@Metadata: {
  allowExtensions:true,
  ignorePropagatedAnnotations:true
}

define view I_SalesOrderImport
  as select from I_SalesOrder as SalesOrder

  //Associations

  association [0..*] to I_SalesOrderItemImport as _Item      on $projection.SalesOrder = _Item.SalesOrder

  //Extensibility

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

      //Key

  key SalesOrder,

      //Category

      @ObjectModel.foreignKey.association: '_SalesOrderType'
      SalesOrderType,
      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

//      @Consumption.valueHelpDefinition: [

//        { entity:  { name:    'I_Customer_VH',

//                     element: 'Customer' }

//        }]

//      @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,
//      @Consumption.valueHelpDefinition: [

//        { entity:  { name:    'I_CreditControlAreaStdVH',

//                     element: 'CreditControlArea' }

//        }]

//      @ObjectModel.text.association: '_CreditControlAreaText'

//      @ObjectModel.foreignKey.association: '_CreditControlArea'

      CreditControlArea,
      CustomerRebateAgreement,
      SalesOrderDate,
      ServicesRenderedDate,
//      @ObjectModel.foreignKey.association: '_SDDocumentReason'

      SDDocumentReason,
      PurchaseOrderByCustomer,
      cast ( PurchaseOrderByShipToParty as sd_purchase_order_by_shipto preserving type ) as 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,
      SalesOrderCondition,
//      @ObjectModel.foreignKey.association: '_SDPricingProcedure'

      SDPricingProcedure,
//      @ObjectModel.foreignKey.association: '_CustomerPriceGroup'

      CustomerPriceGroup,
//      @ObjectModel.foreignKey.association: '_PriceListType'

      PriceListType,

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

      TaxDepartureCountry,
      VATRegistrationCountry,

      //Shipping

      RequestedDeliveryDate,
//      @ObjectModel.foreignKey.association: '_DeliveryDateTypeRule'

      DeliveryDateTypeRule,
//      @ObjectModel.foreignKey.association: '_ShippingType'

      ShippingType,
//      @ObjectModel.foreignKey.association: '_ShippingCondition'

      ShippingCondition,
//      @ObjectModel.foreignKey.association: '_IncotermsClassification'

      IncotermsClassification,
      IncotermsTransferLocation,
      IncotermsLocation1,
      IncotermsLocation2,
//      @ObjectModel.foreignKey.association: '_IncotermsVersion'

      IncotermsVersion,
      CompleteDeliveryIsDefined,
//      @ObjectModel.foreignKey.association: '_DeliveryBlockReason'

      DeliveryBlockReason,

      //Fashion

      FashionCancelDate,

      //Approval Management

//      @ObjectModel.foreignKey.association: '_SalesOrderApprovalReason'

      SalesOrderApprovalReason,

      //Billing

      BillingDocumentDate,
//      @Consumption.valueHelpDefinition: [

//        { entity:  { name:    'I_CompanyCodeStdVH',

//                     element: 'CompanyCode' }

//        }]

//      @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,
//      @Consumption.valueHelpDefinition: [

//        { entity:  { name:    'I_BusinessAreaStdVH',

//                     element: 'BusinessArea' }

//        }]

//      @ObjectModel.text.association: '_BusinessAreaText'

//      @ObjectModel.foreignKey.association: '_BusinessArea'

      BusinessArea,
//      @ObjectModel.foreignKey.association: '_CustomerAccountAssgmtGroup'

      CustomerAccountAssignmentGroup,
//      @Consumption.valueHelpDefinition: [

//        { entity:  { name:    'I_BusinessAreaStdVH',

//                     element: 'BusinessArea' }

//        }]

//      @ObjectModel.text.association: '_CostCenterBusinessAreaText'

//      @ObjectModel.foreignKey.association: '_CostCenterBusinessArea'

      CostCenterBusinessArea,
      CostCenter,
//      @Consumption.valueHelpDefinition: [

//        { entity:  { name:    'I_ControllingAreaStdVH',

//                     element: 'ControllingArea' }

//        }]

//      @ObjectModel.foreignKey.association: '_ControllingArea'

      ControllingArea,
      OrderID,
//      @Consumption.valueHelpDefinition: [

//        { entity:  { name:    'I_ControllingObjectStdVH',

//                     element: 'ControllingObject' }

//        }]

//      @ObjectModel.foreignKey.association: '_ControllingObject'

      ControllingObject,
      AssignmentReference,
      PaymentPlan,

      //Credit Block

//      @ObjectModel.foreignKey.association: '_CustomerCreditAccount'

      CustomerCreditAccount,

      //Reference

      ReferenceSDDocument,
//      @ObjectModel.foreignKey.association: '_ReferenceSDDocumentCategory'

      ReferenceSDDocumentCategory,
      CorrespncExternalReference,
      AccountingDocExternalReference,

//      @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,
//      @ObjectModel.foreignKey.association: '_OverallChmlCmplncStatus'

      OverallChmlCmplncStatus,
//      @ObjectModel.foreignKey.association: '_OverallDangerousGoodsStatus'

      OverallDangerousGoodsStatus,
//      @ObjectModel.foreignKey.association: '_OvrlSftyDataSheetSts'

      OverallSafetyDataSheetStatus,
//      @ObjectModel.foreignKey.association: '_SalesDocApprovalStatus'

      SalesDocApprovalStatus,
//      @ObjectModel.foreignKey.association: '_OvrlTradeCmplncEmbargoStatus'

      OverallTrdCmplncEmbargoSts,
//      @ObjectModel.foreignKey.association: '_OvTrdCmplncSnctndListChkSts'

      OvrlTrdCmplncSnctndListChkSts,
//      @ObjectModel.foreignKey.association: '_OvrlTrdCmplncLegalCtrlChkSts'

      OvrlTrdCmplncLegalCtrlChkSts,
//      @ObjectModel.foreignKey.association: '_DownPaymentStatus'

      SalesOrderDownPaymentStatus,


      /* Associations */
      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
      _Item,
      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
      _Partner,
      _StandardPartner,
      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
      _PricingElement,
      _SalesOrderType
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SALESORDER"
],
"ASSOCIATED":
[
"E_SALESDOCUMENTBASIC",
"I_SALESDOCUMENTSTANDARDPARTNER",
"I_SALESORDERITEMIMPORT",
"I_SALESORDERPARTNER",
"I_SALESORDERPRICINGELEMENT",
"I_SALESORDERTYPE"
],
"BASE":
[
"I_SALESORDER"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/