SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

www.saptables.net

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
2FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
3/ISDFPS/CHVW_E34External Batch Where-Used List
4FMARCPAR4Parallelization of FMARC_BATCH
5CEKRS5Movement type parameters for automatic ERS
6/1RA/0SD010MI170Items for Class SD01 - Raw Data
7/ATL/AANLCP79Periodic Asset-value fields, like anlc, for all areas
8AUDLORIPR7KPro: Logical Information Object Attribute Values
9/OPT/Z1344Reporting table: Text table for exception definitions
10FCO_DOC_HEAD61Failure Cost Document Header

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7JDT1124Journal Entry - Rows
8OACT114G/L Accounts
9OPOR386Purchase Order
10OPCH386A/P Invoice

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2OINV268A/R Invoice
3OVPM154Outgoing Payments
4ORCT154Incoming Payment
5OIVL77Whse Journal
6OPCH268A/P Invoice
7OOCR9Loading Factors
8OSRN20Serial Numbers Master Data
9JDT1110Journal Entry - Rows
10OBOT10Bill Of Exchang Transaction
PHPRef.com - the webs number one PHP Function reference tool
Project System :: Simulation
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0VSAFVC_CN1864Version: Operation in orderSimulation
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, VSNMR, AUFPL, APLZL, PLNFL, PLNKN, PLNAL, PLNTY, VINTV, PLNNR, ZAEHL, VORNR, STEUS, ARBID, PDEST, WERKS, KTSCH, LTXA1, LTXA2, TXTSP, VPLTY, VPLNR, VPLAL, VPLFL, VGWTS, LAR01, LAR02, LAR03, LAR04, LAR05, LAR06, ZERMA, ZGDAT, ZCODE, ZULNR, LOANZ, LOART, RSANZ, QUALF, ANZMA, RFGRP, RFSCH, RASCH, AUFAK, LOGRP, UEMUS, UEKAN, FLIES, SPMUS, SPLIM, ABLIPKZ, RSTRA, SUMNR, SORTL, LIFNR, PREIS, PEINH, SAKTO, WAERS, INFNR, ESOKZ, EKORG, EKGRP, KZLGF, KZWRTF, MATKL, DDEHN, ANZZL, PRZNT, MLSTN, PPRIO, BUKRS, ANFKO, ANFKOKRS, INDET, LARNT, PRKST, APLFL, RUECK, RMZHL, PROJN, OBJNR, SPANZ, BEDID, BEDZL, BANFN, BNFPO, LEK01, LEK02, LEK03, LEK04, LEK05, LEK06, SELKZ, KALID, FRSP, STDKN, ANLZU, ISTRU, ISTTY, ISTNR, ISTKN, ISTPO, IUPOZ, EBORT, VERTL, LEKNW, NPRIO, PVZKN, PHFLG, PHSEQ, KNOBJ, ERFSICHT, QPPKTABS, OTYPE, OBJEKTID, QLKAPAR, RSTUF, NPTXTKY, SUBSYS, PSPNR, PACKNO, TXJCD, SCOPE, GSBER, PRCTR, NO_DISP, QKZPRZEIT, QKZZTMG1, QKZPRMENG, QKZPRFREI, KZFEAT, QKZTLSBEST, AENNR, CUOBJ_ARB, EVGEW, ARBII, WERKI, CY_SEQNRV, KAPT_PUFFR, EBELN, EBELP, WEMPF, ABLAD, CLASF, FRUNV, ZSCHL, KALSM, SCHED_END, NETZKONT, OWAER, AFNAM, BEDNR, KZFIX, PERNR, FRDLB, QPART, LOEKZ, WKURS, PROD_ACT, FPLNR, OBJTYPE, CH_PROC, KLVAR, KALNR, FORDN, FORDP, MAT_PRKST, PRZ01, RFPNT, FUNC_AREA, TECHS, ADPSP, RFIPPNT, MES_OPERID, MES_STEPID, /CUM/CUGUID, /ISDFPS/OBJNR, AFVC_STATUS, MILL_OC_AUFNR_MO, WTY_IND, ORGAUFPL, ORGAPLZL, INACT, TPLNR, EQUNR FROM VSAFVC_CN
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2VSNMRNumber or description of a versionnvarchar120CHAR(N' ')NoVSNMR Allow NULL? 
3AUFPLRouting number of operations in the ordernvarchar100NUMC(N'0000000000')NoCO_AUFPL Allow NULL? 
4APLZLGeneral counter for ordernvarchar80NUMC(N'00000000')NoAFVCCO_APLZL Allow NULL? 
5PLNFLSequencenvarchar60CHAR(N' ')YesPLNFOLGE Allow NULL? 
6PLNKNNumber of the task list nodenvarchar80NUMC(N'00000000')YesPLNKN Allow NULL? 
7PLNALGroup Counternvarchar20CHAR(N' ')YesPLNAL Allow NULL? 
8PLNTYTask List Typechar10CHAR(N' ')YesTCA01PLNTY Allow NULL? 
9VINTVIncrement between referenced operationsdecimal30DEC((0))YesVINTV
10PLNNRKey for Task List Groupnvarchar80CHAR(N' ')YesPLNNR Allow NULL? 
11ZAEHLInternal counternvarchar80NUMC(N'00000000')YesCIM_COUNT Allow NULL? 
12VORNROperation/Activity Numbernvarchar40CHAR(N' ')YesVORNR Allow NULL? 
13STEUSControl keynvarchar40CHAR(N' ')YesT430STEUS Allow NULL? 
14ARBIDObject ID of the resourcenvarchar80NUMC(N'00000000')YesCRIDCR_OBJID Allow NULL? 
15PDESTPrinter for shop papersnvarchar40CHAR(N' ')YesTSP03CR_PDEST Allow NULL? 
16WERKSPlantnvarchar40CHAR(N' ')YesT001WWERKS_D Allow NULL? 
17KTSCHStandard text keynvarchar70CHAR(N' ')YesT435KTSCH Allow NULL? 
18LTXA1Operation short textnvarchar400CHAR(N' ')YesLTXA1 Allow NULL? 
19LTXA2Second line of the descriptionnvarchar400CHAR(N' ')YesLTXA2 Allow NULL? 
20TXTSPLanguage Keychar10LANG(N' ')YesT002SPRAS Allow NULL? 
21VPLTYType of the referenced task listchar10CHAR(N' ')YesTCA01VPLNTY Allow NULL? 
22VPLNRGroup of the referenced task listnvarchar80CHAR(N' ')YesVPLNNR Allow NULL? 
23VPLALGroup counter of the referenced task listnvarchar20CHAR(N' ')YesVPLNAL Allow NULL? 
24VPLFLReferenced sequence in routingnvarchar60CHAR(N' ')YesVPLBFL Allow NULL? 
25VGWTSStandard value keynvarchar40CHAR(N' ')YesTC21VORGSCHL Allow NULL? 
26LAR01Activity Typenvarchar60CHAR(N' ')YesCSLALSTAR Allow NULL? 
27LAR02Activity Typenvarchar60CHAR(N' ')YesCSLALSTAR Allow NULL? 
28LAR03Activity Typenvarchar60CHAR(N' ')YesCSLALSTAR Allow NULL? 
29LAR04Activity Typenvarchar60CHAR(N' ')YesCSLALSTAR Allow NULL? 
30LAR05Activity Typenvarchar60CHAR(N' ')YesCSLALSTAR Allow NULL? 
31LAR06Activity Typenvarchar60CHAR(N' ')YesCSLALSTAR Allow NULL? 
32ZERMAType of standard value calculationnvarchar50CHAR(N' ')YesT429DZERMA Allow NULL? 
33ZGDATDate when the standard value was calculatednvarchar40CHAR(N' ')YesDZGDAT Allow NULL? 
34ZCODEReference number for standard value codenvarchar60CHAR(N' ')YesDZCODE Allow NULL? 
35ZULNRBasis for standard value calculationnvarchar50CHAR(N' ')YesDZULNR Allow NULL? 
36LOANZNumber of Time Ticketsdecimal30DEC((0))YesLOHNANZ
37LOARTWage Typenvarchar40CHAR(N' ')YesLOHNART Allow NULL? 
38RSANZNumber of confirmation slipsnvarchar30NUMC(N'000')YesCR_RS_ANZ Allow NULL? 
39QUALFSuitabilitynvarchar20CHAR(N' ')YesT423QUALF Allow NULL? 
40ANZMANumber of employeesdecimal52DEC((0))YesANZMS
41RFGRPSetup group categorynvarchar100CHAR(N' ')YesT426RUEFAGRP Allow NULL? 
42RFSCHSetup group keynvarchar100CHAR(N' ')YesT425RUEFASCHLU Allow NULL? 
43RASCHSetup Type Keynvarchar20CHAR(N' ')YesT428RUEARSCHLU Allow NULL? 
44AUFAKScrap factordecimal53DEC((0))YesAUSCHUFAK
45LOGRPWage groupnvarchar30CHAR(N' ')YesT421LOHNGRP Allow NULL? 
46UEMUSRequired overlappingchar10CHAR(N' ')YesUEMUSKZ Allow NULL? 
47UEKANOptional overlappingchar10CHAR(N' ')YesUEKANKZ Allow NULL? 
48FLIESIndicator: continuous flow productionchar10CHAR(N' ')YesFLIESSKZ Allow NULL? 
49SPMUSRequired splittingchar10CHAR(N' ')YesSPLITTUNG Allow NULL? 
50SPLIMMaximum number of splitsdecimal30DEC((0))YesSPLITTANZ
51ABLIPKZIndicator: simultaneous teardown and waitchar10CHAR(N' ')YesABLIPKZ Allow NULL? 
52RSTRAReduction strategy per operation/activitynvarchar20CHAR(N' ')YesT499QRSTRA Allow NULL? 
53SUMNRNode number of the superior operationnvarchar80NUMC(N'00000000')YesSUMKNTNR Allow NULL? 
54SORTLSort Term for Non-Stock Info Recordsnvarchar100CHAR(N' ')YesSORTI Allow NULL? 
55LIFNRAccount Number of Vendor or Creditornvarchar100CHAR(N' ')YesLFA1LIFNR Allow NULL? 
56PREISPricedecimal112CURR((0))YesPREIS
57PEINHPrice Unitdecimal50DEC((0))YesPEINH
58SAKTOCost Elementnvarchar100CHAR(N' ')YesCSKAKSTAR Allow NULL? 
59WAERSCurrency Keynvarchar50CUKY(N' ')YesTCURCWAERS Allow NULL? 
60INFNRNumber of Purchasing Info Recordnvarchar100CHAR(N' ')YesEINAINFNR Allow NULL? 
61ESOKZPurchasing info record categorychar10CHAR(N' ')YesESOKZ Allow NULL? 
62EKORGPurchasing Organizationnvarchar40CHAR(N' ')YesT024EEKORG Allow NULL? 
63EKGRPPurchasing group for external processingnvarchar30CHAR(N' ')YesT024VG_EKGRP Allow NULL? 
64KZLGFIndicator: fixed lot external processingchar10CHAR(N' ')YesKZLGF Allow NULL? 
65KZWRTFIndicator: Fixed price for external processingchar10CHAR(N' ')YesKZWRTF Allow NULL? 
66MATKLMaterial Groupnvarchar90CHAR(N' ')YesT023MATKL Allow NULL? 
67DDEHNIndicator: flexible durationchar10CHAR(N' ')YesDAUDEHN Allow NULL? 
68ANZZLNumber of capacities requiredtinyint30INT1((0))YesANZKAP
69PRZNTWork percentagetinyint30INT1((0))YesAPROZENT
70MLSTNUsagenvarchar50CHAR(N' ')YesT433MILESTONE Allow NULL? 
71PPRIOPrioritynvarchar20CHAR(N' ')YesPRIORITAET Allow NULL? 
72BUKRSCompany Codenvarchar40CHAR(N' ')YesT001BUKRS Allow NULL? 
73ANFKORequesting cost centernvarchar100CHAR(N' ')YesCSKSANFKO Allow NULL? 
74ANFKOKRSControlling area of the requesting cost centernvarchar40CHAR(N' ')YesTKA01ANFKOKRS Allow NULL? 
75INDETKey for calculationchar10CHAR(N' ')YesINDET Allow NULL? 
76LARNTActivity Typenvarchar60CHAR(N' ')YesCSLALSTAR Allow NULL? 
77PRKSTCosts in the activitydecimal112CURR((0))YesPRKST
78APLFLSequencenvarchar60CHAR(N' ')YesPLNFOLGE Allow NULL? 
79RUECKCompletion confirmation number for the operationnvarchar100NUMC(N'0000000000')YesCO_RUECK Allow NULL? 
80RMZHLConfirmation counternvarchar80NUMC(N'00000000')YesCO_RMZHL Allow NULL? 
81PROJNWork breakdown structure element (WBS element)nvarchar80NUMC(N'00000000')YesPRPSPS_PSP_ELE Allow NULL? 
82OBJNRObject numbernvarchar220CHAR(N' ')YesONR00J_OBJNR Allow NULL? 
83SPANZActual number of splitsdecimal30DEC((0))YesSPLITTERM
84BEDIDID of the capacity requirements recordnvarchar120NUMC(N'000000000000')Yes*BEDID Allow NULL? 
85BEDZLInternal counternvarchar80NUMC(N'00000000')YesCIM_COUNT Allow NULL? 
86BANFNPurchase requisition numbernvarchar100CHAR(N' ')YesCO_BANFN Allow NULL? 
87BNFPOItem number of the purchase requisition in the ordernvarchar50NUMC(N'00000')YesEBANCO_BNFPO Allow NULL? 
88LEK01Indicator: No remaining activity expectedchar10CHAR(N' ')YesCO_LEIKZ Allow NULL? 
89LEK02Indicator: No remaining activity expectedchar10CHAR(N' ')YesCO_LEIKZ Allow NULL? 
90LEK03Indicator: No remaining activity expectedchar10CHAR(N' ')YesCO_LEIKZ Allow NULL? 
91LEK04Indicator: No remaining activity expectedchar10CHAR(N' ')YesCO_LEIKZ Allow NULL? 
92LEK05Indicator: No remaining activity expectedchar10CHAR(N' ')YesCO_LEIKZ Allow NULL? 
93LEK06Indicator: No remaining activity expectedchar10CHAR(N' ')YesCO_LEIKZ Allow NULL? 
94SELKZSelection indicator for costing line itemschar10CHAR(N' ')YesTCK08CO_SELKZ Allow NULL? 
95KALIDFactory Calendarnvarchar20CHAR(N' ')YesTFACDWFCID Allow NULL? 
96FRSPEarliest possible activity / Latest possible activitychar10CHAR(N' ')YesFRSP Allow NULL? 
97STDKNNode of operation within reference operation setnvarchar80NUMC(N'00000000')YesSTDKN Allow NULL? 
98ANLZUSyst.Conditionchar10CHAR(N' ')YesT357MANLZU Allow NULL? 
99ISTRUAssemblynvarchar180CHAR(N' ')YesMARAISTRU Allow NULL? 
100ISTTYBOM categorychar10CHAR(N' ')YesSTLTY Allow NULL? 
101ISTNRBill of materialnvarchar80CHAR(N' ')YesSTNUM Allow NULL? 
102ISTKNBOM item node numbernvarchar80NUMC(N'00000000')YesSTLKN Allow NULL? 
103ISTPOInternal counternvarchar80NUMC(N'00000000')YesCIM_COUNT Allow NULL? 
104IUPOZSubitem Numbernvarchar40CHAR(N' ')YesUPOSZ Allow NULL? 
105EBORTInstallation Point for Subitemnvarchar200CHAR(N' ')YesEBORT Allow NULL? 
106VERTLDistr.cap.reqmts (plant maint.,process order, network)nvarchar80CHAR(N' ')YesTC29CR_VERTN Allow NULL? 
107LEKNWIndicator: No Remaining Work Expectedchar10CHAR(N' ')YesLEKNW Allow NULL? 
108NPRIOPrioritychar10CHAR(N' ')YesTCN07NW_PRIO Allow NULL? 
109PVZKNGeneral counter for ordernvarchar80NUMC(N'00000000')Yes*CO_APLZL Allow NULL? 
110PHFLGIndicator: Phasechar10CHAR(N' ')YesPHFLG Allow NULL? 
111PHSEQControl Recipe Destinationnvarchar20CHAR(N' ')YesTC52PHSEQ Allow NULL? 
112KNOBJNumber of Object with Assigned Dependenciesnvarchar180NUMC(N'000000000000000000')YesKNOBJ Allow NULL? 
113ERFSICHTRecording Viewnvarchar20CHAR(N' ')YesQERFSICHT Allow NULL? 
114QPPKTABSFlow Variants for Inspection Point Completionchar10CHAR(N' ')YesQPPKTABS Allow NULL? 
115OTYPEObject Typenvarchar20CHAR(N' ')YesT778OOTYPE Allow NULL? 
116OBJEKTIDObject IDnvarchar80NUMC(N'00000000')YesOBJEKTID Allow NULL? 
117QLKAPARCapacity categorynvarchar30CHAR(N' ')YesTC26QL_KAPART Allow NULL? 
118RSTUFReduction level which reduces operation lead timechar10NUMC(N'0')YesRSTUF Allow NULL? 
119NPTXTKYInternal text number (12-character)nvarchar120CHAR(N' ')YesTXTKY Allow NULL? 
120SUBSYSSubsystem Identifier for QM Subsystem Interfacenvarchar60CHAR(N' ')Yes*QEIFSUBSYS Allow NULL? 
121PSPNRStandard WBS elementnvarchar80NUMC(N'00000000')Yes*PS_SPS_ELE Allow NULL? 
122PACKNOPackage numbernvarchar100NUMC(N'0000000000')Yes*PACKNO Allow NULL? 
123TXJCDTax Jurisdictionnvarchar150CHAR(N' ')YesTTXJTXJCD Allow NULL? 
124SCOPEObject Classnvarchar20CHAR(N' ')YesSCOPE_CV Allow NULL? 
125GSBERBusiness Areanvarchar40CHAR(N' ')YesTGSBGSBER Allow NULL? 
126PRCTRProfit Centernvarchar100CHAR(N' ')YesCEPCPRCTR Allow NULL? 
127NO_DISPEffective for Materials Planningchar10CHAR(N' ')YesNO_DISP_PLUS Allow NULL? 
128QKZPRZEITInterval = Time (Time-Related)char10CHAR(N' ')YesQKZPRZEIT Allow NULL? 
129QKZZTMG1Quantity Confirmation for Each Partial Lotchar10CHAR(N' ')YesQKZZTMG1 Allow NULL? 
130QKZPRMENGCreation Cycle = Quantity (Quantity-Reference)char10CHAR(N' ')YesQKZPRMENG Allow NULL? 
131QKZPRFREIInterval Without Reference to Time or Quantitychar10CHAR(N' ')YesQKZPRFREI Allow NULL? 
132KZFEATIndicator Is Not Used Currentlychar10CHAR(N' ')YesQKZFEAT Allow NULL? 
133QKZTLSBESTOperation with Stock-Related Partial Lot Assignmentchar10CHAR(N' ')YesQKZTLSBEST Allow NULL? 
134AENNRChange Numbernvarchar120CHAR(N' ')YesAENRAENNR Allow NULL? 
135CUOBJ_ARBConfiguration (internal object number)nvarchar180NUMC(N'000000000000000000')YesCUOBJ Allow NULL? 
136EVGEWAggregation weight for POC (PS progress)decimal80DEC((0))YesEV_WEIGHTD
137ARBIIActual operating resources object identificationnvarchar80NUMC(N'00000000')YesCRIDCR_OBJID_I Allow NULL? 
138WERKIActual plantnvarchar40CHAR(N' ')YesT001WWERKS_I Allow NULL? 
139CY_SEQNRVSequence number operationnvarchar140NUMC(N'00000000000000')YesCY_SEQNRV Allow NULL? 
140KAPT_PUFFROperation floats after finite scheduling (in seconds)int100INT4((0))YesKAPT_PUFFR Allow NULL? 
141EBELNPurchasing Document Numbernvarchar100CHAR(N' ')YesEKKOEBELN Allow NULL? 
142EBELPItem Number of Purchasing Documentnvarchar50NUMC(N'00000')YesEKPOEBELP Allow NULL? 
143WEMPFGoods Recipient/Ship-To Partynvarchar120CHAR(N' ')YesWEMPF Allow NULL? 
144ABLADUnloading Pointnvarchar250CHAR(N' ')YesABLAD Allow NULL? 
145CLASFInd.: Take Activity Into Account for Project Summarizationchar10CHAR(N' ')YesCLASF Allow NULL? 
146FRUNVIndicator: External procurement data incompletechar10CHAR(N' ')YesFRUNV Allow NULL? 
147ZSCHLOverhead keynvarchar60CHAR(N' ')YesAUFZSCHL Allow NULL? 
148KALSMCosting Sheetnvarchar60CHAR(N' ')Yes*AUFKALSM Allow NULL? 
149SCHED_ENDInd.: Purchase requisition at activity finish datechar10CHAR(N' ')YesSCEND_ACT Allow NULL? 
150NETZKONTIndicator for the account assignment of a network(hdr/act.)char10CHAR(N' ')YesNETZKONT Allow NULL? 
151OWAERObject currency for network activitynvarchar50CUKY(N' ')YesTCURCOWAERS Allow NULL? 
152AFNAMName of Requisitioner/Requesternvarchar120CHAR(N' ')YesAFNAM Allow NULL? 
153BEDNRRequirement Tracking Numbernvarchar100CHAR(N' ')YesBEDNR Allow NULL? 
154KZFIXIndicator: Purchasing info record data are fixedchar10CHAR(N' ')YesCN_KZFIX Allow NULL? 
155PERNRPersonnel numbernvarchar80NUMC(N'00000000')YesCO_PERNR Allow NULL? 
156FRDLBIndicator: Externally processed op. with subcontractingchar10CHAR(N' ')YesCO_FRDLB Allow NULL? 
157QPARTInspection Typenvarchar80CHAR(N' ')YesTQ30QPART Allow NULL? 
158LOEKZDeletion flagchar10CHAR(N' ')YesAUFLOEKZ Allow NULL? 
159WKURSExchange Ratedecimal95DEC((0))YesWKURS
160PROD_ACTIndicator: Activity is a production activitychar10CHAR(N' ')YesPROD_ACT Allow NULL? 
161FPLNRBilling plan number / invoicing plan numbernvarchar100CHAR(N' ')Yes*FPLNR Allow NULL? 
162OBJTYPEChange indicatorchar10CHAR(N' ')YesOCM_OBJ_TYPE Allow NULL? 
163CH_PROCProcess that has lead to the change of an objectchar10CHAR(N' ')YesOCM_CH_PROC Allow NULL? 
164KLVARCosting Variantnvarchar40CHAR(N' ')Yes*CK_KLVAR Allow NULL? 
165KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120NUMC(N'000000000000')Yes*CK_KALNR Allow NULL? 
166FORDNFramework Ordernvarchar100CHAR(N' ')Yes*SFORDN Allow NULL? 
167FORDPItem of framework ordernvarchar50NUMC(N'00000')Yes*FORDP Allow NULL? 
168MAT_PRKSTMaterial planning in networks: primary costsdecimal112CURR((0))YesMAT_PRKST
169PRZ01Business Processnvarchar120CHAR(N' ')Yes*CO_PRZNR Allow NULL? 
170RFPNTReference point for BOM transfernvarchar200CHAR(N' ')YesTCNRFPCN_RFPNT Allow NULL? 
171FUNC_AREAFunctional Areanvarchar160CHAR(N' ')YesTFKBFKBER Allow NULL? 
172TECHSParameter Variant/Standard Variantnvarchar120CHAR(N' ')YesTECHS Allow NULL? 
173ADPSPReference Element PM/PSnvarchar400CHAR(N' ')Yes*ADDCOMPARE_CORE Allow NULL? 
174RFIPPNTReference Point for Relationship Between iPPE and PSnvarchar200CHAR(N' ')YesTCNRPIPCN_RPIP Allow NULL? 
175MES_OPERIDKey of an Operation from an ME Systemnvarchar480CHAR(N' ')YesCO_MES_INT_OPERID Allow NULL? 
176MES_STEPIDKey of a Step in a Routing (SAP ME)nvarchar60CHAR(N' ')YesCO_MES_INT_STEPID Allow NULL? 
177/CUM/CUGUIDUUID in X form (binary)varbinary160RAWYes/CUM/AFCUSYSUUID_X
178/ISDFPS/OBJNRObject numbernvarchar220CHAR(N' ')Yes*J_OBJNR Allow NULL? 
179AFVC_STATUSStatus Combinationtinyint30INT1((0))YesACTCMB_TABACTCMB_DELE
180MILL_OC_AUFNR_MONumber of Combined Ordernvarchar120CHAR(N' ')Yes*MILL_OC_AUFNR_MO Allow NULL? 
181WTY_INDWarranty indicatorchar10CHAR(N' ')YesWTYSC_WTY_INDICATOR Allow NULL? 
182ORGAUFPLRouting number of operations in the ordernvarchar100NUMC(N'0000000000')YesCO_AUFPL Allow NULL? 
183ORGAPLZLGeneral counter for ordernvarchar80NUMC(N'00000000')Yes*CO_APLZL Allow NULL? 
184INACTVersion inactive indicatorchar10CHAR(N' ')YesVSINACT Allow NULL? 
185TPLNRFunctional Locationnvarchar300CHAR(N' ')Yes*TPLNR Allow NULL? 
186EQUNREquipment Numbernvarchar180CHAR(N' ')Yes*EQUNR Allow NULL? 
NamePrimaryUniqueTypeColumns
VSAFVC_CN~0YesYesCLUSTEREDMANDT, VSNMR, AUFPL, APLZL
VSAFVC_CN~1NoNoNONCLUSTEREDMANDT, VSNMR, PROJN
VSAFVC_CN~2NoNoNONCLUSTEREDMANDT, AUFPL
VSAFVC_CN~ANoNoNONCLUSTEREDMANDT, OBJNR