VSAUFK_CN

Transparent Table Application Table
95 Fields 5 CDS Views

Version: Order master data

VSAUFK_CN is an SAP database table in S/4HANA. Version: Order master data. It contains 95 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
E_ProjectNetworkVersion view from EXTENSION Project Network Version - Extension Include View
I_NetworkActivityVersion view inner BASIC Network Activity Version
I_ProjectNetworkVersBasicData view inner BASIC Project Network Version Basic Data
I_ProjectNetworkVersion view from BASIC Project Network with Version
P_ProjectVersion01 view left_outer BASIC Project Version Helper

Fields (95)

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
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_procnr Production Alt.
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

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.

-- Version: Order master data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VSAUFK_CN (
    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]
    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,           -- Production Alt. [ckml_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]
    PRIMARY KEY (MANDT, AUFNR)
);

Learn More