SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

Home | ERP 6.0  | CKIS
JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Controlling :: Product Cost Controlling :: Product Cost Planning
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0CKIS1401Items Unit Costing/Itemization Product CostingProduct Cost Planning
SQL:  selectupdate insert create

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

SELECT MANDT, LEDNR, BZOBJ, KALNR, KALKA, KADKY, TVERS, BWVAR, KKZMA, POSNR, STATP, STRGP, TYPPS, KSTAR, KSTAR_MANUAL, HRKFT, ELEMT, ELEMTNS, FVFLG, OPCOD, FRLNR, BUKRS, WERKS, MATNR, PSCHL, KOKRS_HRK, EXTNR, GPREIS, FPREIS, PEINH, PMEHT, PRICE_MANUAL, WERTB, WERTN, WRTFX, WRTFW_KPF, WRTFW_KFX, FWAER_KPF, WRTFW_POS, WRTFW_PFX, FWAER, MKURS, FWEHT, MENGE, MEEHT, SUMM1, SUMM2, SUMM3, DPREIS, PREIS1, PREIS2, PREIS3, PREIS4, PREIS5, PFKT1, PFKT2, PFKT3, PFKT4, PFKT5, ZUABS, ZUFKT, PSKNZ, SBDKZ, VTKNZ, LSTAR, ARBID, KOSTL, INFNR, EKORG, ESOKZ, LIFNR, EBELN, EBELP, STEUS, FXPRU, STPOS, AFAKT, BWTAR, MKALK, BTYP, KALNR_BA, MISCH_VERH, UMREZ, UMREN, AUSMG, AUSMGKO, AUSPROZ, APLZL, VORNR, UVORN, STEAS, POSNR_EXT, POINTER1, POINTER2, POINTER3, OPREIS, OPREIFX, TPREIS, TPREIFX, PATNR, VERWS, PRSKZ, STRAT, SUBSTRAT, TKURS, SELKZ, VRGGRP, KKZMM, SSEDD, FEHLKZ, NO_CCSPLIT, SCHKZ, SCHKZNS, UFIELD_MODE, UKALN, UKALKA, UKADKY, UTVERS, UBWVAR, HKMAT, SPOSN, USTRAT, BAUGR, ASNUM, PEINH_2, PEINH_3, PRZNR, NLAG, PRCTR, GSBER, PSPNR, PAROB, KZANW, KZLB, SUBKEY, KZWSO, DISST, CUOBJ, GENTYP, COMPONENT_ID FROM CKIS
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2LEDNRLedger for Controlling objectsnvarchar20CHAR(N' ')NoLEDNR Allow NULL? 
3BZOBJReference Objectchar10CHAR(N' ')No*CK_OBJ Allow NULL? 
4KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120NUMC(N'000000000000')NoCKHSCK_KALNR Allow NULL? 
5KALKACosting Typenvarchar20CHAR(N' ')No*CK_KALKA Allow NULL? 
6KADKYCosting Date (Key)nvarchar80DATS(N'00000000')NoCK_KADKY Allow NULL? 
7TVERSCosting Versionnvarchar20NUMC(N'00')NoCK_TVERS Allow NULL? 
8BWVARValuation Variant in Costingnvarchar30CHAR(N' ')No*CK_BWVAR Allow NULL? 
9KKZMACosts Entered Manually in Additive or Automatic Cost Est.char10CHAR(N' ')NoCK_KKZMA Allow NULL? 
10POSNRUnit Costing Line Item Numbernvarchar50NUMC(N'00000')NoCK_POSNR Allow NULL? 
11STATPItem Statusnvarchar40CHAR(N' ')YesSTATP_D Allow NULL? 
12STRGPItem Control (for Internal Use)nvarchar40CHAR(N' ')YesSTRGP Allow NULL? 
13TYPPSItem Categorychar10CHAR(N' ')YesTYPPS Allow NULL? 
14KSTARCost Elementnvarchar100CHAR(N' ')Yes*KSTAR Allow NULL? 
15KSTAR_MANUALCost Element Has Been Manually Changedchar10CHAR(N' ')YesCK_COST_ELEMENT_MANUAL Allow NULL? 
16HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40CHAR(N' ')Yes*HRKFT Allow NULL? 
17ELEMTCost Component Number of Main Cost Component Splitnvarchar30NUMC(N'000')Yes*CK_ELEMENTHS Allow NULL? 
18ELEMTNSCost Component Number of Auxiliary Cost Component Splitnvarchar30NUMC(N'000')Yes*CK_ELEMENTNS Allow NULL? 
19FVFLGFixed/Variable Indicatorchar10CHAR(N' ')YesFVFLG Allow NULL? 
20OPCODFormula field for calculations at item levelnvarchar500CHAR(N' ')YesOPCOD Allow NULL? 
21FRLNRUnit Costing Formula Numbernvarchar30CHAR(N' ')YesFORML_EK Allow NULL? 
22BUKRSCompany Codenvarchar40CHAR(N' ')YesT001BUKRS Allow NULL? 
23WERKSPlantnvarchar40CHAR(N' ')YesT001WWERKS_D Allow NULL? 
24MATNRMaterial Numbernvarchar180CHAR(N' ')YesMARAMATNR Allow NULL? 
25PSCHLPricing Keynvarchar180CHAR(N' ')YesPSCHL Allow NULL? 
26KOKRS_HRKOrigin Controlling Area Itemnvarchar40CHAR(N' ')YesTKA01KOKRS_HRK Allow NULL? 
27EXTNRBase Planning Object (External Number)nvarchar180CHAR(N' ')YesCKBSEXTNR Allow NULL? 
28GPREISPrice in Controlling Area Currencydecimal152CURR((0))YesCK_KPT
29FPREISFixed Price in Controlling Area Currencydecimal152CURR((0))YesCK_KPF
30PEINHPrice Unit of Prices in Controlling Area Currencydecimal50DEC((0))YesCK_KPEINH
31PMEHTPrice Quantity Unitnvarchar30UNIT(N' ')YesT006PMEHT Allow NULL? 
32PRICE_MANUALPrice Entered Manuallychar10CHAR(N' ')YesCK_PRICE_MANUAL Allow NULL? 
33WERTBValue in Controlling Area Currencydecimal152CURR((0))YesCK_KWT
34WERTNValue in Controlling Area Currencydecimal152CURR((0))YesCK_KWT
35WRTFXFixed Value in Controlling Area Currencydecimal152CURR((0))YesCK_KWF
36WRTFW_KPFValue in Object Currencydecimal152CURR((0))YesCK_OWT
37WRTFW_KFXFixed Value in Object Currencydecimal152CURR((0))YesCK_OWF
38FWAER_KPFObject Currencynvarchar50CUKY(N' ')Yes*CK_OWAER Allow NULL? 
39WRTFW_POSValue in Transaction Currencydecimal152CURR((0))YesCK_TWT
40WRTFW_PFXFixed Value in Transaction Currencydecimal152CURR((0))YesCK_TWF
41FWAERTransaction Currencynvarchar50CUKY(N' ')YesTCURCCK_TWAER Allow NULL? 
42MKURSAverage ratenvarchar90NUMC(N'000000000')YesMKURS Allow NULL? 
43FWEHTCurrency unitnvarchar40NUMC(N'0000')YesEINHT_CUR Allow NULL? 
44MENGEQuantitydecimal153QUAN((0))YesMENGE_POS
45MEEHTBase Unit of Measurenvarchar30UNIT(N' ')YesT006MEINS Allow NULL? 
46SUMM1Quantities total for item category Sdecimal153QUAN((0))YesSUMME_MNG
47SUMM2Capital Spending Total for Item Category Sdecimal152CURR((0))YesSUMME_INV
48SUMM3Total of two or more itemsdecimal152CURR((0))YesSUMME_POS
49DPREISAverage price for periodsdecimal152CURR((0))YesDPREIS
50PREIS1Value of Delta Profit in CO Area Currency - Legal Viewdecimal152CURR((0))YesPREIS1
51PREIS2Value of Delta Profit in Object Currency - Legal Viewdecimal152CURR((0))YesPREIS2
52PREIS3Value of Delta Profit in CO Area Currency - Profit Ctr Viewdecimal152CURR((0))YesPREIS3
53PREIS4Value of Delta Profit in Object Currency - Profit Ctr Viewdecimal152CURR((0))YesPREIS4
54PREIS5Price Component 5decimal152CURR((0))YesPREIS5
55PFKT1Price Component Factordecimal52DEC((0))YesPFKTX
56PFKT2Price Component Factordecimal52DEC((0))YesPFKTX
57PFKT3Price Component Factordecimal52DEC((0))YesPFKTX
58PFKT4Price Component Factordecimal52DEC((0))YesPFKTX
59PFKT5Price Component Factordecimal52DEC((0))YesPFKTX
60ZUABSOverhead as absolute figuredecimal152CURR((0))YesDZUABS
61ZUFKTOverhead factordecimal54DEC((0))YesDZUFKT
62PSKNZLot-Size-Independent Indicatorchar10CHAR(N' ')YesPSKNZ Allow NULL? 
63SBDKZDependent requirements ind. for individual and coll. reqmtschar10CHAR(N' ')YesSBDKZ Allow NULL? 
64VTKNZDistribution Indicatorchar10CHAR(N' ')YesVTKNZ Allow NULL? 
65LSTARActivity Typenvarchar60CHAR(N' ')Yes*LSTAR Allow NULL? 
66ARBIDObject IDnvarchar80NUMC(N'00000000')YesOBJEKTID Allow NULL? 
67KOSTLCost Centernvarchar100CHAR(N' ')Yes*KOSTL Allow NULL? 
68INFNRNumber of Purchasing Info Recordnvarchar100CHAR(N' ')YesEINAINFNR Allow NULL? 
69EKORGPurchasing Organizationnvarchar40CHAR(N' ')Yes*EKORG Allow NULL? 
70ESOKZPurchasing info record categorychar10CHAR(N' ')YesESOKZ Allow NULL? 
71LIFNRAccount Number of Vendor or Creditornvarchar100CHAR(N' ')Yes*LIFNR Allow NULL? 
72EBELNPurchasing Document Numbernvarchar100CHAR(N' ')Yes*EBELN Allow NULL? 
73EBELPItem Number of Purchasing Documentnvarchar50NUMC(N'00000')Yes*EBELP Allow NULL? 
74STEUSControl Keynvarchar40CHAR(N' ')YesCK_STEUS Allow NULL? 
75FXPRUFixed-Price Co-Productchar10CHAR(N' ')YesCK_FIXPRKU Allow NULL? 
76STPOSEquivalence Number with 4 Placesdecimal40DEC((0))YesCK_AEQUI4
77AFAKTCostg.: Apportionment Factor for Itemiz. Line in Joint Prod.float1516FLTP((0))YesCK_SPLITFAC
78BWTARValuation Typenvarchar100CHAR(N' ')YesT149DBWTAR_D Allow NULL? 
79MKALKMixed Costing Indicatorchar10CHAR(N' ')YesCK_MKALK Allow NULL? 
80BTYPProcess Categorynvarchar40CHAR(N' ')Yes*CKML_BTYP Allow NULL? 
81KALNR_BACost Estimate Number of Procurement Alternativenvarchar120NUMC(N'000000000000')Yes*CKKALNRBA Allow NULL? 
82MISCH_VERHMixing Ratiodecimal133DEC((0))YesCK_CROSSR
83UMREZNumerator for Conversion of Order Unit to Base Unitdecimal50DEC((0))YesUMBSZ
84UMRENDenominator for Conversion of Order Unit to Base Unitdecimal50DEC((0))YesUMBSN
85AUSMGScrap Quantitydecimal153QUAN((0))YesCK_AUSMG
86AUSMGKOComponent Scrap Quantitydecimal153QUAN((0))YesCK_AUSMGKO
87AUSPROZScrap Factordecimal63DEC((0))YesCK_SCRAP
88APLZLContinuous Counter for Differentiating Database Entriesnvarchar80NUMC(N'00000000')YesCK_COUNT Allow NULL? 
89VORNROperation/Activity Numbernvarchar40CHAR(N' ')YesVORNR Allow NULL? 
90UVORNSuboperationnvarchar40CHAR(N' ')YesUVORN Allow NULL? 
91STEASTarget start date of the operationnvarchar80DATS(N'00000000')YesCK_STEAS Allow NULL? 
92POSNR_EXTItem Number for External Layout (Unit Costing)nvarchar50NUMC(N'00000')Yes*CK_POSEXT Allow NULL? 
93POINTER1Pointer n on Item Numbernvarchar50NUMC(N'00000')Yes*CK_POS_POI Allow NULL? 
94POINTER2Pointer n on Item Numbernvarchar50NUMC(N'00000')Yes*CK_POS_POI Allow NULL? 
95POINTER3Pointer n on Item Numbernvarchar50NUMC(N'00000')Yes*CK_POS_POI Allow NULL? 
96OPREISPrice in Object Currencydecimal152CURR((0))YesCK_OPT
97OPREIFXFixed Price in Object Currencydecimal152CURR((0))YesCK_OPF
98TPREISPrice in Transaction Currencydecimal152CURR((0))YesCK_TPT
99TPREIFXFixed Price in Transaction Currencydecimal152CURR((0))YesCK_TPF
100PATNRPartner number for costingnvarchar60NUMC(N'000000')YesNKPRTN Allow NULL? 
101VERWSReference of KALKTAB Items to a Contextnvarchar350CHAR(N' ')YesCK_VERWEIS Allow NULL? 
102PRSKZPrice Indicatornvarchar30CHAR(N' ')YesCK_PRSKZ Allow NULL? 
103STRATValuation Strategy used for Costing Itemchar10CHAR(N' ')YesCK_STRAT Allow NULL? 
104SUBSTRATSubstrategy for Material Valuat. with Purchasing Info Recordchar10CHAR(N' ')YesCK_SUBSTRAT Allow NULL? 
105TKURSExchange Rate for Item Foreign Currencydecimal95DEC((0))YesTKURS
106SELKZIndicator for Relevancy to Costingchar10CHAR(N' ')YesTCK08CK_SELKZ Allow NULL? 
107VRGGRPTransaction Group for Cost Element Itemizationnvarchar30CHAR(N' ')Yes*CK_VRGGRP Allow NULL? 
108KKZMMCosts Were Entered Manually in an Additive Cost Estimatechar10CHAR(N' ')YesKKZMM Allow NULL? 
109SSEDDLatest scheduled finish: Execution (date)nvarchar80DATS(N'00000000')YesSSEDD Allow NULL? 
110FEHLKZError Indicatorchar10CHAR(N' ')YesCK_FEHLKZ Allow NULL? 
111NO_CCSPLITDo Not Determine Item Value via Cost Component Splitchar10CHAR(N' ')YesCK_NO_CCSPLIT Allow NULL? 
112SCHKZMain Cost Component Split for KALKTAB Item Existschar10CHAR(N' ')YesCK_SCHKZHS Allow NULL? 
113SCHKZNSAuxiliary Cost Component Split for KALKTAB Item Existschar10CHAR(N' ')YesCK_SCHKZNS Allow NULL? 
114UFIELD_MODEIndicator to Override Transfer Controlchar10CHAR(N' ')YesCK_UFIELD_MODE Allow NULL? 
115UKALNCost Estimate Number of Transferred Cost Estimatenvarchar120NUMC(N'000000000000')Yes*CK_UKALN Allow NULL? 
116UKALKACosting Type of Transferred Cost Estimatenvarchar20CHAR(N' ')Yes*CK_UKALKA Allow NULL? 
117UKADKYDate of Transferred Cost Estimatenvarchar80DATS(N'00000000')YesCK_UKADKY Allow NULL? 
118UTVERSCosting Version for Transfernvarchar20NUMC(N'00')YesCK_UTVERS Allow NULL? 
119UBWVARValuation Variant of Transferred Cost Estimatenvarchar30CHAR(N' ')Yes*CK_UBWVAR Allow NULL? 
120HKMATMaterial-related originchar10CHAR(N' ')YesHKMAT Allow NULL? 
121SPOSNBOM Item Numbernvarchar40CHAR(N' ')YesSPOSN Allow NULL? 
122USTRATTransfer Strategy: Search Term 1char10NUMC(N'0')YesCK_UEBPER1 Allow NULL? 
123BAUGRItem Is an Assemblychar10CHAR(N' ')YesCK_BAUGR Allow NULL? 
124ASNUMActivity Numbernvarchar180CHAR(N' ')YesASMDASNUM Allow NULL? 
125PEINH_2Price Unitdecimal50DEC((0))YesPEINH
126PEINH_3Price Unitdecimal50DEC((0))YesPEINH
127PRZNRBusiness Processnvarchar120CHAR(N' ')Yes*CO_PRZNR Allow NULL? 
128NLAGNon-Stock Materialchar10CHAR(N' ')YesCK_NLAG Allow NULL? 
129PRCTRProfit Centernvarchar100CHAR(N' ')Yes*PRCTR Allow NULL? 
130GSBERBusiness Areanvarchar40CHAR(N' ')Yes*GSBER Allow NULL? 
131PSPNRWork Breakdown Structure Element (WBS element)nvarchar80NUMC(N'00000000')Yes*WB_POSNR Allow NULL? 
132PAROBPartner Objectnvarchar220CHAR(N' ')Yes*PAROB Allow NULL? 
133KZANW'X' = Do Not Calculate Overhead Costschar10CHAR(N' ')YesCK_KZANW Allow NULL? 
134KZLB'X' = Header Material Is Subcontractedchar10CHAR(N' ')YesCK_KZLB Allow NULL? 
135SUBKEYCO key subnumbernvarchar140CHAR(N' ')Yes*CO_SUBKEY Allow NULL? 
136KZWSOUnits of measure usagechar10CHAR(N' ')YesKZWSO Allow NULL? 
137DISSTLow-Level Codenvarchar30CHAR(N' ')YesDISST Allow NULL? 
138CUOBJObject Number for Conf. Objectsnvarchar180NUMC(N'000000000000000000')YesCK_CUOBJ Allow NULL? 
139GENTYPGeneration Type of Itemchar10CHAR(N' ')YesCK_GENTYP Allow NULL? 
140COMPONENT_IDUnique Pointer to the Itemization Line (Persistent)nvarchar70NUMC(N'0000000')YesCK_COMPONENT_ID Allow NULL? 
NamePrimaryUniqueTypeColumns
CKIS~0YesYesCLUSTEREDPOSNR, KKZMA, BWVAR, TVERS, KADKY, KALKA, KALNR, BZOBJ, LEDNR, MANDT

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy