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

29 columns | Print definition?ERP 6.0  | SUBST

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1N1ME_THREC_LBMedication: Link Module Data for Therapy Recommendation17SUBSTMedication: Substitutionsntext10737418230
2PA3375HR Master Record: Infotype 337591SUBSTSubmission statusnvarchar30
3PA3376HR Master Record: Infotype 337632SUBSTSubmission statusnvarchar30
4T5UPBS20DSDrug screening substance test4SUBSTSubstance test content codenvarchar40
5T5UPBS20DSNDrug screening substance test unit4SUBSTSubstance test content codenvarchar40
6T5UPBS20DSNTDrug screening substance test unit5SUBSTSubstance test content codenvarchar40
7T5UPBS20DSTDrug screening substance test text5SUBSTSubstance test content codenvarchar40
TOPB2A Business to Administration
8PB2ASTATHR-B2A: Status Management5SUBSTSubstatus of B2A Documentnvarchar20
9T50BDHR-B2A: Status Management6SUBSTSubstatus of B2A Documentnvarchar20
10T50BDTHR-B2A: Texts for Status Management7SUBSTSubstatus of B2A Documentnvarchar20
11T50BE2HR-B2A: External Return Codes7SUBSTSubstatus of B2A Documentnvarchar20
12T50BFHR-B2A: Method Table6SUBSTSubstatus of B2A Documentnvarchar20
13T50BFCHR-B2A: Method Table6SUBSTSubstatus of B2A Documentnvarchar20
14T50BGHRB2A: Manual Status Switch6SUBSTSubstatus of B2A Documentnvarchar20
TOPData Transfer
15PPDITTransfer to Accounting: Lines in HR IDOCs31SUBSTFlag: Object substitutednvarchar10
TOPDatabase Monitors
16INFCFGALRSINFCFGCHECK: temp. storing of alert results4SUBSTINFCFGCHECK: Monit. attribute identifier (name)nvarchar400
TOPFinancial Accounting
17T001QSubstitution in Accounting Documents4SUBSTSubstitution namenvarchar70
TOPJoint Venture und Production Sharing Accounting
18T8JZSUBValidation of accounting documents4SUBSTSubstitution namenvarchar70
TOPKorea
19PA0557HR Master Record: Infotype 055735SUBSTRecruit substitute of the retireenvarchar10
TOPNetwork and Activity
20TCN41Network Defaults72SUBSTSubstitution namenvarchar70
TOPOperative Structures
21TCJ41Default Values for Work Breakdown Structure74SUBSTSubstitution namenvarchar70
TOPPublic Sector
22PA0752HR Master Record: Infotype 075238SUBSTSubmission statusnvarchar30
23PA0753HR Master Record: Infotype 075330SUBSTSubmission statusnvarchar30
24PA0754HR Master Record: Infotype 075428SUBSTSubmission statusnvarchar30
25PA0755HR Master Record: Infotype 075525SUBSTSubmission statusnvarchar30
TOPReuse Services for Country Development
26T5F99BXHR-BE: Substatus transitions in B2A6SUBSTSubstatus of B2A Documentnvarchar20
27T5F99STStatus9SUBSTSubstatus of B2A Documentnvarchar20
TOPSAP Healthcare - Industry-Specific Components for Hospitals
28NWCHPSYIS-H: Tab. für BFS-Statistik um Psychodaten bereitzustelle25SUBSTIS-H: farmaci sostit.in caso di assuefazione(ad es.Metadone)nvarchar10
TOPSyntax, Compiler, Runtime
29ICONPIcons: Assignment to SAPicon character set3SUBSTIcon: Replacement characternvarchar40