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  | TCK03
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
4OIVL77Whse Journal
5OVPM154Outgoing Payments
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.0TCK03441Costing VariantsProduct Cost Planning
SQL:  selectupdate insert create

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

SELECT MANDT, KLVAR, KALKA, BWVAR, STGER, STGEI, ELEHK, ELEVV, ELEPK, ELEAB, ELESK, ELESM, NUMKR, ORGEB, ONLUP, MANER, KPROF, KOAKNZ, WAEKNZ, SCHKZ, AUFKZ, FEHLST, PARTNER, EINZELS, ZUSDS, UEBID, VORAEND, LOSDR, SPEISCH, SPEIKOA, SPEIEIN, SPEIFEP, SPEIVAE, BZOBJ, UMMANKO, TERID, KALVAR, KALVAR_KMAT, REFID, UERBERNAHME_ERR, UEBERNAHME_ASL, PRFCTR_CALC, KLVAR_NETZPKOSVO, KLVAR_NETZPKOMP FROM TCK03
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2KLVARCosting Variantnvarchar40CHAR(N' ')NoCK_KLVAR Allow NULL? 
3KALKACosting Typenvarchar20CHAR(N' ')NoTCK01CK_KALKA Allow NULL? 
4BWVARValuation Variant in Costingnvarchar30CHAR(N' ')NoTCK05CK_BWVAR Allow NULL? 
5STGERReservedchar10CHAR(N' ')NoCK_STGER Allow NULL? 
6STGEIReservedchar10CHAR(N' ')NoCK_STGEI Allow NULL? 
7ELEHKReserve Field for Cost Component Structurenvarchar20CHAR(N' ')NoTCKH4CK_ELERES2 Allow NULL? 
8ELEVVReserve Field for Cost Component Structurenvarchar20CHAR(N' ')NoTCKH4CK_ELERES2 Allow NULL? 
9ELEPKReserve Field for Cost Component Structurenvarchar20CHAR(N' ')NoTCKH4CK_ELERES2 Allow NULL? 
10ELEABReserve Field for Cost Component Structurenvarchar20CHAR(N' ')No*CK_ELERES2 Allow NULL? 
11ELESKReserve Field for Cost Component Structurenvarchar20CHAR(N' ')No*CK_ELERES2 Allow NULL? 
12ELESMReserve Field for Cost Component Structurenvarchar20CHAR(N' ')No*CK_ELERES2 Allow NULL? 
13NUMKRNumber rangenvarchar20CHAR(N' ')NoNUMKR Allow NULL? 
14ORGEBOrganizational Level for Costing Variantchar10CHAR(N' ')NoCK_ORGANI Allow NULL? 
15ONLUPUpdate Allowedchar10CHAR(N' ')NoCK_ONLUPD Allow NULL? 
16MANERInclude Additive Costschar10CHAR(N' ')NoMANER Allow NULL? 
17KPROFCosting profilenvarchar40CHAR(N' ')NoKPROF Allow NULL? 
18KOAKNZUsage Indicator for Cost Element in Unit Costingchar10CHAR(N' ')NoKK_KOAKNZ Allow NULL? 
19WAEKNZUsage Indicator for Currencieschar10NUMC(N'0')NoKK_WAEKNZ Allow NULL? 
20SCHKZTable Entry Protected Against Changeschar10CHAR(N' ')NoCK_SCHUETZ Allow NULL? 
21AUFKZQuantity Structure Control in Costingnvarchar40CHAR(N' ')NoTCK19ACK_AUFKZ Allow NULL? 
22FEHLSTParameters for Error Managementchar10NUMC(N'0')NoCK_FEHLST Allow NULL? 
23PARTNERIndicator for Partner Determination During Costingchar10CHAR(N' ')NoCK_PARTNER Allow NULL? 
24EINZELSIgnore Product Cost Estimate Without Quantity Structurechar10CHAR(N' ')NoCK_EINZELS Allow NULL? 
25ZUSDSDisplay of Overhead in Unit Costingchar10NUMC(N'0')NoCK_ZUSDS Allow NULL? 
26UEBIDTransfer Controlnvarchar40CHAR(N' ')NoTCK24CK_UEBID Allow NULL? 
27VORAENDDefaults Can Be Changedchar10CHAR(N' ')NoCK_VORAEND Allow NULL? 
28LOSDRPass On Lot Sizechar10CHAR(N' ')NoCK_LOSDR Allow NULL? 
29SPEISCHDefault for Saving the Cost Component Splitchar10CHAR(N' ')NoCK_SPEISCH Allow NULL? 
30SPEIKOADefault for Saving the Cost Element Itemizationchar10CHAR(N' ')NoCK_SPEIKOA Allow NULL? 
31SPEIEINDefault for Saving the Itemizationchar10CHAR(N' ')NoCK_SPEIEIN Allow NULL? 
32SPEIFEPDefault for Saving the Error Logchar10CHAR(N' ')NoCK_SPEIFEP Allow NULL? 
33SPEIVAEDefault Values for Saving Can Be Changed by Userchar10CHAR(N' ')NoCK_SPEIVAE Allow NULL? 
34BZOBJReference Objectchar10CHAR(N' ')NoTCK22CK_OBJ Allow NULL? 
35UMMANKOInclude Additive Costs with Stock Transferschar10CHAR(N' ')NoCK_UMMANKO Allow NULL? 
36TERIDDate Controlnvarchar40CHAR(N' ')YesTCK16CK_TERID Allow NULL? 
37KALVARCosting Variant for Postprocessing with Unit Costingnvarchar40CHAR(N' ')YesTCK03CK_KALVAR Allow NULL? 
38KALVAR_KMATCost Estimate Without Dialog for Configurable Materialsnvarchar40CHAR(N' ')YesTCK03CK_KALVAR_NETZ Allow NULL? 
39REFIDReference Variantnvarchar20NUMC(N'00')YesTCK31CK_REFID Allow NULL? 
40UERBERNAHME_ERRTransfer Active Std Cost Est. if Material Costed with Errorschar10CHAR(N' ')YesCK_UERBERNAHME_ERR Allow NULL? 
41UEBERNAHME_ASLTransfer Cost Estimate of an Order BOMchar10CHAR(N' ')YesCK_UEBERNAHME_ASL Allow NULL? 
42PRFCTR_CALCCost Beyond Profit Center Boundarieschar10CHAR(N' ')YesCK_PRFCTR_CALC Allow NULL? 
43KLVAR_NETZPKOSVOCosting Variant for General Costs Activitynvarchar40CHAR(N' ')YesTCK03CK_KLVAR_NETZPL_KOSTVORG Allow NULL? 
44KLVAR_NETZPKOMPCosting Variant for Network Componentnvarchar40CHAR(N' ')YesTCK03CK_KLVAR_NETZPLKOMP Allow NULL? 
NamePrimaryUniqueTypeColumns
TCK03~0YesYesCLUSTEREDKLVAR, 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