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  | RTYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BI0/SRTYPEMaster Data IDs: InfoObject Exchange Rate Type1RTYPEExchange Rate Typenvarchar40
2DRP_SMTC_METRDEV Reporting (SE28): Formulas for Calculation9RTYPEDEV Reporting (SE28): Result of Formula Interpreternvarchar10
3GRACBGRANGERange table values for Background Job variant5RTYPECharacter field, length 32nvarchar320
4GRFNQRATINGQustion Ratings2RTYPEQuestion Rating Typenvarchar20
5GRFNQRATINGTQustion Rating Texts3RTYPEQuestion Rating Typenvarchar20
6GRFNQRATINGTYPEQuestion Rating Types2RTYPEQuestion Rating Typenvarchar20
7GRFNQRATINGTYPETQuestion Rating Types - Text3RTYPEQuestion Rating Typenvarchar20
8P08P_USSCUSS Interface Control Table (Contributions & Salary Changes)2RTYPEInterface Control File Run Typenvarchar10
9P08P_USSC_CAREUSS Interface Control Table (Contributions & Salary Changes)2RTYPEInterface Control File Run Typenvarchar10
10P2RU_GRRECPayroll Results: Garnishment for US Record9RTYPERecord typenvarchar10
11P2RU_TAXRPayroll result: Tax authorities of resident/unemployment(US)6RTYPELetternvarchar10
12T512VRPDSYS00 - Cross References2RTYPEDocumentation Object Typenvarchar40
13T588F- is no longer used (now T588G) -5RTYPERetroactive Accounting Categorynvarchar10
14T7CNRM_REPORTReport6RTYPEReport Typenvarchar10
15ZTARGET_PARTNERGSystem Landscapes: Header Data4RTYPELandscape namenvarchar200
TOPBasic Functions
16T046SExceptions from cashed bills of exchange paid to vendors5RTYPEReason for refusal to pay bill/exch. returned to house banknvarchar20
17T884Currency translation8RTYPEExchange rate indicatornvarchar10
18TABADepreciation posting documents12RTYPEType of Depreciation Runnvarchar10
TOPClinical System
19N1ORATEIS-H*MED: Medication, Dosage Quantities Infusions24RTYPEMedication: Flow Rate Typenvarchar20
20N1TPORATEIS-H*MED: Dosage Quantities of Template20RTYPEMedication: Flow Rate Typenvarchar20
TOPCompensation Management
21T71LB1Award20RTYPESecurity Price Typenvarchar20
TOPConsumption-Based Planning See Also PP-MRP
22MDRDDelivery Relationships: Recipients per Plant and Material5RTYPEDelivery Relationship: Type of Goods Recipientnvarchar10
23MDRD_EXTWGDelivery Relationships: Recipients per Plant and Material5RTYPEDelivery Relationship: Type of Goods Recipientnvarchar10
24WDRDDelivery Relationships: Recipients per Plant and Material5RTYPEDelivery Relationship: Type of Goods Recipientnvarchar10
25WDRD_EXTWGDelivery Relationships: Recipients per Plant and Material5RTYPEDelivery Relationship: Type of Goods Recipientnvarchar10
TOPContract Accounts Receivable and Payable
26DFKKDOUBTD_RET_WBuffer: Printout for Ind.Val.Ad - Return Values (User Event)19RTYPEFPRW: Record Type (Internal Use)nvarchar10
27DFKKDOUBTD_WBuffer: Create Printout for Receivables Adjustment34RTYPEFPRW: Record Type (Internal Use)nvarchar10
TOPData Staging
28RSTRAN_R_CURRCurrency Translations for Transformation Runtime Unit Test2RTYPEExchange Rate Typenvarchar40
TOPEnvironment, Health and Safety Master Data
29THM097DG: Mixed Loading Rules6RTYPEResponse Type for Mixed Loading Rulesnvarchar10
TOPFinancial Accounting
30FBICRC001AICRC: Open Items GL Accounts: Documents19RTYPERecord Typenvarchar10
31FBICRC001CICRC: Open Items GL Accounts: Object Table 24RTYPERecord Typenvarchar10
32FBICRC001PNot in use18RTYPERecord Typenvarchar10
33FBICRC001TICRC: Open Items GL Accounts: Totals18RTYPERecord Typenvarchar10
34FBICRC002AICRC: GL Accounts: Documents19RTYPERecord Typenvarchar10
35FBICRC002CICRC: GL Accounts: Object table 24RTYPERecord Typenvarchar10
36FBICRC002PNot in use18RTYPERecord Typenvarchar10
37FBICRC002TICRC: GL Accounts: Totals18RTYPERecord Typenvarchar10
38FBICRC003AICRC: Open Items Customers/Vendors: Documents20RTYPERecord Typenvarchar10
39FBICRC003CICRC: Open Items Customers/Vendors: Object table 24RTYPERecord Typenvarchar10
40FBICRC003PNot in use19RTYPERecord Typenvarchar10
41FBICRC003TICRC: Open Items Customers/Vendors: Totals19RTYPERecord Typenvarchar10
TOPForms
42T59_PROTLRPDSYS-SE61 Conversion: Log Table Reference9RTYPEDocumentation Object Typenvarchar40
TOPGlobal Trade Services
43/SAPSLL/LCCUSMPTSLL: Reproduction of Customs Duty Types - Description5RTYPEDuty Type from Data Providernvarchar40
44/SAPSLL/LC_CUSMGTS: Customs Processing: Mapping of Customs Duty Types3RTYPEDuty Type from Data Providernvarchar40
45/SAPSLL/LC_CUSMPSLL: Customs Processing: Reproduction of Customs Duty Types4RTYPEDuty Type from Data Providernvarchar40
TOPGreat Britain
46T5G28SMP Rates Payable6RTYPEMaternity pay record type - amount/percentnvarchar10
TOPIreland
47T7IEEEHECS: Return Data9RTYPEEHECS: Report Typenvarchar10
TOPJapan
48T7JPLV_FILESTRUDefine File Structure6RTYPERecord Typenvarchar20
TOPLong-Term Incentives
49T71LTI02LTI Plan Time Dependent Attributes9RTYPESecurity Price Typenvarchar20
TOPNorway
50REIMB_RECON_COMComments for Reimbursement Reconciliation report5RTYPESingle-Character Indicatornvarchar10
TOPOLAP Technology
51RSCURTRTCurrency Translation Types3RTYPEExchange Rate Typenvarchar40
52RSDDTPS_CONVConversion Indices in Polestar4RTYPEExchange Rate Typenvarchar40
TOPOverhead Cost Controlling
53CSKRResource master record6RTYPEResource typenvarchar10
TOPPerformance Assessment Workbench
54SLS_PRESPAW - Person Results Structure30RTYPEResult type (PAW)nvarchar10
55SLS_RTESTPAW - Participant's Aggregated Test Results8RTYPEResult type (PAW)nvarchar10
56SLS_YTESTPAW - Participant's Aggregated Test Results8RTYPEResult type (PAW)nvarchar10
TOPPersonnel Administration
57T513VRPDSYS00 - Cross References3RTYPEDocumentation Object Typenvarchar40
58T588GField-Specific Retroactive Accounting Recognition6RTYPERetroactive Accounting Categorynvarchar10
TOPProcess Controls
59GRPCQLIBRARYQuestion Library7RTYPEQuestion Rating Typenvarchar20
TOPReporting
60MCRSV_USRSelection version: Assigned distribution lists or users5RTYPESpecification of recipient typenvarchar10
TOPSAP Healthcare - Industry-Specific Components for Hospitals
61/ISHFR/TN290_CODIS-H FR: Receipt Codes3RTYPEIS-H FR: Code Type (Receipt)nvarchar10
TOPStructures Workbench
62/ISDFPS/CCRTYPE1Assign Usage Types to Relationship Types3RTYPERelationship Typenvarchar30
63/ISDFPS/CCRTYPE2Relationship Assignment for Each Usage/Relationship Ty. Pair3RTYPERelationship Typenvarchar30
64/ISDFPS/CFDPSC1Relationship Types2RTYPERelationship Typenvarchar30
65/ISDFPS/CFDPSC1TText Table Relationship Types2RTYPERelationship Typenvarchar30
66/ISDFPS/CFDPSC2Relationship Groups2RTYPERelationship Typenvarchar30
67/ISDFPS/CFDPSC3Relationship Group Assignment2RTYPERelationship Typenvarchar30
68/ISDFPS/CFDPSC3TText Table Relationship Group Assignment2RTYPERelationship Typenvarchar30
69/ISDFPS/CFDPSC4Assignment of Relationship Types to Force Element Types4RTYPERelationship Typenvarchar30
TOPSyntax, Compiler, Runtime
70SXBNFRULEXBNF rules3RTYPEXBNF RTYPEnvarchar10
TOPTraders and Schedulers Workbench
71OIJNOMCOMMNomination Partner Communication4RTYPEOIL-TSW: Role typenvarchar60
72OIJRRAOIL-TSW: Partner roles6RTYPEOIL-TSW: Role typenvarchar60
73OIJRRTOIL-TSW: Partner role types2RTYPEOIL-TSW: Role typenvarchar60
74OIJRRTTOIL-TSW: Partner role type texts3RTYPEOIL-TSW: Role typenvarchar60
75OIJSHIPVALDOIL TSW: Shipper valid for other partner roles2RTYPEOIL-TSW: Role typenvarchar60
76TOIJ_BPD_FIELDSCustomizing Table Business Process Dialog2RTYPEOIL-TSW: Role typenvarchar60
77TOIJ_BPD_PMAPNomination Partner Communication Partner Mapping2RTYPEOIL-TSW: Role typenvarchar60
78TOIJ_EL_MVSCENTSW: Define Movement scenarios17RTYPEOIL-TSW: Role typenvarchar60
TOPUSA
79BRCDTABSI-TAX 4.0 BRCDTA5RTYPEBSI40: RTYPEnvarchar10
80BRCGDTABSI-TAX 4.0 BRCGDTA5RTYPEBSI40: RTYPEnvarchar10