ICM_PARTNER_ORGANIZATION

DDL: ICM_PARTNER_ORGANIZATION SQL: ICM_PARTNER_ORG Type: view

BusinessPartner_Organization

ICM_PARTNER_ORGANIZATION is a CDS View that provides data about "BusinessPartner_Organization" in SAP S/4HANA. It reads from 5 data sources (adr2, adr6, adrc, but000, but020) and exposes 20 fields with key fields partner, addrnumber, nation, persnumber, consnumber.

5 data source(s) 20 fields

Data Sources (5)

SourceAliasJoin Type
adr2 a2 left_outer
adr6 a6 left_outer
adrc ac inner
but000 b00 from
but020 b20 inner

Annotations (3)

NameValueLevelField
AbapCatalog.sqlViewName ICM_PARTNER_ORG view
AbapCatalog.compiler.compareFilter true view
EndUserText.label BusinessPartner_Organization view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY partner but000 partner
KEY addrnumber adrc addrnumber
KEY nation adrc nation
KEY persnumber adr2 persnumber
KEY consnumber adr2 consnumber
KEY consnumber_1 adr6 consnumber
type but000 type
augrp but000 augrp
name1 adrc name1
name2 adrc name2
name3 adrc name3
name4 adrc name4
city1 adrc city1
post_code1 adrc post_code1
street adrc street
house_num1 adrc house_num1
country adrc country
region adrc region
telnr_long adr2 telnr_long
smtp_addr adr6 smtp_addr 
@AbapCatalog.sqlViewName: 'ICM_PARTNER_ORG'
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'BusinessPartner_Organization'
@ObjectModel.semanticKey: ['addrnumber']

define view ICM_PARTNER_ORGANIZATION
  as select from    but000 as b00
    inner join but020   as b20  on(
       b00.partner = b20.partner
    )
    inner join adrc  as ac  on(
      b20.addrnumber = ac.addrnumber

    )
    left outer join adr2  as a2  on(
      ac.addrnumber = a2.addrnumber

    )
    left outer join adr6  as a6  on(
      ac.addrnumber = a6.addrnumber

    )

{

      key b00.partner,

      key ac.addrnumber as addrnumber,
      key ac.date_from   as date_from_adrc,
      key ac.nation      as nation,

      key a2.persnumber,
      key a2.date_from   as date_from_adr2_adr,
      key a2.consnumber,

      key a6.persnumber  as persnumber_adr6,
      key a6.date_from   as date_from_adr6_adr,
      key a6.consnumber  as consnumber_1,


      b00.type,
      b00.augrp,
      ac.name1,
      ac.name2,
      ac.name3, 
      ac.name4,     
      ac.city1,
      ac.post_code1,
      ac.street,
      ac.house_num1,
      ac.country,
      ac.region,
      a2.telnr_long as telnr_long,
      a6.smtp_addr as smtp_addr

}

// organizations and groups

where b00.type = '2' or
      b00.type = '3' 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ADR2",
"ADR6",
"ADRC",
"BUT000",
"BUT020"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More