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

50 columns | Print definition?ERP 6.0  | OBLIGATORY

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000149000PSA for 0DPR_TASK_ATTR T90CLNT090 Task Attributes12OBLIGATORYnvarchar10
2/IAM/C_ACT_ACTActivity Templates for Activity Templates9OBLIGATORYObligatory Activitynvarchar10
3/IAM/C_ISS_ACTActivity Templates for Issue Types10OBLIGATORYObligatory Activitynvarchar10
4/IAM/D_ACT_ROOTRoot20OBLIGATORYObligatory Activitynvarchar10
5/SLOAP/SELOPT_GCNV AS Select Option Groups11OBLIGATORYSingle-Character Indicatornvarchar10
6/SLOAP/SELOPT_GTtransport table for /SLOAS/SELOPT_G13OBLIGATORYSingle-Character Indicatornvarchar10
7COMC_TEXT_PDDefinition of Text Determination Procedure9OBLIGATORYObligatory Textnvarchar10
8COMC_TEXT_PROTLog Text - Text Types6OBLIGATORYObligatory Textnvarchar10
9NWS_EXT_PARAMProgram Parameters9OBLIGATORYSelection indicatornvarchar10
10NWS_EXT_SELData Transport Management Tool SELECT OPTIONS8OBLIGATORYSelection indicatornvarchar10
11/BOBF/CONF_CLIMPInterface impl., instanciation etc. of configured classes5OBLIGATORYData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
TOPAccrual Engine
12TACE_EXISTEVENTSPossible Events in the Accrual Engine3OBLIGATORYFlag: Required Eventnvarchar10
TOPASAP AcceleratedSAP
13SPERSSORTPersonalization Table for ALV Tree Sort Order Tables11OBLIGATORYSingle-Character Indicatornvarchar10
TOPBusiness Package for Manager Self-Service FI
14FPB_LP6_R_TYP_CType of Report6OBLIGATORYSingle-Character Indicatornvarchar10
TOPContract Accounts Receivable and Payable
15DFKK_BRF050BRF: Parameters for Expressions That Access the Context13OBLIGATORYMissing Values Not Permittednvarchar10
TOPCross-Application Components
16/IXOS/DC_TACAAdministrator maintenance for Editing17OBLIGATORYObligatory field in the selection screennvarchar10
17/IXOS/DC_TAIAAdministrator maintenance for Creating14OBLIGATORYObligatory field in the selection screennvarchar10
18/IXOS/DC_TASASelectionscreen Administrator maintenance17OBLIGATORYObligatory field in the selection screennvarchar10
19/IXOS/DC_TASUSelectionscreen user maintenance14OBLIGATORYObligatory field in the selection screennvarchar10
TOPEnergy Data Management
20ERTPIFACETEMPAllocation of Reference Parameter to RTP Interface6OBLIGATORYParameter template is requirednvarchar10
TOPEvaluations
21DPR_DASHBOARDDashboard Data for Project44OBLIGATORYMandatorynvarchar10
TOPFSCM In-House Cash
22IHC_TAB_GUI_FLDIHC: Container Field in GUI9OBLIGATORYMandatory Fieldnvarchar10
TOPIncentive and Commission Management ICM
23TCACS_PROCESSTable for Available Processes6OBLIGATORYBoolean Variable (X=True, -=False, Space=Unknown)nvarchar10
TOPIntegrated Product and Process Engineering
24CPNMDLContext Relationships Between Node Types/External Objects6OBLIGATORYIndicator Node can Only Exist in Contextnvarchar10
TOPIntegration Customer Relationship Management
25ESALES_PSFIELDSField Properties for Set Type Attributes for each Product5OBLIGATORYEntries in the Fieldnvarchar10
TOPLink to Geographic Information System
26GCCFGBC: Parameters/Attributes13OBLIGATORYMandatory Parameternvarchar10
TOPLoans Management
27TDB23Activity Type - Control of Requirements5OBLIGATORYSelection field for required screen entriesnvarchar10
TOPMaster Data Framework
28DML_SETTYPEMDF: Properties of Set Types4OBLIGATORYObligatorynvarchar10
TOPOLAP Technology
29RSBBSCUBEMAPPINGFixed Mapping for BW-R/RI11OBLIGATORYBooleannvarchar10
30RSBBSQRYMAPPINGFixed Mapping for BW-R/RI12OBLIGATORYBooleannvarchar10
TOPProcess Management
31POC_DB_STEPDomain Model: Table for Step Basic Data10OBLIGATORYData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
TOPProfitability Analysis
32/EACA/TPMCGRP1PM Characteristics of a Characteristic Group8OBLIGATORYRequired Entrynvarchar10
33/EACA/TPMKGRP1Key Figure Groups - Key Figures7OBLIGATORYRequired Entrynvarchar10
TOPProject System
34SAVESORT_PS_LOGto save the sort for ps_log13OBLIGATORYSingle-Character Indicatornvarchar10
TOPPublic Sector Contract Accounts Receivable and Payable
35DFMCA_BRF050Parameter List of Expressions Accessing Context13OBLIGATORYShows Whether Missing Data is Allowednvarchar10
36DFMCA_BRF170BRF: Progressive Calculation16OBLIGATORYShows Whether Missing Data is Allowednvarchar10
37DFMCA_BRF171BRF: Progressive Calculation16OBLIGATORYShows Whether Missing Data is Allowednvarchar10
38DFMCA_BRF180BRF: Parameters for Value Request with Name of XML Node9OBLIGATORYMissing Values Not Permittednvarchar10
39DFMCA_BRF181BRF: Parameters for Value Request with Name of XML Node11OBLIGATORYMissing Values Not Permittednvarchar10
TOPReal Estate Contract
40TIVTMTERMTYPETerm Category4OBLIGATORYIs Term Type Required?nvarchar10
TOPRegulatory reporting for insurance companies
41TISSR_TP_ALVSORTISSR: Einstellung ALV-Grid Sortierkriterien14OBLIGATORYEinstelliges Kennzeichennvarchar10
TOPStructure
42DPR_CHECKLIST_IChecklist Items16OBLIGATORYMandatorynvarchar10
43DPR_TASKTasks11OBLIGATORYMandatorynvarchar10
TOPTable Maintenance Tool
44SDMEDPSCDME: Dialog Pool Component 'Selection' (Conditions)10OBLIGATORYDME: Required Field Flagnvarchar10
TOPTransaction Variant and Table Control Settings
45SHDFVTransaction variants: Field contents12OBLIGATORYFlag: Mandatory fieldnvarchar10
46SHDFVCITransaction variants: Field contents (cross-client)11OBLIGATORYFlag: Mandatory fieldnvarchar10
47SHDSVFVCIScreen variants: Field contents8OBLIGATORYFlag: Mandatory fieldnvarchar10
TOPTransport Organizer
48WBOATTRCTS: Request Attributes2OBLIGATORYAttribute Required for Requestsnvarchar10
49WBOATTRCCTS: Client-Specific Settings for Attributes3OBLIGATORYAttribute Required for Requestsnvarchar10
TOPWorkforce Management Core
50WFDS_QUA_REQQualification Requirements6OBLIGATORYRequirement Is Mandatorynvarchar10