SAP CAPSHIFT Shift Information for the Capacity Table data and field list

CAPSHIFT is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Shift Information for the Capacity" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_CAPSHIFT TYPE CAPSHIFT.

The CAPSHIFT table consists of various fields, each holding specific information or linking keys about Shift Information for the Capacity data available in SAP. These include KAPID (Capacity ID), TAGE (System Date), SCHNR (Shift number of the available capacity), DTELI (Downtime Element ID)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

CAPSHIFT structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

SAP CAPSHIFT structure fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the CAPSHIFT table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
ARBID	Object ID of the resource	CR_OBJID	NUMC	8	Assigned to domain		CR_OBJID
KAPID	Capacity ID	KAPID	NUMC	8	Assigned to domain		KAPID
TAGE	System Date	SYDATUM	DATS	8			SYDATS
SCHNR	Shift number of the available capacity	SCHICHTNR	NUMC	1			NUM01
DTELI	Downtime Element ID	DTELI	CHAR	8	Assigned to domain		DTELID
STATU	Status of the Capacity	KAPST	CHAR	10			KAPSTATU
KAPAR	Capacity category	KAPAR	CHAR	3			CHAR3
BEGZT	Start time in seconds (internal)	KAPBEGZT	INT4	10			INT4
ENDZT	Finish time in seconds (internal)	KAPENDZT	INT4	10			INT4
DTSUM	Predefined Total Time	DTIMESUM	QUAN	13(3)			MENG13
ATSUM	Actual Time Total	ATIMESUM	QUAN	13(3)			MENG13
KEINH	Unit of the capacity requirements	KAPEH	UNIT	3	Assigned to domain	CUNIT	MEINS

Key field

Non-key field

< CAPRELATION_WRITE005 - GRPHIER_WRITE : Segment CAPRELATION_WRITE CAPTAX_NUM000 - CAPGEN_OBJ_WRITE : Segment CAPTAX_NUM >

How do I retrieve data from SAP structure CAPSHIFT using ABAP code?

As CAPSHIFT is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on CAPSHIFT as there is no data to select.

How to access SAP table CAPSHIFT

Within an ECC or HANA version of SAP you can also view further information about CAPSHIFT and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).