SAP ABAP Table ROIFA (screen fields for maintaining business location data)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ OIF (Package) MRN Marketing Retail Networks
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ OIF (Package) MRN Marketing Retail Networks
Basic Data
Table Category | INTTAB | Structure |
Structure | ROIFA | Table Relationship Diagram |
Short Description | screen fields for maintaining business location data |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
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 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | PBLTYP | OIF_PBLTYP | OIF_PBLTYP | CHAR | 4 | 0 | Business Location Type (IS-Oil MRN) | OIFSPBLT | |
3 | PBLNR | OIF_PBLNR | OIF_PBLNR | CHAR | 10 | 0 | Business location identifier (IS-Oil MRN) | * | |
4 | REF_PBLNR | OIF_R_NR | OIF_PBLNR | CHAR | 10 | 0 | Reference service station PBL number | * | |
5 | ADDRNR | OIF_ADNUM | AD_ADDRNUM | CHAR | 10 | 0 | Address No. in ADRC | ADRC | |
6 | REF_PBLTYP | OIF_R_TYP | OIF_PBLTYP | CHAR | 4 | 0 | Reference service station PBL type | OIFSPBLT | |
7 | AN_DAT | OIF_AN_DAT | DATS | DATS | 8 | 0 | Analysis date - business partner listing (IS-Oil MRN) | ||
8 | AN_TIM | OIF_AN_TIM | TIME | TIMS | 6 | 0 | Analysis time - business partner listing (IS-Oil MRN) | ||
9 | AS_DAT | OIF_AS_DAT | DATS | DATS | 8 | 0 | Analysis start date - business partner listing (IS-Oil MRN) | ||
10 | AS_TIM | OIF_AS_TIM | TIME | TIMS | 6 | 0 | Analysis start time - business partner listing (IS-Oil MRN) | ||
11 | AE_DAT | OIF_AE_DAT | DATS | DATS | 8 | 0 | Analysis end date - business partner listing (IS-Oil MRN) | ||
12 | AE_TIM | OIF_AE_TIM | TIME | TIMS | 6 | 0 | Analysis end time - business partner listing (IS-Oil MRN) | ||
13 | BPLMOD | OIF_BPLMOD | OIF_BPLMOD | CHAR | 1 | 0 | List mode - business partner listing (IS-Oil MRN) | ||
14 | BPLMTX | AS4TEXT | AS4TEXT | CHAR | 60 | 0 | Short Description of Repository Objects | ||
15 | SHOBLO | OIF_SHOBLO | XFELD | CHAR | 1 | 0 | Show blocked flag - business partner listing (IS-Oil MRN) | ||
16 | KUNNR | OIF_KUNNR | KUNNR | CHAR | 10 | 0 | Sold-to party | KNA1 | |
17 | NAME1 | OIF_PBNAM1 | CHAR35 | CHAR | 35 | 0 | Internal name field | ||
18 | LFIRST | OIF_LFIRST | OIF_LFIRST | NUMC | 3 | 0 | List no. of first line in screen loop | ||
19 | LTOTAL | OIF_LTOTAL | OIF_LTOTAL | NUMC | 3 | 0 | Total number of lines in generated list | ||
20 | CITY1 | AD_CITY1 | TEXT40 | CHAR | 40 | 0 | City | ||
21 | POST_CODE1 | AD_PSTCD1 | CHAR10 | CHAR | 10 | 0 | City postal code | ||
22 | LFIRSTPROJ | OIF_LFIRST | OIF_LFIRST | NUMC | 3 | 0 | List no. of first line in screen loop | ||
23 | LTOTALPROJ | OIF_LTOTAL | OIF_LTOTAL | NUMC | 3 | 0 | Total number of lines in generated list | ||
24 | LFIRSTCOAS | OIF_LFIRST | OIF_LFIRST | NUMC | 3 | 0 | List no. of first line in screen loop | ||
25 | LTOTALCOAS | OIF_LTOTAL | OIF_LTOTAL | NUMC | 3 | 0 | Total number of lines in generated list | ||
26 | TTMDAT | OIF_TTMDAT | DATS | DATS | 8 | 0 | Partner role validity period - end date (IS-Oil MRN) | ||
27 | TTMTIM | OIF_TTMTIM | TIME | TIMS | 6 | 0 | Partner role validity period - end time (IS-Oil MRN) | ||
28 | CLDAT | OIF_CLDAT | DATS | DATS | 8 | 0 | Business location close date | ||
29 | CLTIM | OIF_CLTIM | TIME | TIMS | 6 | 0 | Business location close time | ||
30 | TEXTLINE1 | TEXT80 | TEXT80UEB | CHAR | 80 | 0 | Text (80 Characters) | ||
31 | TEXTLINE2 | TEXT80 | TEXT80UEB | CHAR | 80 | 0 | Text (80 Characters) |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | ROIFA | ADDRNR | ADRC | ADDRNUMBER | |||
2 | ROIFA | KUNNR | KNA1 | KUNNR | 1 | CN | |
3 | ROIFA | MANDT | T000 | MANDT | 1 | CN | |
4 | ROIFA | PBLTYP | OIFSPBLT | PBLTYP | 1 | 1 | |
5 | ROIFA | REF_PBLTYP | OIFSPBLT | PBLTYP | 1 | 1 |
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in |