SAP ABAP Table ROIISPBL (Transfer structure for Business location Data for SO Maint.)

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-DS-BDR (Application Component) Bulk Distribution Requirements Planning
     ⤷ OII (Package) BDRP Bulk Distribution Requirement Planning

Basic Data

Table Category	INTTAB	Structure
Structure	ROIISPBL	Table Relationship Diagram
Short Description	Transfer structure for Business location Data for SO Maint.

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	.INCLUDE	☐				0	0	Update data transfer structure for OIFSPBL
2	.INCLUDE	☐				0	0	Physical Location - Master Data
3	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
4	PBLNR	☐	OIF_PBLNR	OIF_PBLNR	CHAR	10	0	Business location identifier (IS-Oil MRN)	*
5	NAME1	☐	OIF_PBNAM1	CHAR35	CHAR	35	0	Internal name field
6	.INCLU--AP	☐				0	0	Business location property data (IS-Oil MRN demo APPEND)
7	.INCLUDE	☐				0	0	MRN business location - Real estate property data (demo)
8	A1_SGRNDB	☐	OIF_SGRNDB	OIF_SGRNDB	NUMC	8	0	Land Register Number (IS-Oil MRN Demo APPEND)
9	A1_UTILTP	☐	OIF_UTILTP	OIF_UTILTP	CHAR	2	0	Usage Type of Property (IS-Oil MRN Demo APPEND)
10	A1_GRTYP	☐	OIF_GRTYP	OIF_GRTYP	NUMC	3	0	Property Type (IS-Oil MRN Demo APPEND)
11	A1_GRQAL	☐	OIF_GRQAL	OIF_GRQAL	NUMC	3	0	Quality of Business Location (IS-Oil MRN Demo APPEND)
12	A1_GRFRM	☐	OIF_GRFRM	OIF_GRFRM	NUMC	3	0	Property Type (IS-Oil MRN Demo APPEND)
13	A1_GRGZS	☐	OIF_GRGZS	OIF_GRGZS	NUMC	3	0	Overall Condition of Property (IS-Oil MRN Demo APPEND)
14	A1_DAKTB	☐	OIF_DAKTB	OIF_DAKTB	DATS	8	0	Date Active in Inventory (IS-Oil MRN Demo APPEND)
15	.INCLU--AP	☐				0	0	Oil fields OIFSPBL
16	PBLTYP	☐	OIF_PBLTYP	OIF_PBLTYP	CHAR	4	0	Business Location Type (IS-Oil MRN)	OIFSPBLT
17	ADDRNUM	☐	OIF_ADNUM	AD_ADDRNUM	CHAR	10	0	Address No. in ADRC	OIFSMCADDR
18	ERDAT	☐	OIF_ERDAT	DATS	DATS	8	0	Date Record Created on (Date)
19	ERZEIT	☐	OIF_ERZEIT	TIME	TIMS	6	0	Time Record Created at (Time)
20	ERNAM	☐	OIF_ERNAM	USNAM	CHAR	12	0	User who Created Record
21	AEDAT	☐	OIF_AEDAT	DATS	DATS	8	0	Date Record Changed on (Date)
22	AEZEIT	☐	OIF_AEZEIT	TIME	TIMS	6	0	Time when Record Was Changed
23	AENAM	☐	OIF_AENAM	USNAM	CHAR	12	0	User who Changed Record
24	BLOIND	☐	OIF_BLOIND	XFELD	CHAR	1	0	Block Indicator
25	DELIND	☐	OIF_DELIND	XFELD	CHAR	1	0	Deletion indicator
26	BLCODE	☐	OIF_BLCD	OIF_BLCD	CHAR	2	0	Business Location Blocking Indicator (IS-Oil MRN)	OIFSBLCD
27	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
28	.INCLUDE	☐				0	0	Business location enhancement for OIFSPBL (IS-OIL SSR)
29	BRAND	☐	OIRB_BRAND	OIRB_BRAND	CHAR	5	0	Location brand	OIRBBRAND
30	LOCVALUE	☐	OIRB_VAL	OIRB_VAL	CHAR	2	0	Relative location value	OIRBPBLVAL
31	LOCVDIFF	☐	OIRB_LOCVDIFF	OIRB_LOCVDIFF	CHAR	2	0	Location value differentiator	OIRBPBLVALD
32	LOCAA	☐	OIRB_LAA	OIRB_LAA	CHAR	5	0	Location area assignment	OIRBLAA
33	LOCMP	☐	OIRC_KALKS	OIRC_KALKS	CHAR	1	0	SSR Pricing - Margins procedure assigned to this location	OIRCTVKD
34	PCGROUP	☐	OIRA_PCG	OIRA_PCG	CHAR	10	0	Process control group	OIRAPCG
35	AUTGR	☐	OIRB_AUTGR	CHAR4	CHAR	4	0	Authorization group
36	VALGP	☐	OIREVALGROUP	OIREVALGROUP	CHAR	2	0	SSR PC: Upload validation group	OIREVALGP
37	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
38	OIRIPGRP	☐	OIRI_PGRP	OIRI_PGRP	CHAR	2	0	SSR SD/FI Invoice posting group
39	.INCLUDE	☐				0	0	Conversion Group Structure-Field Conversion(IS-OIL, SSR)
40	CONVGR	☐	OIRH_CONVGR	CHAR4	CHAR	4	0	SSR Interface conversion group definition (IS-Oil, SSR)	OIRHCVGRDEFC
41	LOGSYS	☐	OIRH_LOGSYS	LOGSYS	CHAR	10	0	Logical system for EDI	TBDLS
42	UPD_FLAG	☐	TRTYP	TRTYP	CHAR	1	0	Transaction type
43	DESCR	☐	OIF_DESCR	TEXT50	CHAR	50	0	Descriptive text
44	CITY1	☐	AD_CITY1	TEXT40	CHAR	40	0	City
45	POST_CODE1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
46	TZONE	☐	TZNZONE	TZNZONE	CHAR	6	0	Time Zone	*

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in