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

57 columns | Print definition?ERP 6.0  | STYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CCGLT_PR_SLS_UTEHS: Print Request Sequential Data Test Data for Unit Tests8STYPEOutput Format for Sequential Numberingnvarchar10
2CCGLT_PR_SNO_UTEHS: Print Request Sequence Numbers Test Data for Unit Tests9STYPEOutput Format for Sequential Numberingnvarchar10
3DMC_STREE_TRACEMWB: Trace storage for table DMC_STREE6STYPEDMC: Flag if receiver or sender structurenvarchar10
4P2CO_COSEVPC2CO_SEV6STYPECalculation procedure for severance paymentsnvarchar20
5P2RB_SVSocial Insurance payroll Belgium94STYPEContribution Type (00083)nvarchar10
6P2RM_MSTATPayroll Structure MDADS: DA/DS Statistics (DK)7STYPEStatistics type (DK)nvarchar40
7P2RR_RMPayroll Results: Table for Master data (SG)53STYPEQuota type (attendance/absence quota)nvarchar10
8T5BSDOGSSDoG: Sections5STYPESDoG: Section Typenvarchar10
9T5BSDOGSWSDoG: Sections (SAP entries)4STYPESDoG: Section Type SAPnvarchar10
10T5BVYBase Rates for SI Contributions4STYPEContribution Type (00083)nvarchar10
11T5UPBS01FAVORITENature of Actions Favorites Tree15STYPENatural Numberint100
12T5UPBS01TREEPersonnel Actions Tree15STYPENatural Numberint100
13T7AEPBS08End Of Service Slabs2STYPEEnd Of Service Pay Typenvarchar30
14T7CNRM_FMTITMFormat Item3STYPERow/Columnnvarchar10
15T7CNRM_FMTITMTFormat Item Text4STYPERow/Columnnvarchar10
16T7CNRM_FMTSETFormat Set - OBSOLETE3STYPERow/Columnnvarchar10
17T7CNRM_FMTSETTFormat Set Text - OBSOLETE4STYPERow/Columnnvarchar10
18UMD01Default values for MRP18STYPEScheduling levelnvarchar10
TOPBalanced Scorecard
19UMB_SC100Scorecard: Header Table25STYPEScorecard Typenvarchar10
TOPBelgium
20PA0100HR Master Record: Infotype 0100 (SI B)56STYPEContribution Type - Master Datanvarchar10
21T5BD3Additional Social Insurance Contributions (obsolete)12STYPEContribution Type (00083)nvarchar10
22T5BDAAdditional Social Insurance Contributions5STYPEContribution Type (00083)nvarchar10
TOPCommon Parts
23T7XSSREUSEUISNReuse of Screen Structure Name for New Country Version4STYPEType of Screen Structurenvarchar40
TOPData Conversion
24DMC_STREEDMC: Tree Structure for Administration of Structures3STYPEDMC: Flag if receiver or sender structurenvarchar10
25DMC_STREETDMC: Structure Names4STYPEDMC: Flag if receiver or sender structurenvarchar10
TOPDB2 for OS39
26DB2COPYIDB2 copy information from SYSIBM.SYSCOPY16STYPEColumn STYPE of table SYSIBM.SYSCOPY (DB2 on OS/390)nvarchar10
TOPDenmark
27PA0204HR Master Record, Infotype 0204 (DA/DS Statistics DK)84STYPEStatistics type (DK)nvarchar40
TOPFinancial Accounting
28AVIPPayment Advice Line Item42STYPEType of Selection Field (Character, Date, Amount)nvarchar10
TOPLoans Management
29VDINSURE_HEADER0Do Not Use: Insurance - Header Data3STYPEnvarchar100
TOPMaster Data
30T442CControl: activity reqmts transfer MRP/SOP -> CO12STYPEScheduling levelnvarchar10
TOPNew Zealand
31PT0416Time Quota Compensation Infotype: Database Table25STYPEQuota type (attendance/absence quota)nvarchar10
TOPOrganizational Management
32T777RRequest - Server - Table5STYPEServer Typenvarchar10
33T77S1Menu: Functions4STYPEServer Typenvarchar10
TOPPatient Accounting
34NSIGHIS-H: Digital Signature3STYPEIS-H: Type of Digital Signaturenvarchar100
TOPPerformance Assessment Workbench
35SLS_SUTESTPAW - Subtest6STYPEPAW - Subtest Typenvarchar10
TOPPeriodical Sales and Distribution
36JLTPST0IS-M/SD: Session Header Record f.Batch Input Postal Charges3STYPEBatch Input Interface Record Typenvarchar10
37JLTPST1IS-M/SD: Header Data for Batch Input Postal Charges3STYPEBatch Input Interface Record Typenvarchar10
38JLTPST2IS-M/SD: Main Data for Batch Input Postal Charges3STYPEBatch Input Interface Record Typenvarchar10
39JLTPST3IS-M/SD: Scale Data for Batch Input Postal Charges3STYPEBatch Input Interface Record Typenvarchar10
TOPPersonnel Administration
40T588UICONVCLASAssignment UI Structures and UI Conversion Classes3STYPEType of Screen Structurenvarchar40
41T7COT3Payroll external results transfer: COSEV6STYPECalculation procedure for severance paymentsnvarchar20
TOPPersonnel Time Management
42PA0416Time Quota Compensation Infotype: Database Table25STYPEQuota type (attendance/absence quota)nvarchar10
TOPProject System
43FILTER_PS_LOGFilter for PS EHP410STYPESingle-Character Indicatornvarchar10
TOPProxy Generation
44SPROXXSLTNProxy Generation: Number Assignment for Style Sheets1STYPECHAR05 data element for SYSTnvarchar50
TOPPublic Sector
45PA0495HR-PS-SG: Pensions Scheme24STYPESuperannuation Schemenvarchar60
46T5RPBS8ADefine Superannuation Scheme2STYPESuperannuation Schemenvarchar60
47T5RPBS8ATText Table for Superannuation Scheme3STYPESuperannuation Schemenvarchar60
48T5RPBS8COBSOLETE(Pensions Scheme Payment Option Eligibility Crite)2STYPESuperannuation Schemenvarchar60
49T5RPBS8EOBSOLETE (SG Public Sector Pensions Scheme Constants Tab)2STYPESuperannuation Schemenvarchar60
50T5RPBS8VAssign Superannuation Option to Superannuation Scheme2STYPESuperannuation Schemenvarchar60
TOPReuse Services for Country Development
51T5F99FSForms: Sections7STYPEForms: Type of formsnvarchar10
TOPSAP Records Management
52SRMHLELEMSElements of Hierarchical Lists11STYPEnvarchar320
TOPSAPscript
53TTDCFTable for style sheet conversion1STYPEKey: 'S' style, 'F' form, 'D' Word document templatenvarchar10
TOPSwitzerland
54T5C2P_STREETWithholding Tax for Geneva: Street Name Conversion3STYPEStreet Type Codenvarchar10
TOPUSA
55T5UG6Government Service Charge9STYPEType of withholdingnvarchar10
56T5UGGCompany Service Charge10STYPEType of withholdingnvarchar10
TOPWeb Application Builder
57W3SPARWAB: Possible Service Parameters2STYPEWAB: Type of Internet-Servicenvarchar100