SAP ABAP Table RSPAB1MIET (RE: Partner - Address of Master Tenant and Addit.Fields)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ FVVI (Package) R/3 appl.dev. for Financial Assets Management: Real estate
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ FVVI (Package) R/3 appl.dev. for Financial Assets Management: Real estate
Basic Data
Table Category | INTTAB | Structure |
Structure | RSPAB1MIET | Table Relationship Diagram |
Short Description | RE: Partner - Address of Master Tenant and Addit.Fields |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
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 | .INCLUDE | 0 | 0 | BP Structure: Business Partner - Address | |||||
2 | .INCLUDE | 0 | 0 | BP: Business partner - address | |||||
3 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
4 | PARTNR | BP_PARTNR_OLD | BP_PARTNR | CHAR | 10 | 0 | Business Partner Number | BP000 | |
5 | ADR_REF_K | BP_ADR_REF_OLD | BP_ADR_REF | CHAR | 10 | 0 | Address ID | TP14 | |
6 | ADR_DAT | BP_ADR_DAT | DATUM | DATS | 8 | 0 | Business partner address relationship valid from | ||
7 | .INCLUDE | 0 | 0 | BP: Business Partner - Address Data | |||||
8 | ADRNR | BP_ADRNR_OLD | SADRNR | CHAR | 10 | 0 | Address Number | SANS1 | |
9 | ADDRNUMBER | AD_ADDRNUM | AD_ADDRNUM | CHAR | 10 | 0 | Address number | ADRC | |
10 | ADDRESS_ID | AD_ADDR_ID | AD_ADDR_ID | CHAR | 10 | 0 | (Not supported) Physical address ID | ||
11 | ADR_D_E | BP_ADR_D_E | DATUM | DATS | 8 | 0 | Business Partner Address Relationship Valid Until | ||
12 | ADR_LOC | BP_ADR_LOC | CHAR20 | CHAR | 20 | 0 | Building | ||
13 | FLOOR | BP_FLOOR | CHAR10 | CHAR | 10 | 0 | Floor | ||
14 | ROOM_NR | BP_ROOM_NR | CHAR10 | CHAR | 10 | 0 | Room Number | ||
15 | NAME3 | BP_NAME3 | TEXT40 | CHAR | 40 | 0 | Name 3 | ||
16 | NAME4 | BP_NAME4 | TEXT40 | CHAR | 40 | 0 | Name 4 | ||
17 | NAME_CO | BP_NAME_CO | TEXT40 | CHAR | 40 | 0 | c/o Name | ||
18 | PFACH | PFACH | PFACH | CHAR | 10 | 0 | PO Box | ||
19 | PSTL2 | PSTL2 | PSTLZ | CHAR | 10 | 0 | P.O. Box Postal Code | ||
20 | .INCLUDE | 0 | 0 | BP: Screen Structure Telecommunications Data | |||||
21 | TELF1 | TELF1 | TEXT16 | CHAR | 16 | 0 | First telephone number | ||
22 | TELF2 | TELF2 | TEXT16 | CHAR | 16 | 0 | Second telephone number | ||
23 | TELFX1 | TELFX | TEXT31 | CHAR | 31 | 0 | Fax Number | ||
24 | TELFX2 | TELFX | TEXT31 | CHAR | 31 | 0 | Fax Number | ||
25 | TELBX | TELBX | TEXT15 | CHAR | 15 | 0 | Telebox number | ||
26 | TELX1 | TELX1 | TEXT30 | CHAR | 30 | 0 | Telex number | ||
27 | DATLT | DATLT | TEXT14 | CHAR | 14 | 0 | Data communication line no. | ||
28 | TELTX | TELTX | TEXT30 | CHAR | 30 | 0 | Teletex number | ||
29 | ADSMTP | AD_SMTPADR | AD_SMTPADR | CHAR | 241 | 0 | E-Mail Address | ||
30 | TELNR_CALL1 | AD_TELNRCL | CHAR30 | CHAR | 30 | 0 | Telephone number for determining caller | ||
31 | TELNR_CALL2 | AD_TELNRCL | CHAR30 | CHAR | 30 | 0 | Telephone number for determining caller | ||
32 | .INCLUDE | 0 | 0 | Additional fields for BPDADREF | |||||
33 | .INCLUDE | 0 | 0 | Additional fields for BP030 | |||||
34 | XADR_REF | BP_XADRREF | TEXT40 | CHAR | 40 | 0 | Description of Address ID |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | RSPAB1MIET | ADDRNUMBER | ADRC | ADDRNUMBER | KEY | ||
2 | RSPAB1MIET | ADRNR | SANS1 | ADRNR | 1 | CN | |
3 | RSPAB1MIET | ADR_REF_K | TP14 | ADR_REF | |||
4 | RSPAB1MIET | MANDT | T000 | MANDT | |||
5 | RSPAB1MIET | PARTNR | BP000 | PARTNR |
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in |