SAP ABAP Table OIISCPBL (SCP: Site control parameters (business loc) - IS-Oil BDRP)

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	TRANSP	Transparent table
Transparent table	OIISCPBL	Table Relationship Diagram
Short Description	SCP: Site control parameters (business loc) - IS-Oil BDRP

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	T000
2	PBLNR	☑	OIF_PBLNR	OIF_PBLNR	CHAR	10	0	Business location identifier (IS-Oil MRN)	OIFSPBL
3	RNBT	☑	OIRA_RNBT	OIRA_RNBT	CHAR	4	0	Business type	OIRARNBT
4	PARFN	☑	OIF_PARFN	OIF_PARFN	CHAR	4	0	MRN business partner role / relation type	OIFBRF1
5	.INCLUDE	☐				0	0	SCP: Site control parameters
6	VKFCAL	☐	OII_VKFCAL	WFCID	CHAR	2	0	SCP: Site factory calendar - sales days	TFACD
7	VKFSID	☐	OII_VKFSID	OII_VKFSID	CHAR	3	0	SCP: Sales hour set ID	OIISCPSH
8	W11BOS	☐	OII_W11BOS	TIME	TIMS	6	0	Monday:time sales begin 1
9	W11EOS	☐	OII_W11EOS	TIME	TIMS	6	0	Monday time sales end 1
10	W12BOS	☐	OII_W12BOS	TIME	TIMS	6	0	Monday:time sales begin 2
11	W12EOS	☐	OII_W12EOS	TIME	TIMS	6	0	Monday:time sales end 2
12	W21BOS	☐	OII_W21BOS	TIME	TIMS	6	0	Tuesday:time sales begin 1
13	W21EOS	☐	OII_W21EOS	TIME	TIMS	6	0	Tuesday:time sales end 1
14	W22BOS	☐	OII_W22BOS	TIME	TIMS	6	0	Tuesday:time sales begin 2
15	W22EOS	☐	OII_W22EOS	TIME	TIMS	6	0	Tuesday:time sales end 2
16	W31BOS	☐	OII_W31BOS	TIME	TIMS	6	0	Wednesday:time sales begin 1
17	W31EOS	☐	OII_W31EOS	TIME	TIMS	6	0	Wednesday:time sales end 1
18	W32BOS	☐	OII_W32BOS	TIME	TIMS	6	0	Wednesday:time sales begin 2
19	W32EOS	☐	OII_W32EOS	TIME	TIMS	6	0	Wednesday:time sales end 2
20	W41BOS	☐	OII_W41BOS	TIME	TIMS	6	0	Thursday:time sales begin 1
21	W41EOS	☐	OII_W41EOS	TIME	TIMS	6	0	Thursday:time sales end 1
22	W42BOS	☐	OII_W42BOS	TIME	TIMS	6	0	Thursday:time sales begin 2
23	W42EOS	☐	OII_W42EOS	TIME	TIMS	6	0	Thursday:time sales end 2
24	W51BOS	☐	OII_W51BOS	TIME	TIMS	6	0	Friday:time sales begin 1
25	W51EOS	☐	OII_W51EOS	TIME	TIMS	6	0	Friday:time sales end 1
26	W52BOS	☐	OII_W52BOS	TIME	TIMS	6	0	Friday:time sales begin 2
27	W52EOS	☐	OII_W52EOS	TIME	TIMS	6	0	Friday:time sales end 2
28	W61BOS	☐	OII_W61BOS	TIME	TIMS	6	0	Saturday:time sales begin 1
29	W61EOS	☐	OII_W61EOS	TIME	TIMS	6	0	Saturday:time sales end 1
30	W62BOS	☐	OII_W62BOS	TIME	TIMS	6	0	Saturday:time sales begin 2
31	W62EOS	☐	OII_W62EOS	TIME	TIMS	6	0	Saturday:time sales end 2
32	W71BOS	☐	OII_W71BOS	TIME	TIMS	6	0	Sunday:time sales begin 1
33	W71EOS	☐	OII_W71EOS	TIME	TIMS	6	0	Sunday:time sales end 1
34	W72BOS	☐	OII_W72BOS	TIME	TIMS	6	0	Sunday:time sales begin 2
35	W72EOS	☐	OII_W72EOS	TIME	TIMS	6	0	Sunday:time sales end 2
36	W81BOS	☐	OII_W81BOS	TIME	TIMS	6	0	Public holiday: time sales begin 1
37	W81EOS	☐	OII_W81EOS	TIME	TIMS	6	0	Public holiday: time sales end 1
38	W82BOS	☐	OII_W82BOS	TIME	TIMS	6	0	Public holiday: time sales begin 2
39	W82EOS	☐	OII_W82EOS	TIME	TIMS	6	0	Public holiday: time sales end 2
40	.INCLUDE	☐				0	0	Standard status field set (BDRP)
41	ERDAT	☐	OII_ERDAT	DATS	DATS	8	0	Date record created
42	ERZEIT	☐	OII_ERZEIT	TIME	TIMS	6	0	Time record created
43	ERNAM	☐	OII_ERNAM	USNAM	CHAR	12	0	User who created record
44	AEDAT	☐	OII_AEDAT	DATS	DATS	8	0	Date record changed
45	AEZEIT	☐	OII_AEZEIT	TIME	TIMS	6	0	Time record changed
46	AENAM	☐	OII_AENAM	USNAM	CHAR	12	0	User who changed record
47	BLOIND	☐	OII_BLOIND	XFELD	CHAR	1	0	Blocking indicator
48	DELIND	☐	OII_DELIND	XFELD	CHAR	1	0	Deletion indicator
49	BLOSH	☐	OII_BLOSH	XFELD	CHAR	1	0	Site control: block use of sales hours
50	BLOLT	☐	OII_BLOLT	XFELD	CHAR	1	0	Site control: block use of lead time entries
51	SOEGRP	☐	OII_SOEGRP	OII_SOEGRP	CHAR	4	0	Sales order entry default group	OIISCPSOE
52	TPIPRD	☐	OII_TPIPRD	OIF_PARFN	CHAR	4	0	OIL-TPI: Default partner role for partner look-up	OIFBRF1
53	CONWK	☐	OII_CONWK	WERKS	CHAR	4	0	OIL-BDRP: Consignment stock receiving plant in delivery	T001W
54	CONLG	☐	OII_CONLG	LGORT	CHAR	4	0	OIL-BDRP: Consignment stock receiving s/loc in delivery	T001L
55	RCBLK	☐	OII_RCBLK	XFELD	CHAR	1	0	Block automatic replenishment at this site (OIL-BDRP)
56	DOBLK	☐	OII_DOBLK	XFELD	CHAR	1	0	Block dispatch optimization at this site (OIL-BDRP)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OIISCPBL	CONLG	T001L	LGORT	REF	1	CN
2	OIISCPBL	CONWK	T001W	WERKS	REF	1	CN
3	OIISCPBL	MANDT	T000	MANDT	KEY	1	CN
4	OIISCPBL	PARFN	OIFBRF1	PARFN	KEY	1	CN
5	OIISCPBL	PBLNR	OIFSPBL	PBLNR	KEY	1	CN
6	OIISCPBL	RNBT	OIRARNBT	RNBT
7	OIISCPBL	SOEGRP	OIISCPSOE	SOEGRP	REF	1	CN
8	OIISCPBL	TPIPRD	OIFBRF1	PARFN	REF	1	CN
9	OIISCPBL	VKFCAL	TFACD	IDENT	KEY	1	CN
10	OIISCPBL	VKFSID	OIISCPSH	VKFSID	KEY	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in