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

83 columns | Print definition?ERP 6.0  | RECTYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/AIF/T_FMAPField mapping5RECTYPESource Structurenvarchar450
2/AIF/T_FMAPCONDField condition mapping5RECTYPESource Structurenvarchar450
3/AIF/T_FMAPCONDVField condition mapping variant7RECTYPESource Structurenvarchar450
4/AIF/T_FMAPVField mapping (obsolete)8RECTYPESource Structurenvarchar450
5/AIF/T_IFCHECKCheck assignment5RECTYPESource Structurenvarchar450
6/AIF/T_IFCHECKVCheck assignment7RECTYPESource Structurenvarchar450
7/AIF/T_INTFIXFix value for interface5RECTYPESource Structurenvarchar450
8/AIF/T_INTFIXVFix value for interface7RECTYPESource Structurenvarchar450
9/AIF/T_INTRECDestination record type for interface5RECTYPESource Structurenvarchar450
10/AIF/T_LFA_DTSTRSubstructures determination for AIF File Adapter5RECTYPEDestination Structurenvarchar300
11/AIF/T_RECFLDSField definition3RECTYPESource Structurenvarchar450
12/AIF/T_RECTYPERecordtype3RECTYPESource Structurenvarchar450
13/AIF/T_SMAPStructure mapping5RECTYPESource Structurenvarchar450
14/AIF/T_SM_FMAPVField mapping condition7RECTYPESource Structurenvarchar450
15/AIF/T_STRMAPVSelect & Add Structure Mapping7RECTYPESource Structurenvarchar450
16/CPD/PWS_RCB_BPBBAP Billing Plan Manager4RECTYPERecord Typenvarchar60
17/CPD/PWS_RCB_BPFFixed Price Billing Plan Manager4RECTYPERecord Typenvarchar60
18/OTX/RM_WSC_ERRQECM Workspace Error Queue6RECTYPEName of Receiver Typenvarchar140
19ECWD_TRACEeCATT - Trace for Web Dynpro Recording4RECTYPEntext10737418230
20FARR_C_RAI51AInterface Components: Structures2RECTYPERecord Type of a Revenue Accounting Itemnvarchar20
21FARR_C_RAI51KRAI: Structures for Key Definition1RECTYPERecord Type of a Revenue Accounting Itemnvarchar20
22FARR_C_RAI51RRAI: Interface Basic Components2RECTYPERecord Type of a Revenue Accounting Itemnvarchar20
23FARR_C_RAI52Fields of a Revenue Accounting Item Class2RECTYPERecord Type of a Revenue Accounting Itemnvarchar20
24FARR_C_RAI52EChangeable Fields of a Revenue Accounting Item Class3RECTYPERecord Type of a Revenue Accounting Itemnvarchar20
25FARR_C_RAI54Indexes of Tables of Revenue Accounting Items2RECTYPERecord Type of a Revenue Accounting Itemnvarchar20
26FARR_C_RAI54FFields of Indexes of Tables of Revenue Accounting Item2RECTYPERecord Type of a Revenue Accounting Itemnvarchar20
27FARR_C_RAI54TTexts of Indexes for RAI Tables3RECTYPERecord Type of a Revenue Accounting Itemnvarchar20
28FARR_D_RAIC52Configuration Version RAI Class (FARR_C_RAI52)3RECTYPERecord Type of a Revenue Accounting Itemnvarchar20
29FARR_D_RAIC54RAI Class Configuration Version (Table FARR_C_RAI54)3RECTYPERecord Type of a Revenue Accounting Itemnvarchar20
30FARR_D_RAIC54FRAI Class Configuration Version (Table FARR_C_RAI54F)3RECTYPERecord Type of a Revenue Accounting Itemnvarchar20
31FARR_D_RAIC54TRAI Class Configuration Version (Table FARR_C_RAI54T)4RECTYPERecord Type of a Revenue Accounting Itemnvarchar20
32FARR_D_RAIG52Generation Version RAI Class (FARR_C_RAI52)3RECTYPERecord Type of a Revenue Accounting Itemnvarchar20
33FARR_D_RAIG54RAI Class Generation Version (Table FARR_C_RAI54)3RECTYPERecord Type of a Revenue Accounting Itemnvarchar20
34FARR_D_RAIG54FRAI Class Generation Version (Table FARR_C_RAI54F)3RECTYPERecord Type of a Revenue Accounting Itemnvarchar20
35FARR_D_RAIG54TRAI Class Generation Version (Table FARR_C_RAI54T)4RECTYPERecord Type of a Revenue Accounting Itemnvarchar20
36FARR_D_RAIW52Working Version Configuration RAI Class (FARR_C_RAI52)2RECTYPERecord Type of a Revenue Accounting Itemnvarchar20
37FARR_D_RAIW54RAI Class Working Version (Table FARR_C_RAI54)2RECTYPERecord Type of a Revenue Accounting Itemnvarchar20
38FARR_D_RAIW54FRAI Class Working Version (Table FARR_C_RAI54F)2RECTYPERecord Type of a Revenue Accounting Itemnvarchar20
39FARR_D_RAIW54TRAI Class Working Version (Table FARR_C_RAI54T)3RECTYPERecord Type of a Revenue Accounting Itemnvarchar20
40FARR_D_RAI_CHChange Sequence of Changed Items3RECTYPERecord Type of a Revenue Accounting Itemnvarchar20
41FARR_D_RAI_GENOBGenerated Objects for a Revenue Accounting Item Class6RECTYPERecord Type of a Revenue Accounting Itemnvarchar20
42J_1GMYF0_MMYF data5RECTYPEMYF record typenvarchar20
43PIQDB_DE_GLSTATDGuest Listener Statistics Detail Table5RECTYPELine Typenvarchar10
TOPBasis Services Communication Interfaces
44TWPALRTEVTAlert framework events in the component system3RECTYPEName of Receiver Typenvarchar140
TOPBusiness Process Engine
45SWFBBINDEFBAM Definition: Bindings5RECTYPEName of Receiver Typenvarchar320
46SWFBRULECOMBAM: Client-Specific Conditions5RECTYPEName of Receiver Typenvarchar320
47SWFBRULECOUBAM: Cross-Client Condition4RECTYPEName of Receiver Typenvarchar320
TOPClinical System
48N2DI_RECORDAdministration Data of Speech Recording6RECTYPERecording Typenvarchar20
TOPCross-Application Components
49CCMSBI_BWPTR_CPHCPH/BI: Delta Management Table for Extraction of CPH Data3RECTYPEAggregation and Resolution of a CPH Data Recordnvarchar60
50CCMSBI_CPH_BWPTRCPH/BW: Reader Pointer for the Extraction of CPH Data7RECTYPEAggregation and Resolution of a CPH Data Recordnvarchar60
TOPF4 Help
51DDSHPVAL50Personal Help Values from Release 5.06RECTYPEnvarchar10
TOPFinancial Accounting
52J_1GMYF0MYF data4RECTYPEMYF record typenvarchar20
TOPJoint Venture und Production Sharing Accounting
53T8J_GJCB_REVCutback reversal control table15RECTYPEJV cutback reversal record typenvarchar10
TOPLocalization
54J_1BNFEPARKTAXNota fiscal electronica: Invoice create failed25RECTYPENota Fiscal tax record typenvarchar10
55J_1BNFSTXNota Fiscal tax per item11RECTYPENota Fiscal tax record typenvarchar10
TOPMaterial Categories
56/ISDFPS/MPO_PROTLog of Data Transfers into MPO4RECTYPERecord Typenvarchar10
TOPMonitoring
57ALPERFDBAlert: Performance database7RECTYPEAggregation and Resolution of a CPH Data Recordnvarchar60
58ALPERFDB_CAlert: Performance Database7RECTYPEAggregation and Resolution of a CPH Data Recordnvarchar60
59ALPFCOLLSYSSystems from Which the CPH Collects Data2RECTYPEAggregation and Resolution of a CPH Data Recordnvarchar60
60ALPFCOLLTIDTID List Created from ALPFREORG:Objects to Collect in PerfDB13RECTYPEAggregation and Resolution of a CPH Data Recordnvarchar60
61ALPFREP_CATPerfDB Reporting Catalog13RECTYPEAggregation and Resolution of a CPH Data Recordnvarchar60
TOPPeriodical Sales and Distribution
62TJKRECTYPERecord Types for Data Import in Order Environment1RECTYPEIS-M/SD: Record Type for Data Import in Order Environmentnvarchar20
63TJKRECTYPETIS-M/SD: Texts for Record Types for Order Data Import1RECTYPEIS-M/SD: Record Type for Data Import in Order Environmentnvarchar20
TOPProduct Safety
64CCRCC_ERRMAILEHS: Specify Recipients for Error Messages8RECTYPERecipient Typenvarchar10
65CCRCC_ERRORMAILEHS: RegCheck: Specify Recipients for Error Messages4RECTYPERecipient Typenvarchar10
66CVCERDDS: Error handler - recipient allocation (situation, error)6RECTYPERecipient Typenvarchar10
67CVDDHEHS: Report shipping orders26RECTYPEType of recipient numbernvarchar20
TOPSAP Business Workflow
68SWD_RTYPESWorkflow: Rec Types for Workflow Event Receivers2RECTYPEName of Receiver Typenvarchar320
69SWEINSTCOUInstance Linkage Event - Receiver5RECTYPEName of Receiver Typenvarchar140
70SWELOGTable for entries of the event log3RECTYPEName of Receiver Typenvarchar140
71SWEQUEUEEvent Queue for Temporary Storage of Triggered Events8RECTYPEName of Receiver Typenvarchar320
72SWETYPECOUType Linkage Events - Receiver4RECTYPEName of Receiver Typenvarchar140
73SWETYPEENAType Linkage Events - Receiver: Activation Table4RECTYPEName of Receiver Typenvarchar140
74SWFDEVENAActivations for Event Linkages5RECTYPEName of Receiver Typenvarchar320
75SWFDEVINSTEvent Linkages with Instance Reference6RECTYPEName of Receiver Typenvarchar320
76SWFDEVTYPEvent Linkages Without Instance Reference5RECTYPEName of Receiver Typenvarchar320
77SWFMIG_REF_EVNTEvents of Workflows6RECTYPErectype : the task id for the event.nvarchar320
78SWFREVTLOGEvent Log8RECTYPEName of Receiver Typenvarchar320
TOPSAP Healthcare - Industry-Specific Components for Hospitals
79/ISHFR/TNHISTRTYIS-H FR: Assignment Table "Scheme for Recipient Type"3RECTYPEIS-H FR: Recipient Typenvarchar20
TOPSoftware Agent Framework
80CRMC_SAF_LESAF: Customizing table for learning parameters7RECTYPELearning Engine: Recommendation Typenvarchar10
TOPStructures Workbench
81/ISDFPS/CMATRCTTText for Record Types in Material Planning3RECTYPERecord Type Planningnvarchar30
82/ISDFPS/CMATRCTYRecord Types for Material Planning2RECTYPERecord Type Planningnvarchar30
83/ISDFPS/MATSPPLNMaterials Planned for Force Element3RECTYPERecord Type Planningnvarchar30