TablesTCodes

OIFSPBL

Physical Location - Master Data

SAP ECC

Table Content Language:

🇺🇸English

Get Pro Pass to select language

OIFSPBL (Physical Location - Master Data) is a transparent table in SAP ERP ECC 6.0 EHP8 systems. It is part of the LO (Logistics - General) Module and is located in the OILF (IS-Oil Marketing Retail Network MRN (standard objects)) package.

Below is the full application component hierarchy path of the table. By selecting any node, you can navigate through the hierarchy and view all elements of the respective node.

After the hierarchy path, you can find the technical details of the table, including the fields, field descriptions, data elements, checktables, domains, datatypes, field lengths, decimals, and possible standard values. The key fields are marked with a key icon and are highlighted.

Loading hierarchy path...

Table Metadata

Table Name

OIFSPBL

Table Description

Physical Location - Master Data

Table Type

Transparent

	#	Field	Description	Data Element	Checktable	Domain	Datatype	Length	Decimals
	1	MANDT	Client	MANDT	T000	MANDT	CLNT	000003	000000
	2	PBLNR	Business location identifier (IS-Oil MRN)	OIF_PBLNR	OIFSPBL	OIF_PBLNR	CHAR	000010	000000
	3	NAME1	Internal name field	OIF_PBNAM1		CHAR35	CHAR	000035	000000
	4	A1_SGRNDB	Land Register Number (IS-Oil MRN Demo APPEND)	OIF_SGRNDB		OIF_SGRNDB	NUMC	000008	000000
	5	A1_UTILTP	Usage Type of Property (IS-Oil MRN Demo APPEND)	OIF_UTILTP		OIF_UTILTP	CHAR	000002	000000
	6	A1_GRTYP	Property Type (IS-Oil MRN Demo APPEND)	OIF_GRTYP		OIF_GRTYP	NUMC	000003	000000
	7	A1_GRQAL	Quality of Business Location (IS-Oil MRN Demo APPEND)	OIF_GRQAL		OIF_GRQAL	NUMC	000003	000000
	8	A1_GRFRM	Property Type (IS-Oil MRN Demo APPEND)	OIF_GRFRM		OIF_GRFRM	NUMC	000003	000000
	9	A1_GRGZS	Overall Condition of Property (IS-Oil MRN Demo APPEND)	OIF_GRGZS		OIF_GRGZS	NUMC	000003	000000
	10	A1_DAKTB	Date Active in Inventory (IS-Oil MRN Demo APPEND)	OIF_DAKTB		OIF_DAKTB	DATS	000008	000000
	11	PBLTYP	Business Location Type (IS-Oil MRN)	OIF_PBLTYP	OIFSPBLT	OIF_PBLTYP	CHAR	000004	000000
	12	ADDRNUM	Address No. in ADRC	OIF_ADNUM	ADRC	AD_ADDRNUM	CHAR	000010	000000
	13	ERDAT	Date Record Created on (Date)	OIF_ERDAT		DATS	DATS	000008	000000
	14	ERZEIT	Time Record Created at (Time)	OIF_ERZEIT		TIME	TIMS	000006	000000
	15	ERNAM	User who Created Record	OIF_ERNAM		USNAM	CHAR	000012	000000
	16	AEDAT	Date Record Changed on (Date)	OIF_AEDAT		DATS	DATS	000008	000000
	17	AEZEIT	Time when Record Was Changed	OIF_AEZEIT		TIME	TIMS	000006	000000
	18	AENAM	User who Changed Record	OIF_AENAM		USNAM	CHAR	000012	000000
	19	BLOIND	Block Indicator	OIF_BLOIND		XFELD	CHAR	000001	000000
You've found a Pro Pass Feature! Get a Pro PassNOW to view all standard values
	20	DELIND	Deletion indicator	OIF_DELIND		XFELD	CHAR	000001	000000
You've found a Pro Pass Feature! Get a Pro PassNOW to view all standard values
	21	BLCODE	Business Location Blocking Indicator (IS-Oil MRN)	OIF_BLCD	OIFSBLCD	OIF_BLCD	CHAR	000002	000000
	22	OBJNR	Object number	J_OBJNR	ONR00	J_OBJNR	CHAR	000022	000000
	23	BRAND	Location brand	OIRB_BRAND	OIRBBRAND	OIRB_BRAND	CHAR	000005	000000
	24	LOCVALUE	Relative location value	OIRB_VAL	OIRBPBLVAL	OIRB_VAL	CHAR	000002	000000
	25	LOCVDIFF	Location value differentiator	OIRB_LOCVDIFF	OIRBPBLVALD	OIRB_LOCVDIFF	CHAR	000002	000000
	26	LOCAA	Location area assignment	OIRB_LAA	OIRBLAA	OIRB_LAA	CHAR	000005	000000
	27	LOCMP	SSR Pricing - Margins procedure assigned to this location	OIRC_KALKS	OIRCTVKD	OIRC_KALKS	CHAR	000001	000000
	28	PCGROUP	Process control group	OIRA_PCG	OIRAPCG	OIRA_PCG	CHAR	000010	000000
	29	AUTGR	Authorization group	OIRB_AUTGR		CHAR4	CHAR	000004	000000
	30	VALGP	SSR PC: Upload validation group	OIREVALGROUP	OIREVALGP	OIREVALGROUP	CHAR	000002	000000
	31	BUKRS	Company Code	BUKRS	T001	BUKRS	CHAR	000004	000000
	32	OIRIPGRP	SSR SD/FI Invoice posting group	OIRI_PGRP		OIRI_PGRP	CHAR	000002	000000
	33	CONVGR	SSR Interface conversion group definition (IS-Oil	OIRH_CONVGR	OIRHCVGRDEFC	CHAR4	CHAR	000004	000000
	34	LOGSYS	Logical system for EDI	OIRH_LOGSYS	TBDLS	LOGSYS	CHAR	000010	000000
	35	TPLST	Transportation planning point	TPLST	TTDS	TPLST	CHAR	000004	000000
	36	TPLST_TXT	Description of transportation planning point	TPLST_TXT		TEXT20	CHAR	000020	000000
	37	LONGITUDE	Geo location longitude	GEOLON		GEOLONLAT	DEC	000015	000012
	38	LATITUDE	Geo location latitude	GEOLAT		GEOLONLAT	DEC	000015	000012
	39	TIME_TO_ADD	Duration to Add at Base Location (in hours:minutes)	OIO_TIME_TO_ADD		TSTRDURAN	DEC	000011	000000
	40	AVRG_STAYT	Duration of Stay at Remote Location (in hours:minutes)	OIO_AVRG_STAYT		TSTRDURAN	DEC	000011	000000
	41	KNOTE	Transportation Connection Points	KNOTE	TVKN	KNOTN	CHAR	000010	000000
	42	KNOTE_BEZ	Node name	KNOTE_BEZ		TEXT30	CHAR	000030	000000
	43	ROUTE	Shipment route	ROUTR	TVRO	ROUTE	CHAR	000006	000000
	44	TXROU	Description of Route	ROUTBEZ		TEXT40	CHAR	000040	000000
	45	R_CON_POINT	Radiobutton for connection point in RLM VMIS location	OIO_VMIS_C		XRADI	CHAR	000001	000000
You've found a Pro Pass Feature! Get a Pro PassNOW to view all standard values
	46	R_ROUTE	Radiobutton for shipment route in RLM VMIS location	OIO_VMIS_R		XRADI	CHAR	000001	000000
You've found a Pro Pass Feature! Get a Pro PassNOW to view all standard values
	47	XCOOR	X coordinate	OIRB_COOR_X			FLTP	000016	000016
	48	YCOOR	Y coordinate	OIRB_COOR_Y			FLTP	000016	000016

OIFSPBL

Physical Location - Master Data

SAP ECC

SAP S/4HANA

Table Content Language:

🇺🇸English

Get Pro Pass to select language

Below is the full application component hierarchy path of the table. By selecting any node, you can navigate through the hierarchy and view all elements of the respective node.

Loading hierarchy path...

Table Metadata

Table Name

OIFSPBL

Table Description

Physical Location - Master Data

Table Type

Transparent

	#	Field	Description	Data Element	Checktable	Domain	Datatype	Length	Decimals
	1	MANDT	Client	MANDT	T000	MANDT	CLNT	000003	000000
	2	PBLNR	Business location identifier (IS-Oil MRN)	OIF_PBLNR	OIFSPBL	OIF_PBLNR	CHAR	000010	000000
	3	NAME1	Internal name field	OIF_PBNAM1		CHAR35	CHAR	000035	000000
	4	A1_SGRNDB	Land Register Number (IS-Oil MRN Demo APPEND)	OIF_SGRNDB		OIF_SGRNDB	NUMC	000008	000000
	5	A1_UTILTP	Usage Type of Property (IS-Oil MRN Demo APPEND)	OIF_UTILTP		OIF_UTILTP	CHAR	000002	000000
	6	A1_GRTYP	Property Type (IS-Oil MRN Demo APPEND)	OIF_GRTYP		OIF_GRTYP	NUMC	000003	000000
	7	A1_GRQAL	Quality of Business Location (IS-Oil MRN Demo APPEND)	OIF_GRQAL		OIF_GRQAL	NUMC	000003	000000
	8	A1_GRFRM	Property Type (IS-Oil MRN Demo APPEND)	OIF_GRFRM		OIF_GRFRM	NUMC	000003	000000
	9	A1_GRGZS	Overall Condition of Property (IS-Oil MRN Demo APPEND)	OIF_GRGZS		OIF_GRGZS	NUMC	000003	000000
	10	A1_DAKTB	Date Active in Inventory (IS-Oil MRN Demo APPEND)	OIF_DAKTB		OIF_DAKTB	DATS	000008	000000
	11	PBLTYP	Business Location Type (IS-Oil MRN)	OIF_PBLTYP	OIFSPBLT	OIF_PBLTYP	CHAR	000004	000000
	12	ADDRNUM	Address No. in ADRC	OIF_ADNUM	ADRC	AD_ADDRNUM	CHAR	000010	000000
	13	ERDAT	Date Record Created on (Date)	OIF_ERDAT		DATS	DATS	000008	000000
	14	ERZEIT	Time Record Created at (Time)	OIF_ERZEIT		TIME	TIMS	000006	000000
	15	ERNAM	User who Created Record	OIF_ERNAM		USNAM	CHAR	000012	000000
	16	AEDAT	Date Record Changed on (Date)	OIF_AEDAT		DATS	DATS	000008	000000
	17	AEZEIT	Time when Record Was Changed	OIF_AEZEIT		TIME	TIMS	000006	000000
	18	AENAM	User who Changed Record	OIF_AENAM		USNAM	CHAR	000012	000000
	19	BLOIND	Block Indicator	OIF_BLOIND		XFELD	CHAR	000001	000000
You've found a Pro Pass Feature! Get a Pro PassNOW to view all standard values
	20	DELIND	Deletion indicator	OIF_DELIND		XFELD	CHAR	000001	000000
You've found a Pro Pass Feature! Get a Pro PassNOW to view all standard values
	21	BLCODE	Business Location Blocking Indicator (IS-Oil MRN)	OIF_BLCD	OIFSBLCD	OIF_BLCD	CHAR	000002	000000
	22	OBJNR	Object number	J_OBJNR	ONR00	J_OBJNR	CHAR	000022	000000
	23	BRAND	Location brand	OIRB_BRAND	OIRBBRAND	OIRB_BRAND	CHAR	000005	000000
	24	LOCVALUE	Relative location value	OIRB_VAL	OIRBPBLVAL	OIRB_VAL	CHAR	000002	000000
	25	LOCVDIFF	Location value differentiator	OIRB_LOCVDIFF	OIRBPBLVALD	OIRB_LOCVDIFF	CHAR	000002	000000
	26	LOCAA	Location area assignment	OIRB_LAA	OIRBLAA	OIRB_LAA	CHAR	000005	000000
	27	LOCMP	SSR Pricing - Margins procedure assigned to this location	OIRC_KALKS	OIRCTVKD	OIRC_KALKS	CHAR	000001	000000
	28	PCGROUP	Process control group	OIRA_PCG	OIRAPCG	OIRA_PCG	CHAR	000010	000000
	29	AUTGR	Authorization group	OIRB_AUTGR		CHAR4	CHAR	000004	000000
	30	VALGP	SSR PC: Upload validation group	OIREVALGROUP	OIREVALGP	OIREVALGROUP	CHAR	000002	000000
	31	BUKRS	Company Code	BUKRS	T001	BUKRS	CHAR	000004	000000
	32	OIRIPGRP	SSR SD/FI Invoice posting group	OIRI_PGRP		OIRI_PGRP	CHAR	000002	000000
	33	CONVGR	SSR Interface conversion group definition (IS-Oil	OIRH_CONVGR	OIRHCVGRDEFC	CHAR4	CHAR	000004	000000
	34	LOGSYS	Logical system for EDI	OIRH_LOGSYS	TBDLS	LOGSYS	CHAR	000010	000000
	35	TPLST	Transportation planning point	TPLST	TTDS	TPLST	CHAR	000004	000000
	36	TPLST_TXT	Description of transportation planning point	TPLST_TXT		TEXT20	CHAR	000020	000000
	37	LONGITUDE	Geo location longitude	GEOLON		GEOLONLAT	DEC	000015	000012
	38	LATITUDE	Geo location latitude	GEOLAT		GEOLONLAT	DEC	000015	000012
	39	TIME_TO_ADD	Duration to Add at Base Location (in hours:minutes)	OIO_TIME_TO_ADD		TSTRDURAN	DEC	000011	000000
	40	AVRG_STAYT	Duration of Stay at Remote Location (in hours:minutes)	OIO_AVRG_STAYT		TSTRDURAN	DEC	000011	000000
	41	KNOTE	Transportation Connection Points	KNOTE	TVKN	KNOTN	CHAR	000010	000000
	42	KNOTE_BEZ	Node name	KNOTE_BEZ		TEXT30	CHAR	000030	000000
	43	ROUTE	Shipment route	ROUTR	TVRO	ROUTE	CHAR	000006	000000
	44	TXROU	Description of Route	ROUTBEZ		TEXT40	CHAR	000040	000000
	45	R_CON_POINT	Radiobutton for connection point in RLM VMIS location	OIO_VMIS_C		XRADI	CHAR	000001	000000
You've found a Pro Pass Feature! Get a Pro PassNOW to view all standard values
	46	R_ROUTE	Radiobutton for shipment route in RLM VMIS location	OIO_VMIS_R		XRADI	CHAR	000001	000000
You've found a Pro Pass Feature! Get a Pro PassNOW to view all standard values
	47	XCOOR	X coordinate	OIRB_COOR_X			FLTP	000016	000016
	48	YCOOR	Y coordinate	OIRB_COOR_Y			FLTP	000016	000016

OIFSPBL

Physical Location - Master Data

Table Content Language:

Table Metadata

You've found a Pro Pass Feature!Get a Pro PassNOW to view all standard values

You've found a Pro Pass Feature!Get a Pro PassNOW to view all standard values

You've found a Pro Pass Feature!Get a Pro PassNOW to view all standard values

You've found a Pro Pass Feature!Get a Pro PassNOW to view all standard values

OIFSPBL

Physical Location - Master Data

Table Content Language:

Table Metadata

You've found a Pro Pass Feature!Get a Pro PassNOW to view all standard values

You've found a Pro Pass Feature!Get a Pro PassNOW to view all standard values

You've found a Pro Pass Feature!Get a Pro PassNOW to view all standard values

You've found a Pro Pass Feature!Get a Pro PassNOW to view all standard values

You've found a Pro Pass Feature!
Get a Pro PassNOW to view all standard values

You've found a Pro Pass Feature!
Get a Pro PassNOW to view all standard values

You've found a Pro Pass Feature!
Get a Pro PassNOW to view all standard values

You've found a Pro Pass Feature!
Get a Pro PassNOW to view all standard values

You've found a Pro Pass Feature!
Get a Pro PassNOW to view all standard values

You've found a Pro Pass Feature!
Get a Pro PassNOW to view all standard values

You've found a Pro Pass Feature!
Get a Pro PassNOW to view all standard values

You've found a Pro Pass Feature!
Get a Pro PassNOW to view all standard values