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

29 columns | Print definition?ERP 6.0  | REFID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/PERSOS/SYSPROFSystem Profile Controls3REFIDReference IDnvarchar320
2MIGTRIGGERTrigger during DMO (database migration option)2REFIDChar 20nvarchar200
3P2KR_KRTAXPayroll Result Korea : Tax17REFIDExemption by Income tax law/Tax exemption regulation lawnvarchar10
TOPABAP Test Frameworks ATC, CheckMan, Code Inspector
4CRMCHKOBJHHeader of Object Sets15REFIDCheck Results Management: ID of Object Set to Be Checkednvarchar40
TOPBasic Data
5NC301VIS-H: EDI Receipt, Storage for Specific Message Types7REFIDIS-HCM: Identification for Unique Assignmentnvarchar40
6NC301WIS-H: EDI Receipt, Worklist for Processing Agent7REFIDIS-HCM: Identification for Unique Assignmentnvarchar40
TOPBusiness Planning and Simulation
7UPC_STEPSRelations between Characteristics of a Planning Area10REFIDUUID in compressed form (22 character UUENCODEd)nvarchar220
8UPF_PARAMPlanning Functions: Parameterization6REFIDUUID in compressed form (22 character UUENCODEd)nvarchar220
TOPClinical System
9TN2CARDREFReference Values for Medical Examinations3REFIDID of Reference Valuenvarchar250
TOPCollectionsDisbursements
10ITAGCYCOLLTRTransfer Information10REFIDReference Sourcenvarchar320
TOPCompany Pension Scheme Germany
11P01RBM_HISTNotification Status: Pension Receipt Notifications9REFIDReference Notification (Internal ID)nvarchar320
12P01RBM_STATNotification Status: Pension Receipt Notifications15REFIDReference Notification (Internal ID)nvarchar320
13P01RBM_STAT_RStatus of Confirmations (Pension Receipt Notifications)15REFIDReference Notification (Internal ID)nvarchar320
TOPContract Accounts Receivable and Payable
14DFKKDOCFI-CA DMS: Administrative Data of Documents27REFIDDMS: Reference ID of Document (Example: Barcode)nvarchar300
TOPGlobal Performance Analysis Transaction ST3
15AMHDGlobal Performance Analysis: Header Data Log Operation7REFIDLog ID for Cross-System Performance Analysisnvarchar400
16AMHDTGlobal Performance Analysis: Texts for Log Operation3REFIDLog ID for Cross-System Performance Analysisnvarchar400
17AMIDCTest Case Names for Log ID1REFIDLog ID for Cross-System Performance Analysisnvarchar400
18AMIDTLog IDs (Global Performance Analysis)1REFIDLog ID for Cross-System Performance Analysisnvarchar400
19AMIDTPLink to Texts for Reference ID (Log Global Perf. Analysis)1REFIDLog ID for Cross-System Performance Analysisnvarchar400
TOPInterface to External Payroll Systems
20PA0491HR Master Record: Infotype 49148REFIDOutsourcing reference identifiernvarchar200
TOPInventory Management
21MMIM_PREDOC_ORGParked Material Documents, Organizational Data11REFIDNotes for held datanvarchar400
TOPKorea
22PA0541HR Master Record: Infotype 054130REFIDExemption by Income tax law/Tax exemption regulation lawnvarchar10
TOPPatient Management
23NTMNIS-H: Patient-Specific Appointments (Header Table for NAPP)30REFIDIS-H: Reference Number of Next Appointmentnvarchar100
TOPProduct Cost Planning
24KEKOProduct Costing - Header Data119REFIDReference Variantnvarchar20
25TCK03Costing Variants39REFIDReference Variantnvarchar20
26TCK31Reference Cost Estimate2REFIDReference Variantnvarchar20
27TCK31TReference Cost Estimate Texts2REFIDReference Variantnvarchar20
TOPRecruitment
28PB4003Infotype 4003: Applicant Activities29REFIDReference activity IDnvarchar40
TOPWork Center
29KAKOCapacity Header Segment21REFIDCapacity IDnvarchar80