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

100 columns | Print definition?ERP 6.0  | NAME3

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/ATL/KPRCPTDetail of receipt13NAME3Name 3nvarchar350
2/ATL/KPRCPTKPDetail of temporary receipt13NAME3Name 3nvarchar350
3/FLDQ/AD_INI_ERRRecord records which encounter an error in RSADRINI31NAME3Name 3nvarchar400
4/FLDQ/AD_INI_IDXCopy of Shadow Table /fldq/ad_mtc_sh31NAME3Name 3nvarchar400
5/FLDQ/AD_MTCCODEFirstLogic Match Code Index Table31NAME3Name 3nvarchar400
6/FLDQ/AD_MTCRSLTMatch Results table to store results from RSADRINI program32NAME3Name 3nvarchar400
7/FLDQ/AD_MTC_SHFirstLogic Shadow table for /FLDQ/AD_MTCCODE31NAME3Name 3nvarchar400
8/FLDQ/AD_MTC_SH2FirstLogic Shadow table for /FLDQ/AD_MTCCODE31NAME3Name 3nvarchar400
9/FLDQ/AD_PUPDATEMatchcode Records pending to be updated31NAME3Name 3nvarchar400
10/FLDQ/HNA_BM_INHANA task Batch Match Input Records24NAME3Name 3nvarchar400
11BBP_SUS_STG_ADRStaging address table58NAME3Name 3 of organizationnvarchar400
12BBP_TMP_ZD_ORGTemporary: Request 'Bidder', Company Data16NAME3Name 3 of organizationnvarchar400
13BSECOne-Time Account Data Document Segment8NAME3Name 3nvarchar350
14CNVTDMS_11_SCADRScrambling Addresses6NAME3Name 3nvarchar400
15CNV_20305_CEPCSAP LT: Backup table of CEPC18NAME3Name 3nvarchar350
16FUDT_VDOCBSECOne-Time Account Data Segment of Verification Document8NAME3Name 3nvarchar350
17FUDT_VDOCBSECHOne-Time Account Data Segment of Verification Doc(History)8NAME3Name 3nvarchar350
18J_1UF_REEI_XML_AXML table for J_1UF_REEI with User17NAME3Name 3nvarchar400
19J_1UF_REP_XMLXML table for J_1UF_REP16NAME3Name 3nvarchar400
20J_1UF_REP_XML_AXML table for J_1UF_REEI with User17NAME3Name 3nvarchar400
21J_1UF_RES_XMLXML table for J_1UF_RES14NAME3Name 3nvarchar400
22TZGRGrouping rules for automatic payments8NAME3Field Name from Tables BSID or BSIKnvarchar300
23TZUNRules for 'Allocation' Field Layout8NAME3Field Name from Tables BKPF, BSEG, BSEC, BSED (field 3)nvarchar50
TOPAddress ManagementBusiness Address
24ADRCAddresses (Business Address Services)9NAME3Name 3nvarchar400
25ADRCSShadow Table: Addresses (Business Address Services)10NAME3Name 3nvarchar400
26ADRCS2Shadow Table 2: Addresses (Business Address Services)11NAME3Name 3nvarchar400
27SADRAddress Management: Company Data7NAME3Name 3nvarchar350
TOPAutomatic Payments
28PAYRQPayment Requests33NAME3Name 3nvarchar350
TOPBank Customer Accounts
29BKKPOGISPEDI Payments: Reporting Data to Clearing, Segm. E1EDLA19NAME3Name 3nvarchar350
TOPBasic Data
30NGPAIS-H: Business Partners8NAME3Third Namenvarchar350
TOPBasic Functions
31FSLSNForeign Trade: Legal Control - Sanctioned Party List - Names12NAME3Name 3nvarchar400
TOPBasis Components
32/XFT/INV_Q_6PO details (header) for an invoice receipt process28NAME3Name 3nvarchar400
33/XFT/INV_Q_6_SPO details (header) for an invoice receipt process28NAME3Name 3nvarchar400
TOPBusiness Partner Enhancements for Financial Services
34BP030BP: Business partner - address12NAME3Name 3nvarchar400
TOPClinical System
35N1DOKEMPFIS-H*MED: Recipient of the Documents17NAME3Third Namenvarchar350
36N2DLV_RECEIVERi.s.h.med: Dispatch - Recipient14NAME3Third Namenvarchar350
37N2MV_DISREQDispatch Request Data Table20NAME3Dispatch Control: 3rd Namenvarchar400
38N2MV_VSDATRecipient Data Table19NAME3Dispatch Control: 3rd Namenvarchar400
TOPControlling
39CSKSCost Center Master Data37NAME3Name 3nvarchar350
TOPCross-Application Components
40/OPT/VPR_ADDRVendor Address for Registered Vendor and Partner6NAME3Name 3nvarchar350
41BC490KKNA1General data in customer master42NAME3Name 3nvarchar350
42KKNA1General Data in Customer Master42NAME3Name 3nvarchar350
43SKNA1Customer Master table for BC417 Course42NAME3Name 3nvarchar350
TOPCustomer Master
44KNA1General Data in Customer Master42NAME3Name 3nvarchar350
TOPData Modeler
45TDM31Check Table for Owner4NAME3Text (30 Characters)nvarchar300
TOPDSD Connector
46/DSD/ME_CUST_HDDSD CN: Customer Details76NAME3DSD Connector: Namenvarchar350
TOPFinancial Accounting
47AC400ADRCP01 Adressen für Programm AC400DEBITOR9NAME3Name 3nvarchar400
48J_1UF_REEII_XMLXML table for J_1UF_REEII14NAME3Name 3nvarchar400
49J_1UF_REEI_XMLXML table for J_1UF_REEI16NAME3Name 3nvarchar400
50LFA1Vendor Master (General Section)6NAME3Name 3nvarchar350
51VBSECDocument Parking One-Time Data Document Segment8NAME3Name 3nvarchar350
TOPFSCM In-House Cash
52IHC_DB_PN_BPIHC: Address Data of Bus. Partners Involved in Payment Order10NAME3Name 3nvarchar350
TOPFunds Management
53FMFCTRFunds Center Master Record26NAME3Name 3nvarchar350
TOPFunds Management-Specific Postings
54PAYRCAdditional Header Data for Recovery Order16NAME3Name 3nvarchar350
55PSOSECRecurring Request Document Segment, One-Time Data10NAME3Name 3nvarchar350
TOPGL Account Posting
56TCJ_CPDFBCJ: One-Time Account Data of Cash Journal Document Items9NAME3Name 3nvarchar350
TOPGlobal Trade Services
57/SAPSLL/PREVDAUDSLL: Preference: Vend.Decl. for Customer Purp.: Audit16NAME3Name 3nvarchar400
58/SAPSLL/SPLAUDLegal Control - SPL - Audit49NAME3Name 3nvarchar400
TOPInvoice Verification
59RBKPDocument Header: Invoice Receipt83NAME3Name 3nvarchar350
TOPLoans Management
60VDAUSZDrawings on Disbursement20NAME3Name 3nvarchar350
61VDZNB_USAGEPayment Postprocessing: Usage of a Payment Postpr. Activity34NAME3Name 3nvarchar350
62VZFZE_VDAUSZCentral Entry Table for Release Procedure22NAME3Name 3nvarchar350
63VZFZE_VDNBZECentral Entry Table for Release Procedure54NAME3Name 3nvarchar350
TOPLocalization
64J_1BNFCPDNota Fiscal one-time accounts6NAME3Name 3nvarchar350
65J_1BNFDOCNota Fiscal Header70NAME3Name 3nvarchar350
66J_1BNFNADNota Fiscal partners10NAME3Name 3nvarchar350
67J_3RBUE_BK_HTABLTable head for EXTRACT19NAME3Name 3nvarchar400
TOPMaster Data
68EFISELField Selection Control for Address Data7NAME3Name 3nvarchar10
69JGTSADRIS-M: Extended Address Management17NAME3IS-M: Further Name Field for Business Partnernvarchar350
TOPOrganizational Management
70HRP1032Infotype 1032 DB Table20NAME3SAPoffice user namenvarchar120
TOPOverhead Cost Controlling
71CMDT_ADRGeneric Master Record: Address10NAME3Name 3nvarchar350
TOPPayment Transactions
72REGUHSettlement data from payment program16NAME3Name 3nvarchar350
TOPPendulum List Indirect Sales
73/BEV4/PLDUMKDNConversion Table Customer/Object Numbers12NAME3Name 3nvarchar350
TOPPeriodical Sales and Distribution
74JKWWWTEMP_BPIS-M/SD: WWW, Temporary Table for BP Data from Internet8NAME3IS-M: Further Name Field for Business Partnernvarchar350
75JKWWWTEMP_GIFTIS-M: Internet Temporary Table: Gift Data26NAME3IS-M: Further Name Field for Business Partnernvarchar350
76JKWWWTEMP_REDIRIS-M: Temporary Internet Table: Redirection Data26NAME3IS-M: Further Name Field for Business Partnernvarchar350
77JKWWWTEMP_SERVIS-M: Temporary Table for Changes from Internet7NAME3IS-M: Further Name Field for Business Partnernvarchar350
TOPPortfolio Management
78/RPM/ACT_GRP_C_TText for Activity Groups for Column Sets Chart7NAME3Activity Name Textnvarchar400
79/RPM/ACT_GRP_G_TText table for activity groups for Gantt Set Chart7NAME3Activity Name Textnvarchar400
TOPProduct Cost Planning
80CKBSBase Planning Object - Unit Costing27NAME3Name 3nvarchar350
TOPProfit Center Accounting
81CEPCProfit Center Master Data Table18NAME3Name 3nvarchar350
TOPPurchasing
82EKANVendor Address: Purchasing Document5NAME3Name 1nvarchar350
TOPReal Estate Management
83VIAKBSEGDocument Line Item from SCS for Interface72NAME3Employee's last namenvarchar350
TOPRecycling Administration Core Functions
84J_7LE01REA Partner Master Record: General Data (Country-Dependent)7NAME3Name 3nvarchar350
85J_7LSADRAddress Management: Company Data7NAME3Name 3nvarchar350
TOPRemaining Beverage - Obsolete Objects
86/BEV1/CLDEBCustomer Information6NAME3Name 3nvarchar350
TOPReuse Services for Country Development
87PA0865HR Master Record: Infotype 086570NAME3ID for Sub-Route in Mobility Recordnvarchar50
TOPSales Promotions
88SADLSTRECBDynamic Part of Address List (Record Body)19NAME3Name 3nvarchar350
TOPSAP Media
89J_1SFSPEDIS-M/SD CH/V: Addresses, Orders for Third-Party Shipping14NAME3IS-M: Further Name Field for Business Partnernvarchar350
TOPShipping
90DVK01R/2-R/3 Link: Delivery Header Data R2 -> R39NAME3Name 3nvarchar350
TOPSocial Insurance
91P01BD_DBKAData Module Different Correspondence Address5NAME3Name/Description of Company - Part 3nvarchar300
92P01BD_DSBDBusiness Data Maintenance Data Record17NAME3Name/Description of Company - Part 3nvarchar300
93T5D32_UVWorkers' Compensation Associations7NAME3Worker's Compensation Association: Name of Institutionnvarchar350
TOPTreasury
94SANO1Address-object relationship5NAME3Name 3nvarchar350
95VZKNA1Collector for batch input KNA1 from RF-VV18NAME3Name 3nvarchar350
TOPUser and Authorization Management
96USR03User address data5NAME3Name of user within the companynvarchar300
TOPWaste Management
97EHSWAT_APPBPMD: Waste Permit Partner30NAME3Name 3nvarchar400
98EHSWAT_MNBPWaste Manifest/Delivery Note: Partners27NAME3Name 3nvarchar400
99EPROP_ADRFLD_SELField Selection Control for Address Screen of Property7NAME3Name 3nvarchar10
100EROB_ADDRFLD_SELField Selection Control for Add. Screen of Cleaning Object7NAME3Name 3nvarchar10