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

94 columns | Print definition?ERP 6.0  | VIEW_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/AIF/T_FUNC_LSTFunction codes for Applications (views)4VIEW_IDView Codenvarchar10
2/AIF/T_FUNC_LSTTText table for /AIF/T_FUNC_LSTT4VIEW_IDView Codenvarchar10
3/CPD/FC_PL_SCENPlan Scenario Master Data11VIEW_IDView IDnvarchar50
4/CPD/IS_MAP_VCONView Definition2VIEW_IDView IDnvarchar50
5/CPD/IS_VIEWDEFView Definition2VIEW_IDView IDnvarchar50
6/CPD/IS_VIEWDEFTView ID Description2VIEW_IDView IDnvarchar50
7/CPD/IS_VW_ID_MPView IDs for Master Project Type3VIEW_IDView IDnvarchar50
8/CPD/PWSC_MPTYPCPD: Master Project Type Table7VIEW_IDView IDnvarchar50
9/GBT/C_VIEWView for filter and aggregation2VIEW_IDView ID for Filter and Aggregationnvarchar400
10/GBT/C_VIEWTText for View for Filter and Aggregation2VIEW_IDView ID for Filter and Aggregationnvarchar400
11/GBT/C_VIEW_SIMPAssignment of Simplifications to View2VIEW_IDView ID for Filter and Aggregationnvarchar400
12/XPPM/FPM_VIEWCustomization table for the view ids2VIEW_IDData element for view idnvarchar600
13/XPPM/GUP_VIEWSPossible views for the Guided Procedure2VIEW_IDPPM Consulting Solution: Guided Procedure Viewsnvarchar30
14/XPPM/GUP_VIEW_TPossible views for the Guided Procedure2VIEW_IDPPM Consulting Solution: Guided Procedure Viewsnvarchar30
15GRFNAEOBJObjects assigned to Audit Entity4VIEW_IDOrganization View IDnvarchar30
16IWP_DP_AP_EV_DIRGenerated Exit Views directory3VIEW_IDView Descriptionnvarchar300
17IWP_DP_AP_LV_DIRGenerated Views directory3VIEW_IDView Descriptionnvarchar300
18RSBPCB_ACTIONBPC: Activity action5VIEW_IDBPC: Resource IDnvarchar320
19RSBPCR_CNTXT_HDRBPC: Resource context header4VIEW_IDBPC: Resource IDnvarchar320
20RSBPCR_CNTXT_ITMBPC: Resource context item4VIEW_IDBPC: Resource IDnvarchar320
21RSBPCR_PROPERTYBPC: Resource Property4VIEW_IDBPC: Resource IDnvarchar320
22RSBPCR_VIEWBPC: Persistence Resource View4VIEW_IDBPC: Resource IDnvarchar320
23RSBPCR_VIEWTBPC: Persistence Resource View Text5VIEW_IDBPC: Resource IDnvarchar320
24RSBPCR_VIEW_VALSBPC: Resource View Values4VIEW_IDBPC: Resource IDnvarchar320
25TFK_VT_C2Counter Groups for Display2VIEW_IDCounter Groups for Displaynvarchar40
26TFK_VT_C2TCounter Groups for Display (Text Table)3VIEW_IDCounter Groups for Displaynvarchar40
27TFK_VT_C3Assignment of Counters to Counter Groups for Display2VIEW_IDCounter Groups for Displaynvarchar40
28VFPRCC_COND2VIEWPricing Condition Type to View Mapping2VIEW_IDPricing View Identifiernvarchar40
29VFPRCC_PRCE2VIEWPricing Elements to View Mapping2VIEW_IDPricing View Identifiernvarchar40
30VFPRCC_VIEW_ASGNPricing View - Allowed View Assignment3VIEW_IDPricing View Identifiernvarchar40
31VFPRCC_VIEW_FCGPricing View - Field Configuration4VIEW_IDPricing View Identifiernvarchar40
32VFPRCC_VIEW_FCGCPricing View - Field Configuration5VIEW_IDPricing View Identifiernvarchar40
33VFPRCC_VIEW_REGPricing View Definition2VIEW_IDPricing View Identifiernvarchar40
34VFPRCC_VIEW_TXTPricing View Name2VIEW_IDPricing View Identifiernvarchar40
35VFPRCC_VIEW_TXTCPricing View Name Override2VIEW_IDPricing View Identifiernvarchar40
36T7PIQREQPRFVIEWT7PIQREQPRFVIEW2VIEW_IDRequirement Profile Viewnvarchar100
37T7PIQREQPRFVIEWTT7PIQREQPRFVIEWT3VIEW_IDRequirement Profile Viewnvarchar100
38T7PIQRQPRFVWASSNAssignment of Requirement Profile View to Req. Element2VIEW_IDRequirement Profile Viewnvarchar100
TOPBusiness Package for Manager Self-Service FI
39FCOM_EQMACL_CAsset Classes for Equipment Monitor2VIEW_IDView in Equipment Monitornvarchar200
40FCOM_EQMECA_CEquipment Types for Equipment Monitor2VIEW_IDView in Equipment Monitornvarchar200
41FCOM_EQMVIEW_CViews for Equipment Monitor2VIEW_IDView in Equipment Monitornvarchar200
42FCOM_EQMVIEW_TText for Views in Equipment Monitor2VIEW_IDView in Equipment Monitornvarchar200
TOPCentral Part of Product Master
43COMC_PRVIEWProduct Maintenance Definition Views2VIEW_IDView IDnvarchar160
44COMC_PRVIEW_DEFProduct Workbench Default Setting Views3VIEW_IDView IDnvarchar160
45COMC_PRVIEW_TDefinition of Views in Product Maintenance2VIEW_IDView IDnvarchar160
46COMM_PRVIEWProduct View3VIEW_IDIdentification of a Viewnvarchar160
47COMM_PRVIEWHProduct View - History4VIEW_IDIdentification of a Viewnvarchar160
48COMS_PRCATVIEWProduct Maintenance Definition Views1VIEW_IDView IDnvarchar160
49COMS_PRCATVIEW_TDefinition of Views in Product Category Maintenance1VIEW_IDView IDnvarchar160
TOPCustomizing Project Management IMG
50TPR_VINDXList of IMG Activities in a Project View2VIEW_IDGUID for Structurenvarchar320
TOPDialog People-Centric UI for Products
51COMC_SETVIEW_BSPSet Types and View Assignment for Set Types in BSP4VIEW_IDIdentification of a Viewnvarchar160
TOPGovernance, Risk and Compliance
52GRFNSCRBWQSAP BW Query Script5VIEW_IDBW Viewnvarchar300
TOPKey Figure Monitor
53KFM_USR_KF_VIEWAssignment of Key Figure Users to Views2VIEW_IDID of User and Context-Specific Viewvarbinary160
54KFM_USR_VIEWUser, Context, and Role-Specific Views2VIEW_IDID of User and Context-Specific Viewvarbinary160
TOPLogistics - General
55EPM_KPI_VIEWAssignment of KPIs to User-Specific Views2VIEW_IDUUID in X form (binary)varbinary160
56EPM_VIEWUser-Specific Combination of KPIs3VIEW_IDUUID in X form (binary)varbinary160
TOPMaintenance Orders
57/MRSS/C_SGU_PROUI Planning Profiles6VIEW_IDView Profile IDnvarchar30
58/MRSS/C_SGU_VIEUI Planning Profile: Views3VIEW_IDView Profile IDnvarchar30
59/MRSS/C_SGU_VIETUI Planning Profile: Views3VIEW_IDView Profile IDnvarchar30
TOPMedia Product Sales and Distribution
60JKSDFCVARIANTIS-M: Reference Issue Header Data8VIEW_IDQuantity Planning Viewnvarchar30
61JKSDFCVARIANTPOIS-M: Header Data for Ref. Issues with Planning Organization9VIEW_IDQuantity Planning Viewnvarchar30
62JKSDVIEWSTATGRPAssignment of Material Status Group to Qty Planning View3VIEW_IDQuantity Planning Viewnvarchar30
63JKSDVIEWUSRGRPAssignment of Quantity Planning Views to User Groups3VIEW_IDQuantity Planning Viewnvarchar30
64TJKSDFCVIEWSCHEMAssignment of Target Fields in Quantity Plan for Forecast3VIEW_IDQuantity Planning Viewnvarchar30
65TJKSDVIEWQuantity Planning View2VIEW_IDQuantity Planning Viewnvarchar30
66TJKSDVIEWAGGMETHAssignment of Distribution Methods to Quantity Planning View2VIEW_IDQuantity Planning Viewnvarchar30
67TJKSDVIEWAGGRAssignment of Aggregation Fields to Quantity Planning View2VIEW_IDQuantity Planning Viewnvarchar30
68TJKSDVIEWCHARAssignment of Additional Fields to Quantity Planning View2VIEW_IDQuantity Planning Viewnvarchar30
69TJKSDVIEWEXFUNCAssignment of Calculation Methods to Quantity Planning View2VIEW_IDQuantity Planning Viewnvarchar30
70TJKSDVIEWFIGUREQuantity Planning View: Display Options for Quantity Fields2VIEW_IDQuantity Planning Viewnvarchar30
71TJKSDVIEWFIG_PQPPlanning View: Display of Quantity Fields per Substructure2VIEW_IDQuantity Planning Viewnvarchar30
72TJKSDVIEWFIG_SQPPlanning View: Display of Quantity Fields per Substructure2VIEW_IDQuantity Planning Viewnvarchar30
73TJKSDVIEWFILTERAssignment of Filters to Quantity Planning Views2VIEW_IDQuantity Planning Viewnvarchar30
74TJKSDVIEWFLDLABLAlternative Field Names for Quantity Planning View Field2VIEW_IDQuantity Planning Viewnvarchar30
75TJKSDVIEWHISTAssignment of Historical Sales Data to Qty Planning View2VIEW_IDQuantity Planning Viewnvarchar30
76TJKSDVIEWTText for Quantity Planning View2VIEW_IDQuantity Planning Viewnvarchar30
77TJKSDVIEWTAAssignment of Quantity Planning Views to Applications3VIEW_IDQuantity Planning Viewnvarchar30
78TJKSDVIEWTA_PQPAssignment of Substructures to Quantity Planning Views2VIEW_IDQuantity Planning Viewnvarchar30
79TJKSDVIEWTA_SQPAssignment of Substructures to Quantity Planning Views2VIEW_IDQuantity Planning Viewnvarchar30
TOPOLAP Technology
80RSRA_ER_LOG_DATATable of Logged Data Cells8VIEW_IDUUID in compressed formnvarchar250
81RSRA_ER_LOG_ENTRLog Entries for every Exception7VIEW_IDUUID in compressed formnvarchar250
82RSRA_ER_LOG_IXBW: Cluster Table for Report Agent Exception Log5VIEW_IDUUID in compressed formnvarchar250
TOPPortfolio Management
83RPM_SCN_ADD_FLDSRPM : Scenario Additional fields3VIEW_IDWhat-If Scenario Fieldnvarchar40
84RPM_SCN_FLD_CRPM : Scenario Customer fields for What_If2VIEW_IDWhat-If Scenario Fieldnvarchar40
85RPM_SCN_FLD_C_TRPM : Customer fields texts for What_If Scenario3VIEW_IDWhat-If Scenario Fieldnvarchar40
TOPProcess Monitoring Infrastructure
86SSPIUICUCDSPI: Definition of Step Collections2VIEW_IDID of View (Currently Process Type GUID) of Processnvarchar320
87SSPIUICUCD_TSPI: Short Texts for Step Transitions3VIEW_IDID of View (Currently Process Type GUID) of Processnvarchar320
TOPQualifications and Requirements
88T77QC_VIEWView of Qualifications Catalog2VIEW_IDView of Qualifications Catalognvarchar200
89T77QC_VIEW_IDView of Qualifications Catalog2VIEW_IDView of Qualifications Catalognvarchar200
90T77QC_VIEW_TEXTView of Qualifications Catalog (Name)3VIEW_IDView of Qualifications Catalognvarchar200
TOPRecipe Development
91/PLMB/RCA_TABSView Sequence per Main View3VIEW_IDSubview IDnvarchar100
92/PLMB/RCA_TABSCView Sequence per Main View (Calculation Results)2VIEW_IDSubview IDnvarchar100
93/PLMB/RCA_TABSFView Sequence per Main View2VIEW_IDSubview IDnvarchar100
94/PLMI/LBL_VIEWCLLabeling: View Classes2VIEW_IDView Class IDnvarchar100