SAP ABAP Table OIFPBLEXTRAKT (Business Location extraction to BW)

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-DS (Application Component) Downstream
     ⤷ OI0_BW (Package) Oil/BW Business Information Warehouse (extractors,..)

Basic Data

Table Category	INTTAB	Structure
Structure	OIFPBLEXTRAKT	Table Relationship Diagram
Short Description	Business Location extraction to BW

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	*
2	PBLNR	☐	OIF_PBLNR	OIF_PBLNR	CHAR	10	0	Business location identifier (IS-Oil MRN)	*
3	PBLTYP	☐	OIF_PBLTYP	OIF_PBLTYP	CHAR	4	0	Business Location Type (IS-Oil MRN)	*
4	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
5	NAME1	☐	OIF_BW_NAM1	TEXT32	CHAR	32	0	Name field 1 (business location)
6	NAME2	☐	OIF_BW_NAM2	TEXT32	CHAR	32	0	Name field 2 (business location)
7	NAME3	☐	OIF_BW_NAM3	TEXT32	CHAR	32	0	Name field 3 (business location)
8	NAME4	☐	OIF_BW_NAM4	TEXT32	CHAR	32	0	Name field 4 (business location)
9	CITY1	☐	OIF_BW_CTY1	TEXT32	CHAR	32	0	City (business location)
10	CITY2	☐	OIF_BW_CTY2	TEXT32	CHAR	32	0	District (business location)
11	STREET	☐	OIF_BW_STRT	TEXT32	CHAR	32	0	Street (business location)
12	HOUSE_NUM1	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
13	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
14	LANGU	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
15	TIME_ZONE	☐	AD_TZONE	TZNZONE	CHAR	6	0	Address time zone	*
16	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
17	TEL_NUMBER	☐	AD_TLNMBR1	CHAR30	CHAR	30	0	First telephone no.: dialling code+number
18	TEL_EXTENS	☐	AD_TLXTNS1	CHAR10	CHAR	10	0	First Telephone No.: Extension
19	FAX_NUMBER	☐	AD_FXNMBR1	CHAR30	CHAR	30	0	First fax no.: dialling code+number
20	FAX_EXTENS	☐	AD_FXXTNS1	CHAR10	CHAR	10	0	First fax no.: extension
21	SORT1	☐	AD_SORT1	CHAR20	CHAR	20	0	Search Term 1
22	SORT2	☐	AD_SORT2	CHAR20	CHAR	20	0	Search Term 2

History

Last changed by/on	SAP	20130529
SAP Release Created in