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  | T000K
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
9BSEG345Accounting Document Segment
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

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

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
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data
Financial Accounting :: Consolidation :: Basic Functions
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0T000K501GroupBasic Functions
SQL:  selectupdate insert create

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

SELECT MANDT, GTEXT, GCURR, GSBK, GBSNO, GSNK, PCK, PERIV, INDLC, INDMC, INDRFKONS, INDAD, INDAR, INDAE, INDAS, INDPR, INDPE, RLDNR_RU, RLDNR_LC, RLDNR_GC, RLDNR_PC, IND_LD_ONE, MVCT_SFLD, MVCT_ACSET, ADD1_SFLD, ADD1_ACSET, ADD2_SFLD, ADD2_ACSET, ADD3_SFLD, ADD3_ACSET, GSB_COBLCK, ROLLUP_1, ROLLUP_2, ROLLUP_3, DTF_RU, RLDNR_RU_1, RLDNR_RU_2, RLDNR_RU_3, INDDP_1, INDRU_1, INDDP_2, INDRU_2, MAIL_DP, INDPE_1, INDPE_2, INDBA_CS, INDCO_CS, GSNK_RF, INDLS_1, INDLS_2 FROM T000K
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2GTEXTGroup namenvarchar300CHAR(N' ')YesGROUPTXT Allow NULL? 
3GCURRCurrency Key for the Group Currencynvarchar50CUKY(N' ')YesTCURCKZWRS Allow NULL? 
4GSBKBusiness area consolidation activechar10CHAR(N' ')YesGSBK Allow NULL? 
5GBSNOActivate: online zero balnce for business areaschar10CHAR(N' ')YesGBSNO Allow NULL? 
6GSNKCompany consolidation activatedchar10CHAR(N' ')YesGSNK Allow NULL? 
7PCKProfit center consolidation activatedchar10CHAR(N' ')YesPCK Allow NULL? 
8PERIVFiscal year variant for consolidationnvarchar20CHAR(N' ')YesT009PERIV_LC Allow NULL? 
9INDLCIndicator: Consolidation system LCchar10CHAR(N' ')YesINDLC Allow NULL? 
10INDMCEC-CS Consolidation Systemchar10CHAR(N' ')YesINDMC Allow NULL? 
11INDRFKONSIndicator: Consolidation system RF-KONSchar10CHAR(N' ')YesINDRFKONS Allow NULL? 
12INDADActual - realtime updatechar10CHAR(N' ')YesLC_INDAD Allow NULL? 
13INDARActual rollup indicatorchar10CHAR(N' ')YesLC_INDAR Allow NULL? 
14INDAEIndicator: FI extract of actual datachar10CHAR(N' ')YesLC_INDAE Allow NULL? 
15INDASActual step consolidation indicatorchar10CHAR(N' ')YesLC_INDAS Allow NULL? 
16INDPRBudgeted Rollup indic'rchar10CHAR(N' ')YesLC_INDPR Allow NULL? 
17INDPEBudgeted FI-Extract indic'rchar10CHAR(N' ')YesLC_INDPE Allow NULL? 
18RLDNR_RURollup ledger for consolidationnvarchar20CHAR(N' ')YesT881RLDNR_RU Allow NULL? 
19RLDNR_LCConsolidation ledgernvarchar20CHAR(N' ')YesT881RLDNR_LC Allow NULL? 
20RLDNR_GCLedger for business area consolidationnvarchar20CHAR(N' ')YesT881RLDNR_BC Allow NULL? 
21RLDNR_PCLedger for Profit Center Consolidationnvarchar20CHAR(N' ')YesT881FC_LD_PC Allow NULL? 
22IND_LD_ONEIndicator: Update specified ledger onlychar10CHAR(N' ')YesLC_LD_ONE Allow NULL? 
23MVCT_SFLDSender field for FI -> FI-LC interfacechar10CHAR(N' ')YesLC_SFIELD Allow NULL? 
24MVCT_ACSETItem selection for the FI -> FI-LC interfacenvarchar120CHAR(N' ')YesLC_ACCSET Allow NULL? 
25ADD1_SFLDSender field for FI -> FI-LC interfacechar10CHAR(N' ')YesLC_SFIELD Allow NULL? 
26ADD1_ACSETItem selection for the FI -> FI-LC interfacenvarchar120CHAR(N' ')YesLC_ACCSET Allow NULL? 
27ADD2_SFLDSender field for FI -> FI-LC interfacechar10CHAR(N' ')YesLC_SFIELD Allow NULL? 
28ADD2_ACSETItem selection for the FI -> FI-LC interfacenvarchar120CHAR(N' ')YesLC_ACCSET Allow NULL? 
29ADD3_SFLDSender field for FI -> FI-LC interfacechar10CHAR(N' ')YesLC_SFIELD Allow NULL? 
30ADD3_ACSETItem selection for the FI -> FI-LC interfacenvarchar120CHAR(N' ')YesLC_ACCSET Allow NULL? 
31GSB_COBLCKCheck if company code/business area is active in doc.char10CHAR(N' ')YesFC_GBCOBL Allow NULL? 
32ROLLUP_1Rollup for Company Consolidationnvarchar80CHAR(N' ')YesT807HFC_ROLLUP1 Allow NULL? 
33ROLLUP_2Rollup for Business Area Consolidationnvarchar80CHAR(N' ')YesT807HFC_ROLLUP2 Allow NULL? 
34ROLLUP_3Rollup for Profit Center Consolidationnvarchar80CHAR(N' ')YesT807HFC_ROLLUP3 Allow NULL? 
35DTF_RUData transfer procedure for rollupschar10NUMC(N'0')YesFC_DTF_RU Allow NULL? 
36RLDNR_RU_1Sender Ledger for Rollup to Company Consolidationnvarchar20CHAR(N' ')YesT881FC_RLDNR1 Allow NULL? 
37RLDNR_RU_2Sender Ledger for Rollup to Business Area Consolidationnvarchar20CHAR(N' ')YesT881FC_RLDNR2 Allow NULL? 
38RLDNR_RU_3Sender Ledger for Rollup to Profit Center Consolidationnvarchar20CHAR(N' ')YesT881FC_RLDNR3 Allow NULL? 
39INDDP_1Realtime Update is Data Transfer Method for Company Cons.char10CHAR(N' ')YesFC_INDDP1 Allow NULL? 
40INDRU_1Transfer Method for Company Cons is Rollupchar10CHAR(N' ')YesFC_INDRU1 Allow NULL? 
41INDDP_2Realtime Update is Data Transfer Method for Bus.Area Cons.char10CHAR(N' ')YesFC_INDDP2 Allow NULL? 
42INDRU_2Transfer Method for Business Area Cons is Rollupchar10CHAR(N' ')YesFC_INDRU2 Allow NULL? 
43MAIL_DPRealtime Update: Send Express Mail with Error Listchar10CHAR(N' ')YesFC_MAILDP Allow NULL? 
44INDPE_1Periodic Extract is Data Transfer Method for Company Cons.char10CHAR(N' ')YesFC_INDPE1 Allow NULL? 
45INDPE_2Transfer Method for Business Area Cons is Periodic Extractchar10CHAR(N' ')YesFC_INDPE2 Allow NULL? 
46INDBA_CSBusiness area consolidation activechar10CHAR(N' ')YesGSBK Allow NULL? 
47INDCO_CSCompany consolidation activatedchar10CHAR(N' ')YesGSNK Allow NULL? 
48GSNK_RFCompany consolidation activatedchar10CHAR(N' ')YesGSNK Allow NULL? 
49INDLS_1Ledger Selection is Active for Company Consolidationchar10CHAR(N' ')YesFC_INDLS1 Allow NULL? 
50INDLS_2Ledger Selection is Active for Business Area Consolidationchar10CHAR(N' ')YesFC_INDLS2 Allow NULL? 
NamePrimaryUniqueTypeColumns
T000K~0YesYesCLUSTEREDMANDT

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