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

57 columns | Print definition?ERP 6.0  | LINK_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CMCBD_BRF_HSTRYCash Budget Workflow History for BRF+3LINK_ID16 Byte UUID in 32 Characters (Hexadecimal Encoded)nvarchar320
2CMCBD_BRF_LINKSCash Budget Workflow Node Links for BRF+3LINK_ID16 Byte UUID in 32 Characters (Hexadecimal Encoded)nvarchar320
3CMCBD_TK_LINKSBRF+ Workflow Task and Link Mapping Table4LINK_ID16 Byte UUID in 32 Characters (Hexadecimal Encoded)nvarchar320
4GRFNCASEISCase table of Issue4LINK_IDObject IDnvarchar500
5RSBPCB_SOBJ_LKBPC: Semantic object link4LINK_IDntext10737418230
6ZLINK_DETAILSLink Details2LINK_IDLink IDnvarchar200
7ZTRANSACTIONTransaction detail( Link/Lane)3LINK_IDLink IDnvarchar200
TOPApplication Frame
8CRMC_UI_BR_WCLTTitles of Work Center Links on Business Role Level5LINK_IDLogical Link IDnvarchar100
9CRMC_UI_CMP_MAPDefine Generic Outbound Plug Mapping7LINK_IDLogical Link IDnvarchar100
10CRMC_UI_CMP_PLUGDefine Specific Outbound Plug Mapping8LINK_IDLogical Link IDnvarchar100
11CRMC_UI_DLG_AAssign Links To Direct Link Group3LINK_IDLogical Link IDnvarchar100
12CRMC_UI_GEN_MAPComponent Specific Override of Generic Outbound Plug Mapping8LINK_IDLogical Link IDnvarchar100
13CRMC_UI_LLINKDefine Logical Link2LINK_IDLogical Link IDnvarchar100
14CRMC_UI_LLINK_TLogical Link Definition2LINK_IDLogical Link IDnvarchar100
15CRMC_UI_NBDefine Navigation Bar Profile3LINK_IDDefault Logical Link IDnvarchar100
16CRMC_UI_NKSTable of CRM keyboard shortcuts3LINK_IDLogical Link IDnvarchar100
17CRMC_UI_ROLE_DL1Display Direct Links per Role5LINK_IDLogical Link IDnvarchar100
18CRMC_UI_ROLE_DL2Display Direct Links per Role4LINK_IDLogical Link IDnvarchar100
19CRMC_UI_ROLE_DLGDisplay Direct Links per Role4LINK_IDLogical Link IDnvarchar100
20CRMC_UI_ROLE_DLTDirect Link Titles on Business Role Level4LINK_IDLogical Link IDnvarchar100
21CRMC_UI_ROLE_WCWork Center Link Details per Role5LINK_IDLogical Link IDnvarchar100
22CRMC_UI_ROLE_WC1Displayed Links per Role6LINK_IDLogical Link IDnvarchar100
23CRMC_UI_ROLE_WC2Displayed Links per Role5LINK_IDLogical Link IDnvarchar100
24CRMC_UI_TLINKTechnical Link Definition2LINK_IDTechnical Navigation Link IDnvarchar100
25CRMC_UI_WCDefine Work Center4LINK_IDLogical Link IDnvarchar100
26CRMC_UI_WCLG_AAssign Links To Work Center Link Group3LINK_IDLogical Link IDnvarchar100
27CRMC_UI_WDG_L_AWidgets Links/Groups Assignment3LINK_IDWeb Link (URL) IDnvarchar100
28CRMC_UI_WEB_LExternal Links (URLs)2LINK_IDWeb Link (URL) IDnvarchar100
29CRMC_UI_WEB_L_AExternal Links/Groups Assignment3LINK_IDWeb Link (URL) IDnvarchar100
30CRMC_UI_WEB_L_TExternal Links Text (URLs Labels)2LINK_IDWeb Link (URL) IDnvarchar100
31CRMS_UI_TLINKTechnical Link Definition1LINK_IDTechnical Navigation Link IDnvarchar100
TOPASAP AcceleratedSAP
32IALINKSAssignment IA Link - LOIO1LINK_IDUnique ID - 32 charactersnvarchar320
33IALINKSTTexts for URL assignments2LINK_IDUnique ID - 32 charactersnvarchar320
34IALINKTRANLinks with Transactions1LINK_IDUnique ID - 32 charactersnvarchar320
35IALINKURLSLinks with Web Addresses1LINK_IDUnique ID - 32 charactersnvarchar320
TOPCapacity and Resource Planning
36/MRSS/D_EBL_LINKEnable Links in the Left Frame2LINK_IDDummy for B20 int1 (Local Everywhere)tinyint30
TOPClinical System
37N2GL_ITEM_LINKIS-H*MED: Connection3LINK_IDConnector IDnvarchar320
TOPCollaborative Cross Applications
38/POA/D_BUI_LINKSTable of Links in BUI Persistence3LINK_IDResource IDnvarchar320
TOPCross-System and Cross-Partner Document Flow
39/SCMB/DF_DNETDocument Flow: Attribute 'Network ID'2LINK_IDSOBL: GUIDvarbinary160
40/SCMB/DF_DQTYDocument Flow: Attribute 'Quantity'2LINK_IDSOBL: GUIDvarbinary160
41/SCMB/DF_DVALUEDocument Flow: Value2LINK_IDSOBL: GUIDvarbinary160
TOPGovernance, Risk and Compliance
42GRFNLINKURLs for related links2LINK_IDObject IDnvarchar80
43GRFNLINKTtext table of GRPCLINK3LINK_IDObject IDnvarchar80
44GRPCLINKURLs for related links2LINK_IDObject IDnvarchar80
45GRPCLINKTtext table of GRPCLINK3LINK_IDObject IDnvarchar80
TOPLoans Management
46/FSIH/LINKTable of Links Between Loan and Insurance Policy2LINK_IDKey for Link Between Loan and Insurance Policyvarbinary160
TOPOLAP Technology
47RSDDTPS_HIER_IDXPolestar Hierarchy Indexes10LINK_IDIndex IDnvarchar640
TOPPortfolio Management
48/RPM/OBJ_LINKIDMaintain Object-LinkId Relation3LINK_IDProject Info:Portal Page Idnvarchar40
49RPM_GROUP_LINKSProject Info Iview: Group Links3LINK_IDProject Info:Portal Page Idnvarchar40
50RPM_PAGE_IDProject Info : Table for Portal Page Id's2LINK_IDProject Info:Portal Page Idnvarchar40
51RPM_PAGE_ID_TProject Info:Portal Page Id Text3LINK_IDProject Info:Portal Page Idnvarchar40
TOPProcess Controls
52GRPCNWBCLINKLinks2LINK_IDLink IDnvarchar100
53GRPCNWBCLINKTLink Texts3LINK_IDFolder IDnvarchar100
54GRPCNWBCMETATask - Link Mapping2LINK_IDLink IDnvarchar100
TOPPublic Sector Contract Accounts Receivable and Payable
55TFMCA_LINKSCustomizing Table for Links4LINK_IDSequence Number for Linknvarchar30
56TFMCA_LINKSTCustomizing Table for Language-Dependent Texts for Services5LINK_IDNumc3, internal usenvarchar30
TOPSAP Utilities
57EMMAC_WUI_REPBPEM: Navigation Repository5LINK_IDLogical Link IDnvarchar100