CFSWCAVAILCAP_D - I_WORKCENTERCAPOVERVIEWTP I_WRKCTRAVAILABLECAPACITYTP
I_WORKCENTERCAPOVERVIEWTP I_WRKCTRAVAILABLECAPACITYTP information is stored in SAP table CFSWCAVAILCAP_D.
It is part of development package PPH_VDM_CAP_EVAL in software component PP-CFS-CE. This development package consists of objects that can be grouped under "Capacity Evaluation:Interface & Private CDS views only".
It is part of development package PPH_VDM_CAP_EVAL in software component PP-CFS-CE. This development package consists of objects that can be grouped under "Capacity Evaluation:Interface & Private CDS views only".
Fields for table CFSWCAVAILCAP_D
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
MANDT | Client | X | MANDT | CLNT | 6 | |
DRAFTUUID | UUID serving as key (parent key, root key) | X | /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 | 16 | ||
WORKCENTERTYPECODE | Object types of the CIM resource | CR_OBJTY | CHAR | 4 | ||
CAPACITYCATEGORYALLOCATION | Capacity allocation number | CR_CAPNUM | NUMC | 8 | ||
CAPACITYINTERNALID | Capacity ID | KAPID | NUMC | 16 | ||
CALENDARDATE | Valid-to date | DATUB | DATS | 16 | ||
VALIDITYENDDATE | Valid-to date | DATUB | DATS | 16 | ||
CAPACITYACTIVEVERSION | Active Version of Available Capacity | KAPVERSAKT | NUMC | 4 | ||
AVAILABLECAPACITYSHIFT | Single-Character Flag | CHAR1 | CHAR | 2 | ||
WEEKDAY | Single-Character Flag | CHAR1 | CHAR | 2 | ||
SHIFTSTARTDATE | Valid-to date | DATUB | DATS | 16 | ||
SHIFTSTARTTIME | Start Time | KAPBEGZEIT | TIMS | 12 | ||
SHIFTENDDATE | Valid-to date | DATUB | DATS | 16 | ||
SHIFTENDTIME | Start Time | KAPBEGZEIT | TIMS | 12 | ||
CALENDARMONTH | Calendar Month | CALENDARMONTH | NUMC | 4 | ||
CALENDARYEAR | Calendar Year | CALENDARYEAR | NUMC | 8 | ||
CALENDARWEEK | Calendar Week | CALENDARWEEK | NUMC | 4 | ||
WORKDAYS | 4 Byte Signed Integer | INT4 | INT4 | 4 | ||
SHIFTNAME | Undefined range (can be used for patch levels) | CHAR4 | CHAR | 8 | ||
SHIFTDEFINITION | Shift Definition | KAPTPROG | CHAR | 8 | ||
SHIFTDEFINITIONNAME | Text for Shift Definition | SCHTXT | CHAR | 30 | ||
SHIFTGROUPING | Grouping for Shift Definitions and Shift Sequences | SCHGRUP | CHAR | 4 | ||
WORKDAYRULE | Indicator: Workdays | KAPFABTAG | CHAR | 2 | ||
FACTORYCALENDAR | Factory Calendar ID | CR_WFCID | CHAR | 4 | ||
CAPACITYSTARTTIME | Start time in seconds (internal) | KAPBEGZT | INT4 | 4 | ||
CAPACITYENDTIME | End Time in Seconds (internal) | KAPENDZT | INT4 | 4 | ||
CAPACITYBREAKDURATION | Break duration in hours | PPH_CAP_EVAL_BREAKHOURS | DEC | 3 | ||
WORKCENTERCAPACITYUNIT | Unit | UNIT | UNIT | 6 | ||
CAPACITYNUMBEROFCAPACITIES | Number of Individual Capacities | KAPANZAHL | INT2 | 2 | ||
WORKCENTERUTILIZATIONUNIT | Unit | UNIT | UNIT | 6 | ||
CAPACITYPLANUTILIZATIONPERCENT | Capacity Utilization Ratio in Percent | NUTZGRAD | NUMC | 6 | ||
VALIDITYBEGINDATE | Valid-to date | DATUB | DATS | 16 | ||
SHIFTSTATUSTEXT | Character Field with Length 10 | CHAR10 | CHAR | 20 | ||
SHIFTSTATUSCODE | Change Status for an Interval/Shift | CFS_INTERVAL_CHANGE_STATUS | CHAR | 2 | ||
TOTOPERATINGDURATIONINHOURS | Capacity expressed in a specific unit of measure | KAPAZIT_EH | QUAN | 5 | ||
OPERATINGCAPACITYDURATIONINHRS | Capacity in hours | KAPAZIT_H | DEC | 4 | ||
HASACTIVEENTITY | Draft - Indicator - Has active document | SDRAFT_HAS_ACTIVE | CHAR | 2 | ||
.INCLUDE | SDRAFT_WRITE_DRAFT_ADMIN | 0 | ||||
DRAFTENTITYCREATIONDATETIME | Draft Created On | SDRAFT_CREATED_AT | DEC | 11 | ||
DRAFTENTITYLASTCHANGEDATETIME | Draft Last Changed On | SDRAFT_LAST_CHANGED_AT | DEC | 11 | ||
DRAFTADMINISTRATIVEDATAUUID | Technical ID for the Administrative Data of a Draft Document | SDRAFT_ADMIN_UUID | RAW | 16 | ||
DRAFTENTITYCONSISTENCYSTATUS | Draft - Consistency Status | SDRAFT_CONSISTENCY_STATUS | CHAR | 2 | ||
DRAFTENTITYOPERATIONCODE | Draft - Operation Code | SDRAFT_OPERATION_CODE | CHAR | 2 |