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  | TCK01
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.0TCK01251Costing TypesProduct Cost Planning
SQL:  selectupdate insert create

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

SELECT MANDT, KALKA, BZOBJ, UPDTM, UPDTO, UPDTV, UPDTC, DTKEY, VSNEX, VSNIN, ANWER, ANWEI, BVKEY, PRVFN, TERID, DMKEY, SCHKZ, GKSICHT, KDFSCHD, KDFRZUS, PART_VRSN, VALUATION, KOKRS_ALL_CALC, DEF_PRICELABEL, DEF_PRICE_VIEW FROM TCK01
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2KALKACosting Typenvarchar20CHAR(N' ')NoCK_KALKA Allow NULL? 
3BZOBJReference Objectchar10CHAR(N' ')NoTCK22CK_OBJ Allow NULL? 
4UPDTMUpdate Materialchar10CHAR(N' ')NoCK_UPDTM Allow NULL? 
5UPDTOUpdate Orderchar10CHAR(N' ')NoCK_UPDTO Allow NULL? 
6UPDTVUpdate Sales Order/Quotationchar10CHAR(N' ')NoCK_UPDTV Allow NULL? 
7UPDTCUpdate to Cost Center/Activity Typechar10CHAR(N' ')NoCK_UPDTC Allow NULL? 
8DTKEYAdd Date to Costing Keychar10CHAR(N' ')NoCK_DTKEY Allow NULL? 
9VSNEXExternal Number Assignment for Costing Versionschar10CHAR(N' ')NoCK_VSNEX Allow NULL? 
10VSNINUse Costing Type for Product Cost Collectorschar10CHAR(N' ')NoCK_VSNIN Allow NULL? 
11ANWERApplication: Product Costingchar10CHAR(N' ')NoCK_ANWER Allow NULL? 
12ANWEIApplication: Unit Costingchar10CHAR(N' ')NoCK_ANWEI Allow NULL? 
13BVKEYInclude Valuation Variant in Keychar10CHAR(N' ')NoCK_BVKEY Allow NULL? 
14PRVFNPricing procedurechar10CHAR(N' ')NoPRVFN Allow NULL? 
15TERIDDate Controlnvarchar40CHAR(N' ')NoTCK16CK_TERID Allow NULL? 
16DMKEYInclude Date in Key of Additive Cost Estimatechar10CHAR(N' ')NoCK_DMKEY Allow NULL? 
17SCHKZTable Entry Protected Against Changeschar10CHAR(N' ')NoCK_SCHUETZ Allow NULL? 
18GKSICHTView on Itemization for Overheadnvarchar20NUMC(N'00')NoTCKH8CK_GKSICHT Allow NULL? 
19KDFSCHDPass On Costing Sheetchar10CHAR(N' ')NoCK_KDFSCHD Allow NULL? 
20KDFRZUSOverhead Only for Raw Materials Assigned to Sales Orderchar10CHAR(N' ')NoCK_KDFRZUS Allow NULL? 
21PART_VRSNPartner Versionnvarchar20NUMC(N'00')YesTCK29CK_PARVRSN Allow NULL? 
22VALUATIONValuation Viewchar10NUMC(N'0')NoVALUTYP Allow NULL? 
23KOKRS_ALL_CALCCosting Across Controlling Areaschar10CHAR(N' ')YesCK_KOKRS_ALL_EMBRACING Allow NULL? 
24DEF_PRICELABELPrice Typenvarchar30CHAR(N' ')YesCK_DEFAULT_PRICELABEL Allow NULL? 
25DEF_PRICE_VIEWDefault View for Price Update in Price Tablenvarchar20NUMC(N'00')YesTCKH8CK_DEFAULT_PLABEL_VIEW Allow NULL? 
NamePrimaryUniqueTypeColumns
TCK01~0YesYesCLUSTEREDKALKA, 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