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
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

46 columns | Print definition?ERP 6.0  | DOC_DATE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/ARBA/AN_ISUINVTemp table for BTE ISU7DOC_DATEDocument Date in Documentnvarchar80
2/ARBA/INVCOMMENTInvoice Status update comments table3DOC_DATEDocument Date in Documentnvarchar80
3/ARBA/INVSTATUPDTemp table for BTE ISU5DOC_DATEDocument Date in Documentnvarchar80
4/BIC/B0000190000PSA for 0MM_PUR_PURCH_DATA T90CLNT090 Purchasing Data10DOC_DATEnvarchar80
5/BIC/B0000191000PSA for 0MM_PUR_PURCH_GROUPS T90CLNT090 Purchasing Groups10DOC_DATEnvarchar80
6/BIC/B0000192000PSA for 0MM_PUR_SRV_LEVEL T90CLNT090 PO Service Level12DOC_DATEnvarchar80
7/GBT/O_DLVY_HDRDelivery19DOC_DATEDocument Date in Documentnvarchar80
8/OPT/VT_DOC_HEA1Document Header - copy of /opt/vt_doc_head21DOC_DATEDocument Date in Documentnvarchar80
9/OPT/VT_DOC_HEADDocument Header21DOC_DATEDocument Date in Documentnvarchar80
10BBP_PCGENProcurement Card Statements: General Data5DOC_DATEDocument Date in Documentnvarchar80
11CMCBD_DOCUMENTCash Budgeting Document5DOC_DATEPosting Datenvarchar80
12FIEUD_SBINV_HSAFT: Self Billing Invoices (Header)- (MM)9DOC_DATEDocument Date in Documentnvarchar80
13J_3RFSPD_ITEMSupporting document statement Items data11DOC_DATEDocument Date in Documentnvarchar80
14PCARD_ARIDXIndex for single doc access fpr arc object bbp_pc_arc4DOC_DATEDocument Date in Documentnvarchar80
15RAM1test3DOC_DATEDocument Date in Documentnvarchar80
16REQHEADSTemporary Header Data: Requirement Coverage Request (Limit)60DOC_DATEDocument Date in Documentnvarchar80
TOPAccounts Receivable Accounting Process Integration
17FDM_DOC_MIRRORDocument Information (Raw Data in Substitute System)25DOC_DATEDocument Date in Documentnvarchar80
TOPBasic Functions
18TTXUExternal tax interface: Audit file update information7DOC_DATEDocument Date in Documentnvarchar80
TOPBasis Components
19/XFT/INV_QInvoice receipt queue: Header38DOC_DATEDocument Date in Documentnvarchar80
20/XFT/INV_Q_SInvoice receipt queue: Header38DOC_DATEDocument Date in Documentnvarchar80
TOPBudgeting and Availability Control
21GMBDGTHEADERBudget Document Header20DOC_DATEDocument Date in Documentnvarchar80
22GMHBDGTHEADERBudget Header: Held Documents21DOC_DATEDocument Date in Documentnvarchar80
TOPContract Accounts Receivable and Payable
23DFKKORDERRequests: Header Data7DOC_DATEDocument Date in Documentnvarchar80
24DFKKORDERAPPROVERequests to be Approved5DOC_DATEDocument Date in Documentnvarchar80
25DFKKORDER_SRequest Templates: Header Data7DOC_DATEDocument Date in Documentnvarchar80
TOPCross-Application Components
26/OPT/S_PO_HISTVSS Staging Table: PO history12DOC_DATEDocument Date in Documentnvarchar80
27/OPT/VIM_HD_DPVIM IE Monitor: Header Data for DP Invoices31DOC_DATEDocument Date in Documentnvarchar80
28/OPT/VIM_HD_NPOVIM IE Monitor: Header Data for Parked NPO Invoices10DOC_DATEDocument Date in Documentnvarchar80
29/OPT/VIM_HD_POVIM IE Monitor: Header Data for Parked PO Invoices13DOC_DATEDocument Date in Documentnvarchar80
TOPDealer Portal
30/SAPDII/SPP_MATEMaterials table6DOC_DATEDatenvarchar80
TOPDistributor-Reseller-Management
31/SAPHT/DRMR3XNDRM relevant ERP Transactions33DOC_DATEDocument creation datenvarchar80
TOPDown Payment Chains
32/SAPPCE/TDPC20Down Payment Chain: Document Header9DOC_DATEDocument Date in Documentnvarchar80
TOPDSD Connector
33/DSD/ME_OPIM_HDDSD CN: Open Items header data5DOC_DATEDSD Connector: Document Datenvarchar80
TOPIncentive and Commission Management ICM
34CACSFI_DOCFI_HDSettlement to FI: Reference Document Header5DOC_DATEDocument Date in Documentnvarchar80
TOPJoint Venture und Production Sharing Accounting
35T8JFRMFarm In/Out & Re-Determination (Farm) Main Table12DOC_DATEDocument Date in Documentnvarchar80
36T8JFRM_STPFarm In/Out & Re-Determination (Farm) Main Table8DOC_DATEDocument Date in Documentnvarchar80
TOPLoans Management
37VDCHK_GROSS_NETStorage of data for report RFVD_GROSS_TO_NET13DOC_DATEDue datenvarchar80
TOPMaster Data
38CMS_AST_DOCAsset Documents6DOC_DATEDocument Datenvarchar80
39CMS_CAG_DOCCollateral Agreement Documents6DOC_DATEDocument Datenvarchar80
40CMS_OMS_DOC_LNKDocuments Link6DOC_DATEDocument Datenvarchar80
TOPReal Estate
41CMS_RE_PRT_DOCReal Estate Document details7DOC_DATEDocument Datenvarchar80
TOPSAP Retail Store
42WGMH_SRSHead for SRS PDC Goodsmovement13DOC_DATEDocument Date in Documentnvarchar80
43WSGM_HEAD_DB_TMPSRS GM: Temporary Persistence for Header Data7DOC_DATEDocument Date in Documentnvarchar80
44WSGR_HEAD_DB_TMPSRS GM: Temporary Persistence for Header Data14DOC_DATEDocument Date in Documentnvarchar80
TOPSecurities
45CMS_SEC_ACC_DOCLink between securities account and Documents is stored here6DOC_DATEDocument Datenvarchar80
TOPVehicle Management System
46VLCBATCHACTVELO : Variant for Action Execution in Batch22DOC_DATEDocument Date in Documentnvarchar80