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

30 columns | Print definition?ERP 6.0  | PVGUID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPCAD Integration
1CDESK_IPPE_RTYPECAD-Specific Relationship Type2PVGUIDInternal Number of the PVS Variantvarbinary160
TOPIntegrated Product and Process Engineering
2CMIG_MAPPINGMapping Table (Classic PP and iPPE Objekt Key)17PVGUIDInternal Identification for PVS Objectsvarbinary160
3POSVIDiPPE Variant: Identification2PVGUIDInternal Number of the PVS Variantvarbinary160
4POSVTXiPPE Node: Texts2PVGUIDInternal Number of the PVS Variantvarbinary160
5PPEOBJObjects for the iPPE Access Object6PVGUIDInternal Identification for PVS Objectsvarbinary160
6PPESCMPViPPE Status, BOM-Specific Data4PVGUIDInternal Number of the PVS Variantvarbinary160
7PVCMPPVS Variant (CMP): History Management2PVGUIDInternal Number of the PVS Variantvarbinary160
8PVCMPDPVS Variant (CMP): Basic Data2PVGUIDInternal Number of the PVS Variantvarbinary160
9PVCMPHObsolete: Replaced by PVCMP2PVGUIDInternal Number of the PVS Variantvarbinary160
10PVCMPPPVS Variant (CMP): Component Attributes2PVGUIDInternal Number of the PVS Variantvarbinary160
11PVCMPRPVS Variant (CMP): Supplement to the Selection Criteria2PVGUIDInternal Number of the PVS Variantvarbinary160
12PVCMPVPVS Variant (CMP): Variable-Size Item Data2PVGUIDInternal Number of the PVS Variantvarbinary160
13PVCOLPVS Variant (COL): Color Attributes2PVGUIDInternal Number of the PVS Variantvarbinary160
14PVCONiPPE Concept2PVGUIDInternal Number of the PVS Variantvarbinary160
15PVSETSet Variant: Table of Attributes2PVGUIDInternal Number of the PVS Variantvarbinary160
16PVTSTTest Variant: Attribute Table2PVGUIDInternal Number of the PVS Variantvarbinary160
TOPMaterial Categories
17/ISDFPS/PVMPOModel Attributes2PVGUIDInternal Identification for PVS Objectsvarbinary160
TOPProduct Data Management
18PDN_MAP_HEADERProduct Designer: Mapping Table for Headers4PVGUIDGlobal identification of an item's change statusvarbinary160
19PDN_MAP_ITEMProduct Designer: Mapping Table for Items4PVGUIDGlobal identification of an item's change statusvarbinary160
TOPResourcen Management
20MRTRST_HDRRMS-MRTRS : MR Transformation Header6PVGUIDUniversal Unique Identifiervarbinary160
21PVFRMDRMS-FRM: Basic Data of PVS Formula Variant2PVGUIDPVS Variant Identifiervarbinary160
22PVFRMHRMS-FRM: PVS Variant (Formula): History Management2PVGUIDPVS Variant Identifiervarbinary160
23PVFRMIRMS-FRM: PVS FRM Variant Stream-Related Data2PVGUIDPVS Variant Identifiervarbinary160
24PVFRMMRMS-FRM: PVS-FRM Variant, Material-Related Data2PVGUIDPVS Variant Identifiervarbinary160
25PVFRMSRMS-FRM: FRM Variant: Substance-Related Data2PVGUIDPVS Variant Identifiervarbinary160
26PVRCPDPVS Header/Recipe Basic Data2PVGUIDInternal Number of the PVS Variantvarbinary160
27RCPT_GRMR_RELRMS-RCP: Relationship Between General Recipe & Master Recipe6PVGUIDInternal Number of the PVS Variantvarbinary160
28RMSAT_POSVTXRMS-ATL: Short Texts for iPPE Variant2PVGUIDInternal Number of the PVS Variantvarbinary160
29RMSAT_RESCREATXRMS-ATL: Creation Reason Texts for iPPE Variant2PVGUIDInternal Number of the PVS Variantvarbinary160
TOPWarranty Claim Processing
30PVWTYWarranty Claim Item (PPE Variant)2PVGUIDInternal Number of the PVS Variantvarbinary160