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

186 columns | Print definition?ERP 6.0  | NAME1

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/AIF/T_INFDET_CHValues for Interface Determination5NAME1Name 1 of Interface Typenvarchar300
2/AIF/T_INFDET_VLValues for Interface Determination5NAME1Name 1 of Interface Typenvarchar300
3/AIF/T_INF_DETInterface Determination5NAME1Name 1 of Interface Typenvarchar300
4/ATL/KPRCPTDetail of receipt11NAME1Name 1nvarchar350
5/ATL/KPRCPTKPDetail of temporary receipt11NAME1Name 1nvarchar350
6/ATL/SHAAMSGWithholding tax for vendors from shaam error file4NAME1Vendor Name by ID or Vat Numbersnvarchar220
7/CEECV/RORFMDATARO RFUMSV00 official run data12NAME1Name 1nvarchar350
8/FLDQ/AD_INI_ERRRecord records which encounter an error in RSADRINI29NAME1Name 1nvarchar400
9/FLDQ/AD_INI_IDXCopy of Shadow Table /fldq/ad_mtc_sh29NAME1Name 1nvarchar400
10/FLDQ/AD_MTCCODEFirstLogic Match Code Index Table29NAME1Name 1nvarchar400
11/FLDQ/AD_MTCRSLTMatch Results table to store results from RSADRINI program30NAME1Name 1nvarchar400
12/FLDQ/AD_MTC_SHFirstLogic Shadow table for /FLDQ/AD_MTCCODE29NAME1Name 1nvarchar400
13/FLDQ/AD_MTC_SH2FirstLogic Shadow table for /FLDQ/AD_MTCCODE29NAME1Name 1nvarchar400
14/FLDQ/AD_PUPDATEMatchcode Records pending to be updated29NAME1Name 1nvarchar400
15/FLDQ/HNA_BM_INHANA task Batch Match Input Records22NAME1Name 1nvarchar400
16/OPT/VT_VENDReporting table: Vendors4NAME1Name 1nvarchar350
17/OPT/VT_WERKSVIM Reporting table: Plants4NAME1Namenvarchar300
18/SAPSRM/SH_PLANTTable for ERP Search Help Plants10NAME1Name 1nvarchar400
19/SLOAP/KNA1General Data in Customer Master4NAME1Name 1nvarchar350
20ANST_NOTE_SEA_PTrace Notes Search Item20NAME1Short textnvarchar600
21BBPD_SUS_BP_DUPLSUS/BP: Staging Table for Duplicate Check6NAME1Name 1 of organizationnvarchar400
22BBPD_SUS_BP_NOTFSupplier to be Notified for First Use4NAME1Name 1 of organizationnvarchar400
23BBP_SUS_STG_ADRStaging address table56NAME1Name 1 of organizationnvarchar400
24BBP_TMP_ZD_ORGTemporary: Request 'Bidder', Company Data14NAME1Name 1 of organizationnvarchar400
25BSECOne-Time Account Data Document Segment6NAME1Name 1nvarchar350
26CNVTDMS_11_SCADRScrambling Addresses4NAME1Name 1nvarchar400
27CNV_20305_CEPCSAP LT: Backup table of CEPC16NAME1Name 1nvarchar350
28CNV_20551_PERSAPersonnel areas (DEL_FLAG=X => relevant for deletion)6NAME1Personnel Area Textnvarchar300
29CNV_20800_KNVKCNV backup copy: Customer master contact person6NAME1Name 1nvarchar350
30DFKKHUREPDSRecording Data for Domestic Sales Hungary28NAME1Name field 1 (name1/last name)nvarchar400
31FIEUD_MMINV_HSAFT:MM: Header table for XML Purchase Invoice17NAME1Name 1nvarchar400
32FUDT_VDOCBSECOne-Time Account Data Segment of Verification Document6NAME1Name 1nvarchar350
33FUDT_VDOCBSECHOne-Time Account Data Segment of Verification Doc(History)6NAME1Name 1nvarchar350
34J_1UF_REEI_XML_AXML table for J_1UF_REEI with User15NAME1Vendor Namenvarchar450
35J_1UF_REP_XMLXML table for J_1UF_REP14NAME1Vendor Namenvarchar450
36J_1UF_REP_XML_AXML table for J_1UF_REEI with User15NAME1Vendor Namenvarchar450
37J_1UF_RES_XMLXML table for J_1UF_RES12NAME1Customer Namenvarchar450
38P01BN_BWXXData Record: Contribution Statement64NAME1Name of Employernvarchar300
39REFXCN_RETSTORETable For Store Retrieve5NAME1Namenvarchar300
40T047RGrouping rules for dunning notices3NAME1Field Name from Tables BSID or BSIKnvarchar300
41TIVXCITF24PYMNTF24 Payment Data10NAME1Namenvarchar240
42TNAD7Output Control: Printer per Storage Location6NAME1Employee's last namenvarchar350
43TZGRGrouping rules for automatic payments2NAME1Field Name from Tables BSID or BSIKnvarchar300
44TZUNRules for 'Allocation' Field Layout2NAME1Field Name from Tables BKPF, BSEG, BSEC, BSED (field 1)nvarchar50
45ZMY310_KNA1Kundenstamm4NAME1Name 1nvarchar350
TOPAccounts Receivable Accounting Process Integration
46FDM_CONTACT_BUFPersonalization of Contact Person Data7NAME1Name of Contact Person at Business Partnernvarchar400
TOPActual CostingMaterial Ledger
47CKMVFM_OUTOutput for the Value_Flow_Monitor, see SAP Note 91298418NAME1Namenvarchar300
TOPAddress ManagementBusiness Address
48ADRCAddresses (Business Address Services)7NAME1Name 1nvarchar400
49ADRCSShadow Table: Addresses (Business Address Services)8NAME1Name 1nvarchar400
50ADRCS2Shadow Table 2: Addresses (Business Address Services)9NAME1Name 1nvarchar400
51SADRAddress Management: Company Data5NAME1Name 1nvarchar350
52SADRPAddress Management: Personal Data9NAME1Name 1nvarchar350
TOPAdvertising Management
53JJTAMIS-M/AM: Media Contact Person14NAME1IS-M: Business Partner Namenvarchar350
TOPAssortment List
54WBBHAssortment list header14NAME1Namenvarchar300
55WBB_SAVE2Temporary Assortment List Objects: Store-Specific16NAME1Name 1nvarchar350
TOPAssortment Maintenance
56WRSTAssortment description4NAME1Description of Assortmentsnvarchar400
TOPAutomatic Payments
57PAYRQPayment Requests31NAME1Name 1nvarchar350
TOPBank Customer Accounts
58BKKPOGISPEDI Payments: Reporting Data to Clearing, Segm. E1EDLA17NAME1Name 1nvarchar350
TOPBasic Data
59NC301PIS-H EDI Data Collection Points8NAME1IS-HCM: EDI - Name 1 of the data collection pointnvarchar350
60NGPAIS-H: Business Partners4NAME1IS-H: Last Name/ 1st Namenvarchar350
TOPBasic Functions
61FSLSNForeign Trade: Legal Control - Sanctioned Party List - Names10NAME1Name 1nvarchar400
62T061ADevelopment Partner2NAME1Name 1nvarchar350
63T850KCompany correspondence data7NAME1Company namenvarchar300
TOPBasis Components
64/XFT/INV_Q_6PO details (header) for an invoice receipt process26NAME1Name 1nvarchar400
65/XFT/INV_Q_6_SPO details (header) for an invoice receipt process26NAME1Name 1nvarchar400
66ZCUSTOMER_IDESCustomer Master (IDES Demo)4NAME1Name 1nvarchar350
TOPBasis-Related Help Functions, Appl. Log, Formula Intepreter
67TBE12Complementary Software Partner3NAME1Name of a Complementary Software Partnernvarchar400
TOPBusiness Partner Enhancements for Financial Services
68BP000Business Partner Master (General Data)12NAME1Name 1 (surname for persons, otherwise company name)nvarchar400
TOPCanada
69T5KB6Registration/Account Grouping texts, Canada5NAME1Namenvarchar300
70T5KYSNo longer used7NAME1Personnel Area Textnvarchar300
TOPClinical System
71N1DOKEMPFIS-H*MED: Recipient of the Documents15NAME1IS-H: Last Name/ 1st Namenvarchar350
72N1LSTEAMIS-H*MED: Tasks/Employees for a Service19NAME1IS-H: Last Name/ 1st Namenvarchar350
73N2DLV_RECEIVERi.s.h.med: Dispatch - Recipient12NAME1IS-H: Last Name/ 1st Namenvarchar350
74N2MV_DISREQDispatch Request Data Table18NAME1Dispatch Control Last Name / 1st Namenvarchar400
75N2MV_VSDATRecipient Data Table17NAME1Dispatch Control Last Name / 1st Namenvarchar400
TOPCollectionsDisbursements
76VVSCPOSESRPayment Plan Item: ISR Attachment9NAME1Name 1 (surname for persons, otherwise company name)nvarchar400
TOPConsolidation
77TF162Consolidation Unit Correspondence4NAME1Name 1nvarchar500
TOPContract Accounts Receivable and Payable
78DFKKESRPOR Payment Supplement7NAME1Name 1 (surname for persons, otherwise company name)nvarchar400
79DFKKGP_SHORTData Extract: BP Data18NAME1Name field 1 (name1/last name)nvarchar400
80DFKKREPZMRecording Data for EC Sales List24NAME1Name field 1 (name1/last name)nvarchar400
81DFKKZAXRepayment Request (Address Data for Check)3NAME1Name field 1 (name1/last name)nvarchar400
82DPAYPPayment program - data on paid item21NAME1Name 1nvarchar400
83FKK_GPSHADData Extract: Business Partner Data (Faster Access)35NAME1Name field 1 (name1/last name)nvarchar400
TOPControlling
84CSKSCost Center Master Data35NAME1Name 1nvarchar350
TOPCross-Application Components
85/OPT/VPR_ADDRVendor Address for Registered Vendor and Partner4NAME1Name 1nvarchar350
86BC490KKNA1General data in customer master4NAME1Name 1nvarchar350
87CACNS_SEARCHCUSTFavorites for Customer Search Consultant Portal5NAME1Name 1nvarchar350
88KKNA1General Data in Customer Master4NAME1Name 1nvarchar350
89SKNA1Customer Master table for BC417 Course4NAME1Name 1nvarchar350
90SKNVKCustomer Master Contact table for BC417 Course5NAME1Name 1nvarchar350
91T001W_EXTPlants (Company's Own and External)4NAME1Namenvarchar300
TOPCustomer Master
92KNA1General Data in Customer Master4NAME1Name 1nvarchar350
93KNVKCustomer Master Contact Partner5NAME1Name 1nvarchar350
TOPData Modeler
94TDM31Check Table for Owner2NAME1Text (30 Characters)nvarchar300
TOPData Retention Tool
95TXW_S_BSEGRetrieve BSEG from archive118NAME1Name 1nvarchar350
TOPDownloadUpload
96/DSD/HH_RACADDSD Route Settlement: Customer Address Data (One-Time Only)4NAME1Name 1nvarchar350
TOPFinancial Accounting
97AC400ADRCP01 Adressen für Programm AC400DEBITOR7NAME1Name 1nvarchar400
98J_1UF_REEII_XMLXML table for J_1UF_REEII12NAME1Customer Namenvarchar450
99J_1UF_REEI_XMLXML table for J_1UF_REEI14NAME1Vendor Namenvarchar450
100LFA1Vendor Master (General Section)4NAME1Name 1nvarchar350
101VBSECDocument Parking One-Time Data Document Segment6NAME1Name 1nvarchar350
TOPFSCM In-House Cash
102IHC_DB_PN_BPIHC: Address Data of Bus. Partners Involved in Payment Order8NAME1Name 1nvarchar350
TOPFunds Management
103FMFCTRFunds Center Master Record24NAME1Name 1nvarchar350
TOPFunds Management-Specific Postings
104PAYRCAdditional Header Data for Recovery Order14NAME1Name 1nvarchar350
105PSOSECRecurring Request Document Segment, One-Time Data8NAME1Name 1nvarchar350
TOPGL Account Posting
106TCJ_CPDFBCJ: One-Time Account Data of Cash Journal Document Items7NAME1Name 1nvarchar350
TOPGlobal Trade Services
107/SAPSLL/PREVDAUDSLL: Preference: Vend.Decl. for Customer Purp.: Audit14NAME1Name 1nvarchar400
108/SAPSLL/SPLAUDLegal Control - SPL - Audit47NAME1Name 1nvarchar400
TOPInformation System
109DKKOSBalance Audit Trail9NAME1Namenvarchar300
110DKOKSOpen Item Account Balance Audit Trail Master Record10NAME1Namenvarchar300
111QSTREFI/HR Withholding Tax Report for Spain13NAME1Name 1nvarchar350
TOPInventory Management
112MWZDM07M1ZDM07M156NAME1Namenvarchar300
TOPInvoice Verification
113RBKPDocument Header: Invoice Receipt81NAME1Name 1nvarchar350
TOPJoint Venture und Production Sharing Accounting
114T8PSA_LIFT_TERMLifting Volumes by terminal15NAME1Additional text for PSC text elementsnvarchar400
TOPLoans Management
115VDAUSZDrawings on Disbursement18NAME1Name 1nvarchar350
116VDZNB_PAYMENTPayment Postprocessing: Payments for a PPP Activity14NAME1Field Namenvarchar210
117VDZNB_USAGEPayment Postprocessing: Usage of a Payment Postpr. Activity32NAME1Name 1nvarchar350
118VZFZE_VDAUSZCentral Entry Table for Release Procedure20NAME1Name 1nvarchar350
119VZFZE_VDNBZECentral Entry Table for Release Procedure52NAME1Name 1nvarchar350
TOPLocalization
120J_1BNFCPDNota Fiscal one-time accounts4NAME1Name 1nvarchar350
121J_1BNFDOCNota Fiscal Header68NAME1Name 1nvarchar350
122J_1BNFNADNota Fiscal partners8NAME1Name 1nvarchar350
123J_1IQRDEPQuarterly Returns Depot structure9NAME1Name 1nvarchar400
124J_3RBUE_BK_HTABLTable head for EXTRACT17NAME1Name 1nvarchar400
125J_3RF_REGINV_DEOutgoing invoice journal transp tab for IBOOK ver 29NAME1Name 1nvarchar350
126J_3RF_REGINV_KIncoming invoice journal transp tab for IBOOK9NAME1Name 1nvarchar350
TOPLocations Location Structure
127EHFNDD_LOC_REVLocation - Revisions24NAME1Line 1 of Address Namenvarchar400
TOPLogistics - General
128OIFSPBLPhysical Location - Master Data3NAME1Internal name fieldnvarchar350
TOPLogistics Basic Data
129DMF_D_T001WTransferred Sites3NAME1Namenvarchar300
TOPMaster Data
130EFISELField Selection Control for Address Data3NAME1Name 1nvarchar10
131JGTSADRIS-M: Extended Address Management15NAME1IS-M: Business Partner Namenvarchar350
132T012House Banks8NAME1Name of contact personnvarchar300
TOPMeter Reading
133TE115Meter Reader3NAME1Namenvarchar300
TOPNetWeaver Enterprise Search
134ESH_TST_CUST_ADRES Test Object Customer Address7NAME1ES Test Object: Namenvarchar350
TOPNon Profit Organizations
135T7UNPAD_AGENCY_TText for Agency4NAME1Name 1nvarchar350
TOPOrganizational Management
136HRP1032Infotype 1032 DB Table18NAME1SAPoffice user namenvarchar120
TOPOverhead Cost Controlling
137CMDT_ADRGeneric Master Record: Address8NAME1Name 1nvarchar350
TOPPatient Accounting
138NEHC_INSIS-H: Health Insurance Card (Insurance Data)85NAME1nvarchar400
TOPPayment Transactions
139FPRL_ITEMItem Data126NAME1Name 1nvarchar350
140REGUHSettlement data from payment program14NAME1Name 1nvarchar350
TOPPayroll
141PA0773Personel ana verileri: Bilgi tipi 077325NAME1Adnvarchar300
142PA0885Personel ana verileri: Bilgi tipi 088524NAME1Adnvarchar300
143PB0885Basvuru verileri bilgi tipi 0885 (örnek)24NAME1Adnvarchar300
144T5HPBS06Technikai azonosító (1) - Közigazgatási szerv3NAME11. névnvarchar400
145T5HPBS07Szervezeti egységek címe3NAME11. névnvarchar400
146T7TRG01General information about company.16NAME1Namenvarchar300
TOPPendulum List Indirect Sales
147/BEV4/PLDUMKDNConversion Table Customer/Object Numbers10NAME1Name 1nvarchar350
TOPPeriodical Sales and Distribution
148JKWWWTEMP_BPIS-M/SD: WWW, Temporary Table for BP Data from Internet6NAME1IS-M: Business Partner Namenvarchar350
149JKWWWTEMP_GIFTIS-M: Internet Temporary Table: Gift Data24NAME1IS-M: Business Partner Namenvarchar350
150JKWWWTEMP_REDIRIS-M: Temporary Internet Table: Redirection Data24NAME1IS-M: Business Partner Namenvarchar350
151JKWWWTEMP_SERVIS-M: Temporary Table for Changes from Internet5NAME1IS-M: Business Partner Namenvarchar350
TOPPersonnel Administration
152T500PPersonnel Areas5NAME1Personnel Area Textnvarchar300
TOPPlant Master
153T001WPlants/Branches3NAME1Namenvarchar300
TOPPortfolio Management
154/RPM/ACT_GRP_C_TText for Activity Groups for Column Sets Chart5NAME1Activity Name Textnvarchar400
155/RPM/ACT_GRP_G_TText table for activity groups for Gantt Set Chart5NAME1Activity Name Textnvarchar400
TOPProduct Cost Planning
156CKBSBase Planning Object - Unit Costing25NAME1Name 1nvarchar350
TOPProfit Center Accounting
157CEPCProfit Center Master Data Table16NAME1Name 1nvarchar350
TOPPromotion
158WAALMaterial-to-vendor assignment in price maintenance (promo.)19NAME1Name 1nvarchar350
TOPPurchasing
159EKANVendor Address: Purchasing Document3NAME1Name 1nvarchar350
160WDFR_DISPPerishables Planning Header14NAME1Namenvarchar300
TOPReal Estate Management
161S401RE standard analysis partner28NAME1Name 1 (surname for persons, otherwise company name)nvarchar400
162VIAKBSEGDocument Line Item from SCS for Interface70NAME1Employee's last namenvarchar350
TOPRecycling Administration Core Functions
163J_7LE01REA Partner Master Record: General Data (Country-Dependent)5NAME1Name 1nvarchar350
164J_7LSADRAddress Management: Company Data5NAME1Name 1nvarchar350
TOPRemaining Beverage - Obsolete Objects
165/BEV1/CLDEBCustomer Information4NAME1Name 1nvarchar350
166/BEV1/RBBOCustomer Master Data Rebate Processing6NAME1Name 1nvarchar350
167/BEV1/RSQUSEQuick Settlement4NAME1Namenvarchar300
TOPReuse Services for Country Development
168PA0865HR Master Record: Infotype 086536NAME1ID for Sub-Route in Mobility Recordnvarchar50
TOPSales Promotions
169SADLSTRECBDynamic Part of Address List (Record Body)17NAME1Name 1nvarchar350
TOPSAP Healthcare - Industry-Specific Components for Hospitals
170TNWATSCDIS-H AT: Systeminformationen für EDI-Scoring6NAME1IS-H AT: Krankenanstalt - Kontaktperson Namenvarchar300
TOPSAP Media
171J_1SFSPEDIS-M/SD CH/V: Addresses, Orders for Third-Party Shipping12NAME1IS-M: Business Partner Namenvarchar350
TOPSchedule Manager
172T880Global Company Data (for KONS Ledger)3NAME1Company namenvarchar300
TOPSecurity
173LAW_RESULTResult of License Measurement Consolidation3NAME1Name of user within the companynvarchar300
TOPService Station Retailing
174OIRECHBPAClearing house bus. partner role assignments (IS-Oil MRN)7NAME1Namenvarchar300
TOPShipping
175DVK01R/2-R/3 Link: Delivery Header Data R2 -> R37NAME1Name 1nvarchar350
TOPSocial Insurance
176P01BD_DBKAData Module Different Correspondence Address3NAME1Name/Description of Company Part 1nvarchar300
177P01BD_DSBDBusiness Data Maintenance Data Record15NAME1Name/Description of Company Part 1nvarchar300
178T5D32_UVWorkers' Compensation Associations5NAME1Worker's Compensation Association: Name of Institutionnvarchar350
TOPTransfer Postings
179J_1AAWAYBLWay Bills for asset movements27NAME1Name 1nvarchar350
TOPTreasury
180VZKNA1Collector for batch input KNA1 from RF-VV16NAME1Name 1nvarchar350
TOPUser and Authorization Management
181USR03User address data3NAME1Name of user within the companynvarchar300
TOPWaste Management
182EHSWAT_APPBPMD: Waste Permit Partner28NAME1Name 1nvarchar400
183EHSWAT_MNBPWaste Manifest/Delivery Note: Partners25NAME1Name 1nvarchar400
184EPROP_ADRFLD_SELField Selection Control for Address Screen of Property3NAME1Name 1nvarchar10
185EROB_ADDRFLD_SELField Selection Control for Add. Screen of Cleaning Object3NAME1Name 1nvarchar10
TOPWorkbench Tools Editors, Painters, Modelers
186BEISPIELRepository Infosystem: Sample Table for Template Report1NAME130 Charactersnvarchar300