COAS SAP (Generated Table for View) Table View details

Dictionary Type: Table View
Description: Generated Table for View




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




Table View field list including key, data, relationships and ABAP select examples

COAS is a standard SAP Table View which is used to store Generated Table for View data and is available within R/3 SAP systems depending on the version and release level.

The COAS table consists of various fields, each holding specific information or linking keys about Generated Table for View data available in SAP. These include AUFNR (Order Number), AUART (Order Type), AUTYP (Order category), REFNR (Reference order number).. 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:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP COAS table view 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
AUFNROrder Number AUFNRCHAR12ALPHAAUFNRANR
AUARTOrder Type AUFARTCHAR4T003OAUFARTAAT
AUTYPOrder category AUFTYPNUMC2AUFTYP
REFNRReference order number AUFREFNRCHAR12AUFKALPHAAUFNRANV
ERNAMEntered by AUFERFNAMCHAR12USNAM
ERDATCreated on AUFERFDATDATS8DATUM
AENAMLast changed by AUFAENAMCHAR12USNAM
AEDATChange date for Order Master AUFAEDATDATS8DATUM
KTEXTDescription AUFTEXTCHAR40TEXT40
LTEXTLong Text Exists AUFLTEXTCHAR1XFELD
BUKRSCompany Code BUKRSCHAR4T001BUKRSBUKC_T001
WERKSPlant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
GSBERBusiness Area GSBERCHAR4TGSBGSBERGSB
KOKRSControlling Area KOKRSCHAR4TKA01CACCDCAC
CCKEYCost collector key CCKEYCHAR23CCKEY
KOSTVResponsible cost center AUFKOSTVCHAR10CSKSALPHAKOSTL
STORTLocation AUFSTORTCHAR10T499SAP_STAND
SOWRKLocation plant AUFSOWRKCHAR4T001WWERKS
ASTKZIdentifier for statistical order AUFSTKZCHAR1XFELD
WAERSOrder Currency AUFWAERSCUKY5TCURCWAERS
ASTNROrder status AUFASTNRNUMC2AUFSTNR
STDATDate of last status change AUFSTDATDATS8DATUM
ESTNRStatus reached so far AUFESTNRNUMC2TKO03AUFSTNR
PHAS0Phase 'Order created' AUFPHAS0CHAR1XFELD
PHAS1Phase 'Order released' AUFPHAS1CHAR1XFELD
PHAS2Phase 'order completed' AUFPHAS2CHAR1XFELD
PHAS3Phase 'order closed' AUFPHAS3CHAR1XFELD
PDAT1Planned release date AUFPDAT1DATS8DATUM
PDAT2Planned completion date AUFPDAT2DATS8DATUM
PDAT3Planned closing date AUFPDAT3DATS8DATUM
IDAT1Release date AUFIDAT1DATS8DATUM
IDAT2Technical completion date AUFIDAT2DATS8DATUM
IDAT3Close date AUFIDAT3DATS8DATUM
OBJIDObject ID CCOBJIDCHAR1CHAR1
VOGRPGroup of disallowed transactions AUFSPSETCHAR4TKAVGVOGRP
LOEKZDeletion flag AUFLOEKZCHAR1XFELD
PLGKZIdentifier for planning with line items PLGKZCHAR1XFELD
KVEWEUsage of the condition table KVEWECHAR1T681VKVEWEKVW
KAPPLApplication KAPPLCHAR2T681AKAPPLKAP
KALSMCosting Sheet AUFKALSMCHAR6T683KALSM
ZSCHLOverhead key AUFZSCHLCHAR6CHAR6
ABKRSProcessing group AUFABKRSNUMC2TKO08AKREISAKR
KSTARSettlement cost element AUFKSTARCHAR10CSKBALPHAKSTAR
KOSTLCost center for basic settlement AUFKOSTLCHAR10CSKSALPHAKOSTLKOS
SAKNRG/L account for basic settlement AUFSAKNRCHAR10SKB1ALPHASAKNRSAK
SETNMAllocation set AUFSETNMCHAR12SETNRGSE
CYCLECost center to which costs are actually posted ST_KOSTLCHAR10CSKSALPHAKOSTL
SDATEStart Date SDATEDATS8SDATEGAS
SEQNRSequence number AUFSEQNRNUMC4SQNR
USER0Applicant AUFUSER0CHAR20AUFUSER0
USER1Applicant's telephone number AUFUSER1CHAR20AUFUSER1
USER2Person responsible AUFUSER2CHAR20AUFUSER2
USER3Telephone number of person in charge AUFUSER3CHAR20AUFUSER3
USER4Estimated total costs of order AUFUSER4CURR11(2) AUFUSER4
USER5Application Date AUFUSER5DATS8AUFUSER5
USER6Department AUFUSER6CHAR15AUFUSER6
USER7Work Start AUFUSER7DATS8AUFUSER7
USER8End of Work AUFUSER8DATS8AUFUSER8
USER9Identifier for work permit issued AUFUSER9CHAR1AUFUSER9
OBJNRObject number J_OBJNRCHAR22ONR00J_OBJNRONR
PRCTRProfit Center PRCTRCHAR10CEPCALPHAPRCTRPRCPRCTR_EMPTY
PSPELWork breakdown structure element (WBS element) PS_PSP_ELENUMC8PRPSKONPRPS_POSNR
AWSLSVariance Key AWSLSCHAR6TKV01AWSLS
ABGSLResults Analysis Key ABGR_SCHLCHAR6TKKAAABGR_SCHLACS
TXJCDTax Jurisdiction TXJCDCHAR15TTXJTXJCDTXJ
FUNC_AREAFunctional Area FKBERCHAR16TFKBFKBERFBE
SCOPEObject Class SCOPE_CVCHAR2SCOPESCOPE_CVPCO
PLINTIndicator for Integrated Planning PLINTCHAR1XFELD
KDAUFSales Order Number KDAUFCHAR10VBUKALPHAVBELNAUN
KDPOSItem Number in Sales Order KDPOSNUMC6NUM06KPO
AUFEXExternal order number AUFEXCHAR20ALPHAAUFEX
IVPROInvestment measure profile IM_PROFILCHAR6TAPRFIM_PROFIL
LOGSYSTEMLogical System LOGSYSTEMCHAR10TBDLSALPHALOGSYS
FLG_MLTPSOrder with multiple items CO_MLTPSCHAR1KREUZ
ABUKRRequesting company code IM_ABUKRSCHAR4T001BUKRSBUK
AKSTLRequesting cost center PS_AKSTLCHAR10CSKSALPHAKOSTLKOS
SIZECLScale of investment objects IM_SIZECLCHAR2TAIF5ALPHASIZECL
IZWEKReason for investment IZWEKCHAR2T087IIZWEK
UMWKZReason for environmental investment AM_UMWKZCHAR5T087KAM_UMWKZ
KSTEMPFIndicator: Direct cost collector CO_KSTEMPFCHAR1CO_KSTEMPF
ZSCHMInterest Profile for Project/Order Interest Calculation PS_ZSCHMCHAR7TPI01PS_ZSCHM
PKOSACost collector for production process PROCNR PKOSA_DCHAR12ALPHAAUFNR
ANFAUFNRRequesting order AUFANFNRCHAR12AUFKALPHAAUFNR
PROCNRProduction Process CKML_F_PROCNRNUMC12CK_KALNRCKML_PROCNR
PROTYProcess Category (Procurement/Consumption) CKML_PROZESS_TYPCHAR4CKML_PROZESS_TYP
RSORDRefurbishment order indicator (PM) RSORDCHAR1XFELD
BEMOTAccounting Indicator BEMOTCHAR2TBMOTBEMOT
ADRNRAAddress number AD_ADDRNUMCHAR10ALPHAAD_ADDRNUMADR
ERFZEITTime created CO_INS_TIMETIMS6UZEIT
AEZEITChanged at CO_CHG_TIMETIMS6UZEIT
CSTG_VRNTCosting Variant CK_KLVARCHAR4KLVARKRT
COSTESTNRCost Estimate Number for Cost Est. w/o Qty Structure CK_KALNRNUMC12CK_KALNRKNR
VERAA_USERPerson Responsible for CO Internal Order VERAA_USERCHAR12USR02XUBNAMEXUS
DUMMY_CI_AUFKSingle-Character Indicator CHAR1CHAR1CHAR1
VNAMEJoint Venture JV_NAMECHAR6T8JVALPHAJV_NAMEJVV
RECIDRecovery Indicator JV_RECINDCHAR2T8JJALPHAJV_RECIND
ETYPEEquity type JV_ETYPECHAR3T8JGALPHAJV_ETYPE
OTYPEJoint Venture Object Type JV_OTYPECHAR4ALPHAJV_OTYPE
JV_JIBCLJIB/JIBE Class JV_JIBCLCHAR3T8J6AJV_JIBCLJIB
JV_JIBSAJIB/JIBE Subclass A JV_JIBSACHAR5T8J6CJV_JIBSAJBS
JV_OCOJV original cost object JV_OR_COCHAR1JV_OR_COB
CPD_UPDATTime Stamp /CPD/PFP_TSTMPDEC15TSTLC/CPD/PFP_TSTMP
/CUM/INDCUCU: Order is Used for Compatible Units /CUM/INDCUCHAR1FLAG
/CUM/CMNUMCU: Construction Measure Number /CUM/CMNUMCHAR12ALPHA/CUM/CMNUM/CUM/CMNUM/CUM/V_CMNUM_ALL
/CUM/AUESTCU: Automatic Copy of Estimated Costs /CUM/AUESTCHAR1FLAG
/CUM/DESNUMCU: Design Number /CUM/DESNUMCHAR12ALPHA/CUM/DESNUM/CUM/DESNUM
/MRSS/PL_STRU_IDResource planning nodes /MRSS/T_PLAN_STRUCT_IDNUMC8CR_OBJID
/MRSS/PL_MAN_TYPAssignment to resource planner or contact person /MRSS/T_MANAGER_TYPECHAR1/MRSS/_MANAGER_TYPE
/MRSS/ORDER_PROBOrder probability in percent /MRSS/T_ORDER_PROBCHAR3OPROB/MRSS/_ORDER_PROB
/MRSS/ACT_TYPEProcess variant /MRSS/T_ACTIVITY_TYPECHAR1/MRSS/_ACTIVITY_TYPE
/MRSS/INIT_DONEInternal initialization carried out once /MRSS/T_INIT_DONECHAR1FLAG
/MRSS/DATACHANGEData was changed in the controls on the user screen /MRSS/T_USCREENCTL_DATACHANGEDCHAR1FLAG
/MRSS/SALES_ORGSales Organization VKORGCHAR4VKORGVKOC_VKORG
/MRSS/NW_BOOKEDNetwork Set to 'Booked' /MRSS/T_NW_BOOKEDCHAR1FLAG
AD01PROFNRDynamic Item Processor Profile AD01PROFNRCHAR8AD01C_PROFAD01PROFNRAD0DIP_PROFILE
VAPLZMain work center for maintenance tasks GEWRKCHAR8ARBPLVAP
WAWRKPlant associated with main work center WERGWCHAR4WERKS
FERC_INDRegulatory indicator FE_INDCHAR4FERC_C7ALPHAFE_IND
AUFK_STATUSStatus Combination ACTCMB_DELEINT13ACTCMB_TABACTCMB_DOM
CLAIM_CONTROLClaim creation control indicator WTYSC_CLAIM_CONTROLCHAR1WTYSCC_CLM_CONTWTYSC_CLAIM_CONTROL
UPDATE_NEEDEDClaim inconsistency with order indicator WTYSC_UPDATE_NEEDEDCHAR1WTYSC_UPDATE_NEEDED
UPDATE_CONTROLClaim update trigger point from service order WTYSC_UPDATE_CONTROLCHAR1WTYSCC_UPDT_CONTWTYSC_UPDATE_CONTROL

Key field Non-key field



How do I retrieve data from SAP table COAS using ABAP code

The following ABAP code Example will allow you to do a basic selection on COAS to SELECT all data from the table
DATA: WA_COAS TYPE COAS.

SELECT SINGLE *
FROM COAS
INTO CORRESPONDING FIELDS OF WA_COAS
WHERE...

How to access SAP table COAS

Within an ECC or HANA version of SAP you can also view further information about COAS 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!