VIAUFKS

203 Fields 1 CDS Views

Generated Table for View

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
ISU_C4C_SRVORD_V view from Service order using equipment, location, device

Fields (203)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY aufnr AUFNR Order
priok PRIOK Priority
equnr EQUNR Equipment
bautl BAUTL Assembly
anlzu ANLZU SystemCondition
iwerk IWERK Planning Plant
ingpr INGRP Planner Group
apgrp VAGRP Planner Group
gewrk LGWID Work Center
kunum KUNUM Customer
aning ANING Person respons.
gaueh MAUEH Unit
gauzt GAUZT PlanDowntime/h
anlbd ANLBD Available to
anlvd ANLVD Available from
anlbz ANLBZ Avail. to time
anlvz ANLVZ Available from
warpl WARPL MaintenancePlan
wapos WAPOS MaintItem
revnr REVNI Revision
artpr ARTPR PriorityType
iloan ILOAN Loc/AccAssmt
iloai ILOAI ILOA individ.
pm_objty PM_OBJTY Object Type
inspk INSPK TechInspectn by
datan DATAN TechInspec on
abnum ABNUM Call Number
laufn LAUFN Last order
obknr OBJKNR Object list
auart AUFART Order Type
autyp AUFTYP Order category
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
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 KOSTL 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
objnr J_OBJNR Object number
prctr PRCTR Profit Center
vname JV_NAME Joint venture
recid JV_RECIND Recovery Ind.
etype JV_ETYPE Equity Type
pspel PS_PSP_ELE WBS Element
awsls AWSLS Variance key
abgsl ABGR_SCHL RA Key
tplnr TPLNR Functional loc.
abckz ABCKZ ABC Indic.
eqfnr EQFNR Sort Field
swerk SWERK MaintPlant
stort_iloa PMLOC Location
msgrp RAUMNR Room
beber BEBER Plant Section
cr_objty CR_OBJTY Object Type
ppsid PPSID PP work ctr
gsber_iloa GSBER Business Area
kokrs_iloa KOKRS CO Area
proid PS_PSP_PNR WBS Element
bukrs_iloa BUKRS Company Code
anlnr ANLN1 Asset
anlun ANLN2 Sub-number
daufn DAUFN StandgOrder
aufnr_iloa ILOM_ORDST SettlementOrder
gltrp CO_GLTRP Basic fin. date
gstrp PM_ORDGSTRP Bas. Start Date
ftrms CO_FTRMS Release
gltrs CO_GLTRS Sched. finish
gstrs CO_GSTRS Sched. start
gstri CO_GSTRI Actual start
getri CO_GETRI Actual Finish
gltri CO_GLTRI Actual finish
ftrmi CO_FTRMI Actual release
ftrmp CO_FTRMP Planned Release
rsnum RSNUM Reservation
gasmg GASMG Total Scrap
gamng GAMNG Target Quantity
gmein MEINS Base Unit
plnbez MATNR Material
plnty PLNTY Task List Type
plnnr PLNNR Group
plnaw PLNAW Application
plnal PLNAL Group Counter
pverw PLN_VERWE Usage
plauf CO_PLAUF Explosion Date
plsvb LOSGRBIS Lot Size To
plnme PLNME Task List Unit
plsvn LOSGRVON Lot Size From
pdatv DATUV Valid From
paenr AENNR Change Number
plgrp VAGRP Planner Group
lodiv LOSDIV Lot size div.
stlty STLTY BOM category
stlbez MATNR Material
stlst STLST BOM Status
stlnr STNUM BOM
sdatv DATUV Valid From
sbmng BASMN Base quantity
sbmeh MEINS Base Unit
saenr AENNR Change Number
stlal STALT Alternative
stlan STLAN Usage
slsvn LOSVN From Lot Size
slsbs LOSBS To Lot Size
aufld CO_AUFLD BOM Expl. Date
dispo CO_DISPO MRP controller
aufpl CO_AUFPL Plan No.f.Oper.
fevor FEVOR Prodn Supervisor
fhori FHORI Margin Key
terkz TERMKZ Scheduling type
redkz REDKZ Reduction Ind.
aprio CO_APRIO Priority
aufnt CO_TEILNET Subnetwork of
aufpt CO_AUFPL Plan No.f.Oper.
aplzt CO_APLZL Counter
profid PROFIDNZPL Network Profile
vorgz VORGZ Float bef. prod
sichz SICHZ Float aft. prod
freiz FREIZ Release period
upter CO_UPTER Dates Changed
bedid BEDID Capacity Requirement
pronr PS_PSP_PRO Project def.
zaehl CIM_COUNT Counter
mzaehl CIM_COUNT Counter
zkriz DZKRIZ Add. Crit. Cntr
prueflos QPLOS Inspection Lot
klvarp KALKVARPLN Plnd Costing Variant
klvari KALKVARIST Act. Costing Variant
rgekz CO_RGEKZ Backflushing
plart PS_PLART Sched. basis
addat ADDAT Reference Date
aduhr ADUHR Reference time
iphas PM_PHASE Phase
ilart ILA MaintActivType
qmnum QMNUM Notification
flg_aob FLG_AOB Ind:Relshp.data
flg_arbei FLG_ARBEI Ind. work
gltpp CO_GLTPP Finish date
gstpp CO_GSTPP Start date
gltps CO_GLTPS Finish date
gstps CO_GSTPS Start date
ftrps CO_FTRPS Release
rdkzp REDKZP Reduction ind.
trkzp TERMKZP Sched. type for
vkorg VKORG Sales Org.
vtweg VTWEG Distr. Channel
spart SPART Division
adrnr_iloa AD_ADDRNUM Address Number
kdauf KDAUF Sales Order
kdpos KDPOS Sales Ord. Item
gluzp CO_GLUZP Basic Fin. Time
gsuzp CO_GSUZP Start time
gluzs CO_GLUZS Finish time
gsuzs CO_GSUZS SchedStartTime
maufnr MAUFNR Superior Order
lead_aufnr CO_LAUFNR Leading Order
geuzi CO_GEUZI Actual Finish
gsuzi CO_GSUZI ActualStart
owner ILOM_OWNER Obj. reference
plknz AUF_PLKNZ OrderPlanInd.
user4 AUFUSER4 Estimated costs
rsord RSORD Refurbishment
bemot BEMOT AcctIndicator
sermat MATNR Material
serialnr GERNR Serial Number
deviceid DEVICEID Device Data
adrnra AD_ADDRNUM Address Number
uii UII_CHAR72 UII
netzkont NETZKONT Account assgnt

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 VIAUFKS (
    MANDT,       -- Client [MANDT]
    AUFNR,       -- Order [AUFNR]
    PRIOK,       -- Priority [PRIOK]
    EQUNR,       -- Equipment [EQUNR]
    BAUTL,       -- Assembly [BAUTL]
    ANLZU,       -- SystemCondition [ANLZU]
    IWERK,       -- Planning Plant [IWERK]
    INGPR,       -- Planner Group [INGRP]
    APGRP,       -- Planner Group [VAGRP]
    GEWRK,       -- Work Center [LGWID]
    KUNUM,       -- Customer [KUNUM]
    ANING,       -- Person respons. [ANING]
    GAUEH,       -- Unit [MAUEH]
    GAUZT,       -- PlanDowntime/h [GAUZT]
    ANLBD,       -- Available to [ANLBD]
    ANLVD,       -- Available from [ANLVD]
    ANLBZ,       -- Avail. to time [ANLBZ]
    ANLVZ,       -- Available from [ANLVZ]
    WARPL,       -- MaintenancePlan [WARPL]
    WAPOS,       -- MaintItem [WAPOS]
    REVNR,       -- Revision [REVNI]
    ARTPR,       -- PriorityType [ARTPR]
    ILOAN,       -- Loc/AccAssmt [ILOAN]
    ILOAI,       -- ILOA individ. [ILOAI]
    PM_OBJTY,    -- Object Type [PM_OBJTY]
    INSPK,       -- TechInspectn by [INSPK]
    DATAN,       -- TechInspec on [DATAN]
    ABNUM,       -- Call Number [ABNUM]
    LAUFN,       -- Last order [LAUFN]
    OBKNR,       -- Object list [OBJKNR]
    AUART,       -- Order Type [AUFART]
    AUTYP,       -- Order category [AUFTYP]
    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]
    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 [KOSTL]
    SAKNR,       -- G/L Account [AUFSAKNR]
    SETNM,       -- Allocation Set [AUFSETNM]
    CYCLE,       -- CCtr: True post [ST_KOSTL]
    SDATE,       -- Valid From [SDATE]
    SEQNR,       -- Sequence Number [AUFSEQNR]
    OBJNR,       -- Object number [J_OBJNR]
    PRCTR,       -- Profit Center [PRCTR]
    VNAME,       -- Joint venture [JV_NAME]
    RECID,       -- Recovery Ind. [JV_RECIND]
    ETYPE,       -- Equity Type [JV_ETYPE]
    PSPEL,       -- WBS Element [PS_PSP_ELE]
    AWSLS,       -- Variance key [AWSLS]
    ABGSL,       -- RA Key [ABGR_SCHL]
    TPLNR,       -- Functional loc. [TPLNR]
    ABCKZ,       -- ABC Indic. [ABCKZ]
    EQFNR,       -- Sort Field [EQFNR]
    SWERK,       -- MaintPlant [SWERK]
    STORT_ILOA,  -- Location [PMLOC]
    MSGRP,       -- Room [RAUMNR]
    BEBER,       -- Plant Section [BEBER]
    CR_OBJTY,    -- Object Type [CR_OBJTY]
    PPSID,       -- PP work ctr [PPSID]
    GSBER_ILOA,  -- Business Area [GSBER]
    KOKRS_ILOA,  -- CO Area [KOKRS]
    PROID,       -- WBS Element [PS_PSP_PNR]
    BUKRS_ILOA,  -- Company Code [BUKRS]
    ANLNR,       -- Asset [ANLN1]
    ANLUN,       -- Sub-number [ANLN2]
    DAUFN,       -- StandgOrder [DAUFN]
    AUFNR_ILOA,  -- SettlementOrder [ILOM_ORDST]
    GLTRP,       -- Basic fin. date [CO_GLTRP]
    GSTRP,       -- Bas. Start Date [PM_ORDGSTRP]
    FTRMS,       -- Release [CO_FTRMS]
    GLTRS,       -- Sched. finish [CO_GLTRS]
    GSTRS,       -- Sched. start [CO_GSTRS]
    GSTRI,       -- Actual start [CO_GSTRI]
    GETRI,       -- Actual Finish [CO_GETRI]
    GLTRI,       -- Actual finish [CO_GLTRI]
    FTRMI,       -- Actual release [CO_FTRMI]
    FTRMP,       -- Planned Release [CO_FTRMP]
    RSNUM,       -- Reservation [RSNUM]
    GASMG,       -- Total Scrap [GASMG]
    GAMNG,       -- Target Quantity [GAMNG]
    GMEIN,       -- Base Unit [MEINS]
    PLNBEZ,      -- Material [MATNR]
    PLNTY,       -- Task List Type [PLNTY]
    PLNNR,       -- Group [PLNNR]
    PLNAW,       -- Application [PLNAW]
    PLNAL,       -- Group Counter [PLNAL]
    PVERW,       -- Usage [PLN_VERWE]
    PLAUF,       -- Explosion Date [CO_PLAUF]
    PLSVB,       -- Lot Size To [LOSGRBIS]
    PLNME,       -- Task List Unit [PLNME]
    PLSVN,       -- Lot Size From [LOSGRVON]
    PDATV,       -- Valid From [DATUV]
    PAENR,       -- Change Number [AENNR]
    PLGRP,       -- Planner Group [VAGRP]
    LODIV,       -- Lot size div. [LOSDIV]
    STLTY,       -- BOM category [STLTY]
    STLBEZ,      -- Material [MATNR]
    STLST,       -- BOM Status [STLST]
    STLNR,       -- BOM [STNUM]
    SDATV,       -- Valid From [DATUV]
    SBMNG,       -- Base quantity [BASMN]
    SBMEH,       -- Base Unit [MEINS]
    SAENR,       -- Change Number [AENNR]
    STLAL,       -- Alternative [STALT]
    STLAN,       -- Usage [STLAN]
    SLSVN,       -- From Lot Size [LOSVN]
    SLSBS,       -- To Lot Size [LOSBS]
    AUFLD,       -- BOM Expl. Date [CO_AUFLD]
    DISPO,       -- MRP controller [CO_DISPO]
    AUFPL,       -- Plan No.f.Oper. [CO_AUFPL]
    FEVOR,       -- Prodn Supervisor [FEVOR]
    FHORI,       -- Margin Key [FHORI]
    TERKZ,       -- Scheduling type [TERMKZ]
    REDKZ,       -- Reduction Ind. [REDKZ]
    APRIO,       -- Priority [CO_APRIO]
    AUFNT,       -- Subnetwork of [CO_TEILNET]
    AUFPT,       -- Plan No.f.Oper. [CO_AUFPL]
    APLZT,       -- Counter [CO_APLZL]
    PROFID,      -- Network Profile [PROFIDNZPL]
    VORGZ,       -- Float bef. prod [VORGZ]
    SICHZ,       -- Float aft. prod [SICHZ]
    FREIZ,       -- Release period [FREIZ]
    UPTER,       -- Dates Changed [CO_UPTER]
    BEDID,       -- Capacity Requirement [BEDID]
    PRONR,       -- Project def. [PS_PSP_PRO]
    ZAEHL,       -- Counter [CIM_COUNT]
    MZAEHL,      -- Counter [CIM_COUNT]
    ZKRIZ,       -- Add. Crit. Cntr [DZKRIZ]
    PRUEFLOS,    -- Inspection Lot [QPLOS]
    KLVARP,      -- Plnd Costing Variant [KALKVARPLN]
    KLVARI,      -- Act. Costing Variant [KALKVARIST]
    RGEKZ,       -- Backflushing [CO_RGEKZ]
    PLART,       -- Sched. basis [PS_PLART]
    ADDAT,       -- Reference Date [ADDAT]
    ADUHR,       -- Reference time [ADUHR]
    IPHAS,       -- Phase [PM_PHASE]
    ILART,       -- MaintActivType [ILA]
    QMNUM,       -- Notification [QMNUM]
    FLG_AOB,     -- Ind:Relshp.data [FLG_AOB]
    FLG_ARBEI,   -- Ind. work [FLG_ARBEI]
    GLTPP,       -- Finish date [CO_GLTPP]
    GSTPP,       -- Start date [CO_GSTPP]
    GLTPS,       -- Finish date [CO_GLTPS]
    GSTPS,       -- Start date [CO_GSTPS]
    FTRPS,       -- Release [CO_FTRPS]
    RDKZP,       -- Reduction ind. [REDKZP]
    TRKZP,       -- Sched. type for [TERMKZP]
    VKORG,       -- Sales Org. [VKORG]
    VTWEG,       -- Distr. Channel [VTWEG]
    SPART,       -- Division [SPART]
    ADRNR_ILOA,  -- Address Number [AD_ADDRNUM]
    KDAUF,       -- Sales Order [KDAUF]
    KDPOS,       -- Sales Ord. Item [KDPOS]
    GLUZP,       -- Basic Fin. Time [CO_GLUZP]
    GSUZP,       -- Start time [CO_GSUZP]
    GLUZS,       -- Finish time [CO_GLUZS]
    GSUZS,       -- SchedStartTime [CO_GSUZS]
    MAUFNR,      -- Superior Order [MAUFNR]
    LEAD_AUFNR,  -- Leading Order [CO_LAUFNR]
    GEUZI,       -- Actual Finish [CO_GEUZI]
    GSUZI,       -- ActualStart [CO_GSUZI]
    OWNER,       -- Obj. reference [ILOM_OWNER]
    PLKNZ,       -- OrderPlanInd. [AUF_PLKNZ]
    USER4,       -- Estimated costs [AUFUSER4]
    RSORD,       -- Refurbishment [RSORD]
    BEMOT,       -- AcctIndicator [BEMOT]
    SERMAT,      -- Material [MATNR]
    SERIALNR,    -- Serial Number [GERNR]
    DEVICEID,    -- Device Data [DEVICEID]
    ADRNRA,      -- Address Number [AD_ADDRNUM]
    UII,         -- UII [UII_CHAR72]
    NETZKONT,    -- Account assgnt [NETZKONT]
    PRIMARY KEY (MANDT, AUFNR)
);

Learn More