S280 SAP (Order header and item, BW) Table details

Dictionary Type: Table
Description: Order header and item, BW




ABAP Code to SELECT data from S280
Related tables to S280
Access table S280




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
MANDTClient MANDTCLNT3T000MANDT
SSOURStatistic(s) origin SSOURCHAR4SSOUR
VRSIOVersion number in the information structure VRSIOCHAR3Assigned to domainVRSIOMCV
SPMONPeriod to analyze - month SPMONNUMC6PERIMCPERIOD
SPTAGPeriod to analyze - current date SPTAGDATS8DATUM
SPWOCPeriod to analyze - week SPWOCNUMC6PERIMCPERIOD
SPBUPPeriod to analyze - posting period SPBUPNUMC6PERIMCPERIOD
AUFNROrder Number AUFNRCHAR12AUFKALPHAAUFNRANR
POSNROrder Item Number CO_POSNRNUMC4CO_POSNR
PERIVFiscal Year Variant PERIVCHAR2Assigned to domainPERIV
VWDATPointer to administrative data VWDATNUMC10VWDAT
MEINSBase Unit of Measure LAGMEUNIT3T006CUNITMEINS
DFZEHUnit of measure for execution time DFZEHUNIT3CUNITEINHEIT
KEINHUnit of of measure for displaying capacity requirements CY_KEINHUNIT3T006CUNITMEINS
GLTRPBasic finish date CO_GLTRPDATS8DATUM
FTRMIActual release date CO_FTRMIDATS8DATUM
FTRMPPlanned release date CO_FTRMPDATS8DATUM
GSTRIActual start date CO_GSTRIDATS8DATUM
GETRIConfirmed Order Finish Date CO_GETRIDATS8DATUM
GSTRPBasic start date CO_GSTRPDATS8DATUM
GLTRSScheduled finish CO_GLTRSDATS8DATUM
FTRMSScheduled release date CO_FTRMSDATS8DATUM
GSTRSScheduled start CO_GSTRSDATS8DATUM
LTRMIActual delivery/finish date CO_LTRMIDATS8DATUM
LTRMPDelivery date from planned order CO_LTRMPDATS8DATUM
ETRMPOpening date of the planned order CO_ETRMPDATS8DATUM
STRMPStart date of the planned order CO_STRMPDATS8DATUM
PGMNGTotal planned order quantity MC_GSMNGQUAN15(3) MENGV15_3
PAMNGFixed quantity of scrap from production MC_AVMNGQUAN15(3) MENGV15_3
PSMNGOrder item quantity MC_PSMNGQUAN15(3) MENGV15_3
PSAMGScrap quantity in item MC_PSAMGQUAN15(3) MENGV15_3
WEMNGQuantity of goods received MC_WEMNGQUAN15(3) MENGV15_3
IAMNGActual scrap quantity from an order item MC_IAMNGQUAN15(3) MENGV15_3
S_DFZTarget execution time S_DFZQUAN7(1) DAUER_6_1V
I_DFZActual execution time I_DFZQUAN7(1) DAUER_6_1V
KSUMSTotal target capacity requirements MC_KSUMSQUAN7(1) DAUER_6_1V
MCGLTRPBasic Finish Date MCGLTRPDEC9DEC9
MCGSTRPBasic start date MCGSTRPDEC9DEC9
MCFTRMPPlanned release date MCFTRMPDEC9DEC9
MCLTRMIActual delivery/finish date MCLTRMIDEC9DEC9
MCGETRIConfirmed Order Finish Date MCGETRIDEC9DEC9
MCFTRMIActual release date MCFTRMIDEC9DEC9
MCGSTRIActual Start Date MCGSTRIDEC9DEC9
MCLTRMPDelivery date from planned order MCLTRMPDEC9DEC9
MCETRMPOpening Date of the Planned Order MCETRMPDEC9DEC9
MCSTRMPStart date of the planned order MCSTRMPDEC9DEC9
MCFTRMSScheduled release date MCFTRMSDEC9DEC9
MCGSTRSScheduled Start MCGSTRSDEC9DEC9
MCGLTRSScheduled finish MCGLTRSDEC9DEC9
WERKSPlant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
MATNRMaterial Number MATNRCHAR18MARAMATN1MATNRMATS_MAT1
KDAUFSales order number CO_KDAUFCHAR10VBUKALPHAVBELNAUN
PWERKPlanning plant for the order CO_PWERKCHAR4T001WWERKS
P_DLZPlanned lead time P_DLZQUAN7(1) DAUER_6_1V
S_DLZTarget lead time S_DLZQUAN7(1) DAUER_6_1V
I_DLZActual lead time I_DLZQUAN7(1) DAUER_6_1V
PS_FREIPlanned/target deviation in scheduled release date PS_FREIQUAN7(1) DAUER_6_1V
PI_FREIPlanned/actual deviation in scheduled release date PI_FREIQUAN7(1) DAUER_6_1V
SI_FREITarget/actual deviation in scheduled release date DSI_FREIQUAN7(1) DAUER_6_1V
PS_STARPlanned/target deviation in start date PS_STARQUAN7(1) DAUER_6_1V
PI_STARPlanned/actual deviation in scheduled start date PI_STARQUAN7(1) DAUER_6_1V
SI_STARTarget/actual schedule deviation in start date DSI_STARQUAN7(1) DAUER_6_1V
PS_LIEFPlanned/target deviation in scheduled delivery date PS_LIEFQUAN7(1) DAUER_6_1V
PI_LIEFPlanned/actual deviation in scheduled delivery date PI_LIEFQUAN7(1) DAUER_6_1V
SI_LIEFTarget/actual deviation in scheduled delivery date DSI_LIEFQUAN7(1) DAUER_6_1V
PI_FREIPRelease Schedule Deviation Plan/Actual Positive PI_FREIPQUAN7(1) DAUER_6_1
PI_FREINRelease Schedule Deciation Plan/Actual Negative PI_FREINQUAN7(1) DAUER_6_1
PI_LIEFPDelivery Schedule Deviation Plan/Actual Positive PI_LIEFPQUAN7(1) DAUER_6_1
PI_LIEFNDelivery Schedule Deviation Plan/Actual Negative PI_LIEFNQUAN7(1) DAUER_6_1
PI_STARPStart Schedule Deviation Plan/Actual Positive PI_STARPQUAN7(1) DAUER_6_1
PI_STARNStart Schedule Deviation Plan/Actual Negative PI_STARNQUAN7(1) DAUER_6_1
PS_FREIPRelease Schedule Deviation Plan/Target Positive PS_FREIPQUAN7(1) DAUER_6_1
PS_FREINRelease Schedule Deviation Plan/Target Negative PS_FREINQUAN7(1) DAUER_6_1
PS_LIEFPDelivery Schedule Deviation Plan/Target Positive PS_LIEFPQUAN7(1) DAUER_6_1
PS_LIEFNDelivery Schedule Deviation Plan/Target Negative PS_LIEFNQUAN7(1) DAUER_6_1
PS_STARPStart Schedule Deviation Plan/Target Positive PS_STARPQUAN7(1) DAUER_6_1
PS_STARNStart Schedule Deviation Plan/Target Negative PS_STARNQUAN7(1) DAUER_6_1
SI_FREIPRelease Date Variance Target/Actual Positive DSI_FREIPQUAN7(1) DAUER_6_1
SI_FREINRelease Date Variance Target/Actual Negative DSI_FREINQUAN7(1) DAUER_6_1
SI_LIEFPDelivery Date Variance Target/Actual Positive DSI_LIEFPQUAN7(1) DAUER_6_1
SI_LIEFNDelivery Date Variance Target/Actual Negative DSI_LIEFNQUAN7(1) DAUER_6_1
SI_STARPStart Date Variance Target/Actual Positive DSI_STARPQUAN7(1) DAUER_6_1
SI_STARNStart Date Variance Target/Actual Negative DSI_STARNQUAN7(1) DAUER_6_1
ANZFANumber of production orders MC_ANZFADEC9MCZAEHLER

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 table
DATA: 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 as

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


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!