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

42 columns | Print definition?ERP 6.0  | INVISIBLE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SLOAP/SELOPT_GCNV AS Select Option Groups13INVISIBLESingle-Character Indicatornvarchar10
2/SLOAP/SELOPT_GTtransport table for /SLOAS/SELOPT_G15INVISIBLESingle-Character Indicatornvarchar10
3NWS_EXT_TXTOBJAdmissible Text Objects per Data Object14INVISIBLEInvisible Textsnvarchar10
TOPAdditional Material Functions
4WSDT_MAT_LAYOUTCustomizing for Material Creation5INVISIBLEInvisible Field in Material Creationnvarchar10
TOPCentral Part of Product Master
5COMS_EN_TYPE_UIControl Table (Field Status) Dependent on Extension Type6INVISIBLESingle-Character Indicatornvarchar10
TOPContract Accounts Receivable and Payable
6FMRC01_FICAResults List Comparison of FM/FI (FI-CA Documents)22INVISIBLEThe field is invisiblenvarchar10
TOPControlling
7QISRCHAR_EVALHLPCharacteristics: Fields for Extended Search Help7INVISIBLENot Visible on Output Listnvarchar10
TOPCross-Application Components
8TASUVSVOASU: Variants: transparent saved object information11INVISIBLECHAR01 data element for SYSTnvarchar10
9ZGADGETS_CONFIGGadgets Page Configuration for NWBC11INVISIBLEGadget is invisiblenvarchar10
10ZGADGETS_USERSUsers gadget speciffic entries28INVISIBLESingle-Character Indicatornvarchar10
11ZGAD_CONFIG_CUSTGadgets Page Configuration for NWBC12INVISIBLEGadget is invisiblenvarchar10
TOPData Staging
12RS3RDFLDNEWVariable Fields of Third Party Source System - New9INVISIBLESingle-Character Indicatornvarchar10
13RSISInfoSource (transaction data)12INVISIBLEBooleannvarchar10
14RSISNInfoSource - Header Table14INVISIBLEBooleannvarchar10
15RSISOSMAPMapping Between InfoSources and OLTP Sources13INVISIBLEBooleannvarchar10
TOPFunds Management
16FMRC07Results List Documents Bank/Clearing Account Matching FM-FI12INVISIBLECheckboxnvarchar10
17FMRC07_WO_BUNDLEResults List Documents Bank/Clearing Account Matching FM-FI12INVISIBLECheckboxnvarchar10
TOPIntegrated Product and Process Engineering
18PPEFILTOBJObjects in GUI12INVISIBLEVisibility of an Object in Navigation/Assignment Treenvarchar10
TOPIntegration Customer Relationship Management
19ESALES_PSFIELDSField Properties for Set Type Attributes for each Product7INVISIBLEInvisible displaynvarchar10
TOPLaunchpad
20APB_ISR_CUST_F4LInput and Output Fields for Input Help8INVISIBLEInvisible on Output Listnvarchar10
TOPLogical DB, Selection Screens, Selection Variants
21VARIDESCSelection Variants: Description14INVISIBLESelection variants: Invisible flagnvarchar10
22VARIDESCCISelection Variants: Description (Cross-Client)13INVISIBLESelection variants: Invisible flagnvarchar10
TOPOLAP Technology
23RSRVARIANTVariant Values6INVISIBLEBooleannvarchar10
TOPOrganization and Planning
24T77GMSGCGeneric Role Manager: Definition of a Structure Group5INVISIBLEGeneric Role Manager: Do Not Display Structurenvarchar10
TOPOrganizational Management
25T77OMATTUSGeneral Attribute Maintenance: Attributes per Scenario7INVISIBLEGeneral Attribute Maintenance: Attribute Invisiblenvarchar10
TOPPatient Management
26NWVIEW_FCDFunction Bar: Function Code Data9INVISIBLEnvarchar10
TOPPersonnel Administration
27T599XField Control for Report Categories7INVISIBLEOutput invisiblenvarchar10
TOPPersonnel Time Management
28T588NScreen Modification for Account Assignment Block9INVISIBLEThe field is invisiblenvarchar10
TOPProduct Configurator
29COMM_CFGCLFACFacets for Characteristics of Classes9INVISIBLEFlagnvarchar10
TOPProduction and Revenue Accounting
30OIUCM_TAB_MAINTCPRA Generic Table Maintenance - Non Key Field Control Tab5INVISIBLEPRA Generic Table Maintenance - Invisible Flagnvarchar10
TOPRegulatory reporting for insurance companies
31TISSR_TP_C_DYNFISSR: Tabelle zur Feldaussteuerung DSUMB8INVISIBLEISSR: Feld zur Aussteuerg.Sichtbarkeit von Dynprofeldernnvarchar10
32TISSR_TP_C_DYNFSISSR: Feldsteuerung Selektionsbildschirme DSUMB8INVISIBLEISSR: Feld zur Aussteuerg.Sichtbarkeit von Dynprofeldernnvarchar10
TOPRemaining Beverage - Obsolete Objects
33/BEV3/CHBFLDSTATAgreements Field Status9INVISIBLEInvisiblenvarchar10
34/BEV3/CHWDFLDSTField Status of Contract Handling Document9INVISIBLEInvisiblenvarchar10
TOPSales and Distribution
35SCECHAVISCharacteristic of Class Hidden/Shown5INVISIBLEBoolean (T = true, F = false, blank = unknown)nvarchar10
TOPSAP Business Workflow
36SWDSSTEPSWF Definition: Steps44INVISIBLEWork Item Is Not Visible in Inboxnvarchar10
37SWD_STEPSWF-Definition/Runtime: Steps45INVISIBLEWork Item Is Not Visible in Inboxnvarchar10
TOPTransaction Variant and Table Control Settings
38SHDGHeidelberg: Global field pre-assignments6INVISIBLEFlag: Field invisiblenvarchar10
39SHDGVGlobal values7INVISIBLEFlag: Field invisiblenvarchar10
40SHDGVDEGlobal values: Values and flags for data elements4INVISIBLEFlag: Field invisiblenvarchar10
41SHDGVDOGlobal values: Values and flags for domains4INVISIBLEFlag: Field invisiblenvarchar10
TOPUser and Authorization Management
42TUGRPField Assignment for User Types8INVISIBLEStandard Screen Checknvarchar10