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

29 columns | Print definition?ERP 6.0  | PRONR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1T7QA17HSponsor ID6PRONRCompany Representativenvarchar80
2ZPS1IDES Text Pools9PRONRProject definition (internal)nvarchar80
3ZPS1_OLDIDES: Assign text pool to standard structure9PRONRProject definition (internal)nvarchar80
TOPDSD Connector
4/DSD/ME_PRO_FBAMMDSD Promotions - Feedback Amounts in Connector3PRONRDSD Deal Conditions - Deal Condition Numbernvarchar100
5/DSD/ME_PRO_FBFGMDSD Promotions - Feedback Free Goods in Connector3PRONRDSD Deal Conditions - Deal Condition Numbernvarchar100
TOPGlobal Trade Services
6/SAPSLL/CUITCustoms Document: Item97PRONRProject Numbernvarchar200
7/SAPSLL/LCLICJLicense - Projects4PRONRProject Numbernvarchar200
8/SAPSLL/LCPROProject Master3PRONRProject Numbernvarchar200
TOPHandheld Connectivity
9/DSD/PR_ASGNMDSD Promotions - Promotion Assignment2PRONRDSD Deal Conditions - Deal Condition Numbernvarchar100
10/DSD/PR_FBAMMDSD Promotions - Feedback Amounts2PRONRDSD Deal Conditions - Deal Condition Numbernvarchar100
11/DSD/PR_FBFGMDSD Promotions - Feedback Free Goods2PRONRDSD Deal Conditions - Deal Condition Numbernvarchar100
12/DSD/PR_HEADMDSD Promotion - Promotion Header2PRONRDSD Deal Conditions - Deal Condition Numbernvarchar100
13/DSD/PR_HEAD_TMDSD Promotions - Promotion Description2PRONRDSD Deal Conditions - Deal Condition Numbernvarchar100
14/DSD/PR_PCLNMDSD Promotions - Promotion Precondition2PRONRDSD Deal Conditions - Deal Condition Numbernvarchar100
15/DSD/PR_RSAMMDSD Promotions - Promotion Result Amounts2PRONRDSD Deal Conditions - Deal Condition Numbernvarchar100
16/DSD/PR_RSFGMDSD Promotions - Promotion Result Free Goods2PRONRDSD Deal Conditions - Deal Condition Numbernvarchar100
TOPImplementation Guide
17TCUSPCustomizing: Implementation project profile1PRONRNumber of the implementation project in Customizingnvarchar30
18TCUSP40Customizing: Implementation project profile1PRONRProject number for Customizing projectnvarchar80
19TCUSP40TCustomizing: Implementation project profile2PRONRProject number for Customizing projectnvarchar80
20TCUSPTCustomizing: Implementation project profile2PRONRNumber of the implementation project in Customizingnvarchar30
21TCUSSCustomizing: Implementation project - name2PRONRNumber of the implementation project in Customizingnvarchar30
TOPInformation System
22DSKOPBalance Audit Trail71PRONRProject Numbernvarchar160
TOPMaterial
23TCNIFAssembly item/WBS element assignment BOM transfer2PRONRProject definition (internal)nvarchar80
24TCNIP01Control stock/account assignment for interface EBOM/PS2PRONRProject Definitionnvarchar240
TOPProduction Orders
25AFKOOrder Header Data PP Orders59PRONRProject definitionnvarchar80
TOPProject System
26PSHLPDB_HIER_TMPTable to store temporary hierarchy data21PRONRProject definitionnvarchar80
27PSHLP_HIER_DBLocal cache:Project/Independent Network hierarchy21PRONRProject definitionnvarchar80
TOPRevenues and Earnings
28VPKSDITEMSales Pricing Header Data (Specific to SD)5PRONRProject definition (internal)nvarchar80
TOPSimulation
29VSAFKO_CNVersion: Order header data for PP orders60PRONRProject definitionnvarchar80