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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

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
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

24 columns | Print definition?ERP 6.0  | TRANSFER

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SAPPSSRM/TRANSDefine Transfer Status3TRANSFERTransfer Conditionnvarchar320
2CNVCMIS_TAB_TRNSStore info about cmis tables with no data in sender system4TRANSFERCMIS Transfer Flagnvarchar10
3CNVTDMS_01_CCSELCompany dependant org units8TRANSFERGeneral Flagnvarchar10
4CNVTDMS_01_ORSELTDMS table to select Orgunits to be transferred6TRANSFERGeneral Flagnvarchar10
5LAW2D_ATTACHMENTLAW 2.0 Attachement table9TRANSFERLAW 2.0 indicator if the file is transfered via SDCCN to SAPnvarchar10
6VIXCITIRE2DATAIRE2 Master Data44TRANSFERTransfer of Ownershipnvarchar10
TOPClient-System Adapter
7MDMEXTRFLDMDM Field Table for Extraktor Metadata13TRANSFERMDM Extraction Object: Transfernvarchar10
8MDMEXTRGRPMDM Field Group Extraktor Metadata7TRANSFERMDM Extraction Object: Transfernvarchar10
TOPCustomer Contact
9BPCT_CRM_CLASSDisplay Contact Type/Class on CRM Activities6TRANSFERReplication in Customer Relationship Managementnvarchar10
TOPData Staging
10RSDSSEGFDDataSource - Segment Fields24TRANSFERField Will Be Transferred (In PSA and Structures)nvarchar10
11RSDSSEGFDSHDataSource in BW - Shadow Table Fields24TRANSFERField Will Be Transferred (In PSA and Structures)nvarchar10
TOPFlexible Real Estate Management
12VIXCITIREDATAIRE master data42TRANSFERTransfer of Ownershipnvarchar10
TOPLocalization
13J_1BNFITMRULERules for Nota Fiscal Item Type30TRANSFERItem Type for Transfersnvarchar10
TOPPatient Management
14NWPLACE_AD1_BWTYIS-H: Clinical Process Builder - Movement Category Validity7TRANSFERIS-H: Indicator that Variant Is for Transfernvarchar10
TOPPosition Budgeting and Control
15HRFPM_2FC_DIFFHRFPM: Two-Face-Commit Tab Prsnl Cost Svngs for Comm with FM9TRANSFERGeneral Flagnvarchar10
TOPProfitability Analysis
16TKEZVCO-PA:Assignment SD characteristics to CO-PA characteristics5TRANSFERNew Input Valuesnvarchar10
TOPSAP Business Partner
17MDMEXTRFLD_PREFMDM Field Table Extractor Metadata (Copy)13TRANSFERMDM Extraction Object: Transfer (Copy)nvarchar10
18MDMEXTRGRP_PREFMDM Field Group Extractor Metadata (Copy)7TRANSFERMDM Extraction Object: Transfer (Copy)nvarchar10
TOPSAP NetWeaver Mobile - Use subcomponents
19MEREP_405Mapping Result for Synchronization (BAPI)11TRANSFERMapnvarchar10
TOPService Data Download
20BDLDTOCRFC download -- Data cluster table of contents17TRANSFERStatus of data transfernvarchar10
TOPTime Sheet
21CATSCOCross-Application Time Sheet (CATS): Transfer to CO26TRANSFERData Transferred to the Target Componentnvarchar10
22CATSMMCross-Application Time Sheet (CATS): Transfer to MM20TRANSFERData Transferred to the Target Componentnvarchar10
23CATSPMCross-Application Time Sheet (CATS): Transfer to PM/CS23TRANSFERData Transferred to the Target Componentnvarchar10
24CATSPSCross-Application Time Sheet (CATS): Transfer to PS23TRANSFERData Transferred to the Target Componentnvarchar10