COAS

115 Fields 1 CDS Views

Generated Table for View

COAS is an SAP database table in S/4HANA. Generated Table for View. It contains 115 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
CTE_CDS_FIN_MON_QM view inner CDS View for Monotoring QM exp to Concur

Fields (115)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY aufnr AUFNR Order
auart AUFART Order Type
autyp AUFTYP Order category
refnr AUFREFNR Order
ernam AUFERFNAM Entered By
erdat AUFERFDAT Created On
aenam AUFAENAM Changed By
aedat AUFAEDAT Changed On
ktext AUFTEXT Description
ltext AUFLTEXT Long Txt Exists
bukrs BUKRS Company Code
werks WERKS_D Plant
gsber GSBER Business Area
kokrs KOKRS CO Area
cckey CCKEY Cost Collector
kostv AUFKOSTV Resp. cost cntr
stort AUFSTORT Location
sowrk AUFSOWRK Location Plant
astkz AUFSTKZ Statistical
waers AUFWAERS Currency
astnr AUFASTNR Status
stdat AUFSTDAT Status Change
estnr AUFESTNR Reached Status
phas0 AUFPHAS0 Created
phas1 AUFPHAS1 Released
phas2 AUFPHAS2 Completed
phas3 AUFPHAS3 Closed
pdat1 AUFPDAT1 Planned release
pdat2 AUFPDAT2 PlannedCompltn
pdat3 AUFPDAT3 Planned.clo.dat
idat1 AUFIDAT1 Release
idat2 AUFIDAT2 Tech.Completion
idat3 AUFIDAT3 Close
objid CCOBJID Object ID
vogrp AUFSPSET DisTranGroup
loekz AUFLOEKZ Deletion Flag
plgkz PLGKZ Plan Line Items
kvewe KVEWE Usage
kappl KAPPL Application
kalsm AUFKALSM Costing Sheet
zschl AUFZSCHL Overhead key
abkrs AUFABKRS Process. group
kstar AUFKSTAR Settlement CE
kostl AUFKOSTL Cost Center
saknr AUFSAKNR G/L Account
setnm AUFSETNM Allocation Set
cycle ST_KOSTL CCtr: True post
sdate SDATE Valid From
seqnr AUFSEQNR Sequence Number
user0 AUFUSER0 Applicant
user1 AUFUSER1 Telephone
user2 AUFUSER2 Person resp.
user3 AUFUSER3 Telephone
user4 AUFUSER4 Estimated costs
user5 AUFUSER5 ApplicDate
user6 AUFUSER6 Department
user7 AUFUSER7 Work Start
user8 AUFUSER8 End of Work
user9 AUFUSER9 Work permit
objnr J_OBJNR Object number
prctr PRCTR Profit Center
pspel PS_PSP_ELE WBS Element
awsls AWSLS Variance key
abgsl ABGR_SCHL RA Key
ebw_key FCO_EBW_KEY Event-Based Proc Key
eb_post FCO_EB_POST Event-Based Posting
txjcd TXJCD Tax Jur.
func_area FKBER Functional Area
scope SCOPE_CV Object Class
plint PLINT Integ. Planning
kdauf KDAUF Sales Order
kdpos KDPOS Sales Ord. Item
aufex AUFEX Ext. order no.
ivpro IM_PROFIL Invest. Profile
logsystem LOGSYSTEM Logical System
flg_mltps CO_MLTPS Multiple Items
abukr IM_ABUKRS Req. co.code
akstl PS_AKSTL Req.cost center
sizecl IM_SIZECL Scale
izwek IZWEK Invest. Reason
umwkz AM_UMWKZ Envir. Invest.
kstempf CO_KSTEMPF Cost collector
zschm PS_ZSCHM Interest Prof.
pkosa PKOSA_D Cost Collector
anfaufnr AUFANFNR Req. order
procnr CKML_F_PROCNR Prod. Proc. No.
proty CKML_PROZESS_TYP Process Cat.
rsord RSORD Refurbishment
bemot BEMOT AcctIndicator
adrnra AD_ADDRNUM Address Number
erfzeit CO_INS_TIME Time created
aezeit CO_CHG_TIME Changed At
cstg_vrnt CK_KLVAR Costing Variant
costestnr CK_KALNR Cost EstimateNo
veraa_user VERAA_USER PersonResponsible
order_proc_mode ORDERPROCMODE Procurement Mode
zzbauleiter ZBAULEITER
eew_aufk_ps_dummy DUMMY Dummy function in length 1
vname JV_NAME Joint venture
recid JV_RECIND Recovery Ind.
etype JV_ETYPE Equity Type
otype JV_OTYPE JV Object Type
jv_jibcl JV_JIBCL JIB/JIBE Class
jv_jibsa JV_JIBSA JIB/JIBE SbClsA
jv_oco JV_OR_CO Or. Cost Obj.
cpd_updat /CPD/PFP_SC_TSTMP Time Stamp
ad01profnr AD01PROFNR DIP Profile
vaplz GEWRK Main WorkCtr
wawrk WERGW Plnt WorkCenter
ferc_ind FE_IND Reg. indicator
aufk_status ACTCMB_DELE Status Comb
claim_control WTYSC_CLAIM_CONTROL Clm Creation Cntrl
update_needed WTYSC_UPDATE_NEEDED Claim inconsistent
update_control WTYSC_UPDATE_CONTROL Claim Upd Trigger

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Generated Table for View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE COAS (
    MANDT,              -- Client [MANDT]
    AUFNR,              -- Order [AUFNR]
    AUART,              -- Order Type [AUFART]
    AUTYP,              -- Order category [AUFTYP]
    REFNR,              -- Order [AUFREFNR]
    ERNAM,              -- Entered By [AUFERFNAM]
    ERDAT,              -- Created On [AUFERFDAT]
    AENAM,              -- Changed By [AUFAENAM]
    AEDAT,              -- Changed On [AUFAEDAT]
    KTEXT,              -- Description [AUFTEXT]
    LTEXT,              -- Long Txt Exists [AUFLTEXT]
    BUKRS,              -- Company Code [BUKRS]
    WERKS,              -- Plant [WERKS_D]
    GSBER,              -- Business Area [GSBER]
    KOKRS,              -- CO Area [KOKRS]
    CCKEY,              -- Cost Collector [CCKEY]
    KOSTV,              -- Resp. cost cntr [AUFKOSTV]
    STORT,              -- Location [AUFSTORT]
    SOWRK,              -- Location Plant [AUFSOWRK]
    ASTKZ,              -- Statistical [AUFSTKZ]
    WAERS,              -- Currency [AUFWAERS]
    ASTNR,              -- Status [AUFASTNR]
    STDAT,              -- Status Change [AUFSTDAT]
    ESTNR,              -- Reached Status [AUFESTNR]
    PHAS0,              -- Created [AUFPHAS0]
    PHAS1,              -- Released [AUFPHAS1]
    PHAS2,              -- Completed [AUFPHAS2]
    PHAS3,              -- Closed [AUFPHAS3]
    PDAT1,              -- Planned release [AUFPDAT1]
    PDAT2,              -- PlannedCompltn [AUFPDAT2]
    PDAT3,              -- Planned.clo.dat [AUFPDAT3]
    IDAT1,              -- Release [AUFIDAT1]
    IDAT2,              -- Tech.Completion [AUFIDAT2]
    IDAT3,              -- Close [AUFIDAT3]
    OBJID,              -- Object ID [CCOBJID]
    VOGRP,              -- DisTranGroup [AUFSPSET]
    LOEKZ,              -- Deletion Flag [AUFLOEKZ]
    PLGKZ,              -- Plan Line Items [PLGKZ]
    KVEWE,              -- Usage [KVEWE]
    KAPPL,              -- Application [KAPPL]
    KALSM,              -- Costing Sheet [AUFKALSM]
    ZSCHL,              -- Overhead key [AUFZSCHL]
    ABKRS,              -- Process. group [AUFABKRS]
    KSTAR,              -- Settlement CE [AUFKSTAR]
    KOSTL,              -- Cost Center [AUFKOSTL]
    SAKNR,              -- G/L Account [AUFSAKNR]
    SETNM,              -- Allocation Set [AUFSETNM]
    CYCLE,              -- CCtr: True post [ST_KOSTL]
    SDATE,              -- Valid From [SDATE]
    SEQNR,              -- Sequence Number [AUFSEQNR]
    USER0,              -- Applicant [AUFUSER0]
    USER1,              -- Telephone [AUFUSER1]
    USER2,              -- Person resp. [AUFUSER2]
    USER3,              -- Telephone [AUFUSER3]
    USER4,              -- Estimated costs [AUFUSER4]
    USER5,              -- ApplicDate [AUFUSER5]
    USER6,              -- Department [AUFUSER6]
    USER7,              -- Work Start [AUFUSER7]
    USER8,              -- End of Work [AUFUSER8]
    USER9,              -- Work permit [AUFUSER9]
    OBJNR,              -- Object number [J_OBJNR]
    PRCTR,              -- Profit Center [PRCTR]
    PSPEL,              -- WBS Element [PS_PSP_ELE]
    AWSLS,              -- Variance key [AWSLS]
    ABGSL,              -- RA Key [ABGR_SCHL]
    EBW_KEY,            -- Event-Based Proc Key [FCO_EBW_KEY]
    EB_POST,            -- Event-Based Posting [FCO_EB_POST]
    TXJCD,              -- Tax Jur. [TXJCD]
    FUNC_AREA,          -- Functional Area [FKBER]
    SCOPE,              -- Object Class [SCOPE_CV]
    PLINT,              -- Integ. Planning [PLINT]
    KDAUF,              -- Sales Order [KDAUF]
    KDPOS,              -- Sales Ord. Item [KDPOS]
    AUFEX,              -- Ext. order no. [AUFEX]
    IVPRO,              -- Invest. Profile [IM_PROFIL]
    LOGSYSTEM,          -- Logical System [LOGSYSTEM]
    FLG_MLTPS,          -- Multiple Items [CO_MLTPS]
    ABUKR,              -- Req. co.code [IM_ABUKRS]
    AKSTL,              -- Req.cost center [PS_AKSTL]
    SIZECL,             -- Scale [IM_SIZECL]
    IZWEK,              -- Invest. Reason [IZWEK]
    UMWKZ,              -- Envir. Invest. [AM_UMWKZ]
    KSTEMPF,            -- Cost collector [CO_KSTEMPF]
    ZSCHM,              -- Interest Prof. [PS_ZSCHM]
    PKOSA,              -- Cost Collector [PKOSA_D]
    ANFAUFNR,           -- Req. order [AUFANFNR]
    PROCNR,             -- Prod. Proc. No. [CKML_F_PROCNR]
    PROTY,              -- Process Cat. [CKML_PROZESS_TYP]
    RSORD,              -- Refurbishment [RSORD]
    BEMOT,              -- AcctIndicator [BEMOT]
    ADRNRA,             -- Address Number [AD_ADDRNUM]
    ERFZEIT,            -- Time created [CO_INS_TIME]
    AEZEIT,             -- Changed At [CO_CHG_TIME]
    CSTG_VRNT,          -- Costing Variant [CK_KLVAR]
    COSTESTNR,          -- Cost EstimateNo [CK_KALNR]
    VERAA_USER,         -- PersonResponsible [VERAA_USER]
    ORDER_PROC_MODE,    -- Procurement Mode [ORDERPROCMODE]
    ZZBAULEITER,        -- ZBAULEITER
    EEW_AUFK_PS_DUMMY,  -- Dummy function in length 1 [DUMMY]
    VNAME,              -- Joint venture [JV_NAME]
    RECID,              -- Recovery Ind. [JV_RECIND]
    ETYPE,              -- Equity Type [JV_ETYPE]
    OTYPE,              -- JV Object Type [JV_OTYPE]
    JV_JIBCL,           -- JIB/JIBE Class [JV_JIBCL]
    JV_JIBSA,           -- JIB/JIBE SbClsA [JV_JIBSA]
    JV_OCO,             -- Or. Cost Obj. [JV_OR_CO]
    CPD_UPDAT,          -- Time Stamp [/CPD/PFP_SC_TSTMP]
    AD01PROFNR,         -- DIP Profile [AD01PROFNR]
    VAPLZ,              -- Main WorkCtr [GEWRK]
    WAWRK,              -- Plnt WorkCenter [WERGW]
    FERC_IND,           -- Reg. indicator [FE_IND]
    AUFK_STATUS,        -- Status Comb [ACTCMB_DELE]
    CLAIM_CONTROL,      -- Clm Creation Cntrl [WTYSC_CLAIM_CONTROL]
    UPDATE_NEEDED,      -- Claim inconsistent [WTYSC_UPDATE_NEEDED]
    UPDATE_CONTROL,     -- Claim Upd Trigger [WTYSC_UPDATE_CONTROL]
    PRIMARY KEY (MANDT, AUFNR)
);

Learn More