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

46 columns | Print definition?ERP 6.0  | VARIA

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/WSOPT/DWSDaily Work Schedule4VARIADaily Work Schedule Variantnvarchar10
2P2B2_CVSHCM Declustering B2 - Cumulated Variable Balances7VARIACommentnvarchar500
3P2B2_PSPHCM Declustering B2 - Personal Work Schedule (Table PSP)12VARIADaily Work Schedule Variantnvarchar10
4P2B2_RUFBHCM Declustering B2 - On-Call Duty (Table RUFB)18VARIADaily Work Schedule Variantnvarchar10
5P2B2_VERTHCM Declustering B2 - Table VERT20VARIADaily Work Schedule Variantnvarchar10
6P2B2_VSHCM Declustering B2 - Variable Balances per Day (Table VS)8VARIACommentnvarchar500
7P2RF_PSPPPersonal Work Schedule (Table PSP)10VARIADaily Work Schedule Variantnvarchar10
8T048BReport Assignment for Automatic Correspondence5VARIAName of Report Variant for Printing Correspondencenvarchar140
9T77PADKZ508ANormative Work Schedule Rules for Personal Work Schedule6VARIAReserved for Variant of Normative Work Schedulenvarchar10
TOPBasic Data
10TNF40IS-H: Smart Forms for Work Organizer Type3VARIASmart Forms: Variantnvarchar80
TOPBasic Functions
11TFBWEPersonal Customizing for Transaction FBWE23VARIALayoutnvarchar120
TOPCompany Pension Scheme Germany
12T5DWJAssignment of Text Elements to Statements4VARIAVariantnvarchar10
13T5DWLControl Logical Pages in CPS Statements4VARIAVariantnvarchar10
TOPData Collection
14CF003Projects35VARIAVariantnvarchar10
15KCSLVSAP-EIS: data slices - variables - parameters4VARIAVariable Namenvarchar100
16KCVARSAP-EIS: data slice variables3VARIAData slice variablenvarchar100
17KCVARTSAP-EIS: data slice variable meanings4VARIAData slice variablenvarchar100
TOPData Transfer
18KCDRAData Transfer Rules: Attributes of Receiver Fields13VARIAVariable Namenvarchar100
TOPGL Account Posting
19TCJ_PRINTCash Journal Print Parameters4VARIACash Journal Print Report Variantnvarchar140
TOPItaly
20T5ITUAUser Data Table of the Company for Report/ Legal Form3VARIAUniEmens: Manual/Automatic override for Company Reportnvarchar40
TOPJapan
21PTJPFWS_ITEMDATA(Obsolete) Request Item Data for Flexible Work Schedule JP6VARIADaily Work Schedule Variantnvarchar10
22TPTJPFWS_ITEMDATRequest Item Data for Flexible Work Schedule JP6VARIADaily Work Schedule Variantnvarchar10
23TPTJPFWS_SUBSTIESS Flexible Work Schedule: Substitution linkage5VARIADaily Work Schedule Variantnvarchar10
TOPOverhead Cost Orders
24TKB1ASettlement Profile31VARIASettle Variancesnvarchar10
TOPPayroll
25T7ROE4Postal fees8VARIAVariable part of the postal feedecimal72
26T7UA508ANormative Work Schedule Rules for Personal Work Schedule6VARIAReserved for Variant of Normative Work Schedulenvarchar10
TOPPayroll General Parts
27T51D5Start Point5VARIAVariable compare datenvarchar10
TOPPension fund General Parts
28T72ACVarainats for the Wage Maintenance Debugger2VARIAVariant namenvarchar140
29T72ADValue types of a variant for the Wage Maintenance Debugger2VARIAVariant namenvarchar140
TOPPersonnel Time Management
30PA2003HR Time Record: Infotype 2003 (Substitutions)44VARIADaily Work Schedule Variantnvarchar10
31PA2004HR Time Record: Infotype 2004 (Availability)34VARIADaily Work Schedule Variantnvarchar10
32PTEX2003GENInterface Table for IT 2003: General Information30VARIADaily Work Schedule Variantnvarchar10
33T550ADaily Work Schedule4VARIADaily Work Schedule Variantnvarchar10
34T550XDaily Work Schedule Selection Rules9VARIADaily Work Schedule Variantnvarchar10
35T552VDynamic Daily Work Schedule Assignment10VARIADaily Work Schedule Variantnvarchar10
36T552WDynamic Daily WS Assignment: Planned/Actual Overlap9VARIADaily Work Schedule Variantnvarchar10
TOPShift Planning
37HRP1046Database Table for Infotype 104628VARIADaily Work Schedule Variantnvarchar10
38HRP1049Database Tables for Infotype 104922VARIADaily Work Schedule Variantnvarchar10
39T77EDShift Planning: Definition of Shifts6VARIADaily Work Schedule Variantnvarchar10
TOPTime Data Recording and Administration
40TMW_TDTYPETime Data ID15VARIADaily Work Schedule Variantnvarchar10
TOPUnited Kingdom
41T5G9AGross to net control report options5VARIALayoutnvarchar120
TOPWarehouse Management
42T327AControl of link WM - subsystem9VARIAVariant for link MM-WM -> external systemnvarchar30
43T327BDefinition of function modules for IDOC setup: Link WM - sub4VARIAVariant for link MM-WM -> external systemnvarchar30
44T327TVariant description for link WM -> subsystem4VARIAVariant for link MM-WM -> external systemnvarchar30
45T327VVariants for WM Link -> Subsystem3VARIAVariant for link MM-WM -> external systemnvarchar30
TOPWork Center
46TC37AShift definition13VARIADaily Work Schedule Variantnvarchar10