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

27 columns | Print definition?ERP 6.0  | VALFROM

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNV_10100_SETLEAFI Set values for interval break down, according SETLEAF9VALFROMCharacter field length 24nvarchar240
2CNV_20100SETLEAFBackup copy - SETLEAF (0102,0109)9VALFROMnvarchar240
3CNV_20375_SETLFBackup for SETLEAF before modification9VALFROMFrom valuenvarchar240
4ZCSM_SRVC_CATLOGcatalog for facility services22VALFROMEffective from datenvarchar80
TOPBulk Distribution Requirements Planning
5OIISLVCHSilo calibration history index5VALFROMFrom/start time stamp (BDRP)nvarchar140
TOPDefault Risk and Limit System
6KLAUSFWKTDefault Risk Probabilities3VALFROMValidity Datenvarchar80
7KLLR01Assignment of Country - Rating/Recovery Rate Determination3VALFROMValidity Datenvarchar80
8KLLR02Assignment of Country - VaR%4VALFROMValidity Datenvarchar80
9KLLR03Assignment of CEQ Class - CEQ in Percentage4VALFROMValidity Datenvarchar80
10KLLR04Country Default Probabilities4VALFROMValidity Datenvarchar80
11KLLR05Assignment of LEQ Class / LEQ in Percentage4VALFROMValidity Datenvarchar80
12KLRATINGRRFZUAssignment of Rating to Recovery Rate Determination3VALFROMValidity Datenvarchar80
13KLRRDEFMaintainance of Values for Recovery Rates4VALFROMValidity Datenvarchar80
TOPFunctions for U.S. Federal Government
14FMFGT_ALC_GWAAssign. of Business Act. Type and Reporter Category to ALC3VALFROMValid From Datenvarchar80
TOPFunds Management
15FMFGAPCONAccountable Property Configuration Data4VALFROMValid from datenvarchar80
TOPResourcen Management
16MRTRST_HDRRMS-MRTRS : MR Transformation Header10VALFROMValid-From Datenvarchar80
17PNEQRRMS - RCP Equipment Requirement Node: Attributes6VALFROMValid-From Datenvarchar80
18PNPOBARMS-RCP: Attributes of "Process Action" POB Node8VALFROMValid-From Datenvarchar80
19PNPOBORMS-RCP: Attributes of the "Process Operation" POB Node8VALFROMValid-From Datenvarchar80
20PNPOBSRMS-RCP: Attributes of POB Nodes, Process and Stage8VALFROMValid-From Datenvarchar80
21PVRCPDPVS Header/Recipe Basic Data13VALFROMValid-From Datenvarchar80
22RCPT_GRMR_RELRMS-RCP: Relationship Between General Recipe & Master Recipe9VALFROMValid-From Datenvarchar80
TOPReturnable Packaging Logistics
23RLPSHPAAssignments Relationship-Account5VALFROMValid from datenvarchar80
TOPSets
24HDB_SETLEAF1Leaf view for SLT hierarchy replication (primary)5VALFROMFrom Valuenvarchar240
25HDB_SETLEAF2Leaf view for SLT hierarchy replication (secondary)5VALFROMFrom Valuenvarchar240
26SETLEAFValues in Sets8VALFROMFrom Valuenvarchar240
TOPTraders and Schedulers Workbench
27OIISOCO1SOC: Storage object characteristic segment: bulk7VALFROMFrom/start time stamp (BDRP)nvarchar140