I_BUSPARTSCRIPTEDGRPADDRPROC
Bus Partner Group Addr Vers in Process
I_BUSPARTSCRIPTEDGRPADDRPROC is a CDS View in S/4HANA. Bus Partner Group Addr Vers in Process. It contains 7 fields. 4 CDS views read from this table.
CDS Views using this table (4)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_BPScrGrpAddrProcessChanges | view | from | TRANSACTIONAL | BP Grp Address Version Process Changes |
| I_BPScrGrpAddrProcessChanges | view | union_all | TRANSACTIONAL | BP Grp Address Version Process Changes |
| I_BusPartScriptedGrpAddrGov | view_entity | from | BASIC | Bus Part Grp Addr Vers Gov TP |
| I_BusPartScriptedGrpAddrProcTP | view_entity | from | TRANSACTIONAL | Bus Part Grp Addr Vers Proc - TP |
Fields (7)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | AddressNumber | AddressNumber | 1 |
| KEY | AddressRepresentationCode | AddressRepresentationCode | 1 |
| KEY | MasterDataChangeProcess | MasterDataChangeProcess | 1 |
| KEY | MDChgProcessSrceObject | MDChgProcessSrceObject | 1 |
| KEY | MDChgProcessSrceSystem | MDChgProcessSrceSystem | 1 |
| KEY | MDChgProcessStep | MDChgProcessStep | 1 |
| MDChgProcessSourceModified | MDChgProcessSourceModified | 1 |
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Bus Partner Group Addr Vers in Process'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
serviceQuality: #X,
sizeCategory: #S,
dataClass: #MIXED
}
@VDM.viewType: #BASIC
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
define view entity I_BusPartScriptedGrpAddrProc
as select from but020_prc
inner join but_adrc_prc on but020_prc.process_id = but_adrc_prc.process_id
and but020_prc.process_step_no = but_adrc_prc.process_step_no
and but020_prc.source_system = but_adrc_prc.source_system
and but020_prc.source_id = but_adrc_prc.source_id
and but020_prc.source_addrnumber = but_adrc_prc.source_addrnumber
association [1..1] to I_BusinessPartnerProcess as _BusinessPartner on but020_prc.process_id = _BusinessPartner.MasterDataChangeProcess
and but020_prc.process_step_no = _BusinessPartner.MDChgProcessStep
and but020_prc.source_system = _BusinessPartner.MDChgProcessSrceSystem
and but020_prc.source_id = _BusinessPartner.MDChgProcessSrceObject
association [0..1] to I_BusPartProtectedAddressProc as _BPProtectedAddress on but020_prc.process_id = _BPProtectedAddress.MasterDataChangeProcess
and but020_prc.process_step_no = _BPProtectedAddress.MDChgProcessStep
and but020_prc.source_system = _BPProtectedAddress.MDChgProcessSrceSystem
and but020_prc.source_id = _BPProtectedAddress.MDChgProcessSrceObject
and but020_prc.source_addrnumber = _BPProtectedAddress.AddressNumber
{
key but020_prc.process_id as MasterDataChangeProcess,
key but020_prc.process_step_no as MDChgProcessStep,
key but020_prc.source_system as MDChgProcessSrceSystem,
key but020_prc.source_id as MDChgProcessSrceObject,
key but020_prc.source_addrnumber as AddressNumber,
key but_adrc_prc.nation as AddressRepresentationCode,
but020_prc.partner as BusinessPartner,
but020_prc.xdfadr as StandardUsage,
but020_prc.address_guid as BusinessPartnerAddressUUID,
but020_prc.addr_valid_from as ValidityStartDate,
but020_prc.addr_valid_to as ValidityEndDate,
//but_adrc_prc
but_adrc_prc.title as FormOfAddress,
but_adrc_prc.name1 as BusinessPartnerName1,
but_adrc_prc.name2 as BusinessPartnerName2,
but_adrc_prc.name3 as BusinessPartnerName3,
but_adrc_prc.name4 as BusinessPartnerName4,
but_adrc_prc.name_co as CareOfName,
cast(substring(replace(concat(but_adrc_prc.name1, concat(' &@', but_adrc_prc.name2)), '&@', ''),1,80)
as bu_name1tx ) as FullName,
but_adrc_prc.city1 as CityName,
but_adrc_prc.city2 as DistrictName,
but_adrc_prc.city_code as CityNumber,
but_adrc_prc.home_city as HomeCityName,
but_adrc_prc.chckstatus as CityFileTestStatus,
but_adrc_prc.post_code1 as PostalCode,
but_adrc_prc.post_code2 as POBoxPostalCode,
but_adrc_prc.post_code3 as CompanyPostalCode,
but_adrc_prc.po_box as POBox,
but_adrc_prc.dont_use_p as AddressPostBoxUnusable,
but_adrc_prc.po_box_num as POBoxIsWithoutNumber,
but_adrc_prc.po_box_loc as POBoxDeviatingCityName,
but_adrc_prc.po_box_reg as POBoxDeviatingRegion,
but_adrc_prc.po_box_cty as POBoxDeviatingCountry,
but_adrc_prc.transpzone as TransportZone,
but_adrc_prc.street as StreetName,
but_adrc_prc.dont_use_s as AddressStreetUnusable,
but_adrc_prc.house_num1 as HouseNumber,
but_adrc_prc.house_num2 as HouseNumberSupplementText,
but_adrc_prc.str_suppl1 as StreetPrefixName,
but_adrc_prc.str_suppl2 as AdditionalStreetPrefixName,
but_adrc_prc.str_suppl3 as StreetSuffixName,
but_adrc_prc.location as AdditionalStreetSuffixName,
but_adrc_prc.building as Building,
but_adrc_prc.floor as Floor,
but_adrc_prc.roomnumber as RoomNumber,
but_adrc_prc.country as Country,
but_adrc_prc.langu as CorrespondenceLanguage,
but_adrc_prc.region as Region,
but_adrc_prc.sort1 as SearchTerm1,
but_adrc_prc.sort2 as SearchTerm2,
but_adrc_prc.deflt_comm as PrfrdCommMediumType,
but_adrc_prc.tel_number as PhoneNumber,
but_adrc_prc.fax_number as AddressFaxNumber,
but_adrc_prc.mc_city1 as CitySearch,
but_adrc_prc.mc_street as StreetSearch,
but_adrc_prc.time_zone as AddressTimeZone,
but_adrc_prc.taxjurcode as TaxJurisdiction,
but_adrc_prc.po_box_lobby as POBoxLobbyName,
but_adrc_prc.deli_serv_type as DeliveryServiceTypeCode,
but_adrc_prc.deli_serv_number as DeliveryServiceNumber,
but_adrc_prc.county_code as CountyCode,
but_adrc_prc.county as BPCountyText,
but_adrc_prc.source_modified as MDChgProcessSourceModified,
but_adrc_prc.source_modification_blip as MDChgProcessSourceModifBinary,
but020_prc.source_modification_blip as MDChgProcessSourceModif2Binary,
but_adrc_prc.source_recency as MDChgProcSrceLastChgdDateTime,
_BusinessPartner,
_BPProtectedAddress
}
where
_BusinessPartner.BusinessPartnerCategory = '3'
and but_adrc_prc.nation != ''