S280 SAP (Order header and item, BW) Table details
Dictionary Type: Table
Description: Order header and item, BW
Description: Order header and item, BW
Table field list including key, data, relationships and ABAP select examples
S280 is a standard SAP Table which is used to store Order header and item, BW data and is available within R/3 SAP systems depending on the version and release level.
The S280 table consists of various fields, each holding specific information or linking keys about Order header and item, BW data available in SAP. These include SSOUR (Statistic(s) origin), VRSIO (Version number in the information structure), SPMON (Period to analyze - month), SPTAG (Period to analyze - current date).. 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. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced
SAP S280 table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
SSOUR | Statistic(s) origin | SSOUR | CHAR | 4 | SSOUR | ||||
VRSIO | Version number in the information structure | VRSIO | CHAR | 3 | Assigned to domain | VRSIO | MCV | ||
SPMON | Period to analyze - month | SPMON | NUMC | 6 | PERI | MCPERIOD | |||
SPTAG | Period to analyze - current date | SPTAG | DATS | 8 | DATUM | ||||
SPWOC | Period to analyze - week | SPWOC | NUMC | 6 | PERI | MCPERIOD | |||
SPBUP | Period to analyze - posting period | SPBUP | NUMC | 6 | PERI | MCPERIOD | |||
AUFNR | Order Number | AUFNR | CHAR | 12 | AUFK | ALPHA | AUFNR | ANR | |
POSNR | Order Item Number | CO_POSNR | NUMC | 4 | CO_POSNR | ||||
PERIV | Fiscal Year Variant | PERIV | CHAR | 2 | Assigned to domain | PERIV | |||
VWDAT | Pointer to administrative data | VWDAT | NUMC | 10 | VWDAT | ||||
MEINS | Base Unit of Measure | LAGME | UNIT | 3 | T006 | CUNIT | MEINS | ||
DFZEH | Unit of measure for execution time | DFZEH | UNIT | 3 | CUNIT | EINHEIT | |||
KEINH | Unit of of measure for displaying capacity requirements | CY_KEINH | UNIT | 3 | T006 | CUNIT | MEINS | ||
GLTRP | Basic finish date | CO_GLTRP | DATS | 8 | DATUM | ||||
FTRMI | Actual release date | CO_FTRMI | DATS | 8 | DATUM | ||||
FTRMP | Planned release date | CO_FTRMP | DATS | 8 | DATUM | ||||
GSTRI | Actual start date | CO_GSTRI | DATS | 8 | DATUM | ||||
GETRI | Confirmed Order Finish Date | CO_GETRI | DATS | 8 | DATUM | ||||
GSTRP | Basic start date | CO_GSTRP | DATS | 8 | DATUM | ||||
GLTRS | Scheduled finish | CO_GLTRS | DATS | 8 | DATUM | ||||
FTRMS | Scheduled release date | CO_FTRMS | DATS | 8 | DATUM | ||||
GSTRS | Scheduled start | CO_GSTRS | DATS | 8 | DATUM | ||||
LTRMI | Actual delivery/finish date | CO_LTRMI | DATS | 8 | DATUM | ||||
LTRMP | Delivery date from planned order | CO_LTRMP | DATS | 8 | DATUM | ||||
ETRMP | Opening date of the planned order | CO_ETRMP | DATS | 8 | DATUM | ||||
STRMP | Start date of the planned order | CO_STRMP | DATS | 8 | DATUM | ||||
PGMNG | Total planned order quantity | MC_GSMNG | QUAN | 15(3) | MENGV15_3 | ||||
PAMNG | Fixed quantity of scrap from production | MC_AVMNG | QUAN | 15(3) | MENGV15_3 | ||||
PSMNG | Order item quantity | MC_PSMNG | QUAN | 15(3) | MENGV15_3 | ||||
PSAMG | Scrap quantity in item | MC_PSAMG | QUAN | 15(3) | MENGV15_3 | ||||
WEMNG | Quantity of goods received | MC_WEMNG | QUAN | 15(3) | MENGV15_3 | ||||
IAMNG | Actual scrap quantity from an order item | MC_IAMNG | QUAN | 15(3) | MENGV15_3 | ||||
S_DFZ | Target execution time | S_DFZ | QUAN | 7(1) | DAUER_6_1V | ||||
I_DFZ | Actual execution time | I_DFZ | QUAN | 7(1) | DAUER_6_1V | ||||
KSUMS | Total target capacity requirements | MC_KSUMS | QUAN | 7(1) | DAUER_6_1V | ||||
MCGLTRP | Basic Finish Date | MCGLTRP | DEC | 9 | DEC9 | ||||
MCGSTRP | Basic start date | MCGSTRP | DEC | 9 | DEC9 | ||||
MCFTRMP | Planned release date | MCFTRMP | DEC | 9 | DEC9 | ||||
MCLTRMI | Actual delivery/finish date | MCLTRMI | DEC | 9 | DEC9 | ||||
MCGETRI | Confirmed Order Finish Date | MCGETRI | DEC | 9 | DEC9 | ||||
MCFTRMI | Actual release date | MCFTRMI | DEC | 9 | DEC9 | ||||
MCGSTRI | Actual Start Date | MCGSTRI | DEC | 9 | DEC9 | ||||
MCLTRMP | Delivery date from planned order | MCLTRMP | DEC | 9 | DEC9 | ||||
MCETRMP | Opening Date of the Planned Order | MCETRMP | DEC | 9 | DEC9 | ||||
MCSTRMP | Start date of the planned order | MCSTRMP | DEC | 9 | DEC9 | ||||
MCFTRMS | Scheduled release date | MCFTRMS | DEC | 9 | DEC9 | ||||
MCGSTRS | Scheduled Start | MCGSTRS | DEC | 9 | DEC9 | ||||
MCGLTRS | Scheduled finish | MCGLTRS | DEC | 9 | DEC9 | ||||
WERKS | Plant | WERKS_D | CHAR | 4 | T001W | WERKS | WRK | H_T001W_C | |
MATNR | Material Number | MATNR | CHAR | 18 | MARA | MATN1 | MATNR | MAT | S_MAT1 |
KDAUF | Sales order number | CO_KDAUF | CHAR | 10 | VBUK | ALPHA | VBELN | AUN | |
PWERK | Planning plant for the order | CO_PWERK | CHAR | 4 | T001W | WERKS | |||
P_DLZ | Planned lead time | P_DLZ | QUAN | 7(1) | DAUER_6_1V | ||||
S_DLZ | Target lead time | S_DLZ | QUAN | 7(1) | DAUER_6_1V | ||||
I_DLZ | Actual lead time | I_DLZ | QUAN | 7(1) | DAUER_6_1V | ||||
PS_FREI | Planned/target deviation in scheduled release date | PS_FREI | QUAN | 7(1) | DAUER_6_1V | ||||
PI_FREI | Planned/actual deviation in scheduled release date | PI_FREI | QUAN | 7(1) | DAUER_6_1V | ||||
SI_FREI | Target/actual deviation in scheduled release date | DSI_FREI | QUAN | 7(1) | DAUER_6_1V | ||||
PS_STAR | Planned/target deviation in start date | PS_STAR | QUAN | 7(1) | DAUER_6_1V | ||||
PI_STAR | Planned/actual deviation in scheduled start date | PI_STAR | QUAN | 7(1) | DAUER_6_1V | ||||
SI_STAR | Target/actual schedule deviation in start date | DSI_STAR | QUAN | 7(1) | DAUER_6_1V | ||||
PS_LIEF | Planned/target deviation in scheduled delivery date | PS_LIEF | QUAN | 7(1) | DAUER_6_1V | ||||
PI_LIEF | Planned/actual deviation in scheduled delivery date | PI_LIEF | QUAN | 7(1) | DAUER_6_1V | ||||
SI_LIEF | Target/actual deviation in scheduled delivery date | DSI_LIEF | QUAN | 7(1) | DAUER_6_1V | ||||
PI_FREIP | Release Schedule Deviation Plan/Actual Positive | PI_FREIP | QUAN | 7(1) | DAUER_6_1 | ||||
PI_FREIN | Release Schedule Deciation Plan/Actual Negative | PI_FREIN | QUAN | 7(1) | DAUER_6_1 | ||||
PI_LIEFP | Delivery Schedule Deviation Plan/Actual Positive | PI_LIEFP | QUAN | 7(1) | DAUER_6_1 | ||||
PI_LIEFN | Delivery Schedule Deviation Plan/Actual Negative | PI_LIEFN | QUAN | 7(1) | DAUER_6_1 | ||||
PI_STARP | Start Schedule Deviation Plan/Actual Positive | PI_STARP | QUAN | 7(1) | DAUER_6_1 | ||||
PI_STARN | Start Schedule Deviation Plan/Actual Negative | PI_STARN | QUAN | 7(1) | DAUER_6_1 | ||||
PS_FREIP | Release Schedule Deviation Plan/Target Positive | PS_FREIP | QUAN | 7(1) | DAUER_6_1 | ||||
PS_FREIN | Release Schedule Deviation Plan/Target Negative | PS_FREIN | QUAN | 7(1) | DAUER_6_1 | ||||
PS_LIEFP | Delivery Schedule Deviation Plan/Target Positive | PS_LIEFP | QUAN | 7(1) | DAUER_6_1 | ||||
PS_LIEFN | Delivery Schedule Deviation Plan/Target Negative | PS_LIEFN | QUAN | 7(1) | DAUER_6_1 | ||||
PS_STARP | Start Schedule Deviation Plan/Target Positive | PS_STARP | QUAN | 7(1) | DAUER_6_1 | ||||
PS_STARN | Start Schedule Deviation Plan/Target Negative | PS_STARN | QUAN | 7(1) | DAUER_6_1 | ||||
SI_FREIP | Release Date Variance Target/Actual Positive | DSI_FREIP | QUAN | 7(1) | DAUER_6_1 | ||||
SI_FREIN | Release Date Variance Target/Actual Negative | DSI_FREIN | QUAN | 7(1) | DAUER_6_1 | ||||
SI_LIEFP | Delivery Date Variance Target/Actual Positive | DSI_LIEFP | QUAN | 7(1) | DAUER_6_1 | ||||
SI_LIEFN | Delivery Date Variance Target/Actual Negative | DSI_LIEFN | QUAN | 7(1) | DAUER_6_1 | ||||
SI_STARP | Start Date Variance Target/Actual Positive | DSI_STARP | QUAN | 7(1) | DAUER_6_1 | ||||
SI_STARN | Start Date Variance Target/Actual Negative | DSI_STARN | QUAN | 7(1) | DAUER_6_1 | ||||
ANZFA | Number of production orders | MC_ANZFA | DEC | 9 | MCZAEHLER |
Key field | Non-key field |
How do I retrieve data from SAP table S280 using ABAP code
The following ABAP code Example will allow you to do a basic selection on S280 to SELECT all data from the tableDATA: WA_S280 TYPE S280.
SELECT SINGLE *
FROM S280
INTO CORRESPONDING FIELDS OF WA_S280
WHERE...
How to access SAP table S280
Within an ECC or HANA version of SAP you can also view further information about S280 and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects