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

74 columns | Print definition?ERP 6.0  | GROUPING

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000149000PSA for 0DPR_TASK_ATTR T90CLNT090 Task Attributes10GROUPINGnvarchar400
2/BIC/B0000151000PSA for 0DPR_PROJECT_ATTR T90CLNT090 Proj. Def. Attr.11GROUPINGnvarchar400
3/BIC/B0000152000PSA for 0DPR_PHASE_ATTR T90CLNT090 Phase Attributes9GROUPINGnvarchar400
4BBP_PD_INITCHECKDescription of the PD Sets by Object Type7GROUPINGSpecifies if an Item is a Lot or Under a Lotnvarchar10
5J_1UF_TPTransfer pricing: main customizing table9GROUPINGGroup Tansactionsnvarchar10
6J_3RF_TPTransfer pricing: main customizing table10GROUPINGGroup Tansactionsnvarchar10
7TJPESS_COM_HELPJP ESS Help Text or Reference Information about ESS Forms3GROUPINGJP ESS Form Section or Pushbuttonnvarchar10
TOPActual Update and Commitment Update
8GTR_TRANSLATORGrantor: Translator of CRM and ERP Integration Attributes9GROUPINGNumc3, internal usenvarchar30
TOPAudit Management
9PLMM_AUDITAudit6GROUPINGGroupingnvarchar400
10PLMM_AUDITPLANAudit Plan5GROUPINGGroupingnvarchar400
11PLMM_AUDIT_ACTAudit - Corrective Action4GROUPINGGroupingnvarchar400
12PLMM_QUEST_HQuestion List14GROUPINGGroupingnvarchar400
13PLMM_QUEST_IQuestion List Item9GROUPINGGroupingnvarchar400
14PLMM_QUEST_RESAudit Question/Reply List/Item15GROUPINGGroupingnvarchar400
TOPCapacity Leveling
15TCY31DTText table for groupings per layout and chart5GROUPINGDescription of a grouping per layout and chartnvarchar100
16TCY31_CDefinition of charts for layout5GROUPINGDescription of a grouping per layout and chartnvarchar100
17TCY31_DDescription of a grouping per layout and chart4GROUPINGDescription of a grouping per layout and chartnvarchar100
18TCY31_EDefinition of a grouping per layout and chart4GROUPINGDescription of a grouping per layout and chartnvarchar100
TOPClinical System
19N2ET2PMD: Definite Elements (Part 2)17GROUPINGPMD: Element Groupingnvarchar200
20N2KAPMD: Catalog Entries for Combo Boxes9GROUPINGPMD: Grouping in N2KA (Combo)nvarchar600
TOPCommon Functions
21INM_OF_FCATField catalog information3GROUPINGGroup of Object Typesnvarchar150
TOPConnection to External Systems
22DPR_MSP_EXT_ATTRMapping of extended attributes field name and field id3GROUPINGGroup of Object Typesnvarchar150
TOPContent Activation
23BSANLY_BCCREP_IBCC Repository Content Objects5GROUPINGCollection Grouping of BI Content Objectsnvarchar30
TOPContract Accounts Receivable and Payable
24DFKKBRPOPSALBalance reporting: Businesspartner balances6GROUPINGGrouping criterionnvarchar100
25DFKKBRPOPSALHDBalance reporting: Businesspartner balances header6GROUPINGGrouping criterionnvarchar100
TOPControlling
26IAOM_CPRO_EXATExternal Characteristics of an Object in cProjects11GROUPINGGroupingnvarchar400
TOPData Staging
27RSTRANTransformation30GROUPINGBooleannvarchar10
28RSTRANFIELDPROPField Properties Within Transformation (obsolete?)8GROUPINGBooleannvarchar10
TOPDocument Management Services
29SDOKCLPROPSDOK: Assessable attributes dependent on document class12GROUPINGGrouping attributesnvarchar30
TOPDSD Connector
30/DSD/ME_CPT_CHANDSD CN: Channel9GROUPINGDSD Connector: Key for Cockpit Groupsnvarchar200
31/DSD/ME_CPT_GRPDSD CN: Groups for Mobile Devices2GROUPINGDSD Connector: Key for Cockpit Groupsnvarchar200
32/DSD/ME_CPT_GRPTDSD CN: Mobile Device Group Description3GROUPINGDSD Connector: Key for Cockpit Groupsnvarchar200
33/DSD/ME_GEN_CUSTDSD CN: General Setting for Mobile Devices2GROUPINGDSD Connector: Key for Cockpit Groupsnvarchar200
34/DSD/ME_ROLE_GRPDSD CN: Assignment of roles to a group of devices2GROUPINGDSD Connector: Key for Cockpit Groupsnvarchar200
TOPEmployee Interaction Center
35THREIC_GROUPINGEIC Grouping2GROUPINGEIC: Employee Groupingnvarchar40
36THREIC_GROUP_CATAssignment EIC Grouping - Category2GROUPINGEIC: Employee Groupingnvarchar40
37THREIC_GROUP_DETEIC Grouping Detail2GROUPINGEIC: Employee Groupingnvarchar40
38THREIC_GROUP_TEIC Grouping - Texts3GROUPINGEIC: Employee Groupingnvarchar40
39THREIC_GRP_PROFAssignment Authentication Profile - Grouping2GROUPINGEIC: Employee Groupingnvarchar40
TOPEvaluations
40DPR_DASHBOARDDashboard Data for Project36GROUPINGGroupingnvarchar400
TOPFinland
41T7FIVACWage types, constants and rules for Vacation Statement2GROUPINGReturn valuenvarchar20
TOPGlobal Trade Services
42/SAPSLL/CTSGENLegal&Logistics Services: Generic Part of Customs Tariff No.12GROUPINGDashes of LLNS Numbersnvarchar100
43/SAPSLL/CTSNUMCustoms Tariff Number12GROUPINGDashes of LLNS Numbersnvarchar100
44/SAPSLL/CTSNUMCL & L Services - Country-Specific Customs Tariff No.13GROUPINGDashes of LLNS Numbersnvarchar100
TOPJapan
45TJPESS_COM_GROUPJP ESS IT0559 Subtype Grouping3GROUPINGJP ESS IT0559 Subtype Groupingnvarchar10
46TJPESS_INT_GROUPJP ESS IT0559 Interval Grouping2GROUPINGJP ESS IT0559 Subtype Groupingnvarchar10
TOPliveCache Applications
47MMRP_LCC_DPNDDependencies of liveCache Routines4GROUPINGtinyint30
TOPLocalization
48IDITSR12_SELECTIntern.Trade Statistic Reporting(Austria):Selection Criteria11GROUPINGGrouping for Assignment to Reporting Category/Subcategorynvarchar30
49IDITSR_SELECTIntern. Trade Statistic Reporting: Selection Criteria10GROUPINGGrouping for Assignment to Reporting Category/Subcategorynvarchar30
TOPLogistics Basic Data
50WRF_REF_MODULEHeader Data for a Reference Module13GROUPINGMaterial Grouping of the Reference Modulenvarchar200
TOPMaster Data Synchronization
51CVIC_CUST_TO_BP1Setting for Numbering for Customer According to BP3GROUPINGBusiness Partner Groupingnvarchar40
52CVIC_VEND_TO_BP1Setting for Numbering for Vendor According to BP3GROUPINGBusiness Partner Groupingnvarchar40
TOPMaterial Master
53WER_TEST_ARTICLESubset of articles used for testing6GROUPINGMaterial Groupnvarchar90
TOPMetadata Repository
54RSOCOLLECTGRPBW Repository: Object Type Grouping1GROUPINGBW Repository: Grouping of types when collecting objectsnvarchar30
TOPObject Links
55DPR_OBL_OBGRPGroup of Object Types2GROUPINGGroup of Object Typesnvarchar150
56DPR_OBL_OBGRP_TName of Grouping of Object Types3GROUPINGGroup of Object Typesnvarchar150
57DPR_OBL_OBTYPProperties of Object Link to Object Type18GROUPINGGroup of Object Typesnvarchar150
TOPProduction and Revenue Accounting
58OIUCM_LV_GROUPTList Viewer Group Definition2GROUPINGJil Groupingnvarchar30
59OIUCM_LV_JILSlist viewer - jil table3GROUPINGJil Groupingnvarchar30
60OIUCM_LV_MAINGRPlist viewer - group table1GROUPINGJil Groupingnvarchar30
TOPRemaining Beverage - Obsolete Objects
61/DSD/ME_CPT_C_SUGroup Customizing for DSD HH11GROUPINGDSD Connector: Key for Cockpit Groupsnvarchar200
62/DSD/ME_CPT_GROUChannel Groups2GROUPINGDSD Connector: Key for Cockpit Groupsnvarchar200
63/DSD/ME_CPT_ROLEDSD Roles3GROUPINGDSD Connector: Key for Cockpit Groupsnvarchar200
TOPSAP Business Workflow
64SWN_CATEGORYWF Notif: Category8GROUPINGCollective Messagenvarchar10
TOPSAP NetWeaver Mobile - Use subcomponents
65MEREP_507Conversation Control (Mobile ID)12GROUPINGGroup Messagesnvarchar10
TOPStructure
66DPR_CHECKLIST_HChecklist Header9GROUPINGGroupingnvarchar400
67DPR_CHECKLIST_IChecklist Items8GROUPINGGroupingnvarchar400
68DPR_PHASEPhase8GROUPINGGroupingnvarchar400
69DPR_PROJECTProject Definition10GROUPINGGroupingnvarchar400
70DPR_TASKTasks9GROUPINGGroupingnvarchar400
TOPTime Sheet
71CATS_DEF_ACCOUNTCATS Default Accounting5GROUPINGDefault Accounting Groupint100
72CATS_MY_PUSHCATS notebook: Synchronize Static Objects6GROUPINGnvarchar20
TOPTransfer to Financial Accounting
73TRACC_GROUPDefinition of Grouping Characteristic Values3GROUPINGGrouping Characteristic for Acct Assignment Ref. Definitionnvarchar80
74TRACC_GROUP_TDescription of Grouping Characteristic Values3GROUPINGGrouping Characteristic for Acct Assignment Ref. Definitionnvarchar80