VSAFVC_CN

Transparent Table Application Table
211 Fields 6 CDS Views

Version: Operation in order

VSAFVC_CN is an SAP database table in S/4HANA. Version: Operation in order. It contains 211 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
E_NetworkActivityVersion view from EXTENSION Network Activity Version - Extension Include View
I_NetworkActivityVersByIntKey view from BASIC Network Activity Version By Internal Key
I_NetworkActivityVersion view from BASIC Network Activity Version
I_NetworkActivityVersion view left_outer BASIC Network Activity Version
I_NtwkActyForProjSchedVersHier view from BASIC Network Activity Version Information
P_ProjectVersion01 view left_outer BASIC

Fields (211)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY vsnmr VSNMR Vers. key
KEY aufpl CO_AUFPL Plan No.f.Oper.
KEY aplzl CO_APLZL Counter
plnfl PLNFOLGE Sequence
plnkn PLNKN Node
plnal PLNAL Group Counter
plnty PLNTY Task List Type
vintv VINTV Op. increment
plnnr PLNNR Group
zaehl CIM_COUNT Counter
vornr VORNR Activity
steus STEUS Control Key
arbid CR_OBJID Object ID
pdest CR_PDEST Printer
werks WERKS_D Plant
ktsch KTSCH_CHG Std Text Key
ltxa1 LTXA1 Op. Short Text
ltxa2 LTXA2 Description
txtsp SPRAS Language
vplty VPLNTY Ref TList type
vplnr VPLNNR Ref. group
vplal VPLNAL Ref. group cntr
vplfl VPLBFL Ref. sequence
vgwts VORGSCHL Std Value Key
lar01 LSTAR Activity Type
lar02 LSTAR Activity Type
lar03 LSTAR Activity Type
lar04 LSTAR Activity Type
lar05 LSTAR Activity Type
lar06 LSTAR Activity Type
zerma DZERMA SV Determ. Type
zgdat DZGDAT Std.val.date
zcode DZCODE Std value code
zulnr DZULNR BasisStdValCalc
loanz LOHNANZ No.TimeTickets
loart LOHNART Wage type
rsanz CR_RS_ANZ No. of Conf. Slips
qualf QUALF Suitability
anzma ANZMS No. employees
rfgrp RUEFAGRP Setup group cat
rfsch RUEFASCHLU Setup group key
rasch RUEARSCHLU Setup Type Key
aufak AUSCHUFAK Scrap
logrp LOHNGRP Wage Group
uemus UEMUSKZ Req.Overlapping
uekan UEKANKZ Opt.Overlapping
flies FLIESSKZ Flow Manufact.
spmus SPLITTUNG Splitting Reqd
splim SPLITTANZ No. of Splits
ablipkz ABLIPKZ Teardown/Wait Par.
rstra RSTRA Red. Strategy
sumnr SUMKNTNR Sup. Op. Node
sortl SORTI Sort Term
lifnr LIFNR Supplier
preis PREIS Price
peinh PEINH Price unit
sakto KSTAR Cost Element
waers WAERS Currency
infnr INFNR Info Record
esokz ESOKZ Infotype
ekorg EKORG Purchasing Org.
ekgrp VG_EKGRP Purch. Group
kzlgf KZLGF LSI Ext. Proc.
kzwrtf KZWRTF Fixed price
matkl MATKL Material Group
ddehn DAUDEHN Flex. duration
anzzl ANZKAP Number
prznt APROZENT Percent
mlstn MILESTONE Usage
pprio PRIORITAET Priority
bukrs BUKRS Company Code
anfko ANFKO Rqstg Cost Cntr
anfkokrs ANFKOKRS Controll. Area
indet INDET Calculation key
larnt LSTAR Activity Type
prkst PRKST Amount
aplfl PLNFOLGE Sequence
rueck CO_RUECK Confirmation
rmzhl CO_RMZHL Counter
projn PS_PSP_ELE WBS Element
objnr J_OBJNR Object number
spanz SPLITTERM No. of splits
bedid BEDID Capacity Requirement
bedzl CIM_COUNT Counter
banfn CO_BANFN Requisition
bnfpo CO_BNFPO Requisition Itm
lek01 CO_LEIKZ No Remain. Act.
lek02 CO_LEIKZ No Remain. Act.
lek03 CO_LEIKZ No Remain. Act.
lek04 CO_LEIKZ No Remain. Act.
lek05 CO_LEIKZ No Remain. Act.
lek06 CO_LEIKZ No Remain. Act.
selkz CO_SELKZ Cost
kalid WFCID Factory Cal. ID
frsp FRSP Early/Late
stdkn STDKN Nodes
anlzu ANLZU SystemCondition
istru ISTRU Assembly
istty STLTY BOM category
istnr STNUM BOM
istkn STLKN Item node
istpo CIM_COUNT Counter
iupoz UPOSZ Subitem
ebort EBORT Install. Point
vertl CR_VERTN Int. dist. key
leknw LEKNW No Remain. Work
nprio NW_PRIO Priority
pvzkn CO_APLZL Counter
phflg PHFLG Ind.: Phase
phseq PHSEQ CtrlRec.Destin.
knobj KNOBJ Assgmt no.
erfsicht QERFSICHT Recording View
qppktabs QPPKTABS InspPtComplete
otype OTYPE Object type
objektid OBJEKTID Object ID
qlkapar QL_KAPART Capacity cat.
rstuf RSTUF Reduction Level
nptxtky TXTKY Text number
subsys QEIFSUBSYS QDR System
pspnr PS_SPS_ELE Std.WBS element
packno PACKNO Package number
txjcd TXJCD Tax Jur.
scope SCOPE_CV Object Class
gsber GSBER Business Area
prctr PRCTR Profit Center
no_disp NO_DISP_PLUS Eff. mat. plng
qkzprzeit QKZPRZEIT Time-related
qkzztmg1 QKZZTMG1 Quan. pt. lot
qkzprmeng QKZPRMENG Qty-related
qkzprfrei QKZPRFREI No Reference
kzfeat QKZFEAT Indicator Is Not Used Currently
qkztlsbest QKZTLSBEST Last part. lot
aennr AENNR Change Number
cuobj_arb CUOBJ Int. object no.
evgew EV_WEIGHTD POC weight
arbii CR_OBJID_I Object ID
werki WERKS_I Plant
cy_seqnrv CY_SEQNRV Sequence number
kapt_puffr KAPT_PUFFR Operation floats after finite scheduling (in seconds)
ebeln EBELN Purchasing Doc.
ebelp EBELP Item
wempf WEMPF Recipient
ablad ABLAD Unloading Point
clasf CLASF Summarization
frunv FRUNV Ext.dat.incompl
zschl AUFZSCHL Overhead key
kalsm AUFKALSM Costing Sheet
sched_end SCEND_ACT Purch.Req. fin.
netzkont NETZKONT Account assgnt
owaer OWAERS Object crcy
afnam AFNAM Requisitioner
bednr BEDNR Tracking Number
kzfix CN_KZFIX Price_fixed
pernr CO_PERNR Personnel no.
frdlb CO_FRDLB Subcontracting
qpart QPART Inspection Type
loekz AUFLOEKZ Deletion Flag
wkurs WKURS Exchange Rate
prod_act PROD_ACT Production activ.
fplnr FPLNR Bill. Plan No.
objtype OCM_OBJ_TYPE ChangeInd
ch_proc OCM_CH_PROC ChangeProcType
klvar CK_KLVAR Costing Variant
kalnr CK_KALNR Cost EstimateNo
fordn SFORDN Framework Order
fordp FORDP Frwrk. ord. item
mat_prkst MAT_PRKST_CHG Mat.planning
prz01 CO_PRZNR Business Process
rfpnt CN_RFPNT Reference point
func_area FKBER Functional Area
techs TECHS StandardVariant
adpsp ADDCOMPARE_CORE Ref. Element PM/PS
rfippnt CN_RPIP Reference Point
mes_operid CO_MES_INT_OPERID MES Operation
mes_stepid CO_MES_INT_STEPID Step ID
oan_inst_id_setup MPE_OAN_INSTANCE_ID Instance ID
oan_inst_id_produce MPE_OAN_INSTANCE_ID Instance ID
oan_inst_id_teardown MPE_OAN_INSTANCE_ID Instance ID
tl_versn PLNVERSN Routing Version
versn_track_guid CP_GUID Guid
set_versn_track_guid CP_GUID Guid
maintordopprocessphasecode EAM_OSTAT_PHASE Process Phase
maintordopprocesssubphasecode EAM_OSTAT_SPHASE Process Subphase
cl_type EAM_CL_TYPE Checklist Type
allmaintordcompcmtdqtsarekept ALLMAINTORDCOMPCMTDQTSAREKEPT Keep Committed Qties
dummy_eam_afvc_incl_eew_ps CFD_DUMMY Dummy
dummy_afvc_incl_eew_ps DUMMY Dummy function in length 1
afvc_status ACTCMB_DELE Status Comb
adrnr CADNR Address number
adrn2 AD_ADDRNUM Address Number
kunn2 QKUNUM Customer
ind_adr XFELD Checkbox
fldlogsdelivisheldonshore FLOG_HOLD Hold On-Shore
svobj_id SVOBJ_ID Service obj. ID
svobj SVOBJ Service object
kennz_incl KENNZ_INCL Copy task list
mill_oc_aufnr_mo MILL_OC_AUFNR_MO Combined Order
ps_adrnr CADNR Address number
ps_adrn2 AD_ADDRNUM Address Number
ps_kunnr EKUNNR Customer
ps_emlif EMLIF Supplier
wty_ind WTYSC_WTY_INDICATOR Warranty
maintopexecutionphasecode EAM_PREMAINPOST Execution Stage
maintordophasleanservices EAM_OPERATION_HAS_SERVICE operation has srv
orgaufpl CO_AUFPL Plan No.f.Oper.
orgaplzl CO_APLZL Counter
inact VSINACT Inactive
cpd_updat /CPD/PFP_TSTMP Time Stamp
tplnr TPLNR Functional loc.
equnr EQUNR Equipment

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: Operation in order
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VSAFVC_CN (
    MANDT,                          -- Client [MANDT]
    VSNMR,                          -- Vers. key [VSNMR]
    AUFPL,                          -- Plan No.f.Oper. [CO_AUFPL]
    APLZL,                          -- Counter [CO_APLZL]
    PLNFL,                          -- Sequence [PLNFOLGE]
    PLNKN,                          -- Node [PLNKN]
    PLNAL,                          -- Group Counter [PLNAL]
    PLNTY,                          -- Task List Type [PLNTY]
    VINTV,                          -- Op. increment [VINTV]
    PLNNR,                          -- Group [PLNNR]
    ZAEHL,                          -- Counter [CIM_COUNT]
    VORNR,                          -- Activity [VORNR]
    STEUS,                          -- Control Key [STEUS]
    ARBID,                          -- Object ID [CR_OBJID]
    PDEST,                          -- Printer [CR_PDEST]
    WERKS,                          -- Plant [WERKS_D]
    KTSCH,                          -- Std Text Key [KTSCH_CHG]
    LTXA1,                          -- Op. Short Text [LTXA1]
    LTXA2,                          -- Description [LTXA2]
    TXTSP,                          -- Language [SPRAS]
    VPLTY,                          -- Ref TList type [VPLNTY]
    VPLNR,                          -- Ref. group [VPLNNR]
    VPLAL,                          -- Ref. group cntr [VPLNAL]
    VPLFL,                          -- Ref. sequence [VPLBFL]
    VGWTS,                          -- Std Value Key [VORGSCHL]
    LAR01,                          -- Activity Type [LSTAR]
    LAR02,                          -- Activity Type [LSTAR]
    LAR03,                          -- Activity Type [LSTAR]
    LAR04,                          -- Activity Type [LSTAR]
    LAR05,                          -- Activity Type [LSTAR]
    LAR06,                          -- Activity Type [LSTAR]
    ZERMA,                          -- SV Determ. Type [DZERMA]
    ZGDAT,                          -- Std.val.date [DZGDAT]
    ZCODE,                          -- Std value code [DZCODE]
    ZULNR,                          -- BasisStdValCalc [DZULNR]
    LOANZ,                          -- No.TimeTickets [LOHNANZ]
    LOART,                          -- Wage type [LOHNART]
    RSANZ,                          -- No. of Conf. Slips [CR_RS_ANZ]
    QUALF,                          -- Suitability [QUALF]
    ANZMA,                          -- No. employees [ANZMS]
    RFGRP,                          -- Setup group cat [RUEFAGRP]
    RFSCH,                          -- Setup group key [RUEFASCHLU]
    RASCH,                          -- Setup Type Key [RUEARSCHLU]
    AUFAK,                          -- Scrap [AUSCHUFAK]
    LOGRP,                          -- Wage Group [LOHNGRP]
    UEMUS,                          -- Req.Overlapping [UEMUSKZ]
    UEKAN,                          -- Opt.Overlapping [UEKANKZ]
    FLIES,                          -- Flow Manufact. [FLIESSKZ]
    SPMUS,                          -- Splitting Reqd [SPLITTUNG]
    SPLIM,                          -- No. of Splits [SPLITTANZ]
    ABLIPKZ,                        -- Teardown/Wait Par. [ABLIPKZ]
    RSTRA,                          -- Red. Strategy [RSTRA]
    SUMNR,                          -- Sup. Op. Node [SUMKNTNR]
    SORTL,                          -- Sort Term [SORTI]
    LIFNR,                          -- Supplier [LIFNR]
    PREIS,                          -- Price [PREIS]
    PEINH,                          -- Price unit [PEINH]
    SAKTO,                          -- Cost Element [KSTAR]
    WAERS,                          -- Currency [WAERS]
    INFNR,                          -- Info Record [INFNR]
    ESOKZ,                          -- Infotype [ESOKZ]
    EKORG,                          -- Purchasing Org. [EKORG]
    EKGRP,                          -- Purch. Group [VG_EKGRP]
    KZLGF,                          -- LSI Ext. Proc. [KZLGF]
    KZWRTF,                         -- Fixed price [KZWRTF]
    MATKL,                          -- Material Group [MATKL]
    DDEHN,                          -- Flex. duration [DAUDEHN]
    ANZZL,                          -- Number [ANZKAP]
    PRZNT,                          -- Percent [APROZENT]
    MLSTN,                          -- Usage [MILESTONE]
    PPRIO,                          -- Priority [PRIORITAET]
    BUKRS,                          -- Company Code [BUKRS]
    ANFKO,                          -- Rqstg Cost Cntr [ANFKO]
    ANFKOKRS,                       -- Controll. Area [ANFKOKRS]
    INDET,                          -- Calculation key [INDET]
    LARNT,                          -- Activity Type [LSTAR]
    PRKST,                          -- Amount [PRKST]
    APLFL,                          -- Sequence [PLNFOLGE]
    RUECK,                          -- Confirmation [CO_RUECK]
    RMZHL,                          -- Counter [CO_RMZHL]
    PROJN,                          -- WBS Element [PS_PSP_ELE]
    OBJNR,                          -- Object number [J_OBJNR]
    SPANZ,                          -- No. of splits [SPLITTERM]
    BEDID,                          -- Capacity Requirement [BEDID]
    BEDZL,                          -- Counter [CIM_COUNT]
    BANFN,                          -- Requisition [CO_BANFN]
    BNFPO,                          -- Requisition Itm [CO_BNFPO]
    LEK01,                          -- No Remain. Act. [CO_LEIKZ]
    LEK02,                          -- No Remain. Act. [CO_LEIKZ]
    LEK03,                          -- No Remain. Act. [CO_LEIKZ]
    LEK04,                          -- No Remain. Act. [CO_LEIKZ]
    LEK05,                          -- No Remain. Act. [CO_LEIKZ]
    LEK06,                          -- No Remain. Act. [CO_LEIKZ]
    SELKZ,                          -- Cost [CO_SELKZ]
    KALID,                          -- Factory Cal. ID [WFCID]
    FRSP,                           -- Early/Late [FRSP]
    STDKN,                          -- Nodes [STDKN]
    ANLZU,                          -- SystemCondition [ANLZU]
    ISTRU,                          -- Assembly [ISTRU]
    ISTTY,                          -- BOM category [STLTY]
    ISTNR,                          -- BOM [STNUM]
    ISTKN,                          -- Item node [STLKN]
    ISTPO,                          -- Counter [CIM_COUNT]
    IUPOZ,                          -- Subitem [UPOSZ]
    EBORT,                          -- Install. Point [EBORT]
    VERTL,                          -- Int. dist. key [CR_VERTN]
    LEKNW,                          -- No Remain. Work [LEKNW]
    NPRIO,                          -- Priority [NW_PRIO]
    PVZKN,                          -- Counter [CO_APLZL]
    PHFLG,                          -- Ind.: Phase [PHFLG]
    PHSEQ,                          -- CtrlRec.Destin. [PHSEQ]
    KNOBJ,                          -- Assgmt no. [KNOBJ]
    ERFSICHT,                       -- Recording View [QERFSICHT]
    QPPKTABS,                       -- InspPtComplete [QPPKTABS]
    OTYPE,                          -- Object type [OTYPE]
    OBJEKTID,                       -- Object ID [OBJEKTID]
    QLKAPAR,                        -- Capacity cat. [QL_KAPART]
    RSTUF,                          -- Reduction Level [RSTUF]
    NPTXTKY,                        -- Text number [TXTKY]
    SUBSYS,                         -- QDR System [QEIFSUBSYS]
    PSPNR,                          -- Std.WBS element [PS_SPS_ELE]
    PACKNO,                         -- Package number [PACKNO]
    TXJCD,                          -- Tax Jur. [TXJCD]
    SCOPE,                          -- Object Class [SCOPE_CV]
    GSBER,                          -- Business Area [GSBER]
    PRCTR,                          -- Profit Center [PRCTR]
    NO_DISP,                        -- Eff. mat. plng [NO_DISP_PLUS]
    QKZPRZEIT,                      -- Time-related [QKZPRZEIT]
    QKZZTMG1,                       -- Quan. pt. lot [QKZZTMG1]
    QKZPRMENG,                      -- Qty-related [QKZPRMENG]
    QKZPRFREI,                      -- No Reference [QKZPRFREI]
    KZFEAT,                         -- Indicator Is Not Used Currently [QKZFEAT]
    QKZTLSBEST,                     -- Last part. lot [QKZTLSBEST]
    AENNR,                          -- Change Number [AENNR]
    CUOBJ_ARB,                      -- Int. object no. [CUOBJ]
    EVGEW,                          -- POC weight [EV_WEIGHTD]
    ARBII,                          -- Object ID [CR_OBJID_I]
    WERKI,                          -- Plant [WERKS_I]
    CY_SEQNRV,                      -- Sequence number [CY_SEQNRV]
    KAPT_PUFFR,                     -- Operation floats after finite scheduling (in seconds) [KAPT_PUFFR]
    EBELN,                          -- Purchasing Doc. [EBELN]
    EBELP,                          -- Item [EBELP]
    WEMPF,                          -- Recipient [WEMPF]
    ABLAD,                          -- Unloading Point [ABLAD]
    CLASF,                          -- Summarization [CLASF]
    FRUNV,                          -- Ext.dat.incompl [FRUNV]
    ZSCHL,                          -- Overhead key [AUFZSCHL]
    KALSM,                          -- Costing Sheet [AUFKALSM]
    SCHED_END,                      -- Purch.Req. fin. [SCEND_ACT]
    NETZKONT,                       -- Account assgnt [NETZKONT]
    OWAER,                          -- Object crcy [OWAERS]
    AFNAM,                          -- Requisitioner [AFNAM]
    BEDNR,                          -- Tracking Number [BEDNR]
    KZFIX,                          -- Price_fixed [CN_KZFIX]
    PERNR,                          -- Personnel no. [CO_PERNR]
    FRDLB,                          -- Subcontracting [CO_FRDLB]
    QPART,                          -- Inspection Type [QPART]
    LOEKZ,                          -- Deletion Flag [AUFLOEKZ]
    WKURS,                          -- Exchange Rate [WKURS]
    PROD_ACT,                       -- Production activ. [PROD_ACT]
    FPLNR,                          -- Bill. Plan No. [FPLNR]
    OBJTYPE,                        -- ChangeInd [OCM_OBJ_TYPE]
    CH_PROC,                        -- ChangeProcType [OCM_CH_PROC]
    KLVAR,                          -- Costing Variant [CK_KLVAR]
    KALNR,                          -- Cost EstimateNo [CK_KALNR]
    FORDN,                          -- Framework Order [SFORDN]
    FORDP,                          -- Frwrk. ord. item [FORDP]
    MAT_PRKST,                      -- Mat.planning [MAT_PRKST_CHG]
    PRZ01,                          -- Business Process [CO_PRZNR]
    RFPNT,                          -- Reference point [CN_RFPNT]
    FUNC_AREA,                      -- Functional Area [FKBER]
    TECHS,                          -- StandardVariant [TECHS]
    ADPSP,                          -- Ref. Element PM/PS [ADDCOMPARE_CORE]
    RFIPPNT,                        -- Reference Point [CN_RPIP]
    MES_OPERID,                     -- MES Operation [CO_MES_INT_OPERID]
    MES_STEPID,                     -- Step ID [CO_MES_INT_STEPID]
    OAN_INST_ID_SETUP,              -- Instance ID [MPE_OAN_INSTANCE_ID]
    OAN_INST_ID_PRODUCE,            -- Instance ID [MPE_OAN_INSTANCE_ID]
    OAN_INST_ID_TEARDOWN,           -- Instance ID [MPE_OAN_INSTANCE_ID]
    TL_VERSN,                       -- Routing Version [PLNVERSN]
    VERSN_TRACK_GUID,               -- Guid [CP_GUID]
    SET_VERSN_TRACK_GUID,           -- Guid [CP_GUID]
    MAINTORDOPPROCESSPHASECODE,     -- Process Phase [EAM_OSTAT_PHASE]
    MAINTORDOPPROCESSSUBPHASECODE,  -- Process Subphase [EAM_OSTAT_SPHASE]
    CL_TYPE,                        -- Checklist Type [EAM_CL_TYPE]
    ALLMAINTORDCOMPCMTDQTSAREKEPT,  -- Keep Committed Qties [ALLMAINTORDCOMPCMTDQTSAREKEPT]
    DUMMY_EAM_AFVC_INCL_EEW_PS,     -- Dummy [CFD_DUMMY]
    DUMMY_AFVC_INCL_EEW_PS,         -- Dummy function in length 1 [DUMMY]
    AFVC_STATUS,                    -- Status Comb [ACTCMB_DELE]
    ADRNR,                          -- Address number [CADNR]
    ADRN2,                          -- Address Number [AD_ADDRNUM]
    KUNN2,                          -- Customer [QKUNUM]
    IND_ADR,                        -- Checkbox [XFELD]
    FLDLOGSDELIVISHELDONSHORE,      -- Hold On-Shore [FLOG_HOLD]
    SVOBJ_ID,                       -- Service obj. ID [SVOBJ_ID]
    SVOBJ,                          -- Service object [SVOBJ]
    KENNZ_INCL,                     -- Copy task list [KENNZ_INCL]
    MILL_OC_AUFNR_MO,               -- Combined Order [MILL_OC_AUFNR_MO]
    PS_ADRNR,                       -- Address number [CADNR]
    PS_ADRN2,                       -- Address Number [AD_ADDRNUM]
    PS_KUNNR,                       -- Customer [EKUNNR]
    PS_EMLIF,                       -- Supplier [EMLIF]
    WTY_IND,                        -- Warranty [WTYSC_WTY_INDICATOR]
    MAINTOPEXECUTIONPHASECODE,      -- Execution Stage [EAM_PREMAINPOST]
    MAINTORDOPHASLEANSERVICES,      -- operation has srv [EAM_OPERATION_HAS_SERVICE]
    ORGAUFPL,                       -- Plan No.f.Oper. [CO_AUFPL]
    ORGAPLZL,                       -- Counter [CO_APLZL]
    INACT,                          -- Inactive [VSINACT]
    CPD_UPDAT,                      -- Time Stamp [/CPD/PFP_TSTMP]
    TPLNR,                          -- Functional loc. [TPLNR]
    EQUNR,                          -- Equipment [EQUNR]
    PRIMARY KEY (MANDT, VSNMR, AUFPL, APLZL)
);

Learn More