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

83 columns | Print definition?ERP 6.0  | NAME4

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/ATL/KPRCPTDetail of receipt14NAME4Name 4nvarchar350
2/ATL/KPRCPTKPDetail of temporary receipt14NAME4Name 4nvarchar350
3/FLDQ/AD_INI_ERRRecord records which encounter an error in RSADRINI32NAME4Name 4nvarchar400
4/FLDQ/AD_INI_IDXCopy of Shadow Table /fldq/ad_mtc_sh32NAME4Name 4nvarchar400
5/FLDQ/AD_MTCCODEFirstLogic Match Code Index Table32NAME4Name 4nvarchar400
6/FLDQ/AD_MTCRSLTMatch Results table to store results from RSADRINI program33NAME4Name 4nvarchar400
7/FLDQ/AD_MTC_SHFirstLogic Shadow table for /FLDQ/AD_MTCCODE32NAME4Name 4nvarchar400
8/FLDQ/AD_MTC_SH2FirstLogic Shadow table for /FLDQ/AD_MTCCODE32NAME4Name 4nvarchar400
9/FLDQ/AD_PUPDATEMatchcode Records pending to be updated32NAME4Name 4nvarchar400
10/FLDQ/HNA_BM_INHANA task Batch Match Input Records25NAME4Name 4nvarchar400
11BBP_SUS_STG_ADRStaging address table59NAME4Name 4 of organizationnvarchar400
12BBP_TMP_ZD_ORGTemporary: Request 'Bidder', Company Data17NAME4Name 4 of organizationnvarchar400
13BSECOne-Time Account Data Document Segment9NAME4Name 4nvarchar350
14CNVTDMS_11_SCADRScrambling Addresses7NAME4Name 4nvarchar400
15CNV_20305_CEPCSAP LT: Backup table of CEPC19NAME4Name 4nvarchar350
16FUDT_VDOCBSECOne-Time Account Data Segment of Verification Document9NAME4Name 4nvarchar350
17FUDT_VDOCBSECHOne-Time Account Data Segment of Verification Doc(History)9NAME4Name 4nvarchar350
18J_1UF_REEI_XML_AXML table for J_1UF_REEI with User18NAME4Name 4nvarchar400
19J_1UF_REP_XMLXML table for J_1UF_REP17NAME4Name 4nvarchar400
20J_1UF_REP_XML_AXML table for J_1UF_REEI with User18NAME4Name 4nvarchar400
21J_1UF_RES_XMLXML table for J_1UF_RES15NAME4Name 4nvarchar400
22TZUNRules for 'Allocation' Field Layout11NAME4Field Name from Tables BKPF, BSEG, BSEC, BSED (field 4)nvarchar50
TOPAddress ManagementBusiness Address
23ADRCAddresses (Business Address Services)10NAME4Name 4nvarchar400
24ADRCSShadow Table: Addresses (Business Address Services)11NAME4Name 4nvarchar400
25ADRCS2Shadow Table 2: Addresses (Business Address Services)12NAME4Name 4nvarchar400
26SADRAddress Management: Company Data8NAME4Name 4nvarchar350
TOPAutomatic Payments
27PAYRQPayment Requests34NAME4Name 4nvarchar350
TOPBank Customer Accounts
28BKKPOGISPEDI Payments: Reporting Data to Clearing, Segm. E1EDLA110NAME4Name 4nvarchar350
TOPBasic Functions
29FSLSNForeign Trade: Legal Control - Sanctioned Party List - Names13NAME4Name 4nvarchar400
TOPBasis Components
30/XFT/INV_Q_6PO details (header) for an invoice receipt process29NAME4Name 4nvarchar400
31/XFT/INV_Q_6_SPO details (header) for an invoice receipt process29NAME4Name 4nvarchar400
TOPBusiness Partner Enhancements for Financial Services
32BP030BP: Business partner - address13NAME4Name 4nvarchar400
TOPControlling
33CSKSCost Center Master Data38NAME4Name 4nvarchar350
TOPCross-Application Components
34BC490KKNA1General data in customer master43NAME4Name 4nvarchar350
35KKNA1General Data in Customer Master43NAME4Name 4nvarchar350
36SKNA1Customer Master table for BC417 Course43NAME4Name 4nvarchar350
TOPCustomer Master
37KNA1General Data in Customer Master43NAME4Name 4nvarchar350
TOPData Modeler
38TDM31Check Table for Owner5NAME4Text (30 Characters)nvarchar300
TOPDSD Connector
39/DSD/ME_CUST_HDDSD CN: Customer Details77NAME4DSD Connector: Namenvarchar350
TOPFinancial Accounting
40AC400ADRCP01 Adressen für Programm AC400DEBITOR10NAME4Name 4nvarchar400
41J_1UF_REEII_XMLXML table for J_1UF_REEII15NAME4Name 4nvarchar400
42J_1UF_REEI_XMLXML table for J_1UF_REEI17NAME4Name 4nvarchar400
43LFA1Vendor Master (General Section)7NAME4Name 4nvarchar350
44VBSECDocument Parking One-Time Data Document Segment9NAME4Name 4nvarchar350
TOPFSCM In-House Cash
45IHC_DB_PN_BPIHC: Address Data of Bus. Partners Involved in Payment Order11NAME4Name 4nvarchar350
TOPFunds Management
46FMFCTRFunds Center Master Record27NAME4Name 4nvarchar350
TOPFunds Management-Specific Postings
47PAYRCAdditional Header Data for Recovery Order17NAME4Name 4nvarchar350
48PSOSECRecurring Request Document Segment, One-Time Data11NAME4Name 4nvarchar350
TOPGL Account Posting
49TCJ_CPDFBCJ: One-Time Account Data of Cash Journal Document Items10NAME4Name 4nvarchar350
TOPGlobal Trade Services
50/SAPSLL/PREVDAUDSLL: Preference: Vend.Decl. for Customer Purp.: Audit17NAME4Name 4nvarchar400
51/SAPSLL/SPLAUDLegal Control - SPL - Audit50NAME4Name 4nvarchar400
TOPInvoice Verification
52RBKPDocument Header: Invoice Receipt84NAME4Name 4nvarchar350
TOPLoans Management
53VDAUSZDrawings on Disbursement21NAME4Name 4nvarchar350
54VDZNB_USAGEPayment Postprocessing: Usage of a Payment Postpr. Activity35NAME4Name 4nvarchar350
55VZFZE_VDAUSZCentral Entry Table for Release Procedure23NAME4Name 4nvarchar350
56VZFZE_VDNBZECentral Entry Table for Release Procedure55NAME4Name 4nvarchar350
TOPLocalization
57J_1BNFCPDNota Fiscal one-time accounts7NAME4Name 4nvarchar350
58J_1BNFDOCNota Fiscal Header71NAME4Name 4nvarchar350
59J_1BNFNADNota Fiscal partners11NAME4Name 4nvarchar350
60J_3RBUE_BK_HTABLTable head for EXTRACT20NAME4Name 4nvarchar400
TOPMaster Data
61EFISELField Selection Control for Address Data10NAME4Name 4nvarchar10
62JGTSADRIS-M: Extended Address Management18NAME4IS-M: Further Name Field for Business Partnernvarchar350
TOPOrganizational Management
63HRP1032Infotype 1032 DB Table21NAME4SAPoffice user namenvarchar120
TOPOverhead Cost Controlling
64CMDT_ADRGeneric Master Record: Address11NAME4Name 4nvarchar350
TOPPayment Transactions
65REGUHSettlement data from payment program17NAME4Name 4nvarchar350
TOPPendulum List Indirect Sales
66/BEV4/PLDUMKDNConversion Table Customer/Object Numbers13NAME4Name 4nvarchar350
TOPProduct Cost Planning
67CKBSBase Planning Object - Unit Costing28NAME4Name 4nvarchar350
TOPProfit Center Accounting
68CEPCProfit Center Master Data Table19NAME4Name 4nvarchar350
TOPPurchasing
69EKANVendor Address: Purchasing Document6NAME4Name 1nvarchar350
TOPReal Estate Management
70VIAKBSEGDocument Line Item from SCS for Interface73NAME4Employee's last namenvarchar350
TOPRecycling Administration Core Functions
71J_7LSADRAddress Management: Company Data8NAME4Name 4nvarchar350
TOPRemaining Beverage - Obsolete Objects
72/BEV1/CLDEBCustomer Information7NAME4Name 4nvarchar350
TOPReuse Services for Country Development
73PA0865HR Master Record: Infotype 086587NAME4ID for Sub-Route in Mobility Recordnvarchar50
TOPSales Promotions
74SADLSTRECBDynamic Part of Address List (Record Body)20NAME4Name 4nvarchar350
TOPSAP Media
75J_1SFSPEDIS-M/SD CH/V: Addresses, Orders for Third-Party Shipping15NAME4IS-M: Further Name Field for Business Partnernvarchar350
TOPShipping
76DVK01R/2-R/3 Link: Delivery Header Data R2 -> R310NAME4Name 4nvarchar350
TOPTreasury
77SANO1Address-object relationship6NAME4Name 4nvarchar350
78VZKNA1Collector for batch input KNA1 from RF-VV19NAME4Name 4nvarchar350
TOPUser and Authorization Management
79USR03User address data6NAME4Name of user within the companynvarchar300
TOPWaste Management
80EHSWAT_APPBPMD: Waste Permit Partner31NAME4Name 4nvarchar400
81EHSWAT_MNBPWaste Manifest/Delivery Note: Partners28NAME4Name 4nvarchar400
82EPROP_ADRFLD_SELField Selection Control for Address Screen of Property10NAME4Name 4nvarchar10
83EROB_ADDRFLD_SELField Selection Control for Add. Screen of Cleaning Object10NAME4Name 4nvarchar10