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
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
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

65 columns | Print definition?ERP 6.0  | HEADER

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/GSINS/NLG_INBGBA Interface: Incoming Message Lines6HEADERGBA Interface: Message Header Flag(Only for Hf01)nvarchar10
2/GSINS/NLG_OUTBGBA Interface: Outgoing Message Lines7HEADERGBA Interface: Message Header Flag(Only for Hf01)nvarchar10
3/OPT/X005Approval COA Fields6HEADERnvarchar10
4/OPT/Y005Approval COA Fields6HEADERnvarchar10
5/OPT/Z005Approval COA Fields6HEADERnvarchar10
6/SAPPSSRM/SOSIndex-Table con. 'Governm. Proc.'-specific sources of supply3HEADERGUID of a CRM Order Objectvarbinary160
7BBPD_PD_INDEXIndex Table for Fast Access to Contracts and AVLs3HEADERGUID of a CRM Order Objectvarbinary160
8BBP_PDIAD_VBusiness transaction item9HEADERGUID of a CRM Order Objectvarbinary160
9BBP_SUS_NEWSSRM-SUS: News Management by Purchaser6HEADERText Headernvarchar1280
10CNVTDMSBW_ALLOBJAll Objects and their tables14HEADERHeader flagnvarchar10
11CNVTDMSSCR_GRPScrambling Groups6HEADERSingle-Character Indicatornvarchar10
12FUCNFICUIBBAppend Application-Specific Views4HEADERConfiguration Identificationnvarchar320
13SRMSOCO_DRFT_ITMDraft Items for FIORI SOCO249HEADERGlobally Unique identifiervarbinary160
14TCA15Lang.-dependent texts for TCA14: Object overview versions5HEADERObject-independent header line of an object overviewnvarchar780
15TGSU0SAP Structural Graphics: Log Description5HEADERHeader flagnvarchar10
TOPAccounting Engine
16/EACC/CONFIGS_PLConfigurations for Line Item Persistence7HEADERTable Namenvarchar300
TOPAuto-ID Backend Integration
17AIDEPCDTLObsolite: EPC Details3HEADEREPC Headernvarchar100
18AIN_TEPC_TYPEHeader and URI Format4HEADEREPC Headernvarchar80
TOPAuto-ID Infrastructure
19/AIN/TEPC_TYPEHeader and URI Format4HEADERID Headernvarchar80
TOPBasic Functions
20QSTRLST_CRITGroup.Criteria for List Config. for Ext.W/holding Tax Report8HEADERDisplay header?nvarchar10
TOPClaims Management
21TICL197Navigation Tree Note Dependent on PDOCCAT3HEADERFlag Whether Claim Item Grouping Is in Claim Headernvarchar10
TOPCompletion Confirmations
22TCMFULScreen Layout for Completion Confirmations13HEADERHeader Data Combination for Confirmation Screennvarchar20
TOPConfiguration Control
23CCMHOLEStructure Gap Table15HEADERCCM: Equipment Bill of Material Indicatornvarchar10
TOPConfiguration management
24TCM_DYNPPARTSCM: For each activity - Cumulation of current screen2HEADERCM: Indicatornvarchar10
TOPContract Billing
25TE443_TEXT_HTexts for Bill Correction Texts4HEADERText (30 Characters)nvarchar300
TOPDunning
26T047IStandard texts for dunning notices9HEADERSmart Forms: Name of Header Text in Text Processingnvarchar300
TOPE-Recruiting
27HRP5121DB Table for Infotype 512118HEADERJob Posting Title (Pointer)nvarchar60
28HRP5125DB Table for Infotype 512519HEADERRequisition Titlenvarchar800
29T77RCF_ACTION_PLAssignment of Activities to Processes6HEADEROTR Text Alias for Pushbutton for Activity Typenvarchar500
30T77RCF_CS_IDDefinition of Container Sequences (Standard)2HEADEROTR Alias for Titlenvarchar500
31T77RCF_CS_IDCDefinition of Container Sequences3HEADEROTR Alias for Titlenvarchar500
32T77RCF_SP_GROUPDefinition of Groups for Start Pages (Standard)2HEADEROTR Alias for Titlenvarchar500
33T77RCF_SP_GROUPCDefinition of Start Page Groups3HEADEROTR Alias for Titlenvarchar500
34T77RCF_SP_IDDefinition of Start Pages (Standard)2HEADEROTR Alias for Titlenvarchar500
35T77RCF_SP_IDCDefinition of Start Pages3HEADEROTR Alias for Titlenvarchar500
TOPEmployee Self-Service
36T7XSSSERHEBBasic Header Definition2HEADERKey for Header Configurationnvarchar400
37T7XSSSERHEBCXSS: Basic Header definition customer2HEADERKey for Header Configurationnvarchar400
38T7XSSSERHEBCTXSS: Basic Header definition text customer3HEADERKey for Header Configurationnvarchar400
39T7XSSSERHEBTBasic Header Definition Text3HEADERKey for Header Configurationnvarchar400
TOPEnvironment, Health and Safety
40T7EHS00_QTFIELDGText Fields for the General Questionnaire3HEADERQuestionnaire Headernvarchar400
41T7EHS00_QTFIELDSText Fields for Specific Questionnaire4HEADERQuestionnaire Headernvarchar400
TOPExchanges
42TOIAQExchange Statement Customising Assignments6HEADERHeader formatting routinenvarchar30
TOPFinancial Accounting
43/OPT/BL_T401Approval COA Fields6HEADERnvarchar10
44T001GCompany Code-Dependent Standard Texts10HEADERSmart Forms: Name of Header Text in Text Processingnvarchar300
TOPGeneral Application Functions
45CRMD_ORDERADM_IBusiness Transaction Item9HEADERGUID of a CRM Order Objectvarbinary160
TOPHandheld Connectivity
46/DSD/PR_RSAMMDSD Promotions - Promotion Result Amounts7HEADERDSD Deal Conditions - Header Result Flagnvarchar10
TOPIntegration of FPM and Persistency Frameworks like BOPF
47/BOFU/IPBI_POWLFPOWL: Field Definition5HEADERColumn Headernvarchar500
TOPMaintenance Orders
48/MRSS/D_DEM_ADMAdministrative Demand Item Data4HEADERGUIDvarbinary160
49/MRSS/D_DEM_HComplex Demand3HEADERGUIDvarbinary160
50/MRSS/D_DEM_RELRelationships Between Demand Items8HEADERGUIDvarbinary160
TOPMarketing, Accounting and Pricing
51OICRDTReport column description6HEADERHeader textnvarchar300
TOPOccupational Health
52T7EHS00_LIMFORMForm: Restrictions10HEADERHeadernvarchar300
53T7EHS00_RESQINFOHeader Information for Questionnaires7HEADERQuestionnaire Headernvarchar400
TOPPatient Management
54N1COMPIS-H: Clinical Order - Module Master Data4HEADERCORD/PREG: Header Component Indicatornvarchar10
TOPPersonal Object Worklist
55POWL_SELCRIT_CCust table for powl selcrit18HEADERnvarchar300
TOPProduct Safety
56ESTDFAdditional Information - User-Defined Text21HEADERStart of User-Defined Textnvarchar1320
TOPProduction Orders
57COCF_SR_SNGRPVTDescription of Shift Note Group6HEADERHeading for Shift Note Groupnvarchar500
TOPRepository Browser
58RSEUMODSettings for ABAP Workbench127HEADERGeneral Indicatornvarchar10
TOPReuse Services for Country Development
59T50F0HR-FORMS: Assignment of Standard Texts to Forms9HEADERHR-FORMS: Standard text for headernvarchar300
TOPSAP Media
60J_1SPTAXREPIS-M/SD-CH: Settings for Postal Charge Reporting6HEADERCharacter Length 25nvarchar250
TOPScreen Painter
61SCRP_UTIL_TODTExisting Checks for Screens7HEADERSingle-Character Indicatornvarchar10
TOPService Station Retailing
62OIRECHSETTFMTTReport column description5HEADERSSR PC: Header text for settlement reportnvarchar300
63OIRESETTDOCFMTTSettlement Document Report column description5HEADERSSR PC: Header text for settlement reportnvarchar300
TOPSocial Services and Social Security
64PSSCD_SXPITEMSXP Item Data27HEADERGUID of a CRM Order Objectvarbinary160
TOPTraders and Schedulers Workbench
65OIJNOM_FIELDSTSTNomination field status locking4HEADERCheckboxnvarchar10