I_BPCustomerProcessTP

@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Business Partner Customer Data - TP'
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #XXL,
  dataClass: #TRANSACTIONAL
}
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@Search.searchable: true
define view entity I_BPCustomerProcessTP
  as select from I_BPCustomerProcess

  association        to parent I_BusinessPartnerProcessTP as _BusinessPartner         on  $projection.MasterDataChangeProcess = _BusinessPartner.MasterDataChangeProcess
                                                                                      and $projection.MDChgProcessStep        = _BusinessPartner.MDChgProcessStep
                                                                                      and $projection.MDChgProcessSrceSystem  = _BusinessPartner.MDChgProcessSrceSystem
                                                                                      and $projection.MDChgProcessSrceObject  = _BusinessPartner.MDChgProcessSrceObject

  association [0..1] to I_BPProcessKPIRecordType          as _RecordType              on  $projection.MasterDataChangeProcess = _RecordType.MasterDataChangeProcess
                                                                                      and $projection.MDChgProcessStep        = _RecordType.MDChgProcessStep
                                                                                      and $projection.MDChgProcessSrceSystem  = _RecordType.MDChgProcessSrceSystem
                                                                                      and $projection.MDChgProcessSrceObject  = _RecordType.MDChgProcessSrceObject
  association [0..1] to I_MDChangeProcessKPIRowVH         as _KPIUpdateStatusText     on  $projection.MDChgProcKPIUpdateStatus = _KPIUpdateStatusText.MDChgProcKPIUpdateStatus
  association [0..*] to I_MDChgProcRecordMessages         as _RecordMessages          on  $projection.MasterDataChangeProcess = _RecordMessages.MasterDataChangeProcess
                                                                                      and $projection.MDChgProcessStep        = _RecordMessages.MDChgProcessStep
                                                                                      and $projection.MDChgProcessSrceSystem  = _RecordMessages.MDChgProcessSrceSystem
                                                                                      and $projection.MDChgProcessSrceObject  = _RecordMessages.MDChgProcessSrceObject

  composition [0..*] of I_BPCustomerCompanyProcessTP      as _CustomerCompanyCode
  composition [0..*] of I_BPCustomerTaxIndicatorProcTP    as _CustomerTaxIndicator
  composition [0..*] of I_BPCustomerSalesAreaProcessTP    as _CustomerSalesArea
  composition [0..*] of I_BPCustUnloadingPointProcTP      as _CustomerUnloadingPoint

  association [0..1] to I_CustomerAccountGroup            as _CustomerAccountGroup    on  $projection.CustomerAccountGroup = _CustomerAccountGroup.CustomerAccountGroup
  association [0..1] to I_BusPartAuthorizationGroupTxt    as _AuthorizationGroupText  on  $projection.AuthorizationGroup              = _AuthorizationGroupText.AuthorizationGroup
                                                                                      and _AuthorizationGroupText.AuthorizationObject = 'CUST'
                                                                                      and _AuthorizationGroupText.Language            = $session.system_language
  //association [0..1] to C_OrderIsBlockedTextVHTemp as _OrderIsBlocked on $projection.OrderIsBlockedForCustomer = _OrderIsBlocked.OrderIsBlockedForCustomer

  association [0..1] to I_BillingBlockReason              as _BillingBlockReason      on  $projection.BillingIsBlockedForCustomer = _BillingBlockReason.BillingBlockReason
  association [0..1] to I_Customer                        as _FiscalAddress           on  $projection.FiscalAddress = _FiscalAddress.Customer
  association [0..1] to I_Customer                        as _AlternativePayerAccount on  $projection.AlternativePayerAccount = _AlternativePayerAccount.Customer
  association [0..1] to I_Supplier                        as _Supplier                on  $projection.Supplier = _Supplier.Supplier
  association [0..1] to I_DeliveryBlockReason             as _DeliveryBlockReason     on  $projection.DeliveryIsBlocked = _DeliveryBlockReason.DeliveryBlockReason
  association [0..1] to I_NielsenRegionIdentifier         as _NielsenRegion           on  $projection.NielsenRegion = _NielsenRegion.NielsenRegion
  //  association [0..1] to I_TaxingCounty                 as _County                  on  $projection.Country = _County.Country

  //                                                                                   and $projection.Region  = _County.Region

  //                                                                                   and $projection.County  = _County.TaxingCounty

  //  association [0..1] to I_CityCode                     as _City                    on  $projection.Country = _City.Country

  //                                                                                   and $projection.Region  = _City.Region

  //                                                                                   and $projection.County  = _City.CityCode

  association [0..1] to I_CustomerIndustryCodeVH          as _IndustryCode1           on  $projection.IndustryCode1 = _IndustryCode1.IndustryCode1
  association [0..1] to I_CustomerIndustryCodeVH          as _IndustryCode2           on  $projection.IndustryCode2 = _IndustryCode2.IndustryCode1
  association [0..1] to I_CustomerIndustryCodeVH          as _IndustryCode3           on  $projection.IndustryCode3 = _IndustryCode3.IndustryCode1
  association [0..1] to I_CustomerIndustryCodeVH          as _IndustryCode4           on  $projection.IndustryCode4 = _IndustryCode4.IndustryCode1
  association [0..1] to I_CustomerIndustryCodeVH          as _IndustryCode5           on  $projection.IndustryCode5 = _IndustryCode5.IndustryCode1
  association [0..1] to I_CustFreeDefinedAttribute01      as _Attribute01             on  $projection.FreeDefinedAttribute01 = _Attribute01.FreeDefinedAttribute01
  association [0..1] to I_CustFreeDefinedAttribute02      as _Attribute02             on  $projection.FreeDefinedAttribute02 = _Attribute02.FreeDefinedAttribute02
  association [0..1] to I_CustFreeDefinedAttribute03      as _Attribute03             on  $projection.FreeDefinedAttribute03 = _Attribute03.FreeDefinedAttribute03
  association [0..1] to I_CustFreeDefinedAttribute04      as _Attribute04             on  $projection.FreeDefinedAttribute04 = _Attribute04.FreeDefinedAttribute04
  association [0..1] to I_CustFreeDefinedAttribute05      as _Attribute05             on  $projection.FreeDefinedAttribute05 = _Attribute05.FreeDefinedAttribute05
  association [0..1] to I_CustFreeDefinedAttribute06      as _Attribute06             on  $projection.FreeDefinedAttribute06 = _Attribute06.FreeDefinedAttribute06
  association [0..1] to I_CustFreeDefinedAttribute07      as _Attribute07             on  $projection.FreeDefinedAttribute07 = _Attribute07.FreeDefinedAttribute07
  association [0..1] to I_CustFreeDefinedAttribute08      as _Attribute08             on  $projection.FreeDefinedAttribute08 = _Attribute08.FreeDefinedAttribute08
  association [0..1] to I_CustFreeDefinedAttribute09      as _Attribute09             on  $projection.FreeDefinedAttribute09 = _Attribute09.FreeDefinedAttribute09
  association [0..1] to I_CustFreeDefinedAttribute10      as _Attribute10             on  $projection.FreeDefinedAttribute10 = _Attribute10.FreeDefinedAttribute10
  association [0..1] to I_CustomerConditionGroupVH        as _ConditionGroup1         on  $projection.CustomerConditionGroup1 = _ConditionGroup1.CustomerConditionGroup
  association [0..1] to I_CustomerConditionGroupVH        as _ConditionGroup2         on  $projection.CustomerConditionGroup2 = _ConditionGroup2.CustomerConditionGroup
  association [0..1] to I_CustomerConditionGroupVH        as _ConditionGroup3         on  $projection.CustomerConditionGroup3 = _ConditionGroup3.CustomerConditionGroup
  association [0..1] to I_CustomerConditionGroupVH        as _ConditionGroup4         on  $projection.CustomerConditionGroup4 = _ConditionGroup4.CustomerConditionGroup
  association [0..1] to I_CustomerConditionGroupVH        as _ConditionGroup5         on  $projection.CustomerConditionGroup5 = _ConditionGroup5.CustomerConditionGroup
  association [0..1] to I_DE_DtaMdmExchRecipientCode      as _DataMediumExchange      on  $projection.DataMediumExchangeIndicator = _DataMediumExchange.DataMediumExchangeIndicator
  association [0..1] to I_AccountType                     as _AccountTypeText         on  $projection.ResponsibleType                    = _AccountTypeText.AccountTaxType
                                                                                      and _AccountTypeText.AccountType                   = 'K'
                                                                                      and _AccountTypeText.AccountTaxTypeDescriptionLang = $session.system_language
{
  key MasterDataChangeProcess,
  key MDChgProcessStep,
  key MDChgProcessSrceSystem,
  key MDChgProcessSrceObject,
  key BPAssignmentID,
      @Search.defaultSearchElement: true
      Customer,
      OrderIsBlockedForCustomer,
      ExpressTrainStationName,
      TrainStationName,
      AuthorizationGroup,
      BillingIsBlockedForCustomer,
      FiscalAddress,
      AlternativePayerAccount,
      CustomerCorporateGroup,
      CustomerAccountGroup,
      CustomerClassification,
      Supplier,
      DeliveryIsBlocked,
      DeletionIndicator,
      NielsenRegion,
      County,
      CityCode,
      PostingIsBlocked,
      VATLiability,
      AlternativePayeeIsAllowed,
      IndustryCode1,
      IndustryCode2,
      IndustryCode3,
      IndustryCode4,
      IndustryCode5,
      FreeDefinedAttribute01,
      FreeDefinedAttribute02,
      FreeDefinedAttribute03,
      FreeDefinedAttribute04,
      FreeDefinedAttribute05,
      FreeDefinedAttribute06,
      FreeDefinedAttribute07,
      FreeDefinedAttribute08,
      FreeDefinedAttribute09,
      FreeDefinedAttribute10,
      DataMediumExchangeIndicator,
      CustomerConditionGroup1,
      CustomerConditionGroup2,
      CustomerConditionGroup3,
      CustomerConditionGroup4,
      CustomerConditionGroup5,
      ResponsibleType,
      TaxInvoiceRepresentativeName,
      BusinessType,
      IndustryType,
      MDChgProcessSourceModified,
      MDChgProcessSourceModifBinary,
      MDChgProcSrceLastChgdDateTime,
      cast( case
      when MDChgProcessSourceModified = '' then 'N'
      when MDChgProcessSourceModified = 'X' then 'M'
      else MDChgProcessSourceModified end as mdc_source_modified ) as MDChgProcKPIUpdateStatus,

      DataControllerSet,
      DataController1,
      DataController2,
      DataController3,
      DataController4,
      DataController5,
      DataController6,
      DataController7,
      DataController8,
      DataController9,
      DataController10,

      _BusinessPartner,
      _CustomerCompanyCode,
      _CustomerTaxIndicator,
      _CustomerSalesArea,
      _CustomerUnloadingPoint,
      _RecordType,
      _KPIUpdateStatusText,
      _RecordMessages,
      // Text

      _AuthorizationGroupText,
      _AccountTypeText,
//      Foreign key

      _CustomerAccountGroup,
      //_OrderIsBlocked,

      _BillingBlockReason,
      _FiscalAddress,
      _AlternativePayerAccount,
      _Supplier,
      _DeliveryBlockReason,
      _NielsenRegion,
//      _County,

//      _City,

      _IndustryCode1,
      _IndustryCode2,
      _IndustryCode3,
      _IndustryCode4,
      _IndustryCode5,
      _Attribute01,
      _Attribute02,
      _Attribute03,
      _Attribute04,
      _Attribute05,
      _Attribute06,
      _Attribute07,
      _Attribute08,
      _Attribute09,
      _Attribute10,
      _DataMediumExchange,
      _ConditionGroup1,
      _ConditionGroup2,
      _ConditionGroup3,
      _ConditionGroup4,
      _ConditionGroup5

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BPCUSTOMERPROCESS"
],
"ASSOCIATED":
[
"I_ACCOUNTTYPE",
"I_BILLINGBLOCKREASON",
"I_BPCUSTOMERCOMPANYPROCESSTP",
"I_BPCUSTOMERSALESAREAPROCESSTP",
"I_BPCUSTOMERTAXINDICATORPROCTP",
"I_BPCUSTUNLOADINGPOINTPROCTP",
"I_BPPROCESSKPIRECORDTYPE",
"I_BUSINESSPARTNERPROCESSTP",
"I_BUSPARTAUTHORIZATIONGROUPTXT",
"I_CUSTFREEDEFINEDATTRIBUTE01",
"I_CUSTFREEDEFINEDATTRIBUTE02",
"I_CUSTFREEDEFINEDATTRIBUTE03",
"I_CUSTFREEDEFINEDATTRIBUTE04",
"I_CUSTFREEDEFINEDATTRIBUTE05",
"I_CUSTFREEDEFINEDATTRIBUTE06",
"I_CUSTFREEDEFINEDATTRIBUTE07",
"I_CUSTFREEDEFINEDATTRIBUTE08",
"I_CUSTFREEDEFINEDATTRIBUTE09",
"I_CUSTFREEDEFINEDATTRIBUTE10",
"I_CUSTOMER",
"I_CUSTOMERACCOUNTGROUP",
"I_CUSTOMERCONDITIONGROUPVH",
"I_CUSTOMERINDUSTRYCODEVH",
"I_DELIVERYBLOCKREASON",
"I_DE_DTAMDMEXCHRECIPIENTCODE",
"I_MDCHANGEPROCESSKPIROWVH",
"I_MDCHGPROCRECORDMESSAGES",
"I_NIELSENREGIONIDENTIFIER",
"I_SUPPLIER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/