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  | TB2BE
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
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
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
10OINM101Whse Journal
Logistics - General
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0TB2BE811Trading Contract: Trading Contract TypeLogistics - General
SQL:  selectupdate insert create

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

SELECT MANDT, TCTYP, TDTPV, TDTPC, STATGR, TXTGR, INCPO, DEFWAERS, DEFKURST, NUMKI, TCUNCGR, TCSACHV, GBATCH, TCTDID, WCHUN, WCHQU, LIVAR, KAPPL_NA, KALSMK_MGT, KALSMP_MGT, TC_URL, USE_CASE, TCCAT, TKONN_EX_ACT, TKONN_EX_CHECK, TC_CHANGE_CHECK, POFOST, BTBSTA_DEF_INCO, BTBSTA_DEF, FOL_DOC_DIR, TC_TYPE_BLOCK, PZUGR, TCGROUP, DELIVDEF, PRICE_DEFAULT, PARGR, CLOSING_RULE, WB2_BEZOB, ASSO_OFF, PRCHGRP, BWREL, PRICING_TYPE, TCVARIANT, GTS_RELEVANT, EVENT_RELEVANT, LIGRU, PLANT_CONTROL, PURCHASE_PLANT, CONTEXT, TYPE_USAGE, REP_GROUP, AR_OBJECT, ITEM_HANDLING, CHANGE_DOC, DOCUMENT_INDEX, DOC_INDEX_DELETE, PARTNER_HI, BATCH_DET_ACT, TXZUF, SINGLE_ORG_DATA, CONSOL_CONTEXT, FREEZE_GROUP, CALL_OFF_PARTY, WRART, LFART_C, LFART_V, LFART, SET_VARIANT, GTS_CHECK, FLOW_DISPLAY, FLOW_SIZE, RELEASE_LOG, PURPOSE, ITEM_REL_TYPE, LOCK_FOL_DOCS, SETTL_PURPOSE, BATCH_CLASS, PPE_GROUP_CODE, DELIVDEF_TYPE, TRMRISK_CTRL, TIME_CONTROL FROM TB2BE
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2TCTYPTrading Contract: Trading Contract Typenvarchar40CHAR(N' ')NoTCTYP Allow NULL? 
3TDTPVTrading Contract: Purchasing Groupnvarchar40CHAR(N' ')YesTB2BCTDTPV Allow NULL? 
4TDTPCTrading Contract: Sales Groupnvarchar40CHAR(N' ')YesTB2BDTDTPC Allow NULL? 
5STATGRTrading Contract: Status Groupchar10CHAR(N' ')YesTB2BBSTATGR Allow NULL? 
6TXTGRText determination procedurenvarchar20CHAR(N' ')YesTTXGTXTGR Allow NULL? 
7INCPOIncrement of item number in the SD documentnvarchar60NUMC(N'000000')YesINCPO Allow NULL? 
8DEFWAERSTrading Contract: Default Currencynvarchar50CUKY(N' ')YesTCURCDEFWAERS Allow NULL? 
9DEFKURSTTrading Contract: Default Exchange Rate Typenvarchar40CHAR(N' ')YesTCURVDEFKURST Allow NULL? 
10NUMKINumber range in the case of internal number assignmentnvarchar20CHAR(N' ')YesNUMKI Allow NULL? 
11TCUNCGRTrading Contract: Incompleteness Groupnvarchar20CHAR(N' ')YesTB2BGTCUNCGR Allow NULL? 
12TCSACHVTrading Contract: Suggest Person Responsiblechar10CHAR(N' ')YesTCSACHV Allow NULL? 
13GBATCHTrading Contract: Automatic Generation of Batcheschar10CHAR(N' ')YesGBATCH Allow NULL? 
14TCTDIDTrading Contract: Default Text Type for Main Screennvarchar40CHAR(N' ')YesTTXIDTCTDID Allow NULL? 
15WCHUNTrad. Contr.: Check Completeness Bef. Setting to Activechar10CHAR(N' ')YesWCHUN Allow NULL? 
16WCHQUTrad. Contr.: Check Quantities Before Setting to Activechar10CHAR(N' ')YesWCHQU Allow NULL? 
17LIVARList variant for sales price calculationnvarchar20CHAR(N' ')YesTWSTLIVAR Allow NULL? 
18KAPPL_NAApplication for output conditionsnvarchar20CHAR(N' ')YesT681ANA_KAPPL Allow NULL? 
19KALSMK_MGTTrading Contract: Message Schema for Messages for Employeenvarchar60CHAR(N' ')YesT683KALSMB_MGT Allow NULL? 
20KALSMP_MGTTrad.Contr: Message Schema f. Empl., Messages at Item Levelnvarchar60CHAR(N' ')YesT683KALSMBP_MGT Allow NULL? 
21TC_URLTrading Contract URLnvarchar1320CHAR(N' ')YesTC_URL Allow NULL? 
22USE_CASEUse Case Typenvarchar20CHAR(N' ')YesWB2_USE_CASE_TYPE Allow NULL? 
23TCCATTrading Contract: Contract Categorychar10CHAR(N' ')YesTCCAT Allow NULL? 
24TKONN_EX_ACTTrading Contract: External Number Activechar10CHAR(N' ')YesTKONN_EX_ACT Allow NULL? 
25TKONN_EX_CHECKTrading Contract: Check External Numberchar10CHAR(N' ')YesTKONN_EX_CHECK Allow NULL? 
26TC_CHANGE_CHECKTrading Contract: Schema for Fields to be Checkednvarchar100CHAR(N' ')YesTB2BVTC_CHANGE_CHECK Allow NULL? 
27POFOSTPortfolio: Control Type for Portfolio Determinationnvarchar40CHAR(N' ')YesTPOSTWB2_CONTR_GROUP Allow NULL? 
28BTBSTA_DEF_INCOTrading Contract: Default Application Status Incompletechar10CHAR(N' ')YesTB2BFBTBSTA_DEF_INCO Allow NULL? 
29BTBSTA_DEFTrading Contract: Default Application statuschar10CHAR(N' ')YesTB2BFBTBSTA_DEF Allow NULL? 
30FOL_DOC_DIRTrading Contract: Create Follow-On Document When TC Postedchar10CHAR(N' ')YesWB2_FOLLOW_DOC_DIRECT Allow NULL? 
31TC_TYPE_BLOCKTrading Contract: Contract Type Blockchar10CHAR(N' ')YesWB2_TC_TYPE_BLOCK Allow NULL? 
32PZUGRResponsibility Groupnvarchar40CHAR(N' ')YesTPOFOBPZUGR Allow NULL? 
33TCGROUPTrading Contract Groupnvarchar40CHAR(N' ')YesTEWTCGROUPWB2_TCGROUP Allow NULL? 
34DELIVDEFTrading Contract: Default Delivery Datechar10CHAR(N' ')YesWB2_DELIVDATE_DEFAULT Allow NULL? 
35PRICE_DEFAULTTrading Contract: Price Proposalchar10CHAR(N' ')YesWB2_PRICE_DEFAULT Allow NULL? 
36PARGRPartner Determination Procedurenvarchar40CHAR(N' ')YesTVPGPARGR Allow NULL? 
37CLOSING_RULETrading Contract: Completion Rulechar10CHAR(N' ')YesWB2_CLOSING_RULE Allow NULL? 
38WB2_BEZOBReference Requiredchar10CHAR(N' ')YesWB2_BEZOB Allow NULL? 
39ASSO_OFFDeactivate Association for One Side in Trading Contractchar10CHAR(N' ')YesWB2_ASSO_OFF Allow NULL? 
40PRCHGRPPrice Change Groupnvarchar20CHAR(N' ')YesTB2BP4WB2_PRCHGRP Allow NULL? 
41BWRELTrading Contract Type: BW Relevancechar10CHAR(N' ')YesBWREL Allow NULL? 
42PRICING_TYPEDefinition of Pricing Procedure in Trading Contractchar10CHAR(N' ')YesWB2_PRICING_TYPE Allow NULL? 
43TCVARIANTTransaction variantnvarchar300CHAR(N' ')YesSHDTVCIUTCVARIANT Allow NULL? 
44GTS_RELEVANTTrading Contract Type Is Relevant for GTS Checkchar10CHAR(N' ')YesWB2_GTS_RELEVANT Allow NULL? 
45EVENT_RELEVANTTrading Contract: Control of Event Call-Upchar10CHAR(N' ')YesWB2_EVENT_RELEVANT Allow NULL? 
46LIGRUList groupchar10CHAR(N' ')YesLIGRU Allow NULL? 
47PLANT_CONTROLControl of Plant Entry in the Trading Contractchar10CHAR(N' ')YesWB2_PLANT_CONTROL Allow NULL? 
48PURCHASE_PLANTControl of Differing Ordering Plant in Trading Contractchar10CHAR(N' ')YesWB2_PURCHASE_PLANT Allow NULL? 
49CONTEXTContextnvarchar100CHAR(N' ')YesTWUF_CONTEXTWUF_CONTEXT Allow NULL? 
50TYPE_USAGEGTM: Usage of Trading Contract Typechar10CHAR(N' ')YesWB2_TYPE_USAGE Allow NULL? 
51REP_GROUPGTM: Replication Groupnvarchar40CHAR(N' ')YesTB2BS2WB2_REPLICATION_GROUP Allow NULL? 
52AR_OBJECTDocument typenvarchar100CHAR(N' ')YesTOADVSAEOBJART Allow NULL? 
53ITEM_HANDLINGControl of Item Number Allocation for Enterprise SOA Call-Upchar10CHAR(N' ')YesWB2_ITEM_HANDLING Allow NULL? 
54CHANGE_DOCGT: Scope of Change Documentchar10CHAR(N' ')YesWB2_CHANGE_DOC Allow NULL? 
55DOCUMENT_INDEXGT: Document Index Activechar10CHAR(N' ')YesWB2_DOCUMENT_INDEX_ACTIVE Allow NULL? 
56DOC_INDEX_DELETEGT: Delete Document Index When Document Is Closedchar10CHAR(N' ')YesWB2_DOC_INDEX_DEL_AFTER_CLOSE Allow NULL? 
57PARTNER_HIGT: Partner Hierarchy activechar10CHAR(N' ')YesWB2_PARTNER_HIERARCHY Allow NULL? 
58BATCH_DET_ACTBatch Determinationchar10CHAR(N' ')YesWB2B_BATCH_DETERMINATION Allow NULL? 
59TXZUFText Groupnvarchar40NUMC(N'0000')YesTXZUF_WB2WB2_TXZUF Allow NULL? 
60SINGLE_ORG_DATAControl of Organizational Datachar10CHAR(N' ')YesWB2_SINGLE_ORG_DATA Allow NULL? 
61CONSOL_CONTEXTContext for Trading Contract consolidationnvarchar100CHAR(N' ')YesTSMT_CONTEXTWB2_CONSOLIDATION_CONTEXT Allow NULL? 
62FREEZE_GROUPGroup of Frozen Fieldsnvarchar40NUMC(N'0000')YesWB2_C_FREEZE_HWB2_FREEZE_GROUP Allow NULL? 
63CALL_OFF_PARTYGT: Check Partner Authorizations for Contract Call Offchar10CHAR(N' ')YesWB2_CALL_OFF_PARTY Allow NULL? 
64WRARTAgency business: Payment typenvarchar40CHAR(N' ')YesTMZRWRART Allow NULL? 
65LFART_CDifferent Billing Type for Customer-Related Settlementnvarchar40CHAR(N' ')YesTMFKWB2_LFART_CUSTOMER Allow NULL? 
66LFART_VDifferent Billing Type for Vendor-Related Settlementnvarchar40CHAR(N' ')YesTMFKWB2_LFART_VENDOR Allow NULL? 
67LFARTDifferent Billing Type at Contract Settlementnvarchar40CHAR(N' ')YesTMFKWB2_LFART Allow NULL? 
68SET_VARIANTBusiness Process Variant for Contract Settlementchar10CHAR(N' ')YesWB2_WASHOUT_SET_VARIANT Allow NULL? 
69GTS_CHECKLegal Control Checkchar10CHAR(N' ')YesWB2_GTS_CHECK_AT_UPDATE Allow NULL? 
70FLOW_DISPLAYDocument Flow Control Indicatorchar10CHAR(N' ')YesWB2_FLOW_DISPLAY Allow NULL? 
71FLOW_SIZEMax Number of Flow Entries to Show in the Document Flow Treeint100INT4((0))YesWB2_FLOW_SIZE Allow NULL? 
72RELEASE_LOGHandling of Release Messageschar10CHAR(N' ')YesWB2_RELEASE_LOG Allow NULL? 
73PURPOSEPurpose of Trading Contractnvarchar20CHAR(N' ')YesWB2_TC_PURPOSE Allow NULL? 
74ITEM_REL_TYPEItem Rel. Determination Type Based on Portfolio Managementnvarchar40CHAR(N' ')YesIFW_C_RELEVANCYCIWB_DE_PM_TYPE Allow NULL? 
75LOCK_FOL_DOCSGT: Lock for Follow-on Documents of a Trading Contractchar10CHAR(N' ')YesWB2_LOCK_FOLLOW_ON_DOCS Allow NULL? 
76SETTL_PURPOSEGT: Settlement Purpose of a Trading Contractchar10CHAR(N' ')YesWB2_SETTLEMENT_PURPOSE Allow NULL? 
77BATCH_CLASSBatch Classification is enabledchar10CHAR(N' ')YesWB2_BATCH_CLASS_ENABLED Allow NULL? 
78PPE_GROUP_CODEGroupnvarchar40CHAR(N' ')YesPPE_C_GROUPPPE_GROUP Allow NULL? 
79DELIVDEF_TYPETrading Contract: Default Delivery Date Typechar10CHAR(N' ')YesWB2_DELIVDATE_TYPE_DEFAULT Allow NULL? 
80TRMRISK_CTRLTRM Raw Exposure Update Controlchar10CHAR(N' ')YesWB2_TRM_RISK_UPD_CONTROL Allow NULL? 
81TIME_CONTROLGT: Setting of date and timechar10CHAR(N' ')YesWB2_TIME_CONTROL Allow NULL? 
NamePrimaryUniqueTypeColumns
TB2BE~0YesYesCLUSTEREDTCTYP, 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