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

95 columns | Print definition?ERP 6.0  | PNAME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/IBS/CRB_ISEVENTRBD: Processing Events Information System4PNAMERBD: Program Namenvarchar400
2CNVCMIS_A_1_FUNCFunc type Repository Analysis7PNAMEProgram Namenvarchar400
3CNVMBTCR_GPCHECKSelected Global Parameters used in Checking Rule fumod2PNAMECharacter field of length 40nvarchar400
4CNVMBTGLOBPARAMTable of global parameters for DMIS1PNAMECharacter field of length 40nvarchar400
5CNVMBTGLOBPARAMTGlobal parameter text table1PNAMECharacter field of length 40nvarchar400
6CNVMBTGPHISTHistory of global parameters1PNAMECharacter field of length 40nvarchar400
7CNVMBTMODIFINFOMBT PCL: Setting for modifiable system information4PNAMEnvarchar400
8CNVMBTPARAMSTable for storing general parameters3PNAMECharacter field of length 40nvarchar400
9CNVTDMS_14_PARAMTable for storing general parameters4PNAMECharacter field of length 40nvarchar400
10T52CXCross References via Generated Schemas2PNAMEName of subschema last changednvarchar40
11T5FPBSD1Décision - Sous-écran6PNAMENom de programmenvarchar400
12T5FPBSTM1Mouvements TG5PNAMENom de programmenvarchar400
13T5UPBSPOOLTSick Leave Pool Text Table4PNAMEAbsence Pool Namenvarchar400
14TNDCV_SCRGeneric Screen Definition1PNAMEModule Name for Generic Screen Definitionnvarchar400
15TNDCV_SCR_DEFCGeneric Screen Definition (Layout)1PNAMEModule Name for Generic Screen Definitionnvarchar400
16TNDCV_SCR_DEFLGeneric Screen Definition (Line Layout)1PNAMEModule Name for Generic Screen Definitionnvarchar400
17TPF03Field Names Profile Parameters in TPF01, TPF021PNAMEName of the Profile Parameternvarchar400
18TSP0ASpool: Device types5PNAMESpool: Namenvarchar300
TOPBasic Data
19TN17JIS-H: Protectable Fields in NV20001PNAMEIS-H: Module Pool Namenvarchar400
20TNDCVIS-H: Screen Fields Dependent on Country Version2PNAMEIS-H: Module Pool Namenvarchar400
21TNDYMIS-H: Screen Modifications3PNAMEIS-H: Module Pool Namenvarchar400
TOPClaims Management
22IMP_PARAMETERS_1IMP: Trigger (Runtime)5PNAMEIMP: Parameter Name (Free Format)nvarchar300
23TIMP130IMP: Permitted Parameters per Trigger Cat.f.IMP_PARAMETERS_14PNAMEIMP: Parameter Name (Free Format)nvarchar300
24TIMP140IMP: No Apparent Usage - Purpose Unclear3PNAMEIMP: Parameter Name (Free Format)nvarchar300
TOPClinical System
25N1PRPATLOGIS-H*MED: PATREG: Fehlerprotokoll für Patientenstammdaten6PNAMEPATREG: Hastanin adi ve soyadinvarchar600
26N2EXTLOADIS-H*MED: External programs1PNAMECharacter field, length 32nvarchar320
TOPContract Accounts Receivable and Payable
27DFKK_DB_TRACEManagement of Trace Data1PNAMEABAP Program Namenvarchar400
28DFKK_TCO_PARTest Cockpit: eCATT Import Parameters (for ECATT_EXECUTE)4PNAMEName of Parameter for eCATT Data Containernvarchar300
29DFKK_TCO_RESTest Cockpit: eCATT Export Parameters (= eCATT Results)5PNAMEName of a Parameter or Command Interfacenvarchar300
TOPContract Billing
30BREBI_BILLP_T002Paramters for Filter Functions2PNAMEParameter Namenvarchar80
TOPCorporate Performance Monitor
31UMC_CUSTGeneral Settings3PNAMEParameter Namenvarchar300
TOPeCATT Extended Computer Aided Test Tool
32ECSCR_DATAValues for eCATT Script Parameters3PNAMEName of a Parameter or Command Interfacenvarchar300
33ECSCR_PARDefinition of eCATT Script Parameters and Variables3PNAMEName of a Parameter or Command Interfacenvarchar300
34ECSCR_PEXTExtended Definition of Parameters of an eCATT Script3PNAMEName of a Parameter or Command Interfacenvarchar300
35ECSCR_SUT_MDObject Under Test Metadata3PNAMEName of a Parameter or Command Interfacenvarchar300
36ECSCR_XMLDefinition/Data of Structured eCATT Parameter (XML)3PNAMEName of a Parameter or Command Interfacenvarchar300
37ECSCR_XML_STRDefinition/Data of Structured Param. of eCATT (XML) STRING3PNAMEName of a Parameter or Command Interfacenvarchar300
38ECSCR_XML_STR_WDDefinition/Data of eCATT (XML) STRING for WD UI Tree3PNAMEName of a Parameter or Command Interfacenvarchar300
39ECSP_PARDefinition of eCATT Test Run Parameters and Variables3PNAMEName of a Parameter or Command Interfacenvarchar300
40ECSP_PAR_DATAValues for eCATT Test Run Data Parameters3PNAMEName of a Parameter or Command Interfacenvarchar300
41ECSP_PAR_XMLDefinition/Data for Structured Param. - Test Run Data3PNAMEName of a Parameter or Command Interfacenvarchar300
42ECSP_PAR_XML_STRDefinition/Data of Structured Param. of TRD (XML) STRING3PNAMEName of a Parameter or Command Interfacenvarchar300
43ECTC_DATAAssignment of TD Parameters to eCATT Interface3PNAMEName of a Parameter or Command Interfacenvarchar300
44ECTC_XMLDefinition/Data of Struct. Parms of a Test Config. (XML)3PNAMEName of a Parameter or Command Interfacenvarchar300
45ECTC_XML_STRDefinition/Data of Struct. Param. of Test Conf. (XML) STRING3PNAMEName of a Parameter or Command Interfacenvarchar300
46ECTD_DATAValues for Test Data Container Parameters3PNAMEName of a Parameter or Command Interfacenvarchar300
47ECTD_DATAXValues for Parameters of Test Data Containers (AUNIT)3PNAMEName of a Parameter or Command Interfacenvarchar300
48ECTD_PARDefinition of Test Data Container Parameters3PNAMEName of a Parameter or Command Interfacenvarchar300
49ECTD_TEXTeCATT Short Texts: Parameters/Variants5PNAMEName of a Parameter or Command Interfacenvarchar300
50ECTD_TEXT_NeCATT Short Texts Parameters/Variants Not Language-Specific4PNAMEName of a Parameter or Command Interfacenvarchar300
51ECTD_XMLDefinition/Data for Structured Param. - Test Data Container3PNAMEName of a Parameter or Command Interfacenvarchar300
52ECTD_XML_STRDef./Data of Struct. Param. of Test Data Cont. (XML) STRING3PNAMEName of a Parameter or Command Interfacenvarchar300
TOPFramework
53CRMC_IC_XMLSTOREXML storage for IC applications5PNAMEProgram Namenvarchar400
54CRMC_IC_XMLSTORXXML storage for IC applications5PNAMEProgram Namenvarchar400
55CRMD_IC_XMLSTOREXML storage for IC applications5PNAMEProgram Namenvarchar400
56CRMD_IC_XMLSTORXXML storage for IC applications5PNAMEProgram Namenvarchar400
TOPFunction Builder
57RSINFDIRInactive table for TFDIR and ENLFDIR2PNAMEProgram Namenvarchar400
TOPFunds Management
58FMRESUPDCStatus Table for Conversion Programs7PNAMEUser Namenvarchar120
TOPIntegrated Product and Process Engineering
59PNODEPositionsknoten in der PVS4PNAMEBezeichnung iPPE-Knotennvarchar400
60PNODIDiPPE Node: Identification3PNAMEiPPE Node Descriptionnvarchar400
61PVSDEXExternal Indicator for Deleted PVS/iPPE Objects8PNAMEiPPE Node Descriptionnvarchar400
TOPNon Profit Organizations
62T7UN_T52CDSchema-Directory11PNAMEName des zuletzt geänderten Teilschemasnvarchar40
TOPNorway
63T5V6DSSB Position Code Description5PNAMESSB Position code descriptionnvarchar300
TOPOccupational Health
64T7EHS00_PROTTProtocol Text Table7PNAMEDescription of Health Surveillance Protocolnvarchar400
TOPOffice Suite Program
65/OSP/T_DUET_MENUDuet Menu Options6PNAMEProgram Namenvarchar400
TOPOnline Correction Support Support Package and Add-On Tools
66TFDIR_INIMAssignment of Function Module for Inactive Source Import2PNAMEProgram Namenvarchar400
TOPOrganizational Management
67T77COUser Interface2PNAMEProgram Namenvarchar400
TOPPayroll
68PA0729Personál.kmen.záznam Infotyp 072993PNAMEJméno referenta, který objekt zmenil.nvarchar120
69PB0729Personál.kmen.záznam Infotyp 072993PNAMEJméno referenta, který objekt zmenil.nvarchar120
70T5TELDPHR Cluster 215PNAMEProgram/Transaction in SQL Trace Evaluationnvarchar400
71T5TPSDPRESHR Cluster 19PNAMEABAP Program Namenvarchar400
72T5TPSTXT01Formuláre infotypu 0729 - doplnku opatrení12PNAME30 znakunvarchar300
73T5TREGHR Cluster 214PNAMEProgram/Transaction in SQL Trace Evaluationnvarchar400
74T5TREGSIHRCZ - insured register14PNAMEProgram/Transaction in SQL Trace Evaluationnvarchar400
TOPPayroll General Parts
75T52CCDirectory of Customer Schemas12PNAMEName of subschema last changednvarchar40
76T52CDSchema Directory12PNAMEName of subschema last changednvarchar40
TOPPerformance Assessment Workbench
77SLS_PRESPAW - Person Results Structure5PNAMEParticipant namenvarchar400
78SLS_QLOGPAW - Qualification Generation Log18PNAMEParticipant namenvarchar400
TOPPerformance Monitors TCC
79ORA_SAP_AUXSTATSOracle monitor: Copy of SAP_AUXSTATS3PNAMEOracle monitor: PNAMEnvarchar310
TOPPersonnel Administration
80T7PL13Ustawienia dla HCM Polska2PNAMENazwa Parametrunvarchar100
81T7PL13TTekst ustawien dla HCM Polska3PNAMENazwa Parametrunvarchar100
TOPPrint and Output Management
82TSPCPCDSCPC: Distribution status1PNAMEPrinter name for CPC printernvarchar300
83TSPCPCDSEExtended distribution status information1PNAMEPrinter name for CPC printernvarchar300
84TSPCPCFAVTarget Systems and Target System Groups as Favorite Targets1PNAMEPrinter name for CPC printernvarchar300
85TSPCPCPGCCPC: Printer group configuration1PNAMEPrinter name for CPC printernvarchar300
86TSPCPCPLCPC: List of CPC managed printers on central system1PNAMEPrinter name for CPC printernvarchar300
TOPProcess Controls
87GRPCCUSTCustomer Switches2PNAMEParameter Namenvarchar300
TOPSales and Distribution
88IPCDESTIPC Parameters for Destinations2PNAMEGeneral Parameter Namenvarchar320
TOPSAP Healthcare - Industry-Specific Components for Hospitals
89NWCHLS_NFALIS-H CH: ALIS-Fehlerhandlung - Falldaten (für Fall-API)6PNAMEIS-H: cognome pazientenvarchar300
TOPSecure Network Communications
90SNCSYSACLSNC Access Control List (ACL): Systems5PNAMESNC: Printable namenvarchar2550
91USRACLSNC Access Control List (ACL): User5PNAMESNC: Printable namenvarchar2550
92USRACLEXTExtended SNC Access Control List (ACL) for Users5PNAMESNC: Printable namenvarchar2550
TOPStructures Workbench
93/ISDFPS/MATSPPLNMaterials Planned for Force Element51PNAMEiPPE Node Descriptionnvarchar400
TOPSyntax, Compiler, Runtime
94TFDIRFunction Module2PNAMEProgram Namenvarchar400
TOPTravel Expenses
95PTRV_CCCError Receipts for Credit Card Clearing5PNAMEName of Employee From Credit Card Clearingnvarchar500