1. Home
  2. Resources
  3. SAP Tables
  4. ROIFA - screen fields for maintaining business location data

SAP Table ROIFA

screen fields for maintaining business location data

ROIFA (screen fields for maintaining business location data) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link ROIFA to other SAP tables.

ROIFA table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
PBLTYP Business Location Type (IS-Oil MRN) OIF_PBLTYP OIFSPBLT CHAR 4 0
PBLNR Business location identifier (IS-Oil MRN) OIF_PBLNR CHAR 10 0
REF_PBLNR Reference service station PBL number OIF_R_NR CHAR 10 0
ADDRNR Address No. in ADRC OIF_ADNUM ADRC CHAR 10 0
REF_PBLTYP Reference service station PBL type OIF_R_TYP OIFSPBLT CHAR 4 0
AN_DAT Analysis date - business partner listing (IS-Oil MRN) OIF_AN_DAT DATS 8 0
AN_TIM Analysis time - business partner listing (IS-Oil MRN) OIF_AN_TIM TIMS 6 0
AS_DAT Analysis start date - business partner listing (IS-Oil MRN) OIF_AS_DAT DATS 8 0
AS_TIM Analysis start time - business partner listing (IS-Oil MRN) OIF_AS_TIM TIMS 6 0
AE_DAT Analysis end date - business partner listing (IS-Oil MRN) OIF_AE_DAT DATS 8 0
AE_TIM Analysis end time - business partner listing (IS-Oil MRN) OIF_AE_TIM TIMS 6 0
BPLMOD List mode - business partner listing (IS-Oil MRN) OIF_BPLMOD CHAR 1 0
1 Active
2 All
3 Select
BPLMTX Short Description of Repository Objects AS4TEXT CHAR 60 0
SHOBLO Show blocked flag - business partner listing (IS-Oil MRN) OIF_SHOBLO CHAR 1 0
X Yes
NULL No
KUNNR Sold-to party OIF_KUNNR KNA1 CHAR 10 0
NAME1 Internal name field OIF_PBNAM1 CHAR 35 0
LFIRST List no. of first line in screen loop OIF_LFIRST NUMC 3 0
LTOTAL Total number of lines in generated list OIF_LTOTAL NUMC 3 0
CITY1 City AD_CITY1 CHAR 40 0
POST_CODE1 City postal code AD_PSTCD1 CHAR 10 0
LFIRSTPROJ List no. of first line in screen loop OIF_LFIRST NUMC 3 0
LTOTALPROJ Total number of lines in generated list OIF_LTOTAL NUMC 3 0
LFIRSTCOAS List no. of first line in screen loop OIF_LFIRST NUMC 3 0
LTOTALCOAS Total number of lines in generated list OIF_LTOTAL NUMC 3 0
TTMDAT Partner role validity period - end date (IS-Oil MRN) OIF_TTMDAT DATS 8 0
TTMTIM Partner role validity period - end time (IS-Oil MRN) OIF_TTMTIM TIMS 6 0
CLDAT Business location close date OIF_CLDAT DATS 8 0
CLTIM Business location close time OIF_CLTIM TIMS 6 0
TEXTLINE1 Text (80 Characters) TEXT80 CHAR 80 0
TEXTLINE2 Text (80 Characters) TEXT80 CHAR 80 0

ROIFA foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
ROIFA ADDRNR * ADRC Addresses (Business Address Services) NATION
ROIFA ADDRNR ROIFA MANDT ADRC Addresses (Business Address Services) CLIENT
ROIFA ADDRNR ROIFA ADDRNR ADRC Addresses (Business Address Services) ADDRNUMBER
ROIFA ADDRNR * ADRC Addresses (Business Address Services) DATE_FROM
ROIFA KUNNR ROIFA MANDT KNA1 General Data in Customer Master MANDT
ROIFA KUNNR ROIFA KUNNR KNA1 General Data in Customer Master KUNNR
ROIFA MANDT ROIFA MANDT T000 Clients MANDT
ROIFA PBLTYP ROIFA MANDT OIFSPBLT Physical Business Location Type MANDT
ROIFA PBLTYP ROIFA PBLTYP OIFSPBLT Physical Business Location Type PBLTYP
ROIFA REF_PBLTYP ROIFA MANDT OIFSPBLT Physical Business Location Type MANDT
ROIFA REF_PBLTYP ROIFA REF_PBLTYP OIFSPBLT Physical Business Location Type PBLTYP