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  | ASPECT_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/CPD/PWSC_ASPECTTable for Aspect ID and Description2ASPECT_IDAspect IDnvarchar40
2/CPD/PWSC_ASPETTAspect ID description2ASPECT_IDAspect IDnvarchar40
3/CPD/PWSC_CONFIGTable to maintain Views2ASPECT_IDAspect IDnvarchar40
4/CPD/PWSC_RA_MAPTable to Map Role and Aspect ID3ASPECT_IDAspect IDnvarchar40
5/CPD/PWSC_UIBBTable to maintain UIBB2ASPECT_IDAspect IDnvarchar40
6ACMACAVIEWDETAILACM: Access-Condition Authorization-View Details9ASPECT_IDACM: UUID of an Aspectvarbinary160
7ACMACFIELDACM: Access-Condition Field6ASPECT_IDACM: UUID of an Aspectvarbinary160
8ACMASPECTPFCGACM: Dedicated PFCG_AUTH-Aspects2ASPECT_IDACM: UUID of an Aspect Viewvarbinary160
9ACMASPECTVIEWACM: Aspect-View Persistence2ASPECT_IDACM: UUID of an Aspect Viewvarbinary160
10ACMATASSIGASPECTACM-Admintime: Assigned Aspects to a Subj2Role entry4ASPECT_IDACM: UUID of an Aspectvarbinary160
11ACMTSTACAVIEWDETACMTST: AC-AuthView-Detail (Expected test-results)9ASPECT_IDACM: UUID of an Aspectvarbinary160
12ACMTSTACFIELDACMTST: AC-Field (Expected test-results)6ASPECT_IDACM: UUID of an Aspectvarbinary160
13ACMTSTASPECTPFCGACMTST: Dedicated PFCG_AUTH-Aspects (Expected results)2ASPECT_IDACM: UUID of an Aspect Viewvarbinary160
14ACMTSTASPECTVIEWACMTST: Aspect-View (Expected test-results)2ASPECT_IDACM: UUID of an Aspect Viewvarbinary160
15ACMTSTATASSIGASPACM-Admintime: Assigned Aspects to a Subj2Role entry4ASPECT_IDACM: UUID of an Aspectvarbinary160
TOPABAP Test Frameworks ATC, CheckMan, Code Inspector
16SATC_AC_ASPERR_BOBSOLETE4ASPECT_IDnvarchar300
17SATC_AC_ASPERR_SOBSOLETE4ASPECT_IDnvarchar300
18SATC_AC_RSLT_AEOBSOLETE: 'Display Load' aspect failure (plug-in error)4ASPECT_IDnvarchar300
19SATC_AC_RSLT_VPOBSOLETE: 'Display Load' processing state2ASPECT_IDnvarchar300
20SATC_AC_RSLT_VTOBSOLETE: 'Display Load' aspect findings (verdicts)2ASPECT_IDnvarchar300
21SATC_AC_VRDCT_BOBSOLETE: 'Finding Set' data > 510 bytes; aspect format2ASPECT_IDnvarchar300
22SATC_AC_VRDCT_SOBSOLETE: 'Finding Set' data > 510 bytes; aspect format2ASPECT_IDnvarchar300
TOPConsolidation
23TF090Interactive Excel Attributes1ASPECT_IDnvarchar30
TOPWorkbench Tools Editors, Painters, Modelers
24SCCD_ASPECTSCC: Check Aspects1ASPECT_IDCheck Aspectnvarchar300
25SCCD_ASPECT_TSCC: Check Aspect Texts1ASPECT_IDCheck Aspectnvarchar300
26SCCD_ASP_PARAMSCC: Values of Parameterizable Check Aspects1ASPECT_IDCheck Aspectnvarchar300
27SCCD_ASP_PARAM_TSCC: Parameterizable Check Aspect Value Texts1ASPECT_IDCheck Aspectnvarchar300
28SCCD_ASP_REG_OBJSCC: Assignment of Object Types to Check Aspects1ASPECT_IDCheck Aspectnvarchar300
29SCCD_CFG_ELEMSCC: Check Configuration Elements3ASPECT_IDCheck Aspectnvarchar300