OIISCPBL

Transparent Table Application Table
54 Fields 1 CDS Views

SCP: Site control parameters (business loc) - IS-Oil BDRP

OIISCPBL is an SAP database table in S/4HANA. SCP: Site control parameters (business loc) - IS-Oil BDRP. It contains 54 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_OIL_LocSiteControlParam view_entity from BASIC Business Loc Site Control Parameter

Fields (54)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY pblnr OIF_PBLNR Location ID
KEY rnbt OIRA_RNBT Business type
KEY parfn OIF_PARFN Partner role
vkfcal OII_VKFCAL Site sales cal.
vkfsid OII_VKFSID Sales hour set
w11bos OII_W11BOS Mon.:begin 1
w11eos OII_W11EOS Mon.:end 1
w12bos OII_W12BOS Mon.:begin 2
w12eos OII_W12EOS Mon. end 2
w21bos OII_W21BOS Tue.:begin 1
w21eos OII_W21EOS Tue.:end 1
w22bos OII_W22BOS Tue.:begin 2
w22eos OII_W22EOS Tue.:end 2
w31bos OII_W31BOS Wed.:begin 1
w31eos OII_W31EOS Wed.:end 1
w32bos OII_W32BOS Wed.:begin 2
w32eos OII_W32EOS Wed.:end 2
w41bos OII_W41BOS Thu.:begin 1
w41eos OII_W41EOS Thu.:end 1
w42bos OII_W42BOS Thu.:begin 2
w42eos OII_W42EOS Thu.:end 2
w51bos OII_W51BOS Fri.:begin 1
w51eos OII_W51EOS Fri.:end 1
w52bos OII_W52BOS Fri.:begin 2
w52eos OII_W52EOS Fri.:end 2
w61bos OII_W61BOS Sat.:begin 1
w61eos OII_W61EOS Sat.:end 1
w62bos OII_W62BOS Sat.:begin 2
w62eos OII_W62EOS Sat.:end 2
w71bos OII_W71BOS Sun.:begin 1
w71eos OII_W71EOS Sun.:end 1
w72bos OII_W72BOS Sun.:begin 2
w72eos OII_W72EOS Sun.:end 2
w81bos OII_W81BOS Hol.:begin 1
w81eos OII_W81EOS Hol.:end 1
w82bos OII_W82BOS Hol.:begin 2
w82eos OII_W82EOS Hol.:end 2
erdat OII_ERDAT Date created
erzeit OII_ERZEIT Time created
ernam OII_ERNAM Created by
aedat OII_AEDAT Date changed
aezeit OII_AEZEIT Time changed
aenam OII_AENAM Changed by
bloind OII_BLOIND Blocking ind.
delind OII_DELIND Deletion ind.
blosh OII_BLOSH Block sls.hrs.
blolt OII_BLOLT Block ld.times
soegrp OII_SOEGRP SOE default grp
tpiprd OII_TPIPRD Def.prtnr.role
conwk OII_CONWK Consign StkPlnt
conlg OII_CONLG Consign StkSLoc
rcblk OII_RCBLK Block rpln.calc
doblk OII_DOBLK Block dispOpt

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- SCP: Site control parameters (business loc) - IS-Oil BDRP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIISCPBL (
    MANDT,   -- Client [MANDT]
    PBLNR,   -- Location ID [OIF_PBLNR]
    RNBT,    -- Business type [OIRA_RNBT]
    PARFN,   -- Partner role [OIF_PARFN]
    VKFCAL,  -- Site sales cal. [OII_VKFCAL]
    VKFSID,  -- Sales hour set [OII_VKFSID]
    W11BOS,  -- Mon.:begin 1 [OII_W11BOS]
    W11EOS,  -- Mon.:end 1 [OII_W11EOS]
    W12BOS,  -- Mon.:begin 2 [OII_W12BOS]
    W12EOS,  -- Mon. end 2 [OII_W12EOS]
    W21BOS,  -- Tue.:begin 1 [OII_W21BOS]
    W21EOS,  -- Tue.:end 1 [OII_W21EOS]
    W22BOS,  -- Tue.:begin 2 [OII_W22BOS]
    W22EOS,  -- Tue.:end 2 [OII_W22EOS]
    W31BOS,  -- Wed.:begin 1 [OII_W31BOS]
    W31EOS,  -- Wed.:end 1 [OII_W31EOS]
    W32BOS,  -- Wed.:begin 2 [OII_W32BOS]
    W32EOS,  -- Wed.:end 2 [OII_W32EOS]
    W41BOS,  -- Thu.:begin 1 [OII_W41BOS]
    W41EOS,  -- Thu.:end 1 [OII_W41EOS]
    W42BOS,  -- Thu.:begin 2 [OII_W42BOS]
    W42EOS,  -- Thu.:end 2 [OII_W42EOS]
    W51BOS,  -- Fri.:begin 1 [OII_W51BOS]
    W51EOS,  -- Fri.:end 1 [OII_W51EOS]
    W52BOS,  -- Fri.:begin 2 [OII_W52BOS]
    W52EOS,  -- Fri.:end 2 [OII_W52EOS]
    W61BOS,  -- Sat.:begin 1 [OII_W61BOS]
    W61EOS,  -- Sat.:end 1 [OII_W61EOS]
    W62BOS,  -- Sat.:begin 2 [OII_W62BOS]
    W62EOS,  -- Sat.:end 2 [OII_W62EOS]
    W71BOS,  -- Sun.:begin 1 [OII_W71BOS]
    W71EOS,  -- Sun.:end 1 [OII_W71EOS]
    W72BOS,  -- Sun.:begin 2 [OII_W72BOS]
    W72EOS,  -- Sun.:end 2 [OII_W72EOS]
    W81BOS,  -- Hol.:begin 1 [OII_W81BOS]
    W81EOS,  -- Hol.:end 1 [OII_W81EOS]
    W82BOS,  -- Hol.:begin 2 [OII_W82BOS]
    W82EOS,  -- Hol.:end 2 [OII_W82EOS]
    ERDAT,   -- Date created [OII_ERDAT]
    ERZEIT,  -- Time created [OII_ERZEIT]
    ERNAM,   -- Created by [OII_ERNAM]
    AEDAT,   -- Date changed [OII_AEDAT]
    AEZEIT,  -- Time changed [OII_AEZEIT]
    AENAM,   -- Changed by [OII_AENAM]
    BLOIND,  -- Blocking ind. [OII_BLOIND]
    DELIND,  -- Deletion ind. [OII_DELIND]
    BLOSH,   -- Block sls.hrs. [OII_BLOSH]
    BLOLT,   -- Block ld.times [OII_BLOLT]
    SOEGRP,  -- SOE default grp [OII_SOEGRP]
    TPIPRD,  -- Def.prtnr.role [OII_TPIPRD]
    CONWK,   -- Consign StkPlnt [OII_CONWK]
    CONLG,   -- Consign StkSLoc [OII_CONLG]
    RCBLK,   -- Block rpln.calc [OII_RCBLK]
    DOBLK,   -- Block dispOpt [OII_DOBLK]
    PRIMARY KEY (MANDT, PBLNR, RNBT, PARFN)
);

Learn More