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

72 columns | Print definition?ERP 6.0  | CHANM

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1RSMDUCMUKADSOUT DataStore Objects (Advanced): identifying attr. for MUKs5CHANMCharacteristicnvarchar300
TOPBatches
2TVBX_CBATPTax Table of Materials for Characteristic-Based ATP8CHANMName of Person Who Changed Objectnvarchar120
3TVBX_MAT_CBATPTax Table of Materials for Characteristic-Based ATP9CHANMName of Person Who Changed Objectnvarchar120
TOPBusiness Information Collection
4UISUBSETAssignment to Evaluation Objects: Subset of Characteristics2CHANMCharacteristicnvarchar300
TOPBusiness Planning
5UPB_CMI_101CMI: Assignment to Characteristics4CHANMCharacteristicnvarchar300
6UPB_HI_REFPlanning Applucations: Reference to Hierarchy5CHANMCharacteristicnvarchar300
7UPB_MD_REFPlanning Applications: OLD!!!!!!! Reference to Master Data2CHANMCharacteristicnvarchar300
8UPB_MD_REF_NPlanning Applications: Reference to Master Data2CHANMCharacteristicnvarchar300
9UPB_T_MD_ROLECharacteristic Role Assignment Persistence2CHANMCharacteristicnvarchar300
10UPB_YT_CRITERIATable for Characteristics1CHANMCharacteristicnvarchar300
TOPBusiness Planning and Simulation
11UPC_BW_TIMEREFAssignment Time Characteristic - Time Reference1CHANMCharacteristicnvarchar300
12UPC_CHACMPProperties of a Characteristic3CHANMCharacteristicnvarchar300
13UPC_CHADEPCompoundend Values5CHANMCharacteristicnvarchar300
14UPC_CHAPROProperties of a Characteristic3CHANMCharacteristicnvarchar300
15UPC_FLDDSFields for Relations between Characteristics5CHANMCharacteristicnvarchar300
16UPC_NODESHierarchy Node7CHANMCharacteristicnvarchar300
17UPC_STEPSRelations between Characteristics of a Planning Area9CHANMCharacteristicnvarchar300
18UPC_VARIABLEVariables - Old Version of Database (New is UPC_VAR)5CHANMCharacteristicnvarchar300
19UPC_VAR_CHAVariables - Characteristics4CHANMCharacteristicnvarchar300
20UPC_VAR_CHADEPVariables - Selections using Hierarchies6CHANMCharacteristicnvarchar300
21UPC_VAR_CHADEPAVariables - Selections using Hierarchies6CHANMCharacteristicnvarchar300
22UPC_VAR_CHA_ACTVariables - Restricted Values5CHANMCharacteristicnvarchar300
23UPC_VAR_CHA_SELVariables - Selections5CHANMCharacteristicnvarchar300
24UPC_VAR_HIEVariables - Hierarchies7CHANMCharacteristicnvarchar300
25UPC_VAR_HIE_SELVariables - Selections using Hierarchies9CHANMCharacteristicnvarchar300
26UPC_VAR_HIE_SELAVariables - Selections using Hierarchies (Active Values)9CHANMCharacteristicnvarchar300
27UPP_DOCPlanning: Layout Builder Info about Document12CHANMCharacteristicnvarchar300
28UPS_HEADERHeader Selections for STS4CHANMCharacteristicnvarchar300
29UPS_TP_HIERARCHYConnection Subplan-Hierarchy7CHANMCharacteristicnvarchar300
30UPX_CHANMGROUPIUPX: Characteristic Groups - Items3CHANMCharacteristicnvarchar300
31UPX_DSRC_CHANMUPX: Data Sources - Header3CHANMCharacteristicnvarchar300
32UPX_DSRC_HEADUPX: Data Sources - Header8CHANMCharacteristicnvarchar300
33UPX_HEADKey Figure Schemes for Planning Layouts: General Fields3CHANMCharacteristicnvarchar300
34UPX_HEAD_TEXTTexts for Key Figure Schemes3CHANMCharacteristicnvarchar300
35UPX_KFS_LKFKey Figure Schemes for Planning Layouts: Layout Key Figures4CHANMCharacteristicnvarchar300
36UPX_KFS_SHIFTKey Figure Schemes for Planning Layouts: Relative Addresses4CHANMCharacteristicnvarchar300
37UPX_SLC_MAINConfiguration of Lead Columns3CHANMCharacteristicnvarchar300
38UPX_SLC_TEXTConfiguration of Lead Columns: Text Table3CHANMCharacteristicnvarchar300
39UPX_SLC_TIMETime Characteristics3CHANMCharacteristicnvarchar300
TOPBW Service API
40RODCHABW: InfoObjects / Characteristics1CHANMCharacteristicnvarchar300
TOPCorporate Performance Monitor
41UMK_BMK002Master Data Mapping2CHANMCharacteristicnvarchar300
42UMK_MB120Benchmark Data Source <-> Measure4CHANMCharacteristicnvarchar300
TOPData Basis
43RSDICHAPROInfoCube-specific characteristic properties3CHANMCharacteristicnvarchar300
44RSMDUCMUKAGGRUT Aggregates: Identifying attributes for MUKs6CHANMCharacteristicnvarchar300
45RSMDUCMUKCMPUT Compound Cha: Identifying attributes for MUKs3CHANMCharacteristicnvarchar300
46RSMDUCMUKCUBEUT InfoCube: identifying attributes for MUKs5CHANMCharacteristicnvarchar300
47RSMDUCMUKMETAUT MetaData: identifying attributes for MUKs5CHANMCharacteristicnvarchar300
48RSMDUCMUKNLSUT Nearline Infoproviders: identifying attributes for MUKs5CHANMCharacteristicnvarchar300
49RSMDUCMUKODSOUT DataStore Objects: identifying attributes for MUKs5CHANMCharacteristicnvarchar300
TOPData Staging
50RSARCHIPROLOCSELBW Archiving: Archived Data Area3CHANMCharacteristicnvarchar300
51RSARCHREQSELBW Archiving: Request-Selections3CHANMCharacteristicnvarchar300
TOPDistribution
52WCAT_PROFILECost allocation profile12CHANMAccount characteristic of cost allocation reference datanvarchar300
TOPGeneric Statistical Data
53/DSD/GS_CDMI_CHADSD: Define Catalog of Returned Characteristic3CHANMCharacteristicnvarchar300
54/DSD/GS_CDMI_SELDSD: Define Selections for Data Provider3CHANMCharacteristicnvarchar300
TOPMetadata Repository
55RSDATRNAVNavigation Attributes1CHANMCharacteristicnvarchar300
56RSDATRNAVSIDAssignment: Navigation attribute -> SID field name2CHANMCharacteristicnvarchar300
57RSDATRNAVTNavigation Attributes2CHANMCharacteristicnvarchar300
58RSDATRNAVT_TXVNavigation Attributes - Text Verticalization3CHANMCharacteristicnvarchar300
59RSDCHACharacteristic Catalog1CHANMCharacteristicnvarchar300
60RSDCHATHJCharacteristics for Temporal Hierarchy Join1CHANMCharacteristicnvarchar300
61RSDMTXTCHANGESLast change to the text table of an InfoObject1CHANMCharacteristicnvarchar300
62RSDNAIPNavigation Attributes of Characteristics as InfoProvider1CHANMCharacteristicnvarchar300
TOPOLAP Technology
63RRKMULTIPROVHINTControl of MultiProvider Hint2CHANMCharacteristicnvarchar300
64RSDDTPS_FILTERMultiProvider for Polestar - Filter2CHANMCharacteristicnvarchar300
65RSDRCRM_SEG_EXSTExecution Plan: Recording Additional Data for Step Calls7CHANMCharacteristicnvarchar300
TOPPlanning
66RSPLS_CHAS_LOCKPlanning: Lock-Relevant Characteristics per InfoProvider2CHANMCharacteristicnvarchar300
67RSPLS_CR_ROLECharacteristic Relationships: Roles of the Characteristics5CHANMCharacteristicnvarchar300
68RSPLS_CR_STEPSRelationships Between Characteristics in Basic InfoProvider16CHANMCharacteristicnvarchar300
TOPPurchasing
69WRFT_BUDG_LEVBudget Level3CHANMName of Info Objectnvarchar300
TOPReport Selection for Product Costing
70TKKREHierarchy Summarization (Summarization Characteristics)2CHANMSummarization Characteristic/CO Summarizationnvarchar300
71TKKRFHierarchy Summarization (Assignment Summar. Char. to Fields)3CHANMSummarization Characteristic/CO Summarizationnvarchar300
TOPStakeholder Relationship Management
72USS_BW_HIERARCHYUSTH0: BW Hierarchy6CHANMCharacteristicnvarchar300