R_SalesOrderWithoutChargeTP

@VDM: {
  lifecycle.contract.type: #SAP_INTERNAL_API,
  viewType: #TRANSACTIONAL
}

@AccessControl: {
  authorizationCheck: #MANDATORY,
  personalData.blocking: #('TRANSACTIONAL_DATA'),
  privilegedAssociations: [ '_CreatedByUser', '_LastChangedByUser'] }

@ObjectModel: {
    sapObjectNodeType:{
        name: 'SalesOrderWithoutCharge'
    },
    usageType: {
        dataClass:      #TRANSACTIONAL,
        serviceQuality: #C,
        sizeCategory:   #L
    },
    semanticKey: ['SalesOrderWithoutCharge']
}

@Metadata.ignorePropagatedAnnotations: true
@EndUserText.label: 'Sales Order Without Charge - TP'

define root view entity R_SalesOrderWithoutChargeTP
  as select from I_SalesOrderWithoutCharge as SalesOrderWithoutCharge

  composition [0..*] of R_SlsOrderWithoutChargeItemTP as _Item

  association [0..1] to I_SlsOrdWthoutChrgPartner     as _SoldToParty              on  $projection.SalesOrderWithoutCharge = _SoldToParty.SalesOrderWithoutCharge
                                                                                   and _SoldToParty.PartnerFunction        = 'AG'
  association [0..1] to I_SlsOrganizationDistrChnl    as _SlsOrganizationDistrChnl on  $projection.SalesOrganization   = _SlsOrganizationDistrChnl.SalesOrganization
                                                                                   and $projection.DistributionChannel = _SlsOrganizationDistrChnl.DistributionChannel

{
  key SalesOrderWithoutCharge.SalesOrderWithoutCharge,
      @ObjectModel.foreignKey.association: '_SalesOrderWithoutChargeType'
      SalesOrderWithoutCharge.SalesOrderWithoutChargeType,

      @ObjectModel.foreignKey.association: '_SalesOrganization'
      SalesOrderWithoutCharge.SalesOrganization,
      @ObjectModel.foreignKey.association: '_DistributionChannel'
      SalesOrderWithoutCharge.DistributionChannel,

      _SlsOrganizationDistrChnl.ReferenceDistributionChannel,

      @ObjectModel.foreignKey.association: '_OrganizationDivision'
      SalesOrderWithoutCharge.OrganizationDivision,
      @ObjectModel.foreignKey.association: '_SalesGroup'
      SalesOrderWithoutCharge.SalesGroup,
      @ObjectModel.foreignKey.association: '_SalesOffice'
      SalesOrderWithoutCharge.SalesOffice,

      @ObjectModel.foreignKey.association: '_SalesDistrict'
      SalesOrderWithoutCharge.SalesDistrict,

      @ObjectModel.text.element: ['CustomerName']
      SalesOrderWithoutCharge.SoldToParty,
      @Semantics.text:true
      _SoldToParty.FullName                                                                                         as CustomerName,

      @ObjectModel.foreignKey.association: '_CreatedByUser'
      SalesOrderWithoutCharge.CreatedByUser,
      SalesOrderWithoutCharge.CreationDate,
      SalesOrderWithoutCharge.CreationTime,

      cast( dats_tims_to_tstmp( SalesOrderWithoutCharge.CreationDate, SalesOrderWithoutCharge.CreationTime, abap_system_timezone( $session.client, 'NULL' ),
        $session.client, 'NULL' ) as creation_date_time )                                                           as SalesDocumentCreationDateTime,

      @ObjectModel.foreignKey.association: '_LastChangedByUser'
      SalesOrderWithoutCharge.LastChangedByUser,
      SalesOrderWithoutCharge.LastChangeDate,
      case tstmp_is_valid(cast(SalesOrderWithoutCharge.LastChangeDateTime as abap.dec(15,0)))
        when 0 then cast( dats_tims_to_tstmp( SalesOrderWithoutCharge.CreationDate, SalesOrderWithoutCharge.CreationTime, 'UTC', $session.client, 'NULL' ) as last_changed_date_time )
            else cast( SalesOrderWithoutCharge.LastChangeDateTime as last_changed_date_time )
      end                                                                                                           as LastChangeDateTime,

      SalesOrderWithoutCharge.PurchaseOrderByCustomer,
      @ObjectModel.foreignKey.association: '_CustomerPurchaseOrderType'
      SalesOrderWithoutCharge.CustomerPurchaseOrderType,
      SalesOrderWithoutCharge.CustomerPurchaseOrderDate,

      @ObjectModel.foreignKey.association: '_CustomerGroup'
      SalesOrderWithoutCharge.CustomerGroup,

      SalesOrderWithoutCharge.SalesOrderWithoutChargeDate,

      @Semantics.amount.currencyCode: 'TransactionCurrency'
      SalesOrderWithoutCharge.TotalNetAmount,
      @ObjectModel.foreignKey.association: '_TransactionCurrency'
      SalesOrderWithoutCharge.TransactionCurrency,

      @ObjectModel.foreignKey.association: '_SDDocumentReason'
      SalesOrderWithoutCharge.SDDocumentReason,

      SalesOrderWithoutCharge.PricingDate,
      SalesOrderWithoutCharge.ServicesRenderedDate,
      // BillingDocumentDate,

      SalesOrderWithoutCharge.FixedValueDate,
      //      @ObjectModel.foreignKey.association: '_CustomerPriceGroup'

      //     CustomerPriceGroup,


      @ObjectModel.foreignKey.association: '_CustomerPaymentTerms'
      SalesOrderWithoutCharge.CustomerPaymentTerms,

      SalesOrderWithoutCharge.PaymentMethod,

      @ObjectModel.foreignKey.association: '_OverallDeliveryBlockStatus'
      SalesOrderWithoutCharge.OverallDeliveryBlockStatus,

      @ObjectModel.foreignKey.association: '_OverallDeliveryStatus'
      SalesOrderWithoutCharge.OverallDeliveryStatus,

      @ObjectModel.foreignKey.association: '_HdrGeneralIncompletionStatus'
      cast(SalesOrderWithoutCharge.HdrGeneralIncompletionStatus as hdr_general_incompltn_status preserving type )   as HdrGeneralIncompletionStatus,


      @ObjectModel.foreignKey.association: '_OvrlItmGeneralIncompletionSts'
      cast(SalesOrderWithoutCharge.OvrlItmGeneralIncompletionSts as itms_ovrl_incompletion_status preserving type ) as OvrlItmGeneralIncompletionSts,

      @ObjectModel.foreignKey.association: '_SalesDocApprovalStatus'
      SalesDocApprovalStatus,

      @ObjectModel.foreignKey.association: '_OverallChmlCmplncStatus'
      SalesOrderWithoutCharge.OverallChmlCmplncStatus,

      @ObjectModel.foreignKey.association: '_OverallDangerousGoodsStatus'
      SalesOrderWithoutCharge.OverallDangerousGoodsStatus,

      @ObjectModel.foreignKey.association: '_OvrlSftyDataSheetSts'
      SalesOrderWithoutCharge.OverallSafetyDataSheetStatus,

      @ObjectModel.foreignKey.association: '_OvrlTradeCmplncEmbargoStatus'
      SalesOrderWithoutCharge.OverallTrdCmplncEmbargoSts,

      @ObjectModel.foreignKey.association: '_OvTrdCmplncSnctndListChkSts'
      cast(SalesOrderWithoutCharge.OvrlTrdCmplncSnctndListChkSts as totwatchlistscrngchksts preserving type )       as OvrlTrdCmplncSnctndListChkSts,

      @ObjectModel.foreignKey.association: '_OvrlTrdCmplncLegalCtrlChkSts'
      SalesOrderWithoutCharge.OvrlTrdCmplncLegalCtrlChkSts,

      @ObjectModel.foreignKey.association: '_ControllingArea'
      SalesOrderWithoutCharge.ControllingArea,

      SalesOrderWithoutCharge.RequestedDeliveryDate,
      @ObjectModel.foreignKey.association: '_DeliveryDateTypeRule'
      SalesOrderWithoutCharge.DeliveryDateTypeRule,
      @ObjectModel.foreignKey.association: '_ShippingCondition'
      SalesOrderWithoutCharge.ShippingCondition,
      SalesOrderWithoutCharge.CompleteDeliveryIsDefined,
      @ObjectModel.foreignKey.association: '_ShippingType'
      SalesOrderWithoutCharge.ShippingType,

      @ObjectModel.foreignKey.association: '_DeliveryBlockReason'
      SalesOrderWithoutCharge.DeliveryBlockReason,

      @ObjectModel.foreignKey.association: '_HeaderBillingBlockReason'
      SalesOrderWithoutCharge.HeaderBillingBlockReason,

      @ObjectModel.foreignKey.association: '_SlsOrdWthoutChrgApprvlReason'
      SalesOrderWithoutCharge.SlsOrdWthoutChrgApprvlReason,

      @ObjectModel.foreignKey.association: '_IncotermsClassification'
      SalesOrderWithoutCharge.IncotermsClassification,
      //      IncotermsTransferLocation,

      SalesOrderWithoutCharge.IncotermsLocation1,
      SalesOrderWithoutCharge.IncotermsLocation2,
      @ObjectModel.foreignKey.association: '_IncotermsVersion'
      SalesOrderWithoutCharge.IncotermsVersion,

      //      CostCenter,


      SalesOrderWithoutCharge.ReferenceSDDocument,
      SalesOrderWithoutCharge.AccountingDocExternalReference,

      // Status

      @ObjectModel.foreignKey.association: '_OverallSDProcessStatus'
      SalesOrderWithoutCharge.OverallSDProcessStatus,
      @ObjectModel.foreignKey.association: '_OverallSDDocumentRejectionSts'
      SalesOrderWithoutCharge.OverallSDDocumentRejectionSts,

      // Compositions

      _Item,

      // Associations

      SalesOrderWithoutCharge._SalesOrderWithoutChargeType,
      SalesOrderWithoutCharge._OrganizationDivision,
      SalesOrderWithoutCharge._CreatedByUser,
      SalesOrderWithoutCharge._LastChangedByUser,
      SalesOrderWithoutCharge._CustomerGroup,
      SalesOrderWithoutCharge._TransactionCurrency,
      SalesOrderWithoutCharge._IncotermsClassification,
      SalesOrderWithoutCharge._IncotermsVersion,
      SalesOrderWithoutCharge._CustomerPaymentTerms,
      SalesOrderWithoutCharge._OverallDeliveryBlockStatus,
      SalesOrderWithoutCharge._OverallDeliveryStatus,
      SalesOrderWithoutCharge._HdrGeneralIncompletionStatus,
      SalesOrderWithoutCharge._OvrlItmGeneralIncompletionSts,
      SalesOrderWithoutCharge._SalesDocApprovalStatus,
      SalesOrderWithoutCharge._OverallChmlCmplncStatus,
      SalesOrderWithoutCharge._OverallDangerousGoodsStatus,
      SalesOrderWithoutCharge._OvrlSftyDataSheetSts,
      SalesOrderWithoutCharge._OvrlTradeCmplncEmbargoStatus,
      SalesOrderWithoutCharge._OvTrdCmplncSnctndListChkSts,
      SalesOrderWithoutCharge._OvrlTrdCmplncLegalCtrlChkSts,
      SalesOrderWithoutCharge._ControllingArea,
      SalesOrderWithoutCharge._SDDocumentReason,
      SalesOrderWithoutCharge._DeliveryDateTypeRule,
      SalesOrderWithoutCharge._ShippingCondition,
      SalesOrderWithoutCharge._ShippingType,
      SalesOrderWithoutCharge._HeaderBillingBlockReason,
      SalesOrderWithoutCharge._DeliveryBlockReason,
      SalesOrderWithoutCharge._SlsOrdWthoutChrgApprvlReason,
      SalesOrderWithoutCharge._OverallSDProcessStatus,
      SalesOrderWithoutCharge._OverallSDDocumentRejectionSts,
      SalesOrderWithoutCharge._SalesOrganization,
      SalesOrderWithoutCharge._DistributionChannel,
      SalesOrderWithoutCharge._SalesGroup,
      SalesOrderWithoutCharge._SalesOffice,
      SalesOrderWithoutCharge._SalesDistrict,
      SalesOrderWithoutCharge._CustomerPurchaseOrderType

}