I_SalesOrderRequestSource

@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'ISORS'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl: {
  authorizationCheck: #CHECK
//  privilegedAssociations: [ '_CreatedByUser', '_LastChangedByUser']

}
@EndUserText.label: 'Sales Order Request Source'
@ObjectModel:{
  representativeKey: 'SalesOrderRequest',
  usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #C,
     sizeCategory:   #L
   }
}
@VDM: {
  viewType: #BASIC
}
define view I_SalesOrderRequestSource
  as select from sdsls_sor_src as SalesOrderRequestSource
  association [0..1] to I_Currency                      as _TransactionCurrency on $projection.TransactionCurrency = _TransactionCurrency.Currency
  association [0..1] to I_SalesOrderRequest             as _SalesOrderRequest   on $projection.SalesOrderRequest = _SalesOrderRequest.SalesOrderRequest
  association [0..*] to I_SalesOrderRequestSourceImage  as _SourceImage         on $projection.SalesOrderRequest = _SourceImage.SalesOrderRequest
{
      //      @ObjectModel.foreignKey.association: '_SalesOrderRequest'

  key SalesOrderRequestSource.salesorderrequest              as SalesOrderRequest,

      SalesOrderRequestSource.masterdatadeterminationstatus  as MasterDataDeterminationStatus,
      SalesOrderRequestSource.languageisocode                as LanguageISOCode,
      SalesOrderRequestSource.purchaseorderbycustomer        as PurchaseOrderByCustomer,
      SalesOrderRequestSource.customerpurchaseorderdate      as CustomerPurchaseOrderDate,
      SalesOrderRequestSource.extractedrequesteddeliverydate as ExtractedRequestedDeliveryDate,
      SalesOrderRequestSource.customerpaymenttermstext       as CustomerPaymentTermsText,
      SalesOrderRequestSource.customerincotermstext          as CustomerIncotermsText,
      SalesOrderRequestSource.extractedsupplier              as ExtractedSupplier,
      SalesOrderRequestSource.currencyisocode                as CurrencyISOCode,
      @Semantics.currencyCode: true
      @ObjectModel.foreignKey.association: '_TransactionCurrency'
      SalesOrderRequestSource.transactioncurrency            as TransactionCurrency,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      SalesOrderRequestSource.customertotalnetamount         as CustomerTotalNetAmount,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      SalesOrderRequestSource.customersubtotalamount         as CustomerSubtotalAmount,


      SalesOrderRequestSource.soldtopartyaddressfullname     as SoldToPartyAddressFullName,
      SalesOrderRequestSource.soldtopartyname                as SoldToPartyName,
      SalesOrderRequestSource.soldtopartyadditionalname      as SoldToPartyAdditionalName,
      SalesOrderRequestSource.soldtopartypostalcode          as SoldToPartyPostalCode,
      SalesOrderRequestSource.soldtopartyhousenumber         as SoldToPartyHouseNumber,
      SalesOrderRequestSource.soldtopartystreetname          as SoldToPartyStreetName,
      SalesOrderRequestSource.soldtopartydistrictname        as SoldToPartyDistrictName,
      SalesOrderRequestSource.soldtopartycityname            as SoldToPartyCityName,
      SalesOrderRequestSource.soldtopartyregionname          as SoldToPartyRegionName,
      SalesOrderRequestSource.soldtopartycountryname         as SoldToPartyCountryName,
      SalesOrderRequestSource.soldtopartytelephonenumber     as SoldToPartyTelephoneNumber,
      SalesOrderRequestSource.soldtopartyfaxnumber           as SoldToPartyFaxNumber,
      SalesOrderRequestSource.soldtopartyemailaddress        as SoldToPartyEmailAddress,
      SalesOrderRequestSource.soldtopartytaxregisternumber   as SoldToPartyTaxRegisterNumber,
      SalesOrderRequestSource.soldtopartytaxnumber           as SoldToPartyTaxNumber,
      SalesOrderRequestSource.soldtopartybankaccount         as SoldToPartyBankAccount,
      SalesOrderRequestSource.soldtopartyiban                as SoldToPartyIBAN,
      SalesOrderRequestSource.soldtopartyextrefid            as SoldToPartyExtRefID,


      SalesOrderRequestSource.shiptopartyaddressfullname     as ShipToPartyAddressFullName,
      SalesOrderRequestSource.shiptopartyname                as ShipToPartyName,
      SalesOrderRequestSource.shiptopartyadditionalname      as ShipToPartyAdditionalName,
      SalesOrderRequestSource.shiptopartypostalcode          as ShipToPartyPostalCode,
      SalesOrderRequestSource.shiptopartyhousenumber         as ShipToPartyHouseNumber,
      SalesOrderRequestSource.shiptopartystreetname          as ShipToPartyStreetName,
      SalesOrderRequestSource.shiptopartydistrictname        as ShipToPartyDistrictName,
      SalesOrderRequestSource.shiptopartycityname            as ShipToPartyCityName,
      SalesOrderRequestSource.shiptopartyregionname          as ShipToPartyRegionName,
      SalesOrderRequestSource.shiptopartycountryname         as ShipToPartyCountryName,
      SalesOrderRequestSource.shiptopartytelephonenumber     as ShipToPartyTelephoneNumber,
      SalesOrderRequestSource.shiptopartyfaxnumber           as ShipToPartyFaxNumber,
      SalesOrderRequestSource.shiptopartyemailaddress        as ShipToPartyEmailAddress,

      //Determination Strategy and Determined values

      SalesOrderRequestSource.detnstrategyforsoldtoparty     as DetnStrategyForSoldToParty,
      SalesOrderRequestSource.determinedsoldtoparty          as DeterminedSoldToParty,
      SalesOrderRequestSource.detnstrategyforshiptoparty     as DetnStrategyForShipToParty,
      SalesOrderRequestSource.determinedshiptoparty          as DeterminedShipToParty,
      SalesOrderRequestSource.detnstrategyforsalesarea       as DetnStrategyForSalesArea,
      SalesOrderRequestSource.determinedsalesorganization    as DeterminedSalesOrganization,
      SalesOrderRequestSource.determineddistributionchannel  as DeterminedDistributionChannel,
      SalesOrderRequestSource.determineddivision             as DeterminedDivision,
      SalesOrderRequestSource.aifmessageuuid                 as AIFMessageUUID,

      _SalesOrderRequest,
      _TransactionCurrency,
      _SourceImage

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"SDSLS_SOR_SRC"
],
"ASSOCIATED":
[
"I_CURRENCY",
"I_SALESORDERREQUEST",
"I_SALESORDERREQUESTSOURCEIMAGE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/