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

107 columns | Print definition?ERP 6.0  | VENDOR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/1CN/CBPSAP001Vendor/product3VENDORSupplier GUIDvarbinary160
2/ATL/SHAAMWithholding tax for vendors from shaam2VENDORVendor number from Shaamnvarchar100
3/ATL/SHAAMSGWithholding tax for vendors from shaam error file2VENDORVendor numbernvarchar100
4/BIC/B0000190000PSA for 0MM_PUR_PURCH_DATA T90CLNT090 Purchasing Data18VENDORnvarchar100
5/BIC/B0000191000PSA for 0MM_PUR_PURCH_GROUPS T90CLNT090 Purchasing Groups13VENDORnvarchar100
6/BIC/B0000192000PSA for 0MM_PUR_SRV_LEVEL T90CLNT090 PO Service Level18VENDORnvarchar100
7/GBT/O_BAT_VENBatch master - Vendor batch3VENDORVendornvarchar100
8/GBT/O_DLVY_HDRDelivery23VENDORVendornvarchar100
9/GBT/O_HU_CONHandling Unit Connection10VENDORVendornvarchar100
10/GBT/O_PURO_HDRPurchasing Document15VENDORVendornvarchar100
11/OPT/VT_DOC_HEA1Document Header - copy of /opt/vt_doc_head15VENDORAccount Number of Vendor or Creditornvarchar100
12/OPT/VT_DOC_HEADDocument Header15VENDORAccount Number of Vendor or Creditornvarchar100
13/SAPSRM/SOCO_SETSettings for search in Sourcing Cockpit20VENDORBusiness Partner Numbernvarchar100
14/XLSO/COMM_SETUPCommunity Setup table5VENDORName/Description of external community vendornvarchar1000
15ARBERP_C_TAXCTGYMap ERP tax code to cXML tax category2VENDORVendor Account Numbernvarchar100
16CMCBD_CONSUMECash Budgeting Consumption34VENDORAccount Number of Vendor or Creditornvarchar100
17EPIC_CBCEPIC:Cash budgeting control consumption table11VENDORAccount Number of Vendor or Creditornvarchar100
18EPIC_CBC_EBRCash Budgeting Control of Bank Receipt8VENDORAccount Number of Vendor or Creditornvarchar100
19J_3RF_DI_OCCODEAssign Operator to Company Code3VENDOROperator of Company Codenvarchar100
20MDUBSMarket Data: Conversion: Basis Spread: Quotation Type2VENDORMarket Data: Data Providernvarchar100
21MDUCMDCSMarket Data: Price Type Conversion: Commodities / DCS2VENDORMarket Data: Data Providernvarchar100
22MDUCSMarket Data: Conversion of Credit Spread Quotation Type2VENDORMarket Data: Data Providernvarchar100
23MRP_REQ_NOTERequests and Notes for MRP Cockpit18VENDORAccount Number of Vendor or Creditornvarchar100
24QAM_L_BCV_AQIM: Temporary Storage Activities f. Business Context Viewer10VENDORVendornvarchar100
25QAM_L_BCV_IQIM: Temporary Storage Issues for Business Context Viewer11VENDORVendornvarchar100
26ZARIBA_VENDORAriba Vendor Mapping table2VENDORAccount Number of Vendor or Creditornvarchar100
27ZEHPRC_CM_D_ROOTRoot3VENDORSuppliernvarchar100
28ZSERV_DET_CUSTService details submitted by the customer7VENDORAccount Number of Vendor or Creditornvarchar100
TOPAustralia
29T5QSCTable for Superannuation SuperChoices15VENDORAccount Number of Vendor or Creditornvarchar100
30T5QSFSuperannuation Fund Code Designation Australia30VENDORAccount Number of Vendor or Creditornvarchar100
TOPBasic Functions
31BBP_ES_SETTINGSSettings for the E-Sourcing-ERP Integration2VENDORVendor Representing External Systemnvarchar100
TOPBasis Components
32/XFT/INV_Q_6PO details (header) for an invoice receipt process19VENDORVendor Account Numbernvarchar100
33/XFT/INV_Q_6_SPO details (header) for an invoice receipt process19VENDORVendor Account Numbernvarchar100
TOPClaims Management
34ICLBUT01External Services: Additions to Business Partner5VENDORReference Number of Business Partner in Procurement Systemnvarchar100
TOPCollaborative Cross Applications
35/POA/D_CLM_PG01Main Details of Package4VENDORVendornvarchar2500
TOPControlling
36IAOM_OM_EXATExternal Characteristics of Object in Outsourcing Manufact8VENDORVendor Account Numbernvarchar100
TOPCross-Application Component CA Enhancements
37/SAPMP/MIG_T002Migration CS -> DIMP: Object Status Batch Stock7VENDORAccount Number of Vendor or Creditornvarchar100
TOPCross-Application Components
38/OPT/S_GR_HDRVSS Staging Table: GR Header7VENDORAccount Number of Vendor or Creditornvarchar100
39/OPT/S_GR_LINVSS Stageing Table: GR Line9VENDORAccount Number of Vendor or Creditornvarchar100
40/OPT/S_INV_HDRVSS Staging Table: Invoice Header19VENDORAccount Number of Vendor or Creditornvarchar100
41/OPT/S_PAYMENTVSS Staging Table: Payment8VENDORAccount Number of Vendor or Creditornvarchar100
42/OPT/S_PO_HDRVSS Staging Table: PO Header14VENDORAccount Number of Vendor or Creditornvarchar100
43/OPT/VPRVendor Portal Registration2VENDORAccount Number of Vendor or Creditornvarchar100
44/OPT/VPR_LOCVendor Registration Location2VENDORAccount Number of Vendor or Creditornvarchar100
45/OPT/VPR_PARTNERPartners for Registered Vendor2VENDORAccount Number of Vendor or Creditornvarchar100
TOPDistribution
46WCAT_PROFILECost allocation profile17VENDORTake vendor into accountnvarchar10
TOPE-Recruiting
47HRP5144Database Table for Infotype 514434VENDORVendor (Pointer)nvarchar100
48HRP5145Database Table for Infotype 514537VENDORVendor (Pointer)nvarchar100
49T77RCF_BGCPAKGAssignment of Packages to Background Check Service Providers2VENDORVendor (Pointer)nvarchar100
50T77RCF_BGCPAKG_TAssignment of Packages to Background Check Service Providers3VENDORVendor (Pointer)nvarchar100
51T77RCF_BGCVNDINFBackground Check Vendor - Additional Information2VENDORVendor (Pointer)nvarchar100
52T77RCF_BGCVRESBackground Check Vendor Result Code2VENDORVendor (Pointer)nvarchar100
53T77RCF_BGCVRES_TText of Background Check Vendor Result Code3VENDORVendor (Pointer)nvarchar100
54T77RCF_RPVATTCHSave Options for Resume Parsing Vendor Attachment2VENDORVendor (Pointer)nvarchar100
55T77RCF_VNDR2ACTAssignment of Service Providers to Activity Types3VENDORVendor (Pointer)nvarchar100
56T77RCF_VNDSERVService Communication Supported by Vendor2VENDORVendor (Pointer)nvarchar100
TOPExchange Infrastructure
57SXMS_AE_AUDITCNFXI: Adapter Runtime Data2VENDORVendor of Adapter or Modulenvarchar400
TOPFinancial Accounting
58/CCEE/SIFIPE17Temporary import of goods16VENDORchar120nvarchar1200
TOPGlobal Trade
59WB2_D_COMSUBTrading Contract: commodity sub items26VENDORVendor Account Numbernvarchar100
60WB2_D_SHD_ITEMShadow Items15VENDORVendor Account Numbernvarchar100
TOPGrantor Management
61GTRVEND_ACCGRPAssignment Vendor -> Vendor account groups3VENDORAccount Number of Vendor or Creditornvarchar100
TOPMarketing, Accounting and Pricing
62OICQOILF&A Oil Table for Repository Default4VENDORF&A repository vendornvarchar100
63OIC_FORM_ATTRIBAttributes of Business Context for F&A Formula30VENDORVendor Account Numbernvarchar100
TOPMaster Data Synchronization
64CVI_VEND_LINKAssignment Between Vendor and Business Partner3VENDORAccount Number of Vendor or Creditornvarchar100
TOPMaterials Management
65J_1GMM2GVEnd year inventory9VENDORAccount Number of Vendor or Creditornvarchar100
TOPNetWeaver Business Content
66BIZCRDCBusiness Content: Development Component Versions4VENDORnvarchar200
67BIZCRDCVObsolete4VENDORnvarchar200
68BIZCRSCVBusiness Content: Software Component Versions5VENDORnvarchar2550
TOPOnline Correction Support Support Package and Add-On Tools
69PATPRDVRSProduct Versions Installed in SPAM/SAINT Queues5VENDORPPMS - Object Vendornvarchar300
70PATSWFEATRSW Features/Instances Installed in SPAM/SAINT Queues6VENDORPPMS - Object Vendornvarchar300
71PATSWFTINCMit SPAM/SAINT Queue installierte inkludierte SW Features8VENDORPPMS - Anbieter eines Objektsnvarchar300
72PRDVERSInformation About Installed Product Versions4VENDORPPMS - Object Vendornvarchar300
73SWFEATUREInformation About Installed Software Features (Instances)5VENDORPPMS - Object Vendornvarchar300
74SWFEATUREINCInformationen zu inkludierten Software-Features (Instanzen)7VENDORPPMS - Anbieter eines Objektsnvarchar300
75TECHUSAGESInformationen zu installierten Technical Usages5VENDORPPMS - Anbieter eines Objektsnvarchar300
TOPPrint and Output Management
76TFRT_INFOTypeface Repo - Font Info28VENDORTypeface Repo - Font Vendornvarchar640
TOPRegulatory reporting for insurance companies
77TMR90Umschlüsselung Kurskennzeichen2VENDORVendornvarchar50
78TMR91Kurskennzeichen / Vendor2VENDORVendornvarchar50
79TMR92Vendor2VENDORVendornvarchar50
80TMR93Umschlüsselung Handelsplatz2VENDORVendornvarchar50
81TMR94Umschlüsselung Währung2VENDORVendornvarchar50
TOPSAP NetWeaver Mobile - Use subcomponents
82MEREP_TEST_CUSTMI Test Tool - Customize Tables with Values16VENDORGeneral Flagnvarchar10
83MEREP_TREPLOPTMI Testtool:Replenishment Option5VENDORMI:Testcases Vendornvarchar100
84MEREP_TREQUISMI Testtool - Requisition2VENDORMI:Testcases Vendornvarchar100
85MEREP_TVENDORMI Testtool - Requisition2VENDORMI:Testcases Vendornvarchar100
TOPSAP Retail Store
86TREC_FORC_COMPLTemporary data for the receiving forecast4VENDORVendor Account Numbernvarchar100
87WGMH_SRSHead for SRS PDC Goodsmovement8VENDORVendor Account Numbernvarchar100
88WSGM_HEAD_DB_TMPSRS GM: Temporary Persistence for Header Data12VENDORAccount Number of Vendor or Creditornvarchar100
TOPSupplier Workplace
89ISAUTOSICVENDTABAccessible vendors per user3VENDORAccount Number of Vendor or Creditornvarchar100
TOPTariffs, Duties and Permits
90OIH_J1B_APRBrazil tax: Acquisition price table6VENDORAccount Number of Vendor or Creditornvarchar100
91OIH_J_1BTXIX1Tax calc.: ISS rules for sales and purchasing exeptions10VENDORAccount Number of Vendor or Creditornvarchar100
TOPTrading Contract
92WB2_D_STRINGLogistical string,circle and washout6VENDORVendor Account Numbernvarchar100
TOPTreasury
93MDUCMCPEMarket Data: Code Conversion Quotation Type Commodities/CPE2VENDORMarket Data: Data Providernvarchar100
94MDUCMVMarket Data: Code Conversion for Index Type2VENDORMarket Data: Data Providernvarchar100
95MDUCRMkt Data: Assign New Key for Curr. Symbols2VENDORMarket Data: Data Providernvarchar100
96MDUCVMkt Data: Assign New Key for Curr.Type2VENDORMarket Data: Data Providernvarchar100
97MDUHRMarket Data: Assign New Keys for Stock Exchanges2VENDORMarket Data: Data Providernvarchar100
98MDUIRMarket Data: Assign New Key for Index Name2VENDORMarket Data: Data Providernvarchar100
99MDUIVMkt Data:Ass.New Key for Index Type2VENDORMarket Data: Data Providernvarchar100
100MDURRMkt Data: Assign New Key for Ref. Interest Rate Name2VENDORMarket Data: Data Providernvarchar100
101MDUVVMkt Data: Assign New Key for Volatil. Type2VENDORMarket Data: Data Providernvarchar100
102MDUWRMarket Data: Assign New Key for Securities/Key 12VENDORMarket Data: Data Providernvarchar100
103MDUWVMkt Data: Assign New Key for Sec. Price Type2VENDORMarket Data: Data Providernvarchar100
TOPUpgrade - General
104NPRDVERSZu installierende Produktversionen im Schattenrepository4VENDORnvarchar300
105NSWFEATINCZu installierende inkludierte Instanzen im Schattenrep.7VENDORnvarchar300
106NSWFEATUREZu installierende Instanzen im Schattenrepository5VENDORnvarchar300
107NTECHUSAGEzu installierende Technical Usages im Schattenrep.5VENDORnvarchar300