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

80 columns | Print definition?ERP 6.0  | TTYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SAPSRM/C_SHDTYDocument Types for Search Document Output1TTYPEPPF: Name of Action Definitionnvarchar300
2/SAPSRM/C_SHDTYTDocument Types for Search Document Output (Text Table)1TTYPEPPF: Name of Action Definitionnvarchar300
3CNVC_SCWB_XTTrigger header table8TTYPETrigger-Typnvarchar30
4DMC_IU_TM_NODEMWB Upgrade: Node Table for Tool Manager5TTYPEMWB: Tool Typenvarchar10
5DMC_TM_NODEMWB: Node Table for Tool Manager5TTYPEMWB: Tool Typenvarchar10
6IDREPFW_TRANS_ERep.Framework: Setup Transactions for Direct Run3TTYPEType of Transaction Code Customizing (SAP or Customer)nvarchar50
7IDREPFW_TRANS_TRep.Framework: Setup Transactions for Direct Run (Text)3TTYPEType of Transaction Code Customizing (SAP or Customer)nvarchar50
8J_1ATAXP_MAP_STCross Table for Mapping Taxpayers File5TTYPETax Type Keynvarchar20
9P2FI_CSTTax result table for Finland, cumulative15TTYPETax card typesnvarchar40
10P2FI_STTax result structure for Finland15TTYPETax card typesnvarchar40
11P2RG_CARCO2Payroll Results: GB Company Cars (CO2 based calculation)11TTYPECar transmission types (for UK only)nvarchar10
12P2RS_SSKATPayroll result: Tax (SE)9TTYPETax Type - (SE)nvarchar40
13T804DReport Writer: Texts of Data Field Descriptions4TTYPEText typenvarchar10
14YLP_TX_CUST_LINKTransaction table for custom link6TTYPEDummy for B20 int1 (Local Everywhere)tinyint30
15YLP_TX_MAST_LINKTransaction table to store Master Link6TTYPEDummy for B20 int1 (Local Everywhere)tinyint30
TOPBasic Functions
16T800AFI-SL tables2TTYPETable typenvarchar20
TOPBrazil
17T7BRT2Transportation type2TTYPETransportation typenvarchar20
18T7BRT3Transportation type description3TTYPETransportation typenvarchar20
19T7BRTRTransportation ticket7TTYPETransportation typenvarchar20
TOPCanada
20T5KTCWage Type Tax Classifications (Canada)1TTYPETax type - Fed. tax.,Prv. basic tax, surtax, flat tax ...nvarchar20
21T5KTSTax types description2TTYPETax type - Fed. tax.,Prv. basic tax, surtax, flat tax ...nvarchar20
22T5KTTTax types Canada1TTYPETax type - Fed. tax.,Prv. basic tax, surtax, flat tax ...nvarchar20
TOPFinancial Accounting
23FBICRC01010Reconciliation Processes: Attributes per Company15TTYPEData Transfer Typenvarchar10
TOPFinancial Services Localization
24/CEEIS/RUOObject table 118TTYPETransaction Typenvarchar20
TOPFinland
25PA0205HR Master Record: Infotype 0205 (taxes Finland)32TTYPETax card typesnvarchar40
26T7FIB1Default Tax Card Type Assignment to Payment Type (ATS)2TTYPETax card typesnvarchar40
27T7FILISTable for Low Income Support Statement8TTYPETax card typesnvarchar40
TOPFrance
28HRT1681Table Part Infotype 16814TTYPETraining Typenvarchar30
29HRT1686Table Part Infotype 16866TTYPETraining Typenvarchar30
30T77TNMFR_TYTNM/France : table de mapping type form./type légal2TTYPEType de formationnvarchar30
31T77TNM_DETNM: deduction customizing table3TTYPETraining Typenvarchar30
32T77TNM_IVCompensation Indirect Valuation6TTYPETraining Typenvarchar30
33T77TNM_QUTNM: quota customizing table3TTYPETraining Typenvarchar30
34T77TNM_TYTraining type3TTYPETraining Typenvarchar30
35T77TNM_TYFCMTraining type / Training Fund Category: mapping table3TTYPETraining Typenvarchar30
36T77TNM_TYTTraining type text4TTYPETraining Typenvarchar30
TOPGlobal Trade Services
37/SAPSLL/TLEACMMessages for Activity9TTYPEPPF: Name of Action Definitionnvarchar300
TOPGreat Britain
38PA0222HR Master Record for Infotype 0222 (Company Cars GB)45TTYPECar transmission types (for UK only)nvarchar10
39T5GC3GB Company car C02 emmissions4TTYPECar transmission types (for UK only)nvarchar10
40T5G_P46ARVHR-GB: Archive for P46(Car)-Forms7TTYPECar transmission types (for UK only)nvarchar10
TOPIndia
41T7INT9Taxability of wage types6TTYPETaxation typenvarchar10
TOPInformation System
42T804AReport Writer: File Description14TTYPEIndicator: Transfer with structurenvarchar10
TOPJoint Venture und Production Sharing Accounting
43T8J6GJV JIB Account Mapping for Non-AFE4TTYPEAsset transaction typenvarchar30
44T8J6HJV JIB Account Mapping and Class5TTYPEAsset transaction typenvarchar30
45T8J6JJV JIB Account Mapping for AFE4TTYPEAsset transaction typenvarchar30
TOPliveCache Applications
46/SAPAPO/ORDKEYKey and descriptive data for order22TTYPEMeans of Transportnvarchar100
TOPLocal Currency Changeover
47EUROFISL_TEMU: Information on Table Level for FI-SL5TTYPETable typenvarchar20
TOPManagement of Internal Controls
48HRP1814DB Table for InfoType 181422TTYPEObject Typenvarchar20
TOPMetadata Repository
49RSQTOBJTable Objects in the InfoSet6TTYPEType of a Table Object in the InfoSetnvarchar20
TOPNetherlands
50T77EIRNLTGRTYPEElectronic Illness Reporting NL: Trigger Types1TTYPETrigger Typenvarchar20
51T77EIRNLTGRTYPETElectronic Illness Reporting (NL): Trigger Types Text2TTYPETrigger Typenvarchar20
TOPOrganizational Management
52HRP1201Infotype 1201 DB Table26TTYPEGeneral Flagnvarchar10
53HRS1201Standard Infotype 1201 (SAP) Object Method13TTYPEGeneral Flagnvarchar10
TOPPersonnel Administration
54PA0442HR Master Record: Infotype 044252TTYPECar transmission types (for UK only)nvarchar10
55T7CO91Days range for compensation for unfair dismissal4TTYPETable typenvarchar10
56T7CO92Severance table life6TTYPETable typenvarchar10
TOPPersonnel Time Events
57TPTCOR_TTYPEESS Korrekturszenario: Feldauswahl Zeitereignisart zuordnen4TTYPEZeitereignisartnvarchar30
TOPPortfolio Management
58/RPM/ITEM_DOperational item persisted data10TTYPETechnology Typenvarchar40
59RPM_ITEM_D_CDItem details - Pseudo table for change documents10TTYPETechnology Typenvarchar40
60RPM_PROJECTProject data7TTYPETechnology Typenvarchar40
61RPM_PROJ_TTYPETechnology Type3TTYPETechnology Typenvarchar40
62RPM_PROJ_TTYPE_TProject Technology Type4TTYPETechnology Typenvarchar40
TOPPost Processing Framework
63PPFTCONDPPF: Condition3TTYPEPPF: Name of Action Definitionnvarchar300
64PPFTCONDTRPPF: Condition (CL_CONDITION_TRANSP_PPF)3TTYPEPPF: Name of Action Definitionnvarchar300
65PPFTTRIGGPPF: Actions8TTYPEPPF: Name of Action Definitionnvarchar300
66PPFTTRTM2PPF: Action Template Table (Transportable)14TTYPEPPF: Name of Action Definitionnvarchar300
67PPFTTRTMPPPF: Action Template Table14TTYPEPPF: Name of Action Definitionnvarchar300
TOPProcess Controls
68HRP5314DB Table for Infotype 531422TTYPEObject Typenvarchar20
TOPReporting
69P05_TTFMMapping: Tax Table - Function Module8TTYPETax Table Typenvarchar50
70P05_TTFM_TTYPECSV Tax Table Check Report: Table Types1TTYPETax Table Typenvarchar50
71P05_TTFM_TTYPETCSV Tax Table Check Report: Tax Table Type Text Table2TTYPETax Table Typenvarchar50
TOPSouth Africa
72T5W31Termination Categories2TTYPEType of Termination Categorynvarchar20
TOPSweden
73PA0273HR Master Record: Infotype 0273 (Tax - SE)24TTYPETax Type - (SE)nvarchar40
TOPSyntax, Compiler, Runtime
74SNAPTABAP Runtime Error Texts3TTYPECHAR01 data element for SYSTnvarchar10
75SNAPTTREXException Table for Translation3TTYPECHAR01 data element for SYSTnvarchar10
TOPWithout Description
76RSTT_ERRORError Archive4TTYPETrace Tool: Trace Typenvarchar40
77RSTT_OBJHISTTrace Tool: History for Trace Objects3TTYPETrace Tool: Trace Typenvarchar40
78RSTT_TJOBTrace Tool: Trace Job/Test Job Table5TTYPETrace Tool: Trace Typenvarchar40
79RSTT_TPACKAGETrace Tool: Basis Info About Trace Packages3TTYPETrace Tool: Trace Typenvarchar40
80RSTT_TRACETrace Tool: Table Trace Attribute5TTYPETrace Tool: Trace Typenvarchar40