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

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

72 columns | Print definition?ERP 6.0  | BLOCK

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SMD/MD_____01BCSID-Tabelle fuer Bulk storage4BLOCKBulk storage indicatornvarchar20
2/SMERP/STG_MM004Data staging - Material warehouse view complex table215BLOCKBulk storage indicatornvarchar20
3DMC_PC_DEF_PARAMMWB: Pseudocode Parameter2BLOCKMWB: Pseudocode Blocktinyint30
4FIAPSAD_BL_EXPO0Customizing “Expenditure Orders Blocking” (1st level)4BLOCKBlock Expenditure Ordersnvarchar10
5GRRMFHLOGForecasting Horizons: change log5BLOCKFH block untilnvarchar80
6IUUC_RECON_F2FIUUC: Reconciliation Field to Field Comparison5BLOCKint100
7IUUC_RECON_F2F_RIUUC: Reconcilation Field-to-Field Result6BLOCKnvarchar100
8NWS_EXT_OBJData Transport Management Tool Data Objects21BLOCKSort Blocknvarchar20
9PA3319Infotype 331928BLOCKBlocked declarationnvarchar10
10SGT_MLGNSegmentation dependent Material Data for Each Warehouse no20BLOCKBulk storage indicatornvarchar20
11T5PPBS9CPortugal Public Sector - BDAP - Scenarys and Blocks6BLOCKInformation Blocknvarchar40
12TGSU0SAP Structural Graphics: Log Description1BLOCKIndicator for data blocknvarchar10
13ZSA_D_OBJxSA Objects18BLOCKSort Blocknvarchar20
TOPActual Update and Commitment Update
14GTRRULE_CONDAssignment Split IDs (Lines)--> Condition Block4BLOCKGTR Rule Condition Block Numbernvarchar30
15GTRRULE_COND_VAssignment Condition Block --> Condition Values3BLOCKGTR Rule Condition Block Numbernvarchar30
TOPAdvertising Management
16JJTWSINIS-M/AM: Assignment of Content Components to a BU6BLOCKIS-M: Commercial Clusternvarchar20
TOPAerospace Defence Industry Solution
17ADPMPRIOSUBCustomizing Priority ( Priority Level )20BLOCKCMC : Block Indicatornvarchar10
TOPAppraisal, Valuation, and Survey Tool
18HRHAP_TAB_DATAAppraisal: Layout Configuration Data16BLOCKBlock Configurationnvarchar10
TOPBasic Functions
19T807Rollup Sequence4BLOCKInd.: Sequence blockednvarchar10
20T881WPossible Combinations of Currency Keys in FI-SL4BLOCKCombination not allowednvarchar10
21VBUKSales Document: Header Status and Administrative Data71BLOCKIndicator: Document preselected for archivingnvarchar10
TOPBasis Application Log
22BALDATApplication Log: Log data4BLOCKApplication log: Internal message serial numbernvarchar60
TOPBudgeting and Availability Control
23GMBDGTVALIDITYGrant budget validity10BLOCKBlock a Budget Validity Periodnvarchar10
TOPBusiness Partner
24BPUMConversion: Tables/Fields to be Converted16BLOCKBlock Number Temporary Backupnvarchar100
TOPClientServer Technology
25D342LTable for long CUA objects9BLOCKimage21474836470
26D345TTable for Long GUI Objects (Texts)9BLOCKntext10737418230
27D346TTable for Long GUI Objects (Texts)8BLOCKntext10737418230
TOPClinical System
28N2DT_HTML_TMPLIS-H*MED: DocCateg. addition HTML template11BLOCKAlias for a Documentation Elementnvarchar120
29N2EXTLOADIS-H*MED: External programs4BLOCKimage21474836470
30N2PCDOCEXTENDEDIS-H*MED: Data that is processed at the frontend15BLOCKimage21474836470
31N2RADWLEXTIS-H*MED: Radiological Worklist for Optional Attributes11BLOCKntext10737418230
TOPCross-Application Components
32VVBUKSales Document: Header Status and Administrative Data71BLOCKIndicator: Document preselected for archivingnvarchar10
TOPExternal Services
33TMP_SPECModel Service Specifications4BLOCKUse of model service specifications blockednvarchar10
TOPFSCM In-House Cash
34IHC_DB_PNSource Document for Incoming Payment Orders7BLOCKItem Is Locked for Automatic Processingnvarchar10
35IHC_DB_PN_STATUSIHC: Payment Order Status16BLOCKItem Is Locked for Automatic Processingnvarchar10
TOPFunctions for U.S. Federal Government
36FMROLINEFM Recurring Obligations - schedule lines11BLOCKBlock schedule linenvarchar10
TOPInformation System
37GREPReport Writer: File of Stored Reports10BLOCKReport Writer: Block number in stored datanvarchar30
38GRIX_AUTReport Writer: Values of Adjustment-Related Characteristics9BLOCKReport Writer: Block number in stored datanvarchar30
TOPMaster Data
39GMGRVALUETYPEValue type settings for posting control5BLOCKBlocking Indicatornvarchar10
40GMSMVALUETYPEValue type control by grant type and status7BLOCKPosting Blocknvarchar10
41GMSMVALUETYPE_1Value type control by grant type and status6BLOCKPosting Blocknvarchar10
TOPMaterial Master
42MLGNMaterial Data for Each Warehouse Number19BLOCKBulk storage indicatornvarchar20
43MLGN_TMPFile for Incorrect Data in Direct Input22BLOCKBulk storage indicatornvarchar20
44MVGNMaterial Data for Each Warehouse Number19BLOCKBulk storage indicatornvarchar20
TOPOracle Database Monitors
45GVD_MANGD_STANBYcopy of GV$MANAGED_STANDBY (currently not provided w. snaps)12BLOCKOracle monitoring: Last processed archived redo log block Nrdecimal220
TOPOverhead Cost Controlling
46PFPARPeriod-End Partner: Processing Parameters12BLOCKNatural Numberint100
47PFSELPeriod-End Partner: Selection Criteria12BLOCKNatural Numberint100
TOPPension fund Netherlands
48T5NDIHR-NL: Eigenschappen van gebeurtenissen7BLOCKHR-NL: Gebeurtenis niet blokkerennvarchar10
TOPPerformance Monitors TCC
49GVD_LOCKCopy of GV$LOCK12BLOCKOracle monitoring: The lock is blocking another lockdecimal220
TOPProfitability Analysis
50TKECHACOBLChange of KOKRS/ERKRS Assignments: Block Administration4BLOCK5 Character Numeric NUMCnvarchar50
51TKECHACOPROTChange to the Assignment KOKRS - ERKRS: Logs3BLOCK5 Character Numeric NUMCnvarchar50
TOPRegulatory reporting for insurance companies
52TISSR_OUT_BLOCKISSR: Blockweise Listen4BLOCKBlock: zusammengehörige Felder in Listenvarchar20
53TISSR_OUT_BLOCKTISSR: Blockweise Listen Texte5BLOCKBlock: zusammengehörige Felder in Listenvarchar20
54TISSR_OUT_BLSPISSR: Blockweise Spalten4BLOCKBlock: zusammengehörige Felder in Listenvarchar20
55TISSR_OUT_BLSPTISSR: Blockweise Spalten Texte5BLOCKBlock: zusammengehörige Felder in Listenvarchar20
56TISSR_OUT_CTFIBLISSR: var. Plazierung der Felder mit Hilfe von Methoden4BLOCKBlock: zusammengehörige Felder in Listenvarchar20
57TISSR_OUT_FIBLISSR: Flexible Listausgabe: Zuweisung Feld/Block5BLOCKBlock: zusammengehörige Felder in Listenvarchar20
TOPReusable Components of Business Suite Foundation
58/BOFU/DTSTSORDHDSales Order Header15BLOCKTest Block Statusnvarchar20
TOPSales and Distribution SD enhancements
59MILL_VS_FIELDSVersion Management: Fields5BLOCKField content in dialog cannot be changed for versionsnvarchar10
60VSVBUK_CNSales Document: Header Status and Administrative Data72BLOCKIndicator: Document preselected for archivingnvarchar10
TOPService Station Retailing
61OIRC_DRREJSSR Stocks - Dip readings rejected records138BLOCKSSR Fuels - Indicator that identifies a blocking statusnvarchar10
62OIRC_DRREJ_ERRSSR Stocks - Dip readings rejected records - Error list6BLOCKSSR Fuels - Indicator that identifies a blocking statusnvarchar10
63OIRC_MRREJSSR Meters - Meter readings rejected records70BLOCKSSR Fuels - Indicator that identifies a blocking statusnvarchar10
64OIRC_MRREJ_ERRSSR Meters - MR rejected records - Error list (OBSOLETE)6BLOCKSSR Fuels - Indicator that identifies a blocking statusnvarchar10
65OIRC_STATUSSSR Fuels - Status2BLOCKSSR Fuels - Indicator that identifies a blocking statusnvarchar10
66OIRC_STATUS_USRSSR Fuels - Status (User checks)2BLOCKSSR Fuels - Indicator that identifies a blocking statusnvarchar10
TOPTask Resource Management
67LNODENode7BLOCKNode Blockednvarchar10
TOPTraders and Schedulers Workbench
68TOI0_JGFIS-OIL: Junction function group / Function assignment9BLOCKFunction customizing blocking indicatornvarchar10
TOPUI Services, Screen, Batch Input
69APQDDATA DEFINITION Queue3BLOCKMessage counter: Batch input, statisticsint100
TOPWarehouse Management
70T337BBulk Storage Sectioning6BLOCKBulk storage indicatornvarchar20
71T338Bulk Storage Indicators3BLOCKBulk storage indicatornvarchar20
72T338TTexts for Bulk Storage Indicators3BLOCKBulk storage indicatornvarchar20