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

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.0VSAUFK_CN1256Version: Order master dataSimulation
SQL:  selectupdate insert create

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

SELECT MANDT, VSNMR, AUFNR, AUART, AUTYP, REFNR, ERNAM, ERDAT, AENAM, AEDAT, KTEXT, LTEXT, BUKRS, WERKS, GSBER, KOKRS, CCKEY, KOSTV, STORT, SOWRK, ASTKZ, WAERS, ASTNR, STDAT, ESTNR, PHAS0, PHAS1, PHAS2, PHAS3, PDAT1, PDAT2, PDAT3, IDAT1, IDAT2, IDAT3, OBJID, VOGRP, LOEKZ, PLGKZ, KVEWE, KAPPL, KALSM, ZSCHL, ABKRS, KSTAR, KOSTL, SAKNR, SETNM, CYCLE, SDATE, SEQNR, USER0, USER1, USER2, USER3, USER4, USER5, USER6, USER7, USER8, USER9, OBJNR, PRCTR, PSPEL, AWSLS, ABGSL, TXJCD, FUNC_AREA, SCOPE, PLINT, KDAUF, KDPOS, AUFEX, IVPRO, LOGSYSTEM, FLG_MLTPS, ABUKR, AKSTL, SIZECL, IZWEK, UMWKZ, KSTEMPF, ZSCHM, PKOSA, ANFAUFNR, PROCNR, PROTY, RSORD, BEMOT, ADRNRA, ERFZEIT, AEZEIT, CSTG_VRNT, COSTESTNR, VERAA_USER, DUMMY_CI_AUFK, VNAME, RECID, ETYPE, OTYPE, JV_JIBCL, JV_JIBSA, JV_OCO, ORGKEY, EXT_AUFNR, INACT, AUFK_STATUS, /CUM/INDCU, /CUM/CMNUM, /CUM/AUEST, /CUM/DESNUM, /MRSS/PL_STRU_ID, /MRSS/PL_MAN_TYP, /MRSS/ORDER_PROB, /MRSS/ACT_TYPE, /MRSS/INIT_DONE, /MRSS/DATACHANGE, /MRSS/SALES_ORG, /MRSS/NW_BOOKED, VAPLZ, WAWRK, FERC_IND, CLAIM_CONTROL, UPDATE_NEEDED, UPDATE_CONTROL FROM VSAUFK_CN
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2VSNMRNumber or description of a versionnvarchar120CHAR(N' ')NoVSNMR Allow NULL? 
3AUFNROrder Numbernvarchar120CHAR(N' ')No*AUFNR Allow NULL? 
4AUARTOrder Typenvarchar40CHAR(N' ')NoT003OAUFART Allow NULL? 
5AUTYPOrder categorynvarchar20NUMC(N'00')NoAUFTYP Allow NULL? 
6REFNRReference order numbernvarchar120CHAR(N' ')NoAUFKAUFREFNR Allow NULL? 
7ERNAMEntered bynvarchar120CHAR(N' ')NoAUFERFNAM Allow NULL? 
8ERDATCreated onnvarchar80DATS(N'00000000')NoAUFERFDAT Allow NULL? 
9AENAMLast changed bynvarchar120CHAR(N' ')NoAUFAENAM Allow NULL? 
10AEDATChange date for Order Masternvarchar80DATS(N'00000000')NoAUFAEDAT Allow NULL? 
11KTEXTDescriptionnvarchar400CHAR(N' ')NoAUFTEXT Allow NULL? 
12LTEXTLong Text Existschar10CHAR(N' ')NoAUFLTEXT Allow NULL? 
13BUKRSCompany Codenvarchar40CHAR(N' ')NoT001BUKRS Allow NULL? 
14WERKSPlantnvarchar40CHAR(N' ')NoT001WWERKS_D Allow NULL? 
15GSBERBusiness Areanvarchar40CHAR(N' ')NoTGSBGSBER Allow NULL? 
16KOKRSControlling Areanvarchar40CHAR(N' ')NoTKA01KOKRS Allow NULL? 
17CCKEYCost collector keynvarchar230CHAR(N' ')NoCCKEY Allow NULL? 
18KOSTVResponsible cost centernvarchar100CHAR(N' ')No*AUFKOSTV Allow NULL? 
19STORTLocationnvarchar100CHAR(N' ')NoT499SAUFSTORT Allow NULL? 
20SOWRKLocation plantnvarchar40CHAR(N' ')NoT001WAUFSOWRK Allow NULL? 
21ASTKZIdentifier for statistical orderchar10CHAR(N' ')NoAUFSTKZ Allow NULL? 
22WAERSOrder Currencynvarchar50CUKY(N' ')NoTCURCAUFWAERS Allow NULL? 
23ASTNROrder statusnvarchar20NUMC(N'00')NoTKO03AUFASTNR Allow NULL? 
24STDATDate of last status changenvarchar80DATS(N'00000000')NoAUFSTDAT Allow NULL? 
25ESTNRStatus reached so farnvarchar20NUMC(N'00')NoTKO03AUFESTNR Allow NULL? 
26PHAS0Phase "Order created"char10CHAR(N' ')NoAUFPHAS0 Allow NULL? 
27PHAS1Phase "Order released"char10CHAR(N' ')NoAUFPHAS1 Allow NULL? 
28PHAS2Phase "order completed"char10CHAR(N' ')NoAUFPHAS2 Allow NULL? 
29PHAS3Phase "order closed"char10CHAR(N' ')NoAUFPHAS3 Allow NULL? 
30PDAT1Planned release datenvarchar80DATS(N'00000000')NoAUFPDAT1 Allow NULL? 
31PDAT2Planned completion datenvarchar80DATS(N'00000000')NoAUFPDAT2 Allow NULL? 
32PDAT3Planned closing datenvarchar80DATS(N'00000000')NoAUFPDAT3 Allow NULL? 
33IDAT1Release datenvarchar80DATS(N'00000000')NoAUFIDAT1 Allow NULL? 
34IDAT2Technical completion datenvarchar80DATS(N'00000000')NoAUFIDAT2 Allow NULL? 
35IDAT3Close datenvarchar80DATS(N'00000000')NoAUFIDAT3 Allow NULL? 
36OBJIDObject IDchar10CHAR(N' ')NoCCOBJID Allow NULL? 
37VOGRPGroup of disallowed transactionsnvarchar40CHAR(N' ')NoTKAVGAUFSPSET Allow NULL? 
38LOEKZDeletion flagchar10CHAR(N' ')NoAUFLOEKZ Allow NULL? 
39PLGKZIdentifier for planning with line itemschar10CHAR(N' ')NoPLGKZ Allow NULL? 
40KVEWEUsage of the condition tablechar10CHAR(N' ')NoT681VKVEWE Allow NULL? 
41KAPPLApplicationnvarchar20CHAR(N' ')NoT681AKAPPL Allow NULL? 
42KALSMCosting Sheetnvarchar60CHAR(N' ')NoT683AUFKALSM Allow NULL? 
43ZSCHLOverhead keynvarchar60CHAR(N' ')NoAUFZSCHL Allow NULL? 
44ABKRSProcessing groupnvarchar20NUMC(N'00')NoTKO08AUFABKRS Allow NULL? 
45KSTARSettlement cost elementnvarchar100CHAR(N' ')NoCSKBAUFKSTAR Allow NULL? 
46KOSTLCost center for basic settlementnvarchar100CHAR(N' ')NoCSKSAUFKOSTL Allow NULL? 
47SAKNRG/L account for basic settlementnvarchar100CHAR(N' ')NoSKB1AUFSAKNR Allow NULL? 
48SETNMAllocation setnvarchar120CHAR(N' ')NoAUFSETNM Allow NULL? 
49CYCLECost center to which costs are actually postednvarchar100CHAR(N' ')NoCSKSST_KOSTL Allow NULL? 
50SDATEStart Datenvarchar80DATS(N'00000000')No*SDATE Allow NULL? 
51SEQNRSequence numbernvarchar40NUMC(N'0000')No*AUFSEQNR Allow NULL? 
52USER0Applicantnvarchar200CHAR(N' ')NoAUFUSER0 Allow NULL? 
53USER1Applicant's telephone numbernvarchar200CHAR(N' ')NoAUFUSER1 Allow NULL? 
54USER2Person responsiblenvarchar200CHAR(N' ')NoAUFUSER2 Allow NULL? 
55USER3Telephone number of person in chargenvarchar200CHAR(N' ')NoAUFUSER3 Allow NULL? 
56USER4Estimated total costs of orderdecimal112CURR((0))NoAUFUSER4
57USER5Application Datenvarchar80DATS(N'00000000')NoAUFUSER5 Allow NULL? 
58USER6Departmentnvarchar150CHAR(N' ')NoAUFUSER6 Allow NULL? 
59USER7Work Startnvarchar80DATS(N'00000000')NoAUFUSER7 Allow NULL? 
60USER8End of Worknvarchar80DATS(N'00000000')NoAUFUSER8 Allow NULL? 
61USER9Identifier for work permit issuedchar10CHAR(N' ')NoAUFUSER9 Allow NULL? 
62OBJNRObject numbernvarchar220CHAR(N' ')NoONR00J_OBJNR Allow NULL? 
63PRCTRProfit Centernvarchar100CHAR(N' ')NoCEPCPRCTR Allow NULL? 
64PSPELWork breakdown structure element (WBS element)nvarchar80NUMC(N'00000000')NoVSPRPS_CNPS_PSP_ELE Allow NULL? 
65AWSLSVariance Keynvarchar60CHAR(N' ')NoTKV01AWSLS Allow NULL? 
66ABGSLResults Analysis Keynvarchar60CHAR(N' ')NoTKKAAABGR_SCHL Allow NULL? 
67TXJCDTax Jurisdictionnvarchar150CHAR(N' ')NoTTXJTXJCD Allow NULL? 
68FUNC_AREAFunctional Areanvarchar160CHAR(N' ')YesTFKBFKBER Allow NULL? 
69SCOPEObject Classnvarchar20CHAR(N' ')NoSCOPE_CV Allow NULL? 
70PLINTIndicator for Integrated Planningchar10CHAR(N' ')NoPLINT Allow NULL? 
71KDAUFSales Order Numbernvarchar100CHAR(N' ')NoVBUKKDAUF Allow NULL? 
72KDPOSItem Number in Sales Ordernvarchar60NUMC(N'000000')NoKDPOS Allow NULL? 
73AUFEXExternal order numbernvarchar200CHAR(N' ')NoAUFEX Allow NULL? 
74IVPROInvestment measure profilenvarchar60CHAR(N' ')NoTAPRFIM_PROFIL Allow NULL? 
75LOGSYSTEMLogical Systemnvarchar100CHAR(N' ')NoTBDLSLOGSYSTEM Allow NULL? 
76FLG_MLTPSOrder with multiple itemschar10CHAR(N' ')NoCO_MLTPS Allow NULL? 
77ABUKRRequesting company codenvarchar40CHAR(N' ')YesT001IM_ABUKRS Allow NULL? 
78AKSTLRequesting cost centernvarchar100CHAR(N' ')NoCSKSPS_AKSTL Allow NULL? 
79SIZECLScale of investment objectsnvarchar20CHAR(N' ')YesTAIF5IM_SIZECL Allow NULL? 
80IZWEKReason for investmentnvarchar20CHAR(N' ')YesT087IIZWEK Allow NULL? 
81UMWKZReason for environmental investmentnvarchar50CHAR(N' ')YesT087KAM_UMWKZ Allow NULL? 
82KSTEMPFIndicator: Direct cost collectorchar10CHAR(N' ')YesCO_KSTEMPF Allow NULL? 
83ZSCHMInterest Profile for Project/Order Interest Calculationnvarchar70CHAR(N' ')YesTPI01PS_ZSCHM Allow NULL? 
84PKOSACost collector for production process PROCNRnvarchar120CHAR(N' ')Yes*PKOSA_D Allow NULL? 
85ANFAUFNRRequesting ordernvarchar120CHAR(N' ')YesAUFKAUFANFNR Allow NULL? 
86PROCNRProduction alternativenvarchar120NUMC(N'000000000000')Yes*CKML_PROCNR Allow NULL? 
87PROTYProcess Category (Procurement/Consumption)nvarchar40CHAR(N' ')Yes*CKML_PROZESS_TYP Allow NULL? 
88RSORDRefurbishment order indicator (PM)char10CHAR(N' ')YesRSORD Allow NULL? 
89BEMOTAccounting Indicatornvarchar20CHAR(N' ')YesTBMOTBEMOT Allow NULL? 
90ADRNRAAddress numbernvarchar100CHAR(N' ')Yes*AD_ADDRNUM Allow NULL? 
91ERFZEITTime creatednvarchar60TIMS(N'000000')YesCO_INS_TIME Allow NULL? 
92AEZEITChanged atnvarchar60TIMS(N'000000')YesCO_CHG_TIME Allow NULL? 
93CSTG_VRNTCosting Variantnvarchar40CHAR(N' ')Yes*CK_KLVAR Allow NULL? 
94COSTESTNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120NUMC(N'000000000000')Yes*CK_KALNR Allow NULL? 
95VERAA_USERPerson Responsible for CO Internal Ordernvarchar120CHAR(N' ')Yes*VERAA_USER Allow NULL? 
96DUMMY_CI_AUFKSingle-Character Indicatorchar10CHAR(N' ')YesCHAR1 Allow NULL? 
97VNAMEJoint Venturenvarchar60CHAR(N' ')YesT8JVJV_NAME Allow NULL? 
98RECIDRecovery Indicatornvarchar20CHAR(N' ')YesT8JJJV_RECIND Allow NULL? 
99ETYPEEquity typenvarchar30CHAR(N' ')YesT8JGJV_ETYPE Allow NULL? 
100OTYPEJoint Venture Object Typenvarchar40CHAR(N' ')YesJV_OTYPE Allow NULL? 
101JV_JIBCLJIB/JIBE Classnvarchar30CHAR(N' ')YesT8J6AJV_JIBCL Allow NULL? 
102JV_JIBSAJIB/JIBE Subclass Anvarchar50CHAR(N' ')YesT8J6CJV_JIBSA Allow NULL? 
103JV_OCOJV original cost objectchar10CHAR(N' ')YesJV_OR_CO Allow NULL? 
104ORGKEYOrder Numbernvarchar120CHAR(N' ')Yes*AUFNR Allow NULL? 
105EXT_AUFNROrder Numbernvarchar120CHAR(N' ')Yes*AUFNR Allow NULL? 
106INACTVersion inactive indicatorchar10CHAR(N' ')YesVSINACT Allow NULL? 
107AUFK_STATUSStatus Combinationtinyint30INT1((0))YesACTCMB_TABACTCMB_DELE
108/CUM/INDCUCU: Order is Used for Compatible Unitschar10CHAR(N' ')Yes/CUM/INDCU Allow NULL? 
109/CUM/CMNUMCU: Construction Measure Numbernvarchar120CHAR(N' ')Yes/CUM/CMNUM Allow NULL? 
110/CUM/AUESTCU: Automatic Copy of Estimated Costschar10CHAR(N' ')Yes/CUM/AUEST Allow NULL? 
111/CUM/DESNUMCU: Design Numbernvarchar120CHAR(N' ')Yes*/CUM/DESNUM Allow NULL? 
112/MRSS/PL_STRU_IDResource planning nodesnvarchar80NUMC(N'00000000')Yes*/MRSS/T_PLAN_STRUCT_ID Allow NULL? 
113/MRSS/PL_MAN_TYPAssignment to resource planner or contact personchar10CHAR(N' ')Yes/MRSS/T_MANAGER_TYPE Allow NULL? 
114/MRSS/ORDER_PROBOrder probability in percentnvarchar30CHAR(N' ')Yes/MRSS/T_ORDER_PROB Allow NULL? 
115/MRSS/ACT_TYPEProcess variantchar10CHAR(N' ')Yes/MRSS/T_ACTIVITY_TYPE Allow NULL? 
116/MRSS/INIT_DONEInternal initialization carried out oncechar10CHAR(N' ')Yes/MRSS/T_INIT_DONE Allow NULL? 
117/MRSS/DATACHANGEData was changed in the controls on the user screenchar10CHAR(N' ')Yes/MRSS/T_USCREENCTL_DATACHANGED Allow NULL? 
118/MRSS/SALES_ORGSales Organizationnvarchar40CHAR(N' ')Yes*VKORG Allow NULL? 
119/MRSS/NW_BOOKEDNetwork Set to "Booked"char10CHAR(N' ')Yes/MRSS/T_NW_BOOKED Allow NULL? 
120VAPLZMain work center for maintenance tasksnvarchar80CHAR(N' ')YesGEWRK Allow NULL? 
121WAWRKPlant associated with main work centernvarchar40CHAR(N' ')Yes*WERGW Allow NULL? 
122FERC_INDRegulatory indicatornvarchar40CHAR(N' ')YesFERC_C7FE_IND Allow NULL? 
123CLAIM_CONTROLClaim creation control indicatorchar10CHAR(N' ')YesWTYSCC_CLM_CONTWTYSC_CLAIM_CONTROL Allow NULL? 
124UPDATE_NEEDEDClaim inconsistency with order indicatorchar10CHAR(N' ')YesWTYSC_UPDATE_NEEDED Allow NULL? 
125UPDATE_CONTROLClaim update trigger point from service orderchar10CHAR(N' ')YesWTYSCC_UPDT_CONTWTYSC_UPDATE_CONTROL Allow NULL? 
NamePrimaryUniqueTypeColumns
VSAUFK_CN~0YesYesCLUSTEREDMANDT, VSNMR, AUFNR
VSAUFK_CN~1NoNoNONCLUSTEREDMANDT, VSNMR, PSPEL
VSAUFK_CN~10NoNoNONCLUSTEREDVSNMR, EXT_AUFNR
VSAUFK_CN~11NoNoNONCLUSTEREDEXT_AUFNR
VSAUFK_CN~2NoNoNONCLUSTEREDMANDT, AUFNR
VSAUFK_CN~ANoNoNONCLUSTEREDMANDT, OBJNR