I_SalesOrderImport

@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Header Fields for Sales Order Import'
@VDM: {
  viewType: #BASIC
}
@AccessControl: {
  authorizationCheck: #PRIVILEGED_ONLY,
  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

      SalesOrganization,
      DistributionChannel,
      OrganizationDivision,
      SalesGroup,
      SalesOffice,

      //Sales

      SoldToParty,
      CustomerGroup,
      AdditionalCustomerGroup1,
      AdditionalCustomerGroup2,
      AdditionalCustomerGroup3,
      AdditionalCustomerGroup4,
      AdditionalCustomerGroup5,
      SlsDocIsRlvtForProofOfDeliv,
      CreditControlArea,
      CustomerRebateAgreement,
      SalesOrderDate,
      ServicesRenderedDate,
      SDDocumentReason,
      PurchaseOrderByCustomer,
      cast ( PurchaseOrderByShipToParty as sd_purchase_order_by_shipto preserving type ) as PurchaseOrderByShipToParty,
      SDDocumentCollectiveNumber,
      CustomerPurchaseOrderType,
      CustomerPurchaseOrderDate,
      CustomerPurchaseOrderSuplmnt,
      SalesDistrict,
      @Semantics.currencyCode: true
      StatisticsCurrency,
      ProductCatalog,
      NextCreditCheckDate,
      LastCustomerContactDate,

      //Pricing

      @DefaultAggregation: #SUM
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      TotalNetAmount,
      @Semantics.currencyCode: true
      TransactionCurrency,
      PricingDate,
      PriceDetnExchangeRate,
      RetailPromotion,
      SalesOrderCondition,
      SDPricingProcedure,
      CustomerPriceGroup,
      PriceListType,

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

      TaxDepartureCountry,
      VATRegistrationCountry,

      //Shipping

      RequestedDeliveryDate,
      DeliveryDateTypeRule,
      ShippingType,
      ShippingCondition,
      IncotermsClassification,
      IncotermsTransferLocation,
      IncotermsLocation1,
      IncotermsLocation2,
      IncotermsVersion,
      CompleteDeliveryIsDefined,
      DeliveryBlockReason,

      //Fashion

      FashionCancelDate,

      //Approval Management

      SalesOrderApprovalReason,

      //Billing

      BillingDocumentDate,
      BillingCompanyCode,
      HeaderBillingBlockReason,

      //Payment

      CustomerPaymentTerms,
      PaymentMethod,
      FixedValueDate,

      //Accounting

      FiscalYear,
      FiscalPeriod,
      ExchangeRateDate,
      ExchangeRateType,
      AccountingExchangeRate,
      BusinessArea,
      CustomerAccountAssignmentGroup,
      CostCenterBusinessArea,
      CostCenter,
      ControllingArea,
      OrderID,
      ControllingObject,
      AssignmentReference,
      PaymentPlan,

      //Credit Block

      CustomerCreditAccount,

      //Reference

      ReferenceSDDocument,
      ReferenceSDDocumentCategory,
      CorrespncExternalReference,
      AccountingDocExternalReference,

      BusinessSolutionOrder,

      //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,
      OverallSafetyDataSheetStatus,
      SalesDocApprovalStatus,
      OverallTrdCmplncEmbargoSts,
      OvrlTrdCmplncSnctndListChkSts,
      OvrlTrdCmplncLegalCtrlChkSts,
      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
}