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

88 columns | Print definition?ERP 6.0  | VALTY

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CF002Human Resources12VALTYValue typenvarchar10
2CF004Stock Prices8VALTYValue typenvarchar10
3P2RB_PKPension Fund, Payroll Belgium8VALTYPC Value Typenvarchar40
4P2RC_PKHR-CH: Pension fund payroll values8VALTYPC Value Typenvarchar40
5P2RN_PKPayroll Result: Pension Module8VALTYPC Value Typenvarchar40
6P2UN_PKPension Fund, Payroll United Nations8VALTYPC Value Typenvarchar40
7T5C1ETransaction Types8VALTYPC Value Typenvarchar40
8T5PPBS3VCheck values for PD infotype fields2VALTYValue typenvarchar20
9T5PPBS3VTText of values for PD infotype fields3VALTYValue typenvarchar20
TOPData Collection
10CF001Profitability Analysis15VALTYValue typenvarchar10
11CF003Projects15VALTYValue typenvarchar10
12CF005Personnel Information13VALTYValue typenvarchar10
13CF006Balance Sheet10VALTYValue typenvarchar10
14CF050Balance sheet/P&L (FI/FILC)19VALTYValue typenvarchar10
15CF500IDES Investment19VALTYValue typenvarchar10
16CF701IDES Marketing13VALTYValue typenvarchar10
17CF703IDES Profitability19VALTYValue typenvarchar10
18CF704IDES Sales Info Sys.12VALTYValue typenvarchar10
19CF705IDES Personnel Info14VALTYValue typenvarchar10
20CF706IDES Legal Cons.19VALTYValue typenvarchar10
21CF707IDES Insight11VALTYValue typenvarchar10
22CF708IDES: Setup Example10VALTYValue typenvarchar10
23CF720Top EIS Aspect19VALTYValue typenvarchar10
24CF750MCRED9VALTYValue typenvarchar10
25CF751MCBLUE9VALTYValue typenvarchar10
26CF752MCBlack10VALTYValue typenvarchar10
27T241WDescription of value type3VALTYValue typenvarchar10
28T242WValue types2VALTYValue typenvarchar10
29TKCUMEIS: Conversion table of new fixed fields 4.03VALTYValue typenvarchar10
TOPFunds Management
30FMLGD_H_CUSTNote to Payee Control7VALTYProcessing variantnvarchar40
31FMLGD_H_VALTYPProcessing variant2VALTYProcessing variantnvarchar40
32FMLGD_H_VALTYPTText Table for FMLGD_H_VALTYP2VALTYProcessing variantnvarchar40
TOPGlobal Trade Services
33/SAPSLL/LEGCULCSLL: Customs Document: Customs Processing: Duties8VALTYType of Value for Customs Declarationnvarchar30
34/SAPSLL/LEGCULCRCustoms Document (Backup): Customs Processing: Duties6VALTYType of Value for Customs Declarationnvarchar30
35/SAPSLL/PRVALLegal and Logistics Services: Product Master - Prices5VALTYValuation Typenvarchar100
36/SAPSLL/SECADJWLWorklist for Automatic Adjustment of Securities10VALTYValue Typenvarchar20
37/SAPSLL/TLC_ASCGTS: Customs Management: Toll Procedure5VALTYType of Value for Customs Declarationnvarchar30
38/SAPSLL/TLC_ASEGTS: Customs Processing: Duty Structure for Exports5VALTYType of Value for Customs Declarationnvarchar30
39/SAPSLL/TLC_ASTGTS: Customs Processing: Duty Structure for Proc. Transit.5VALTYType of Value for Customs Declarationnvarchar30
TOPHR Information Systems
40T72B1_BWHR-PF-BW: Permitted Value Type per PC Activities for BW5VALTYPC Value Typenvarchar40
TOPPension fund General Parts
41T5CA2PC Value Types4VALTYPC Value Typenvarchar40
42T5CA3HR-CH: Value type descriptions5VALTYPC Value Typenvarchar40
43T5CA8PC Method Determination6VALTYPC Value Typenvarchar40
44T5CA9PC Method Variant Determination6VALTYPC Value Typenvarchar40
45T5CACParameter Range Determination4VALTYPC Value Typenvarchar40
46T5CADPC Parameter Values4VALTYPC Value Typenvarchar40
47T5CAGPC Method Definitions5VALTYPC Value Typenvarchar40
48T5CAHSchedule Value Types5VALTYPC Value Typenvarchar40
49T5CAOLine Selection of Processing Schedules5VALTYPC Value Typenvarchar40
50T5CAVValue Type Attribute Assignment5VALTYPC Value Typenvarchar40
51T5CB3PC Parameter Attributes5VALTYPC Value Typenvarchar40
52T5CBEValue Type Field Assignment7VALTYPC Value Typenvarchar40
53T5CBOAdditional Selection Parameters for Reports6VALTYPC Value Typenvarchar40
54T5CBUField Selection for PC Online Evaluation View7VALTYPC Value Typenvarchar40
55T5CC0PC Method Steps Add-Ons5VALTYPC Value Typenvarchar40
56T5CC4HR-PF: Value Type Grouping4VALTYPC Value Typenvarchar40
57T5CP3HR-CH: Field assignment for infotype 2795VALTYPC Value Typenvarchar40
58T5CP4HR-CH: Value assignment for fields (BI)7VALTYPC Value Typenvarchar40
59T5CPAHR-CH: Determination of Wage Types for PF Value Types2VALTYPC Value Typenvarchar40
60T5CPBHR-CH: Pension fund postings5VALTYPC Value Typenvarchar40
61T5CPQInput Parameter Quantity Value Types for PF Calulation4VALTYPC Value Typenvarchar40
62T5CPSAdditional Infotype Field Values for PF Calculation8VALTYPC Value Typenvarchar40
63T5CPWAd Hoc Query Field Assignment4VALTYPC Value Typenvarchar40
64T5CQ1Account View Posting Value Types4VALTYAccount View Posting Value Typenvarchar40
65T5CQ3Account View Result Value Types5VALTYResult value typenvarchar40
66T5NF3PA-PF-NL: Feldzuordnung für Infotyp 2796VALTYVB-waardesoortnvarchar40
67T5NP3HR-Gran: Mapping table VALTY - LGART for Simulation5VALTYPC Value Typenvarchar40
68T72A2HR-PF: Totals Value Types6VALTYPC Value Typenvarchar40
69T72A6HR-IB: Parameters for a PF recalculation7VALTYPC Value Typenvarchar40
70T72A9HR-PF: Total Compensation Statement Integration7VALTYPC Value Typenvarchar40
71T72ADValue types of a variant for the Wage Maintenance Debugger3VALTYPC Value Typenvarchar40
72T72F0HR-PF: FI Posting Characteristics of Value Types6VALTYPC Value Typenvarchar40
73T72FAHR-PF: FI Index Table10VALTYPC Value Typenvarchar40
74T72P0HR-PF: Determination of Payroll Values for PF Value Types4VALTYPC Value Typenvarchar40
75T72T5HR-PF: TS Account Data7VALTYPC Value Typenvarchar40
76T72T6HR-PF: TS Account Data Totals Formation7VALTYPC Value Typenvarchar40
77T72TBHR-PF: TS Parameter Values7VALTYPC Value Typenvarchar40
TOPPension fund Netherlands
78T5NBGBerekeningsmethode (FAS/ALM interface)6VALTYVS-waardesoortnvarchar40
79T5ND1HR-CH: Pension fund postings5VALTYPC Value Typenvarchar40
80T5NDALog tabel voor euroconversie van IT0279 waardecomponenten3VALTYVB-waardesoortnvarchar40
81T5NDBLog tabel voor euroconversie van tabel T5CPB6VALTYVB-waardesoortnvarchar40
82T5NE1Groepsdefinitie (VK-rapport)6VALTYVB-waardesoortnvarchar40
83T5NE6Berekeningsmethode (VK-rapport)11VALTYVB-waardesoortnvarchar40
84T5NK2Pensioen producten - VB-Waardesoorten3VALTYVB-waardesoortnvarchar40
85T5NL3Toewijzing VB-waardesoort aan actuarieel bestandstype kolom4VALTYVB-waardesoortnvarchar40
TOPPension Fund Switzerland
86PA3230Personnel Master Record for Infotype 323029VALTYPC Value Typenvarchar40
87T5CD3House Bank Pension Fund for Non-Recurring Payments3VALTYValue Type of DME Postingnvarchar40
TOPSwitzerland
88T5CELHR-CH: Values from Infotype 0279 for Master Data Sheet4VALTYPC Value Typenvarchar40