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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

100 columns | Print definition?ERP 6.0  | PURPOSE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1EHFNDD_PCHA_ROOTProcess Control - Root27PURPOSEProcess Purposenvarchar230
2EHFNDD_PTN_ROOT27PURPOSEProcess Purposenvarchar230
3EHFNDD_REQC_ROOTProcess Control - Root27PURPOSEProcess Purposenvarchar230
4EHFNDD_SDSE_ROOTProcess Control - Root27PURPOSEProcess Purposenvarchar230
5EHFNDD_TS_ROOTTime Series - Root17PURPOSETime Series Purposenvarchar20
6EHHSSD_CHAI_ROOTProcess Control - Root27PURPOSEProcess Purposenvarchar230
7EHHSSD_CINSP_RTControl Inspection - Root16PURPOSEProcess Purposenvarchar230
8EHHSSD_PCI_ROOTControl Inspection PCBO27PURPOSEProcess Purposenvarchar230
9EHHSSD_PRQ_ROOTProcess Control - Root27PURPOSEProcess Purposenvarchar230
10EHHSSD_PRSPS_RTProcess Control - Sample Shipment - Root27PURPOSEProcess Purposenvarchar230
11EHHSSD_RPL_ROOTProcess Control - Mass Replace Controls - Root27PURPOSEProcess Purposenvarchar230
12EHPRCC_CHECKCompliance requirement check9PURPOSEProcess Purposenvarchar230
13EHPRCC_EMLCCommunication Definition10PURPOSEProcess Purposenvarchar230
14EHPRCC_RLSRELRelease Relevant Levels11PURPOSEProcess Purposenvarchar230
15EHPRCD_BBT_ROOTProcess Control - Root28PURPOSEProcess Purposenvarchar230
16EHPRCD_PBB_ROOTProcess Control - Root28PURPOSEProcess Purposenvarchar230
17EHPRCD_PCA_ROOTProcess Control - Root27PURPOSEProcess Purposenvarchar230
18EHPRCD_PCR_ROOTProcess Control - Root28PURPOSEProcess Purposenvarchar230
19EHPRCD_PSA_ROOTProcess Control - Root28PURPOSEProcess Purposenvarchar230
20EHPRCD_PSI_ROOTProcess Control - Root28PURPOSEProcess Purposenvarchar230
21EPIC_DUM_TRANSACTransactions of Dummy Bank19PURPOSECommentnvarchar500
22GRRMPROPRESPONSETable for Response Proposal4PURPOSEResponse Proposal - Purpose - IDnvarchar10
23SRAL_EXP_LOGRAL expanded log - header table9PURPOSERAL: Purpose IDnvarchar100
24SRAL_LOGRead Access Logging: Log7PURPOSERAL: Purpose IDnvarchar100
25SRAL_LOG_GROUPSRAL: Log Group4PURPOSERAL: Purpose IDnvarchar100
26SRAL_LOG_PERFRead Access Logging: Log (modified version for performance)7PURPOSEnvarchar100
27VIYCSETTLSettlement Identification with Log Reference5PURPOSESettlement Purposenvarchar10
TOPABAP Authorization and Role Management
28URBAPILINKDefault BAPI link for central user administration2PURPOSEDistribution model definitionnvarchar100
TOPBusiness Objects, Common Components
29EHFNDC_PSE_STASteps Assignment4PURPOSEProcess Purposenvarchar230
30EHFNDD_PAM_ROOTProcess Control - Root28PURPOSEProcess Purposenvarchar230
31EHFNDD_PSE_LOGProcess Setup - Log11PURPOSEProcess Purposenvarchar230
32EHFNDD_PSE_ROOTProcess Setup - Root9PURPOSEProcess Purposenvarchar230
TOPClinical System
33N1BCRC2BCSMCBasic Cat.: Display Config. - Main Catalog Assignment6PURPOSEBasis Cat.: Purpose of Display Configurationnvarchar20
34N1MEORDERIS-H*MED: Medication, Medication Order84PURPOSEMedication: Purpose of Ordernvarchar10
35N1TPMEORDERIS-H*MED: Medication, Medication Order Template47PURPOSEMedication: Purpose of Ordernvarchar10
TOPCollaboration Folders
36CFX_VERSION_LOCKVersions Locked Against Changes3PURPOSECharacter field of length 40nvarchar400
TOPCross-System Tools
37SCDTSYSRFC_BIZGenerierte RFC-Destinationen3PURPOSEKlassifizierung der RFC-Destinationennvarchar100
TOPEnvironment, Health and Safety
38/TDAG/RCSA_EPRECEndpoint data records16PURPOSEPurposenvarchar20
TOPFinancial Accounting
39T001URLCompany Code-Dependent URLs4PURPOSEPurpose of URL Addressnvarchar200
TOPGlobal Trade
40TEAGLT_PURPOSE_MAssign Condition Type to Condition Purpose5PURPOSEPurpose of a PriceSpecificationElementnvarchar40
TOPIncident Workflow and Tasks
41EHHSSD_IAC_ROOTAction - Root16PURPOSEProcess Purposenvarchar230
42EHHSSD_IIL_ROOTProcess Control - Root27PURPOSEProcess Purposenvarchar230
43EHHSSD_IIS_ROOTProcess Control - Root27PURPOSEProcess Purposenvarchar230
44EHHSSD_PGI_ROOTProcess Control - Root27PURPOSEProcess Purposenvarchar230
45EHHSSD_PIA_ROOTProcess Control - Root27PURPOSEProcess Purposenvarchar230
46EHHSSD_PIC_ROOTProcess Control - Root27PURPOSEProcess Purposenvarchar230
47EHHSSD_PIH_ROOTProcess Control - Root27PURPOSEProcess Purposenvarchar230
48EHHSSD_PII_ROOTProcess Control - Root27PURPOSEProcess Purposenvarchar230
49EHHSSD_PIL_ROOTProcess Control - Root27PURPOSEProcess Purposenvarchar230
50EHHSSD_PIN_ROOTProcess Control - Root27PURPOSEProcess Purposenvarchar230
51EHHSSD_PIR_ROOTProcess Control - Root27PURPOSEProcess Purposenvarchar230
TOPLogistics - General
52TB2BATrading Contract: Application Status5PURPOSEStatus Purposenvarchar10
53TB2BETrading Contract: Trading Contract Type73PURPOSEPurpose of Trading Contractnvarchar20
54WBHKTrading Contract: Header Data111PURPOSEPurpose of Trading Contractnvarchar20
TOPManagement of Internal Controls
55HRP1804DB Table for InfoType 180419PURPOSEControl Purposenvarchar100
TOPProcess Controls
56HRP5304DB Table for Infotype 530419PURPOSEControl Purposenvarchar100
TOPProcess Foundation
57EHFNDC_NTFTPL_PAAssignment of Templates to Processes5PURPOSEProcess Purposenvarchar230
58EHFNDC_PROCDEFProcess Definitions (Processes and PCOs)3PURPOSEProcess Purposenvarchar230
59EHFNDC_PROCDEF_TTranslatable Table for Process Definition Descriptions4PURPOSEProcess Purposenvarchar230
TOPRecords and Case Management
60RMPSP_MDT_PDAMandate: Data Aquisition Purpose2PURPOSEMandate: Data Aquisition Purposenvarchar40
61RMPSP_MDT_PDATMandate: Data Aquisition Purpose3PURPOSEMandate: Data Aquisition Purposenvarchar40
TOPRegulatory reporting for insurance companies
62ISSR_RPI_MFTISSR: Feste und variable Daten Meldewesen64PURPOSEZweck der Kapitalanlage (des derivativen Geschäftes)nvarchar20
63TISSR_ADMN_PURPISSR: Definition Zweck der Kapitalanlage4PURPOSEZweck der Kapitalanlage (des derivativen Geschäftes)nvarchar20
64TISSR_ADMN_PURPTISSR: Text zum Zweck der Kapitalanlage5PURPOSEZweck der Kapitalanlage (des derivativen Geschäftes)nvarchar20
TOPRisk Assessment
65EHHSSD_PRA_ROOTAction PCBO for Risk Assesment27PURPOSEProcess Purposenvarchar230
66EHHSSD_RAC_ROOTRisk Assesment Actions16PURPOSEProcess Purposenvarchar230
TOPSAP Healthcare - Industry-Specific Components for Hospitals
67N2DWSWL_PROFProfile Template18PURPOSEUsage of a Profilenvarchar10
68N2DWSWL_PROF1Profile Template / Changes18PURPOSEUsage of a Profilenvarchar10
TOPService Charge Settlement
69TIVSCPURPOSEPurpose of Apportionment1PURPOSEPurpose of Apportionmentnvarchar30
70TIVSCPURPOSETWhat Is the Purpose of the Data Record (Text)2PURPOSEPurpose of Apportionmentnvarchar30
71TIVSCSCKEYSESettings per Settlement Purpose3PURPOSESettlement Purposenvarchar10
72TIVSCSUDEFAULTDefaults for Creating SU per SC Key3PURPOSEPurpose of Apportionmentnvarchar30
73VISCSETTLSettlement Identification with Log Reference5PURPOSESettlement Purposenvarchar10
74VISCSHAREOUTSplit settlement factors for settlement variant4PURPOSEPurpose of Apportionmentnvarchar30
75VISCS_MSU_RESTDistribution of Master SU to Remaining Objects9PURPOSEPurpose of Apportionmentnvarchar30
76VISCS_MSU_SUDistribution of Master SU to Participating SUs10PURPOSEPurpose of Apportionmentnvarchar30
77VISCS_RO_CNCosts and Measurement Amounts for REC + RO (Lease-Out View)9PURPOSEPurpose of Apportionmentnvarchar30
78VISCS_SU_ROSum of All Costs and Measurement Amounts for a Rental Object9PURPOSEPurpose of Apportionmentnvarchar30
79VISCS_SU_SUMSum of All Costs and Measurement Amounts for Settlment Unit8PURPOSEPurpose of Apportionmentnvarchar30
TOPTranslation Tools
80STRJ_WRK1Administration of Worklists for SLAT2PURPOSEObject Typenvarchar40
81TRACOLHRequest list of transport collector (header)2PURPOSEPurpose of tracus runnvarchar100
82TRACOLSYSTParameters for transport collector1PURPOSEPurpose of tracus runnvarchar100
83TRMFDIRTRM Table for Storing the Directory for Reorganization, etc.3PURPOSEPurpose of tracus runnvarchar100
84TRMIDXLog Entries for TRM Processing Runs3PURPOSEPurpose of tracus runnvarchar100
85TRMWRKAdministration of Worklists for the Proposal Pool3PURPOSEPurpose of tracus runnvarchar100
86TRNL_WLWorklists of Translation (Header Data)2PURPOSECharacter field, length 5nvarchar50
TOPTransport Organizer
87SI_RQ_CONTENTDescription of a file object4PURPOSEDeployment method of a file objectnvarchar300
88SI_RQ_CONTENTPTransport Preview: Description of a file object4PURPOSEDeployment method of a file objectnvarchar300
TOPWorkflows and Tasks for Risk Assessment
89EHHSSD_EVL_ROOTProcess Control - Root27PURPOSEProcess Purposenvarchar230
90EHHSSD_PRF_ROOTProcess Control - Root27PURPOSEProcess Purposenvarchar230
91EHHSSD_PRL_ROOTProcess Control - Root27PURPOSEProcess Purposenvarchar230
92EHHSSD_PRN_ROOTProcess Control - Root27PURPOSEProcess Purposenvarchar230
93EHHSSD_PRR_ROOTProcess Control - Root28PURPOSEProcess Purposenvarchar230
94EHHSSD_PRS_ROOTProcess Control - Root27PURPOSEProcess Purposenvarchar230
95EHHSSD_PRT_ROOTProcess Control - Root28PURPOSEProcess Purposenvarchar230
TOPWorkforce Management Core
96/SAPAPO/LRPGWAFNRFC Function Names of WFM GW Applications2PURPOSEPurpose with GWAnvarchar20
TOPWorkload Balancing and Group Management
97RGDEFDBMain Table for Resource Group Definitions2PURPOSERG: Purpose/Area of a Resource Groupnvarchar200
98RGDETAILSDetailed Resource Group Info and Properties2PURPOSERG: Purpose/Area of a Resource Groupnvarchar200
99RGLISTMEMResource Group: Assignments/Definition of Member's List Type2PURPOSERG: Purpose/Area of a Resource Groupnvarchar200
100RGPARAMParameters Associated with the Resource Group Quality2PURPOSERG: Purpose/Area of a Resource Groupnvarchar200