P_CN_CADEOrganizationName

CADE Organization Name | view: PCADEORGNAME | Extraction: Not supported | Component: Golden Audit Interface China
Tables used: ADRC, BUT020
Column Name Description
Column Name Description
Column Name Description
Column Name Description
date_from Valid-from date - in current Release only 00010101 possible
date_to Valid-to date in current Release only 99991231 possible
_dataaging Data Filter Value for Data Aging
Column Name Description
chckstatus City file test status Show values
po_box_num Flag: PO Box Without Number Show values
flaggroups Flag: There are more address group assignments Show values
pers_addr Flag: This is a personal address Show values
flagcomm2 Flag: Telephone number(s) defined Show values
flagcomm3 Flag: Fax number(s) defined Show values
flagcomm4 Flag: Teletex number(s) defined Show values
flagcomm5 Flag: Telex number(s) defined Show values
flagcomm6 Flag: E-mail address(es) defined Show values
flagcomm7 Flag: RML (remote mail) addresse(s) defined Show values
flagcomm8 Flag: X.400 addresse(s) defined Show values
flagcomm9 Flag: RFC destination(s) defined Show values
flagcomm10 Flag: Printer defined Show values
flagcomm11 Flag: SSF defined Show values
flagcomm12 Flag: URI/FTP address defined Show values
flagcomm13 Flag: Pager address defined Show values
uuid_belated Indicator: UUID created later Show values
id_category Category of an Address ID Show values
adrc_err_status Error Status of Address Show values
xpcpt Business Purpose Completed Flag Show values
Column Name Description Domain name
addrnumber Address Number AD_ADDRNUM
name1 Name 1 TEXT40
name2 Name 2 TEXT40
name3 Name 3 TEXT40
name4 Name 4 TEXT40
name_text Converted name field (with form of address) TEXT50
name_co c/o name TEXT40
city1 City TEXT40
city2 District TEXT40
home_city City (different from postal city) TEXT40
post_code1 City postal code CHAR10
post_code2 PO Box Postal Code CHAR10
post_code3 Company Postal Code (for Large Customers) CHAR10
pcode1_ext (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code CHAR10
pcode2_ext (Not Supported) PO Box Postal Code Extension CHAR10
pcode3_ext (Not Supported) Major Customer Postal Code Extension CHAR10
po_box PO Box CHAR10
po_box_loc PO Box city TEXT40
postalarea (Not Supported) Post Delivery District TEXT15
street Street TEXT60
house_num1 House Number TEXT10
house_num2 House number supplement TEXT10
house_num3 (Not supported) House Number Range TEXT10
str_suppl1 Street 2 TEXT40
str_suppl2 Street 3 TEXT40
str_suppl3 Street 4 TEXT40
location Street 5 TEXT40
building Building (Number or Code) TEXT20
floor Floor in building TEXT10
roomnumber Room or Apartment Number TEXT10
sort1 Search Term 1 CHAR20
sort2 Search Term 2 CHAR20
sort_phn (Not Supported) Phonetic Search Sort Field CHAR20
tel_number First telephone no.: dialling code+number CHAR30
tel_extens First Telephone No.: Extension CHAR10
fax_number First Fax No.: Area Code + Number CHAR30
fax_extens First fax no.: extension CHAR10
mc_name1 Name (Field NAME1) in Uppercase for Search Help CHAR25
mc_city1 City name in Uppercase for Search Help CHAR25
mc_street Street Name in Uppercase for Search Help CHAR25
extension1 Extension (only for data conversion) (e.g. data line) TEXT40
extension2 Extension (only for data conversion) (e.g. telebox) TEXT40
taxjurcode Tax Jurisdiction AD_TXJCD
address_id (Not supported) Physical address ID AD_ADDR_ID
langu_crea Address record creation original language SPRAS
adrc_uuid UUID Used in the Address SYSUUID
po_box_lobby PO Box Lobby TEXT40
deli_serv_number Number of Delivery Service CHAR10
county_code County code for county CNTY_CODE
county County TEXT40
township_code Township code for Township TWSHP_CODE
township Township TEXT40
mc_county County name in upper case for search help CHAR25
mc_township Township name in upper case for search help CHAR25
duns Dun & Bradstreet number (DUNS) CHAR9
dunsp4 DUNS+4 number (the last four digit) CHAR4
OrganizationName null
Master Data Relations Join Conditions
Source of address data
  • (Not Supported) Address Data Source (Key)
  • Client
  • P_CN_CADEORGANIZATIONNAME.ADDRORIGIN == TSAD6.ORIGIN
  • P_CN_CADEORGANIZATIONNAME.MANDT == TSAD6.CLIENT
Address group P_CN_CADEORGANIZATIONNAME.ADDR_GROUP == TSAD7.ADDR_GROUP
Different city for city/street file
  • Different city for city/street file
  • Client
  • Country/Region Key
  • P_CN_CADEORGANIZATIONNAME.CITYH_CODE == ADRCITY.CITY_CODE
  • P_CN_CADEORGANIZATIONNAME.MANDT == ADRCITY.CLIENT
  • P_CN_CADEORGANIZATIONNAME.COUNTRY == ADRCITY.COUNTRY
City code for city/street file
  • City code for city/street file
  • Client
  • Country/Region Key
  • P_CN_CADEORGANIZATIONNAME.CITY_CODE == ADRCITY.CITY_CODE
  • P_CN_CADEORGANIZATIONNAME.MANDT == ADRCITY.CLIENT
  • P_CN_CADEORGANIZATIONNAME.COUNTRY == ADRCITY.COUNTRY
City PO box code (City file)
  • City PO box code (City file)
  • Client
  • ?
  • P_CN_CADEORGANIZATIONNAME.CITY_CODE2 == ADRCITY.CITY_CODE
  • P_CN_CADEORGANIZATIONNAME.MANDT == ADRCITY.CLIENT
  • P_CN_CADEORGANIZATIONNAME.[column in domain "LAND1"] == ADRCITY.COUNTRY
Country key
  • Client
  • Country/Region Key
  • P_CN_CADEORGANIZATIONNAME.MANDT == T005.MANDT
  • P_CN_CADEORGANIZATIONNAME.COUNTRY == T005.LAND1
Communication Method P_CN_CADEORGANIZATIONNAME.DEFLT_COMM == TSAC.COMM_TYPE
Address Delivery service type text table
  • ?
  • Type of Delivery Service
  • P_CN_CADEORGANIZATIONNAME.[column in domain "SYMANDT"] == ADDRC_DELI_SERV.CLIENT
  • P_CN_CADEORGANIZATIONNAME.DELI_SERV_TYPE == ADDRC_DELI_SERV.DELI_SERV_TYPE
Non-Delivery Reason
  • Client
  • PO Box Address Undeliverable Flag
  • P_CN_CADEORGANIZATIONNAME.MANDT == TSAD12.CLIENT
  • P_CN_CADEORGANIZATIONNAME.DONT_USE_P == TSAD12.UNDELIVER
Non-Delivery Reason
  • Client
  • Street Address Undeliverable Flag
  • P_CN_CADEORGANIZATIONNAME.MANDT == TSAD12.CLIENT
  • P_CN_CADEORGANIZATIONNAME.DONT_USE_S == TSAD12.UNDELIVER
Language key P_CN_CADEORGANIZATIONNAME.LANGU == T002.SPRAS
Version ID for International Addresses P_CN_CADEORGANIZATIONNAME.NATION == TSADV.NATION
Business Partner Number
  • Business Partner Number
  • Client
  • P_CN_CADEORGANIZATIONNAME.PARTNER == BUT000.PARTNER
  • P_CN_CADEORGANIZATIONNAME.MANDT == BUT000.CLIENT
PO Box of Country/Region
  • PO Box of Country/Region
  • Client
  • P_CN_CADEORGANIZATIONNAME.PO_BOX_CTY == T005.LAND1
  • P_CN_CADEORGANIZATIONNAME.MANDT == T005.MANDT
Region for PO Box (Country/Region, State, Province, ...)
  • PO Box of Country/Region
  • Region for PO Box (Country/Region, State, Province, ...)
  • Client
  • P_CN_CADEORGANIZATIONNAME.PO_BOX_CTY == T005S.LAND1
  • P_CN_CADEORGANIZATIONNAME.PO_BOX_REG == T005S.BLAND
  • P_CN_CADEORGANIZATIONNAME.MANDT == T005S.MANDT
Regional structure grouping
  • Client
  • Regional structure grouping
  • P_CN_CADEORGANIZATIONNAME.MANDT == ADRREGGRP.CLIENT
  • P_CN_CADEORGANIZATIONNAME.REGIOGROUP == ADRREGGRP.REGIOGROUP
Region code
  • Client
  • Region (State, Province, County)
  • Country/Region Key
  • P_CN_CADEORGANIZATIONNAME.MANDT == T005S.MANDT
  • P_CN_CADEORGANIZATIONNAME.REGION == T005S.BLAND
  • P_CN_CADEORGANIZATIONNAME.COUNTRY == T005S.LAND1
(Not Supported) Abbreviation of Street Name
  • Client
  • Country/Region Key
  • (Not Supported) Abbreviation of Street Name
  • P_CN_CADEORGANIZATIONNAME.MANDT == ADRSTRTYPE.CLIENT
  • P_CN_CADEORGANIZATIONNAME.COUNTRY == ADRSTRTYPE.COUNTRY
  • P_CN_CADEORGANIZATIONNAME.STREETABBR == ADRSTRTYPE.STRTYPEAB
Street Number for City/Street File
  • Client
  • Street Number for City/Street File
  • Country/Region Key
  • P_CN_CADEORGANIZATIONNAME.MANDT == ADRSTREET.CLIENT
  • P_CN_CADEORGANIZATIONNAME.STREETCODE == ADRSTREET.STRT_CODE
  • P_CN_CADEORGANIZATIONNAME.COUNTRY == ADRSTREET.COUNTRY
Address time zone
  • Client
  • Address time zone
  • P_CN_CADEORGANIZATIONNAME.MANDT == TTZZ.CLIENT
  • P_CN_CADEORGANIZATIONNAME.TIME_ZONE == TTZZ.TZONE
Form-of-Address Key
  • Client
  • Form-of-Address Key
  • P_CN_CADEORGANIZATIONNAME.MANDT == TSAD3.CLIENT
  • P_CN_CADEORGANIZATIONNAME.TITLE == TSAD3.TITLE
Transportation zone to or from which the goods are delivered
  • Transportation zone to or from which the goods are delivered
  • Client
  • Country/Region Key
  • P_CN_CADEORGANIZATIONNAME.TRANSPZONE == TZONE.ZONE1
  • P_CN_CADEORGANIZATIONNAME.MANDT == TZONE.MANDT
  • P_CN_CADEORGANIZATIONNAME.COUNTRY == TZONE.LAND1
Other Relations | to Master Data Relations ↑ Join Conditions
District code for City and Street file
  • City code for city/street file
  • Client
  • District code for City and Street file
  • Country/Region Key
  • P_CN_CADEORGANIZATIONNAME.CITY_CODE == ADRCITYPRT.CITY_CODE
  • P_CN_CADEORGANIZATIONNAME.MANDT == ADRCITYPRT.CLIENT
  • P_CN_CADEORGANIZATIONNAME.CITYP_CODE == ADRCITYPRT.CITYP_CODE
  • P_CN_CADEORGANIZATIONNAME.COUNTRY == ADRCITYPRT.COUNTRY