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
Controlling :: Product Cost Controlling :: Product Cost Planning
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0KEKO1277Product Costing - Header DataProduct Cost Planning
SQL:  selectupdate insert create

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

SELECT MANDT, BZOBJ, KALNR, KALKA, KADKY, TVERS, BWVAR, KKZMA, MATNR, WERKS, BWKEY, BWTAR, KOKRS, KADAT, BIDAT, KADAM, BIDAM, BWDAT, ALDAT, BEDAT, VERID, STNUM, STLAN, STALT, STCNT, PLNNR, PLNTY, PLNAL, PLNCT, LOEKZ, LOSGR, MEINS, ERFNM, ERFMA, CPUDT, CPUDM, CPUTIME, FEH_ANZ, FEH_K_ANZ, FEH_STA, MAXMSG, FREIG, MKALK, BALTKZ, KALNR_BA, BTYP, MISCH_VERH, BWVAR_BA, PLSCN, PLMNG, SOBSL, SOBES, SOWRK, SOBWT, SODIR, SODUM, KALSM, AUFZA, BWSMR, SUBSTRAT, KLVAR, KOSGR, ZSCHL, POPER, BDATJ, STKOZ, ZAEHL, TOPKA, CMF_NR, OCS_COUNT, OBJNR, ERZKA, LOSAU, AUSID, AUSSS, SAPRL, KZROH, AUFPL, CUOBJ, CUOBJID, TECHS, TYPE, WRKLT, VORMDAT, VORMUSR, FREIDAT, FREIUSR, UEBID, PROZESS, PR_VERID, CSPLIT, KZKUP, FXPRU, CFXPR, ZIFFR, SUMZIFFR, AFAKT, VBELN, POSNR, PSPNR, SBDKZ, MLMAA, BESKZ, DISST, KALST, TEMPLATE, PATNR, PART_VRSN, ELEHK, ELEHKNS, VOCNT, GSBER, PRCTR, TPVAR, KURST, MGTYP, HWAER, FWAER_KPF, REFID, MEINH_WS, KZWSO, ASL, KALAID, KALADAT, OTYP, BAPI_CREATED, SGT_SCAT FROM KEKO
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2BZOBJReference Objectchar10CHAR(N' ')No*CK_OBJ Allow NULL? 
3KALNRCost Estimate Number - Product Costingnvarchar120NUMC(N'000000000000')NoCKHSCK_KALNR1 Allow NULL? 
4KALKACosting Typenvarchar20CHAR(N' ')No*CK_KALKA Allow NULL? 
5KADKYCosting Date (Key)nvarchar80DATS(N'00000000')NoCK_KADKY Allow NULL? 
6TVERSCosting Versionnvarchar20NUMC(N'00')NoCK_TVERS Allow NULL? 
7BWVARValuation Variant in Costingnvarchar30CHAR(N' ')NoTCK05CK_BWVAR Allow NULL? 
8KKZMACosts Entered Manually in Additive or Automatic Cost Est.char10CHAR(N' ')NoCK_KKZMA Allow NULL? 
9MATNRMaterial Numbernvarchar180CHAR(N' ')YesMARAMATNR Allow NULL? 
10WERKSPlantnvarchar40CHAR(N' ')YesT001WWERKS_D Allow NULL? 
11BWKEYValuation Areanvarchar40CHAR(N' ')YesT001KBWKEY Allow NULL? 
12BWTARValuation Typenvarchar100CHAR(N' ')YesT149DBWTAR_D Allow NULL? 
13KOKRSControlling Areanvarchar40CHAR(N' ')YesTKA01KOKRS Allow NULL? 
14KADATCosting Date Fromnvarchar80DATS(N'00000000')YesCK_ABDAT Allow NULL? 
15BIDATCosting Date Tonvarchar80DATS(N'00000000')YesCK_BIDAT Allow NULL? 
16KADAMCosting Date Fromnvarchar80DATS(N'00000000')YesCK_ABDAT Allow NULL? 
17BIDAMCosting Date Tonvarchar80DATS(N'00000000')YesCK_BIDAT Allow NULL? 
18BWDATValuation Date of a Cost Estimatenvarchar80DATS(N'00000000')YesCK_BWDAT Allow NULL? 
19ALDATQuantity Structure Date for Costingnvarchar80DATS(N'00000000')YesCK_BRDAT Allow NULL? 
20BEDATRequirements Datenvarchar80DATS(N'00000000')YesCK_BEDAT Allow NULL? 
21VERIDProduction Versionnvarchar40CHAR(N' ')Yes*VERID Allow NULL? 
22STNUMBill of materialnvarchar80CHAR(N' ')YesSTNUM Allow NULL? 
23STLANBOM Usagechar10CHAR(N' ')Yes*STLAN Allow NULL? 
24STALTAlternative BOMnvarchar20CHAR(N' ')YesSTALT Allow NULL? 
25STCNTInternal counternvarchar80NUMC(N'00000000')YesCIM_COUNT Allow NULL? 
26PLNNRKey for Task List Groupnvarchar80CHAR(N' ')YesPLNNR Allow NULL? 
27PLNTYTask List Typechar10CHAR(N' ')Yes*PLNTY Allow NULL? 
28PLNALGroup Counternvarchar20CHAR(N' ')YesPLNAL Allow NULL? 
29PLNCTInternal counternvarchar80NUMC(N'00000000')YesCIM_COUNT Allow NULL? 
30LOEKZDeletion Indicator for Product Costingchar10CHAR(N' ')YesCK_LOEKZ Allow NULL? 
31LOSGRLot Size for Product Costingdecimal133QUAN((0))YesCK_LOSGR
32MEINSValuation Unit of Measurenvarchar30UNIT(N' ')YesT006CK_MEINH_BEW Allow NULL? 
33ERFNMCosted by Usernvarchar120CHAR(N' ')YesCK_KALKUSR Allow NULL? 
34ERFMAUser ID of Person Who Created Additive Cost Estimatenvarchar120CHAR(N' ')YesCK_ERFMA Allow NULL? 
35CPUDTDate on Which Cost Estimate Was Creatednvarchar80DATS(N'00000000')YesCK_CPUDT Allow NULL? 
36CPUDMDate on Which Additive Cost Estimate Was Savednvarchar80DATS(N'00000000')YesCK_CPUDM Allow NULL? 
37CPUTIMESystem Timenvarchar60TIMS(N'000000')YesSYUZEIT Allow NULL? 
38FEH_ANZNo. System Messages in Selection/Qty Structure Determinationint100INT4((0))YesCK_FEH_ANZ Allow NULL? 
39FEH_K_ANZNumber of System Messages in Costingint100INT4((0))YesCK_FEH_ANK Allow NULL? 
40FEH_STACosting Statusnvarchar20CHAR(N' ')YesCK_FEH_STA Allow NULL? 
41MAXMSGMessage Typechar10CHAR(N' ')YesSYMSGTY Allow NULL? 
42FREIGRelease of Standard Cost Estimatechar10CHAR(N' ')YesCK_FREIG Allow NULL? 
43MKALKMixed Costing Indicatorchar10CHAR(N' ')YesCK_MKALK Allow NULL? 
44BALTKZCost Estimate for a Procurement Alternativechar10CHAR(N' ')YesCK_BALT_FLAG Allow NULL? 
45KALNR_BACost Estimate Number of Procurement Alternativenvarchar120NUMC(N'000000000000')Yes*CKKALNRBA Allow NULL? 
46BTYPProcess Categorynvarchar40CHAR(N' ')Yes*CKML_BTYP Allow NULL? 
47MISCH_VERHMixed Costing: Mixing Ratiodecimal133DEC((0))YesCK_MISCHVERH
48BWVAR_BAValuation Variant of Procurement Alternativenvarchar30CHAR(N' ')Yes*CK_BWVAR_BA Allow NULL? 
49PLSCNPlanning Scenario of Long-Term Planningnvarchar30NUMC(N'000')Yes*PLSCN Allow NULL? 
50PLMNGProduction Plan Quantity Transferred to the Cost Estimatedecimal153QUAN((0))YesCKI_PLMNG
51SOBSLSpecial Procurement Key for the Costing Objectnvarchar20CHAR(N' ')Yes*CK_SOBSK Allow NULL? 
52SOBESSpecial procurement typechar10CHAR(N' ')YesSOBES Allow NULL? 
53SOWRKSpecial Procurement Plant - Costingnvarchar40CHAR(N' ')Yes*CK_SOWRK Allow NULL? 
54SOBWTValuation Type from Special Procurementnvarchar100CHAR(N' ')Yes*CK_SOBWT Allow NULL? 
55SODIRIndicator for direct production (collective order)char10CHAR(N' ')YesCLCOR Allow NULL? 
56SODUMPhantom item indicatorchar10CHAR(N' ')YesDUMPS Allow NULL? 
57KALSMCosting Sheet for Calculating Overheadnvarchar60CHAR(N' ')YesT683CK_KALSM Allow NULL? 
58AUFZAOverhead typechar10CHAR(N' ')YesAUFZA Allow NULL? 
59BWSMRValuation Strategy for Raw Materials and Purchased Partschar10CHAR(N' ')YesCK_BWSMR Allow NULL? 
60SUBSTRATSubstrategy for Material Valuat. with Purchasing Info Recordchar10CHAR(N' ')YesCK_SUBSTRAT Allow NULL? 
61KLVARCosting Variantnvarchar40CHAR(N' ')YesTCK03CK_KLVAR Allow NULL? 
62KOSGRCosting Overhead Groupnvarchar100CHAR(N' ')YesTCK14CK_KOSGR Allow NULL? 
63ZSCHLOverhead keynvarchar60CHAR(N' ')YesTKZSLAUFZSCHL Allow NULL? 
64POPERPosting periodnvarchar30NUMC(N'000')YesPOPER Allow NULL? 
65BDATJPosting Date YYYYnvarchar40NUMC(N'0000')YesBDATJ Allow NULL? 
66STKOZInternal counternvarchar80NUMC(N'00000000')YesCIM_COUNT Allow NULL? 
67ZAEHLInternal counternvarchar80NUMC(N'00000000')YesCIM_COUNT Allow NULL? 
68TOPKATop Cost Estimate (Point-of-Entry Position)char10CHAR(N' ')YesCK_TOPKA Allow NULL? 
69CMF_NRError Management Numbernvarchar120NUMC(N'000000000000')YesCMF_NR Allow NULL? 
70OCS_COUNTNumber of OCS Messages Sentnvarchar50NUMC(N'00000')YesCMF_OCSCNT Allow NULL? 
71OBJNRObject numbernvarchar220CHAR(N' ')Yes*J_OBJNR Allow NULL? 
72ERZKACost Estimate Created with Product Costingchar10CHAR(N' ')YesCK_ERZKA Allow NULL? 
73LOSAULot Size Taking Scrap into Accountdecimal133QUAN((0))YesCK_LOSAU
74AUSIDAssembly/Operation Scrap Includedchar10CHAR(N' ')YesCK_AUSID Allow NULL? 
75AUSSSAssembly scrap in percentdecimal52DEC((0))YesAUSSS
76SAPRLRelease the document as it was last savednvarchar40CHAR(N' ')YesKK_SAPRL Allow NULL? 
77KZROHMaterial Componentchar10CHAR(N' ')YesCK_KZROH Allow NULL? 
78AUFPLRouting No. for Operations with Non-Order-Related Productionnvarchar100NUMC(N'0000000000')YesCK_AUFPL Allow NULL? 
79CUOBJObject Number for Conf. Objectsnvarchar180NUMC(N'000000000000000000')YesCK_CUOBJ Allow NULL? 
80CUOBJIDIndicator for Configurable Objectschar10CHAR(N' ')YesCK_CUOBJID Allow NULL? 
81TECHSParameter Variant/Standard Variantnvarchar120CHAR(N' ')YesTECHS Allow NULL? 
82TYPEConfigured Material (Variant)nvarchar180CHAR(N' ')YesMARACK_TYPE Allow NULL? 
83WRKLTPlant (Variant)nvarchar40CHAR(N' ')Yes*CK_WRKLT Allow NULL? 
84VORMDATDate on Which Cost Estimate Was Markednvarchar80DATS(N'00000000')YesCK_VORMDAT Allow NULL? 
85VORMUSRUser Who Marked Cost Estimate in Material Masternvarchar120CHAR(N' ')YesCK_VORMUSR Allow NULL? 
86FREIDATDate on Which Cost Estimate Released in Material Masternvarchar80DATS(N'00000000')YesCK_FREIDAT Allow NULL? 
87FREIUSRUser Who Released Cost Estimate in Material Master Recordnvarchar120CHAR(N' ')YesCK_FREIUSR Allow NULL? 
88UEBIDTransfer Controlnvarchar40CHAR(N' ')Yes*CK_UEBID Allow NULL? 
89PROZESSProcess Through Which Co-Product Was Costednvarchar180CHAR(N' ')Yes*CK_PROZESS Allow NULL? 
90PR_VERIDProduction Version To Be Costednvarchar40CHAR(N' ')YesMKALCK_VERID Allow NULL? 
91CSPLITApportionment Structurenvarchar40CHAR(N' ')Yes*CSPLIT Allow NULL? 
92KZKUPIndicator: Material can be co-productchar10CHAR(N' ')YesKZKUPMAT Allow NULL? 
93FXPRUFixed-Price Co-Productchar10CHAR(N' ')YesCK_FIXPRKU Allow NULL? 
94CFXPRCost Estimate Contains Fixed-Price Co-Productschar10CHAR(N' ')YesCK_CONTFIXPRICE Allow NULL? 
95ZIFFREquivalence Numberdecimal30DEC((0))YesCK_ZIFFR
96SUMZIFFRSum of Equivalence Numbers of Co-Products for a Processdecimal50DEC((0))YesCK_SUMZIFFR
97AFAKTCostg.: Apportionment Factor for Itemiz. Line in Joint Prod.float1516FLTP((0))NoCK_SPLITFAC
98VBELNSales and Distribution Document Numbernvarchar100CHAR(N' ')Yes*VBELN Allow NULL? 
99POSNRItem number of the SD documentnvarchar60NUMC(N'000000')Yes*POSNR Allow NULL? 
100PSPNRWork Breakdown Structure Element (WBS element)nvarchar80NUMC(N'00000000')Yes*WB_POSNR Allow NULL? 
101SBDKZDependent requirements ind. for individual and coll. reqmtschar10CHAR(N' ')YesSBDKZ Allow NULL? 
102MLMAAMaterial ledger activated at material levelchar10CHAR(N' ')YesCK_ML_MAAC Allow NULL? 
103BESKZProcurement Typechar10CHAR(N' ')YesBESKZ Allow NULL? 
104DISSTLow-Level Codenvarchar30CHAR(N' ')YesDISST Allow NULL? 
105KALSTCosting Levelnvarchar40NUMC(N'0000')YesCK_KALST Allow NULL? 
106TEMPLATETemplatenvarchar100CHAR(N' ')Yes*ABC_TEMPL Allow NULL? 
107PATNRPartner number for costingnvarchar60NUMC(N'000000')YesNKPRTN Allow NULL? 
108PART_VRSNPartner Versionnvarchar20NUMC(N'00')YesCK_PARVRSN Allow NULL? 
109ELEHKCost Component Structure - CGM and Sales/Administr. Costsnvarchar20CHAR(N' ')Yes*CK_ELESMHK Allow NULL? 
110ELEHKNSCost Component Structure for Auxiliary Cost Component Splitnvarchar20CHAR(N' ')Yes*CK_ELESMNS Allow NULL? 
111VOCNTCounter for Marking a Cost Estimatechar10NUMC(N'0')YesCK_VOCNT Allow NULL? 
112GSBERBusiness Areanvarchar40CHAR(N' ')Yes*GSBER Allow NULL? 
113PRCTRProfit Centernvarchar100CHAR(N' ')Yes*PRCTR Allow NULL? 
114TPVARVariant for Finding Transfer Pricenvarchar30CHAR(N' ')YesTPVAR1TPVARIANT Allow NULL? 
115KURSTExchange Rate Typenvarchar40CHAR(N' ')YesTCURVKURST Allow NULL? 
116MGTYPQuantity Structure Typenvarchar50CHAR(N' ')YesCKMLMV006CKML_MGTYP Allow NULL? 
117HWAERLocal Currencynvarchar50CUKY(N' ')Yes*HWAER Allow NULL? 
118FWAER_KPFCurrency Keynvarchar50CUKY(N' ')Yes*WAERS Allow NULL? 
119REFIDReference Variantnvarchar20NUMC(N'00')YesCK_REFID Allow NULL? 
120MEINH_WSBatch-specific matl unit of measure (proportion/prod. unit)nvarchar30UNIT(N' ')Yes*LRMEI_WS Allow NULL? 
121KZWSOUnits of measure usagechar10CHAR(N' ')YesKZWSO Allow NULL? 
122ASLCost Estimate of an Order BOMchar10CHAR(N' ')YesCK_ASL Allow NULL? 
123KALAIDName of Costing Runnvarchar80CHAR(N' ')YesCK_KALAID Allow NULL? 
124KALADATCosting Run Datenvarchar80DATS(N'00000000')YesCK_KALADAT Allow NULL? 
125OTYPObject Typenvarchar20CHAR(N' ')YesCKML_OTYP Allow NULL? 
126BAPI_CREATEDCost Estimate Generated by BAPIchar10CHAR(N' ')YesCK_BAPI Allow NULL? 
127SGT_SCATStock Segmentnvarchar160CHAR(N' ')YesSGT_SCAT Allow NULL? 
NamePrimaryUniqueTypeColumns
KEKO~0YesYesCLUSTEREDKKZMA, BWVAR, TVERS, KADKY, KALKA, KALNR, BZOBJ, MANDT
KEKO~ANoNoNONCLUSTEREDMATNR
KEKO~BNoNoNONCLUSTEREDBIDAT
KEKO~CNoNoNONCLUSTEREDKADAT
KEKO~DNoNoNONCLUSTEREDKALADAT, KALAID
KEKO~ENoNoNONCLUSTEREDOBJNR, KOKRS, MANDT
KEKO~FNoNoNONCLUSTEREDOBJNR, MANDT