CNVTDMS_11_SCADR

Scrambling Addresses | #other | #language | Component: Landscape Transformation
Column Name Description
CLIENT FK Client
ADDRNUMBER Address Number
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
TITLE Form-of-Address Key AD_TITLE
NAME1 Name 1 TEXT40
NAME2 Name 2 TEXT40
NAME3 Name 3 TEXT40
NAME4 Name 4 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
PO_BOX PO Box CHAR10
PO_BOX_LOC PO Box city TEXT40
PO_BOX_REG Region for PO Box (Country/Region, State, Province, ...) REGIO
PO_BOX_CTY PO Box of Country/Region LAND1
POSTALAREA (Not Supported) Post Delivery District TEXT15
STREET Street TEXT60
HOUSE_NUM1 House Number TEXT10
LANGU Language Key SPRAS
SORT1 Search Term 1 CHAR20
SORT2 Search Term 2 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
TAXJURCODE Tax Jurisdiction AD_TXJCD
SMTP_ADDR E-Mail Address AD_SMTPADR
Master Data Relations Join Conditions
Client CNVTDMS_11_SCADR.CLIENT == T000.MANDT
Country/Region Key
  • Country/Region Key
  • Client
  • CNVTDMS_11_SCADR.COUNTRY == T005.LAND1
  • CNVTDMS_11_SCADR.CLIENT == T005.MANDT
Region (State, Province, County)
  • PO Box of Country/Region
  • Region (State, Province, County)
  • CNVTDMS_11_SCADR.CLIENT == T005S.MANDT
  • CNVTDMS_11_SCADR.PO_BOX_CTY == T005S.LAND1
  • CNVTDMS_11_SCADR.REGION == T005S.BLAND