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

53 columns | Print definition?ERP 6.0  | PARID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1EDP21OPTIONSPartner Profile: Options9PARIDParameter IDnvarchar200
2N1OBNPARi.s.h.med: Test OBN Parameters (Obsolete)2PARIDUUID in character formnvarchar320
3RSCRMPARAMSRSCRM: Parameters for Report Interface1PARIDUUID in character formnvarchar320
4T021QFast Entry Line Layout: Control13PARIDParameter IDnvarchar30
5T5FDSNPADEFNom des paramètres DSN1PARIDNom du paramètrenvarchar160
6T5FDSNPADEFTDescription des paramètres DSN2PARIDNom du paramètrenvarchar160
7T5FDSNPAVALTable des paramètres DSN5PARIDNom du paramètrenvarchar160
8TCER1Parameter ID for rounding and additional value keys3PARIDParameter IDnvarchar60
TOPAuthentication and SSO
9USR05User Master Parameter ID3PARIDSet/Get parameter IDnvarchar200
TOPClinical System
10N1DCS_AGR_RANGEDCS: Quick Entry of Settings for Roles (Ranges)4PARIDParameter Name (for Quick Entry)nvarchar150
11N1DCS_OUIS-H*med: DCS: OU-Related Quick Entry Control4PARIDDCS: Parameter Name (for Quick Entry)nvarchar150
12N1DCS_PAR_DEFIS-H*med: DCS: Quick Entry: Parameter Definition1PARIDDCS: Parameter Name (for Quick Entry)nvarchar150
13N1DCS_USRIS-H*med: DCS: Quick Entry: Settings for User4PARIDDCS: Parameter Name (for Quick Entry)nvarchar150
14N1DCS_USR_RANGEIS-H*MED: DCS: Quick Entry User Settings (Ranges)4PARIDDCS: Parameter Name (for Quick Entry)nvarchar150
15N1PRECAPPPARi.s.h.med: Patient Record, Application Parameters2PARIDUUID in character formnvarchar320
16N2F4_HIT_HEADERIS-H*MED: Hdr Data of Hit Lists for Dynamic Input Help (F4)24PARIDParameter valuenvarchar400
TOPComputer Aided Process Planning
17PLPHCAPP: Sub-operations20PARIDParameter IDnvarchar60
18TZARTValue types for CAPP3PARIDParameter IDnvarchar60
TOPFinancial Accounting
19/OPT/VIM_1HEADDocument Header222PARIDPartner ID (Customer, Vendor, Business Place)nvarchar100
TOPGermany
20T77PAY00_GPAAssignment of Subapplication SPA/GPA Parameters4PARIDSet/Get parameter IDnvarchar200
TOPGlobal Trade Services
21/SAPSLL/CUSWLDCustoms Processing: Procedures Completed for Customs Decl.19PARIDParent ID for Transfer Postingsnvarchar100
22/SAPSLL/CUSWLOWorklist for Transactions with Reference to Delivery or PO19PARIDParent ID for Transfer Postingsnvarchar100
TOPLocalization
23J_1BNFDOCNota Fiscal Header31PARIDPartner ID (Customer, Vendor, Business Place)nvarchar100
24J_1BNFE_ACTIVEElectronic Nota Fiscal: Actual Status25PARIDPartner ID (Customer, Vendor, Business Place)nvarchar100
25J_1BNFNADNota Fiscal partners4PARIDPartner ID (Customer, Vendor, Business Place)nvarchar100
TOPMaintenance Orders
26/MRSS/D_SQM_KPQualification Catalog: Items5PARIDQualification Numbernvarchar100
TOPMusing Tools
27WDKCUSTSGPARAMMapping Customing Keys => SPA/GPA1PARIDSet/Get parameter IDnvarchar200
28WDKSTATFIELDSStatistical information of component context nodes5PARIDSet/Get parameter IDnvarchar200
TOPPatient Management
29NWVIEW_A05IS-H: Clinical Process Builder - Selection for Appt List4PARIDIS-H: Appointments - Parameter IDnvarchar100
TOPPayroll
30T5T4DConfiguration of parameters of reports4PARIDParameter identifiernvarchar30
31T5T4EText of report parameters5PARIDParameter identifiernvarchar30
32T7RO4DReporting engine - Parameters4PARIDParameter identifiernvarchar30
33T7RO4EReporting engine - Parameter texts5PARIDParameter identifiernvarchar30
34T7SI4DConfiguration of parameters of reports4PARIDParameter IDnvarchar30
35T7SI4EText of report parameters5PARIDParameter IDnvarchar30
36T7SK4DConfiguration of parameters of reports4PARIDParameter identifiernvarchar30
37T7SK4EText of report parameters5PARIDParameter identifiernvarchar30
TOPPerformance Assessment Workbench
38SLS_CEVENTPAW - Comments for an event8PARIDParticipant IDnvarchar450
39SLS_CPETPAW -Comments for an event / test / participant assignment5PARIDParticipant IDnvarchar450
40SLS_CRITEMPAW - Comments for an item from a participant5PARIDParticipant IDnvarchar450
41SLS_CXETPAW - Comments for an event / test assignment8PARIDParticipant IDnvarchar450
42SLS_PARINFPAW - Participant Information4PARIDParticipant IDnvarchar450
43SLS_PARTICPAW - Participants3PARIDParticipant IDnvarchar450
44SLS_PETPAW - Person/Event/Test Relationship Table4PARIDParticipant IDnvarchar450
TOPRisk Analysis
45JBRANTYPERM: Evaluation Category (Internal for Program Generation)3PARIDRM: Use Parameter IDs (Report Generation)nvarchar10
TOPSAP Healthcare - Industry-Specific Components for Hospitals
46/ISHFR/PARAMIS-H FR: System Control Parameters (Instit.- and Time-Dep.)3PARIDIS-H FR: Parameter Namenvarchar100
47N2PRZ_OPS_HEADIS-H*MED: Label for SPC Catalog5PARIDSet/Get parameter IDnvarchar200
48NWATPARAMIS-H AT: Systemsteuerungsparameter (einr. - und zeitabh.)3PARIDIS-H AT: Name des Parametersnvarchar100
TOPUSA
49T5UPBSPA02Nature of Action Attributes3PARIDVariable text idnvarchar10
50T5UPBSPA04Legal Authority Attributes (PS)3PARIDVariable text idnvarchar10
51T5UPBSPA06Remark Code Attributes (PS)3PARIDVariable text idnvarchar10
TOPWork Center
52TC20"Formula Parameters"2PARIDParameter IDnvarchar60
53TC20TText for parameter ID3PARIDParameter IDnvarchar60