OIISCPKN SAP table for – SCP: Site control parameters (customer) – IS-Oil BDRP

Here we would like to draw your attention to OIISCPKN table in SAP. As we know it is being mainly used with the SAP IS-OIL-DS (Downstream in IS-OIL) component which is coming under IS-OIL module (Oil & Gas). OIISCPKN is a SAP standard transp table used for storing SCP: Site control parameters (customer) – IS-Oil BDRP related data in SAP. It comes under the package OII.

SAP OIISCPKN table

Table OIISCPKN technical data

TableOIISCPKN
Data storingSCP: Site control parameters (customer) – IS-Oil BDRP
ModuleIS-OIL
Sub ModuleIS-OIL-DS-BDR
SAP PackageOII
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

SAP OIISCPKN Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in OIISCPKN table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • KUNNR : Customer Number
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • .INCLUDE : SCP: Site control parameters
  • VKFCAL : SCP: Site factory calendar – sales days
    Its data type is CHAR (Character String) with field length 2
  • VKFSID : SCP: Sales hour set ID
    Its data type is CHAR (Character String) with field length 3
  • W11BOS : Monday:time sales begin 1
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • W11EOS : Monday time sales end 1
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • W12BOS : Monday:time sales begin 2
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • W12EOS : Monday:time sales end 2
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • W21BOS : Tuesday:time sales begin 1
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • W21EOS : Tuesday:time sales end 1
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • W22BOS : Tuesday:time sales begin 2
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • W22EOS : Tuesday:time sales end 2
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • W31BOS : Wednesday:time sales begin 1
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • W31EOS : Wednesday:time sales end 1
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • W32BOS : Wednesday:time sales begin 2
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • W32EOS : Wednesday:time sales end 2
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • W41BOS : Thursday:time sales begin 1
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • W41EOS : Thursday:time sales end 1
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • W42BOS : Thursday:time sales begin 2
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • W42EOS : Thursday:time sales end 2
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • W51BOS : Friday:time sales begin 1
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • W51EOS : Friday:time sales end 1
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • W52BOS : Friday:time sales begin 2
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • W52EOS : Friday:time sales end 2
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • W61BOS : Saturday:time sales begin 1
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • W61EOS : Saturday:time sales end 1
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • W62BOS : Saturday:time sales begin 2
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • W62EOS : Saturday:time sales end 2
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • W71BOS : Sunday:time sales begin 1
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • W71EOS : Sunday:time sales end 1
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • W72BOS : Sunday:time sales begin 2
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • W72EOS : Sunday:time sales end 2
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • W81BOS : Public holiday: time sales begin 1
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • W81EOS : Public holiday: time sales end 1
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • W82BOS : Public holiday: time sales begin 2
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • W82EOS : Public holiday: time sales end 2
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • .INCLUDE : Standard status field set (BDRP)
  • ERDAT : Date record created
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ERZEIT : Time record created
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • ERNAM : User who created record
    Its data type is CHAR (Character String) with field length 12
  • AEDAT : Date record changed
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • AEZEIT : Time record changed
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • AENAM : User who changed record
    Its data type is CHAR (Character String) with field length 12
  • BLOIND : Blocking indicator
    Its data type is CHAR (Character String) with field length 1
  • DELIND : Deletion indicator
    Its data type is CHAR (Character String) with field length 1
  • BLOSH : Site control: block use of sales hours
    Its data type is CHAR (Character String) with field length 1
  • BLOLT : Site control: block use of lead time entries
    Its data type is CHAR (Character String) with field length 1
  • SOEGRP : Sales order entry default group
    Its data type is CHAR (Character String) with field length 4
  • TPIPRD : OIL-TPI: Default partner role for partner look-up
    Its data type is CHAR (Character String) with field length 4
  • CONWK : OIL-BDRP: Consignment stock receiving plant in delivery
    Its data type is CHAR (Character String) with field length 4
  • CONLG : OIL-BDRP: Consignment stock receiving s/loc in delivery
    Its data type is CHAR (Character String) with field length 4
  • RCBLK : Block automatic replenishment at this site (OIL-BDRP)
    Its data type is CHAR (Character String) with field length 1
  • DOBLK : Block dispatch optimization at this site (OIL-BDRP)
    Its data type is CHAR (Character String) with field length 1