OIISCPSH

Transparent Table Customizing Table
34 Fields 1 CDS Views

SCP: Site control parameters - sales hour sets

OIISCPSH is an SAP database table in S/4HANA. SCP: Site control parameters - sales hour sets. It contains 34 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_OIL_SteCtrlParamSlsHrSetVH view_entity from BASIC SCP Sales Hour Sets

Fields (34)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY 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

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 - sales hour sets
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIISCPSH (
    MANDT,   -- Client [MANDT]
    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]
    PRIMARY KEY (MANDT, VKFSID)
);

Learn More