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  | CKHS
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.0CKHS831Header: Unit Costing (Control + Totals)Product 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, BUKRS, KOKRS, FCPMG, FROPER, DIPER, TOPER, KKART, GJAHR, ERFDT, ERFNM, AENDT, AENNM, ABSDT, ABSNM, KRSDT, STATK, STRNG, PSDAT, MENGE, MEEHT, HWGES, HWGFX, FWGES, HWAER, FWAER, UKURS, KURST, FFACT, TFACT, GWRT1, GWRT2, GWRT3, GWRT4, GWRT5, STFLG, ZTFLG, FVFLG, DLFLG, FRFLG, PRVFN, PKANZ, PSANZ, KNNZ1, KNNZ2, KNNZ3, KNNZ4, KNNZ5, ME_SUMM1, SUMM1_KPF, SUMM2_KPF, SUMM3_KPF, EXTNR, KOSTL, AUFNR, KSTAR, HRKFT, KALSM, ZSCHL, TEMPLATE, OBJNR, TWGES, TKURST, TWAER, KKBWVAR, KKSAPRL, TKURS, KZROH, FILEPATH, FILENAME, CKCM, CKCMV, MAXCID, INTHIER, LOG_HANDLE FROM CKHS
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')NoCK_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? 
10BUKRSCompany Codenvarchar40CHAR(N' ')YesT001BUKRS Allow NULL? 
11KOKRSControlling Areanvarchar40CHAR(N' ')YesTKA01KOKRS Allow NULL? 
12FCPMGDistribution Keynvarchar40CHAR(N' ')YesT821SSPRED Allow NULL? 
13FROPERFirst Valid Period (from Period)nvarchar30NUMC(N'000')YesCK_FROPER Allow NULL? 
14DIPERInterval Between Planned Periodsnvarchar30NUMC(N'000')YesCK_DIPER Allow NULL? 
15TOPERLast Posting Period Allowednvarchar30NUMC(N'000')YesCK_TOPER Allow NULL? 
16KKARTCosting Variant (Corresponds to KLVAR)nvarchar40CHAR(N' ')YesTKKEAKKART Allow NULL? 
17GJAHRFiscal Yearnvarchar40NUMC(N'0000')YesGJAHR Allow NULL? 
18ERFDTCreated onnvarchar80DATS(N'00000000')YesERFDT Allow NULL? 
19ERFNMEntered bynvarchar120CHAR(N' ')YesERFNM Allow NULL? 
20AENDTDate of last changenvarchar80DATS(N'00000000')YesAENDT Allow NULL? 
21AENNMLast changed bynvarchar120CHAR(N' ')YesAENNM Allow NULL? 
22ABSDTClose datenvarchar80DATS(N'00000000')YesABSDT Allow NULL? 
23ABSNMUser ID of the person who closed the cost estimatenvarchar120CHAR(N' ')YesABSNM Allow NULL? 
24KRSDTExchange Rate Datenvarchar80DATS(N'00000000')YesKRSDT Allow NULL? 
25STATKHeader Statusnvarchar40CHAR(N' ')YesSTATK Allow NULL? 
26STRNGInternal header controlnvarchar40CHAR(N' ')YesSTRNG Allow NULL? 
27PSDATPricing Datenvarchar80DATS(N'00000000')YesPSDAT Allow NULL? 
28MENGELot Sizedecimal153QUAN((0))YesMENGE_KPF
29MEEHTValuation Unit of Measurenvarchar30UNIT(N' ')YesT006CK_MEINH_BEW Allow NULL? 
30HWGESTotal Value of Cost Estimate in Local Currencydecimal152CURR((0))YesHWGES
31HWGFXFixed Portion of Costing Value in Local Currencydecimal152CURR((0))YesHWFIX
32FWGESTotal Value for Cost Estimate in Foreign Currencydecimal152CURR((0))YesFWGES
33HWAERLocal Currencynvarchar50CUKY(N' ')YesTCURCHWAER Allow NULL? 
34FWAERForeign Currency in Headernvarchar50CUKY(N' ')YesTCURCFWAER Allow NULL? 
35UKURSExchange Ratedecimal95DEC((0))YesUKURS_D
36KURSTExchange Rate Typenvarchar40CHAR(N' ')YesTCURVKURST Allow NULL? 
37FFACTFactor for the "From" Currency Unitsdecimal90DEC((0))YesFFACT
38TFACTFactor for the "To" Currency Unitsdecimal90DEC((0))YesTFACT_D
39GWRT1Total Value of Price Component 1decimal152CURR((0))YesGWRT1
40GWRT2Total Value of Price Component 1decimal152CURR((0))YesGWRT1
41GWRT3Total Value of Price Component 1decimal152CURR((0))YesGWRT1
42GWRT4Total Value of Price Component 1decimal152CURR((0))YesGWRT1
43GWRT5Total Value of Price Component 1decimal152CURR((0))YesGWRT1
44STFLGSales Order Cost Estimate Is Markedchar10CHAR(N' ')YesSTFLG Allow NULL? 
45ZTFLGFlag for time-based unit costingchar10CHAR(N' ')YesDZTFLG Allow NULL? 
46FVFLGFixed/Variable Indicatorchar10CHAR(N' ')YesFVFLG Allow NULL? 
47DLFLGDeletion Flag for Unit Costingchar10CHAR(N' ')YesDLFLG Allow NULL? 
48FRFLGRelease Flagchar10CHAR(N' ')YesFRFLG Allow NULL? 
49PRVFNPricing procedurechar10CHAR(N' ')YesPRVFN Allow NULL? 
50PKANZNumber of Price Componentschar10NUMC(N'0')YesPKANZ Allow NULL? 
51PSANZNumber of Costing Itemsnvarchar50NUMC(N'00000')Yes*CK_PSANZ Allow NULL? 
52KNNZ1Cost Estimate Created with Excelchar10CHAR(N' ')YesKK_KZEXL Allow NULL? 
53KNNZ2Indicator - Postprocessing of product cost estimatechar10CHAR(N' ')YesKK_KZEZN Allow NULL? 
54KNNZ3Unit Costing Indicatorchar10CHAR(N' ')YesKZCHN Allow NULL? 
55KNNZ4Unit Costing Indicatorchar10CHAR(N' ')YesKZCHN Allow NULL? 
56KNNZ5Unit Costing Indicatorchar10CHAR(N' ')YesKZCHN Allow NULL? 
57ME_SUMM1Unit of Measure for Quantity Totalnvarchar30UNIT(N' ')YesT006CK_MESUMM Allow NULL? 
58SUMM1_KPFQuantities total for item category Sdecimal153QUAN((0))YesSUMME_MNG
59SUMM2_KPFCapital Spending Total for Item Category Sdecimal152CURR((0))YesSUMME_INV
60SUMM3_KPFTotal of two or more itemsdecimal152CURR((0))YesSUMME_POS
61EXTNRBase Planning Object (External Number)nvarchar180CHAR(N' ')YesCKBSEXTNR Allow NULL? 
62KOSTLCost Centernvarchar100CHAR(N' ')Yes*KOSTL Allow NULL? 
63AUFNROrder Numbernvarchar120CHAR(N' ')YesAUFKAUFNR Allow NULL? 
64KSTARCost Elementnvarchar100CHAR(N' ')Yes*KSTAR Allow NULL? 
65HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40CHAR(N' ')Yes*HRKFT Allow NULL? 
66KALSMCosting Sheetnvarchar60CHAR(N' ')Yes*AUFKALSM Allow NULL? 
67ZSCHLOverhead keynvarchar60CHAR(N' ')YesAUFZSCHL Allow NULL? 
68TEMPLATETemplatenvarchar100CHAR(N' ')Yes*ABC_TEMPL Allow NULL? 
69OBJNRObject numbernvarchar220CHAR(N' ')YesONR00J_OBJNR Allow NULL? 
70TWGESTotal Value in Item Foreign Currencydecimal152CURR((0))YesTWGES
71TKURSTExchange Rate Type for Item Foreign Currencynvarchar40CHAR(N' ')YesTCURVTKURST Allow NULL? 
72TWAERItem Foreign Currencynvarchar50CUKY(N' ')YesTCURCKKTWAER Allow NULL? 
73KKBWVARValuation Variant in Costingnvarchar30CHAR(N' ')YesTCK05KK_BWVAR Allow NULL? 
74KKSAPRLRelease the document as it was last savednvarchar40CHAR(N' ')YesKK_SAPRL Allow NULL? 
75TKURSExchange Rate for Item Foreign Currencydecimal95DEC((0))YesTKURS
76KZROHMaterial Componentchar10CHAR(N' ')YesCK_KZROH Allow NULL? 
77FILEPATHDescriptionnvarchar660CHAR(N' ')YesKK_PATH Allow NULL? 
78FILENAMEFile or Macro Name for Communication with MS Excelnvarchar120CHAR(N' ')YesKKXL_NAME Allow NULL? 
79CKCMCosting Modelnvarchar100CHAR(N' ')YesCKCMCK_COSTMODEL Allow NULL? 
80CKCMVCosting Model: Model Instancenvarchar150NUMC(N'000000000000000')YesCKCMVCKI_MODELINSTANCE Allow NULL? 
81MAXCIDPCP: Highest Component ID Already Assignednvarchar70NUMC(N'0000000')YesCK_MAX_COMPONENT_ID Allow NULL? 
82INTHIERPCP: Cost Estimate Contains Internal Hierarchychar10CHAR(N' ')YesCK_INT_HIERARCHY Allow NULL? 
83LOG_HANDLEApplication Log: Log Handlenvarchar220CHAR(N' ')YesBALLOGHNDL Allow NULL? 
NamePrimaryUniqueTypeColumns
CKHS~0YesYesCLUSTEREDKKZMA, 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