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

39 columns | Print definition?ERP 6.0  | SCODE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1T5PPBS1SSIADAP: Scale Ranges3SCODEProficiency of a Quality Scalenvarchar40
2T5UPBSTC16Certificate: Classification, Area and Level2SCODECode (Classification, Area and Level)nvarchar60
3T5UPBSTC42Assign Codes to Qualifications4SCODECode (Classification, Area and Level)nvarchar60
4T5UPBSTC52Assign Codes to Duty Assignments3SCODECode (Classification, Area and Level)nvarchar60
5T7RU_005YKLADR: Regions - territorial entity5SCODEDescriptionnvarchar200
TOPCompensation Management
6T710SSurvey Data2SCODESalary Surveynvarchar40
7T710STSurvey Texts3SCODESalary Surveynvarchar40
TOPNorway
8T5V1CPeriod Work Schedules Codes6SCODEWork Schedule Codesnvarchar10
TOPPOS Interface
9TWPUBPOS interface: conversion of transaction types sales rcpts4SCODETransact. typenvarchar40
10TWPUCPOS interface: currency code conversion4SCODECurrency Keynvarchar50
11TWPUEPOS interface: conversion of subsystem units of measure4SCODEUnit of Measurementnvarchar30
12TWPUFPOS interface: conversion of store numbers4SCODEPlantnvarchar40
13TWPUKPOS interface: conversion of POS condition types4SCODECondition Typenvarchar40
14TWPULPOS interface: conversion of POS language codes4SCODELanguage Keynvarchar10
15TWPUMPOS interface: conversion of POS movements types4SCODEMovement Type (Inventory Management)nvarchar30
16TWPUSPOS interface: conversion of POS tax codes4SCODETax on sales/purchases codenvarchar20
17TWPUVPOS interface: conversion of POS transaction types FI4SCODEFI transactionnvarchar40
18TWPUWPOS interface: conversion of POS material groups5SCODEClass numbernvarchar180
19TWPUXPOS interface: reassignment of mat. tax classification key4SCODETax classification materialnvarchar10
20TWPUZPOS interface: conversion of POS payment methods4SCODECondition Typenvarchar40
TOPPublic Sector
21PA0502Letter of appointment37SCODESalary Codenvarchar50
22PB0502Letter of appointment37SCODESalary Codenvarchar50
23T5PBSR6BSalary Code3SCODESalary Codenvarchar50
24T5PBSR6BTText for Salary Code4SCODESalary Codenvarchar50
25T5PBSR6CAssignment between Scheme Code and Salary Code4SCODESalary Codenvarchar50
26T5PBSR6EAnnual Wage Adjustment for Basic Component5SCODESalary Codenvarchar50
27T5PBSR6FMonthly Salary Scale4SCODESalary Codenvarchar50
28T5PBSR6GBasic Component3SCODESalary Codenvarchar50
29T5RPBS8ADefine Superannuation Scheme5SCODEPensions Scheme Codesnvarchar60
TOPPublic sector Sweden
30T5S1C_CEPeriod Work Schedule Valuation for VACS2SCODEStatistic codenvarchar10
TOPSAP Utilities
31SASE_INLast Numerical Serial Number for Seal code2SCODESeal codenvarchar80
32SCODET_INDescription of seal code2SCODESeal codenvarchar80
33SCODE_INSeal code2SCODESeal codenvarchar80
34SEAL_INSeal6SCODESeal codenvarchar80
TOPSouth Africa
35T5W5ABank check digit verification table for South Africa9SCODEStream Code CDV ZAnvarchar20
TOPSweden
36T5S1CPeriod Work Schedule Valuation - SE(Leave)6SCODEStatistic codenvarchar10
37T5S1SStatistic codes Leave - SE2SCODEStatistic codenvarchar10
38T5S1TStatistic codes Leave - SE2SCODEStatistic codenvarchar10
TOPVenezuela
39T7VEEVVenezuelan events4SCODEEmployment Termination Codenvarchar40