The CFSWCINTERVAL_D table in SAP ERP or S/4HANA stores I_WORKCENTERCAPOVERVIEWTP I_WRKCTRCAPSHIFTINTERVALTP data. There are total 25 fields in CFSWCINTERVAL_D table. The I_WORKCENTERCAPOVERVIEWTP I_WRKCTRCAPSHIFTINTERVALTP table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of CFSWCINTERVAL_D table. It is in Capacity Evaluation:Interface & Private CDS views only (PPH_VDM_CAP_EVAL) ABAP package and is part of the Capacity Evaluation (PP-CFS-CE) module.
SAP CFSWCINTERVAL_D Table Fields
Following is the list of fields that are available in SAP CFSWCINTERVAL_D table. The primary key fields of the table are MANDT (Client), DRAFTUUID (UUID serving as key (parent key, root key)).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT (3) | |
| DRAFTUUID | UUID serving as key (parent key, root key) | /BOBF/UUID | RAW (16) | |
| PARENTDRAFTUUID | UUID serving as key (parent key, root key) | /BOBF/UUID | RAW (16) | |
| WORKCENTERINTERNALID | Object ID of the resource | CR_OBJID | NUMC (8) | |
| WORKCENTERTYPECODE | Object types of the CIM resource | CR_OBJTY | CHAR (2) | |
| CAPACITYCATEGORYALLOCATION | Capacity Category Allocation | PPH_CR_CAPNUM | NUMC (4) | |
| CAPACITYINTERNALID | Capacity ID | KAPID | NUMC (8) | |
| VALIDITYENDDATE | Valid-to date | DATUB | DATS (8) | |
| CAPACITYACTIVEVERSION | Active Version of Available Capacity | KAPVERSAKT | NUMC (2) | |
| VALIDITYENDDATEFOREDIT | Valid-to date | DATUB | DATS (8) | |
| VALIDITYBEGINDATE | Valid-to date | DATUB | DATS (8) | |
| WORKDAYRULE | Indicator: Workdays | KAPFABTAG | CHAR (1) | |
| CAPACITYNUMBEROFCAPACITIES | Number of Individual Capacities | KAPANZAHL | INT2 (5) | |
| AVAILABLECAPACITYINTERVALDURN | Two digit number | NUMC2 | NUMC (2) | |
| CAPACITYPLANUTILIZATIONPERCENT | Capacity Utilization Ratio in Percent | NUTZGRAD | NUMC (3) | |
| STDAVAILABLECAPACITYISVALID | Ind.: Standard Available Capacity is Valid for this Interval | KAP_KOPF | CHAR (1) | |
| SHIFTSEQUENCE | Key for the Shift Sequence | SCHPROG | CHAR (4) | |
| INTERVALSTATUSTEXT | Char 20 | CHAR20 | CHAR (20) | |
| INTERVALSTATUSCODE | Change Status for an Interval/Shift | CFS_INTERVAL_CHANGE_STATUS | CHAR (1) | |
| HASACTIVEENTITY | Draft – Indicator – Has active document | SDRAFT_HAS_ACTIVE | CHAR (1) | |
| DRAFTENTITYCREATIONDATETIME | Draft Created On | SDRAFT_CREATED_AT | DEC (21) | |
| DRAFTENTITYLASTCHANGEDATETIME | Draft Last Changed On | SDRAFT_LAST_CHANGED_AT | DEC (21) | |
| DRAFTADMINISTRATIVEDATAUUID | Technical ID for the Administrative Data of a Draft Document | SDRAFT_ADMIN_UUID | RAW (16) | |
| DRAFTENTITYCONSISTENCYSTATUS | Draft Consistency Status | SDRAFT_CONSISTENCY_STATUS | CHAR (1) | |
| DRAFTENTITYOPERATIONCODE | Draft – Operation Code | SDRAFT_OPERATION_CODE | CHAR (1) |
