SAP ABAP Table ADRSTREET (Streets)
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷ BC-SRV-ADR (Application Component) Address Management/Business Address
⤷ SZRS (Package) SAP Technology - Business Services: Regional Structure
⤷ BC-SRV-ADR (Application Component) Address Management/Business Address
⤷ SZRS (Package) SAP Technology - Business Services: Regional Structure
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | ADRSTREET | Table Relationship Diagram |
Short Description | Streets |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | C | Customizing table, maintenance only by cust., not SAP import |
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | CLIENT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | COUNTRY | LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | T005 | |
3 | STRT_CODE | STRT_CODE | STRT_CODE | CHAR | 12 | 0 | Street Number for City/Street File | ||
4 | .INCLUDE | 0 | 0 | Data part of the table ADRSTREET | |||||
5 | CITY_CODE | CITY_CODE | CITY_CODE | CHAR | 12 | 0 | City Code for City/Street File | ADRCITY | |
6 | CITYP_CODE | CITYP_CODE | CITYP_CODE | CHAR | 8 | 0 | District code for city and street file | ADRCITYPRT | |
7 | STRTYPEAB | STRTYPEAB | STRTYPEAB | CHAR | 2 | 0 | Street type abbreviation | ADRSTRTYPE | |
8 | COMMU_CODE | COMMU_CODE | COMMU_CODE | CHAR | 15 | 0 | Municipality key | ||
9 | REGIOGROUP | REGIOGROUP | REGIOGROUP | CHAR | 8 | 0 | Regional structure grouping | ADRREGGRP | |
10 | TAXJURCODE | AD_TXJCD | AD_TXJCD | CHAR | 15 | 0 | Tax Jurisdiction |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | ADRSTREET | CITYP_CODE | ADRCITYPRT | CITYP_CODE | REF | C | CN |
2 | ADRSTREET | CITY_CODE | ADRCITY | CITY_CODE | REF | 1 | CN |
3 | ADRSTREET | CLIENT | T000 | MANDT | KEY | 1 | CN |
4 | ADRSTREET | COUNTRY | T005 | LAND1 | KEY | 1 | CN |
5 | ADRSTREET | REGIOGROUP | ADRREGGRP | REGIOGROUP | REF | 1 | CN |
6 | ADRSTREET | STRTYPEAB | ADRSTRTYPE | STRTYPEAB | REF | 1 | CN |
History
Last changed by/on | SAP | 20130604 |
SAP Release Created in |