SAP ABAP Table OIFSPBL_OIL (Oil fields OIFSPBL)

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL (Application Component) Industry Solution Oil
     ⤷ OI1_NO_SW (Package) IS-Oil objects w/o switch assignment (use carefully!)

Basic Data

Table Category	APPEND	Append structure
Append structure	OIFSPBL_OIL	Table Relationship Diagram
Short Description	Oil fields OIFSPBL

Delivery and Maintenance

Pool/cluster	OIFSPBL
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	PBLTYP	☐	OIF_PBLTYP	OIF_PBLTYP	CHAR	4	0	Business Location Type (IS-Oil MRN)	OIFSPBLT
2	ADDRNUM	☐	OIF_ADNUM	AD_ADDRNUM	CHAR	10	0	Address No. in ADRC	OIFSMCADDR
3	ERDAT	☐	OIF_ERDAT	DATS	DATS	8	0	Date Record Created on (Date)
4	ERZEIT	☐	OIF_ERZEIT	TIME	TIMS	6	0	Time Record Created at (Time)
5	ERNAM	☐	OIF_ERNAM	USNAM	CHAR	12	0	User who Created Record
6	AEDAT	☐	OIF_AEDAT	DATS	DATS	8	0	Date Record Changed on (Date)
7	AEZEIT	☐	OIF_AEZEIT	TIME	TIMS	6	0	Time when Record Was Changed
8	AENAM	☐	OIF_AENAM	USNAM	CHAR	12	0	User who Changed Record
9	BLOIND	☐	OIF_BLOIND	XFELD	CHAR	1	0	Block Indicator
10	DELIND	☐	OIF_DELIND	XFELD	CHAR	1	0	Deletion indicator
11	BLCODE	☐	OIF_BLCD	OIF_BLCD	CHAR	2	0	Business Location Blocking Indicator (IS-Oil MRN)	OIFSBLCD
12	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
13	.INCLUDE	☐				0	0	Business location enhancement for OIFSPBL (IS-OIL SSR)
14	BRAND	☐	OIRB_BRAND	OIRB_BRAND	CHAR	5	0	Location brand	OIRBBRAND
15	LOCVALUE	☐	OIRB_VAL	OIRB_VAL	CHAR	2	0	Relative location value	OIRBPBLVAL
16	LOCVDIFF	☐	OIRB_LOCVDIFF	OIRB_LOCVDIFF	CHAR	2	0	Location value differentiator	OIRBPBLVALD
17	LOCAA	☐	OIRB_LAA	OIRB_LAA	CHAR	5	0	Location area assignment	OIRBLAA
18	LOCMP	☐	OIRC_KALKS	OIRC_KALKS	CHAR	1	0	SSR Pricing - Margins procedure assigned to this location	OIRCTVKD
19	PCGROUP	☐	OIRA_PCG	OIRA_PCG	CHAR	10	0	Process control group	OIRAPCG
20	AUTGR	☐	OIRB_AUTGR	CHAR4	CHAR	4	0	Authorization group
21	VALGP	☐	OIREVALGROUP	OIREVALGROUP	CHAR	2	0	SSR PC: Upload validation group	OIREVALGP
22	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
23	OIRIPGRP	☐	OIRI_PGRP	OIRI_PGRP	CHAR	2	0	SSR SD/FI Invoice posting group
24	.INCLUDE	☐				0	0	Conversion Group Structure-Field Conversion(IS-OIL, SSR)
25	CONVGR	☐	OIRH_CONVGR	CHAR4	CHAR	4	0	SSR Interface conversion group definition (IS-Oil, SSR)	OIRHCVGRDEFC
26	LOGSYS	☐	OIRH_LOGSYS	LOGSYS	CHAR	10	0	Logical system for EDI	TBDLS

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OIFSPBL_OIL	ADDRNUM	OIFSMCADDR	ADDRNUM	REF
2	OIFSPBL_OIL	BLCODE	OIFSBLCD	BLCODE	REF
3	OIFSPBL_OIL	BRAND	OIRBBRAND	BRANDID	REF
4	OIFSPBL_OIL	BUKRS	T001	BUKRS
5	OIFSPBL_OIL	CONVGR	OIRHCVGRDEFC	CONVGR
6	OIFSPBL_OIL	LOCAA	OIRBLAA	LOCAA
7	OIFSPBL_OIL	LOCMP	OIRCTVKD	KALKS	KEY
8	OIFSPBL_OIL	LOCVALUE	OIRBPBLVAL	LOCVALUE	REF
9	OIFSPBL_OIL	LOCVDIFF	OIRBPBLVALD	LOCVDIFF	REF
10	OIFSPBL_OIL	LOGSYS	TBDLS	LOGSYS
11	OIFSPBL_OIL	PBLTYP	OIFSPBLT	PBLTYP	REF
12	OIFSPBL_OIL	PCGROUP	OIRAPCG	PCGROUP	REF	1	CN
13	OIFSPBL_OIL	VALGP	OIREVALGP	VALGP	REF

History

Last changed by/on	SAP	20110901
SAP Release Created in	46C