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

178 columns | Print definition?ERP 6.0  | NAME2

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/AIF/T_INFDET_CHValues for Interface Determination6NAME2Name 2 of Interface Typenvarchar300
2/AIF/T_INFDET_VLValues for Interface Determination6NAME2Name 2 of Interface Typenvarchar300
3/AIF/T_INF_DETInterface Determination6NAME2Name 2 of Interface Typenvarchar300
4/ATL/KPRCPTDetail of receipt12NAME2Name 2nvarchar350
5/ATL/KPRCPTKPDetail of temporary receipt12NAME2Name 2nvarchar350
6/ATL/SHAAMSGWithholding tax for vendors from shaam error file6NAME2Vendor Name by ID or Vat Numbersnvarchar220
7/FLDQ/AD_INI_ERRRecord records which encounter an error in RSADRINI30NAME2Name 2nvarchar400
8/FLDQ/AD_INI_IDXCopy of Shadow Table /fldq/ad_mtc_sh30NAME2Name 2nvarchar400
9/FLDQ/AD_MTCCODEFirstLogic Match Code Index Table30NAME2Name 2nvarchar400
10/FLDQ/AD_MTCRSLTMatch Results table to store results from RSADRINI program31NAME2Name 2nvarchar400
11/FLDQ/AD_MTC_SHFirstLogic Shadow table for /FLDQ/AD_MTCCODE30NAME2Name 2nvarchar400
12/FLDQ/AD_MTC_SH2FirstLogic Shadow table for /FLDQ/AD_MTCCODE30NAME2Name 2nvarchar400
13/FLDQ/AD_PUPDATEMatchcode Records pending to be updated30NAME2Name 2nvarchar400
14/FLDQ/HNA_BM_INHANA task Batch Match Input Records23NAME2Name 2nvarchar400
15/OPT/VT_VENDReporting table: Vendors5NAME2Name 2nvarchar350
16/OTEI/OCR_TSTGStaging table for HDCC download data5NAME2Name at Birthnvarchar400
17/SAPSRM/SH_PLANTTable for ERP Search Help Plants12NAME2Name 2nvarchar400
18/SLOAP/KNA1General Data in Customer Master5NAME2Name 2nvarchar350
19BBPD_SUS_BP_NOTFSupplier to be Notified for First Use5NAME2Name 2 of organizationnvarchar400
20BBP_SUS_STG_ADRStaging address table57NAME2Name 2 of organizationnvarchar400
21BBP_TMP_ZD_ORGTemporary: Request 'Bidder', Company Data15NAME2Name 2 of organizationnvarchar400
22BSECOne-Time Account Data Document Segment7NAME2Name 2nvarchar350
23CNVTDMS_11_SCADRScrambling Addresses5NAME2Name 2nvarchar400
24CNV_20305_CEPCSAP LT: Backup table of CEPC17NAME2Name 2nvarchar350
25FUDT_VDOCBSECOne-Time Account Data Segment of Verification Document7NAME2Name 2nvarchar350
26FUDT_VDOCBSECHOne-Time Account Data Segment of Verification Doc(History)7NAME2Name 2nvarchar350
27J_1UF_REEI_XML_AXML table for J_1UF_REEI with User16NAME2Name 2nvarchar400
28J_1UF_REP_XMLXML table for J_1UF_REP15NAME2Name 2nvarchar400
29J_1UF_REP_XML_AXML table for J_1UF_REEI with User16NAME2Name 2nvarchar400
30J_1UF_RES_XMLXML table for J_1UF_RES13NAME2Name 2nvarchar400
31P01BN_BWXXData Record: Contribution Statement65NAME2Second Part of Employer's Namenvarchar300
32P2RB_ADRAddress payroll Belgium13NAME2Name at Birthnvarchar400
33P2RN_NADRAddress Data15NAME2Contact Namenvarchar400
34P2RN_NNAMPersonal Data5NAME2Second Namenvarchar400
35PAPBSGB_SWF_STAFSWF: Staff Details13NAME2Name at Birthnvarchar400
36T047RGrouping rules for dunning notices6NAME2Field Name from Tables BSID or BSIKnvarchar300
37T7RUPA0006PA0006 copy25NAME2Contact Namenvarchar400
38TIVXCITF24PYMNTF24 Payment Data11NAME2Name (Cont.)nvarchar200
39TZGRGrouping rules for automatic payments5NAME2Field Name from Tables BSID or BSIKnvarchar300
40TZUNRules for 'Allocation' Field Layout5NAME2Field Name from Tables BKPF, BSEG, BSEC, BSED (field 2)nvarchar50
41ZMY310_KNA1Kundenstamm5NAME2Name 2nvarchar350
TOPAddress ManagementBusiness Address
42ADRCAddresses (Business Address Services)8NAME2Name 2nvarchar400
43ADRCSShadow Table: Addresses (Business Address Services)9NAME2Name 2nvarchar400
44ADRCS2Shadow Table 2: Addresses (Business Address Services)10NAME2Name 2nvarchar400
45ADRPPersons (Business Address Services)9NAME2Name of person at birthnvarchar400
46ADRPSShadow Table: Persons (Business Address Services)10NAME2Name of person at birthnvarchar400
47SADRAddress Management: Company Data6NAME2Name 2nvarchar350
48SADRPAddress Management: Personal Data10NAME2Name 2nvarchar350
TOPAdvertising Management
49JJTAMIS-M/AM: Media Contact Person15NAME2IS-M: First Name of Business Partnernvarchar350
TOPAssortment List
50WBBHAssortment list header15NAME2Name 2nvarchar300
TOPAutomatic Payments
51PAYRQPayment Requests32NAME2Name 2nvarchar350
TOPBank Customer Accounts
52BKKPOGISPEDI Payments: Reporting Data to Clearing, Segm. E1EDLA18NAME2Name 2nvarchar350
TOPBasic Data
53NC301PIS-H EDI Data Collection Points9NAME2IS-HCM: EDI - Name 2 of the data collection pointnvarchar350
54NGPAIS-H: Business Partners6NAME2First Name / Second Namenvarchar350
TOPBasic Functions
55FSLSNForeign Trade: Legal Control - Sanctioned Party List - Names11NAME2Name 2nvarchar400
56T850KCompany correspondence data8NAME2Name of company 2nvarchar300
TOPBasis Components
57/XFT/INV_Q_6PO details (header) for an invoice receipt process27NAME2Name 2nvarchar400
58/XFT/INV_Q_6_SPO details (header) for an invoice receipt process27NAME2Name 2nvarchar400
59ZCUSTOMER_IDESCustomer Master (IDES Demo)5NAME2Name 2nvarchar350
TOPBusiness Partner Enhancements for Financial Services
60BP000Business Partner Master (General Data)13NAME2Name 2 (Continuation of NAME 1)nvarchar400
TOPCanada
61T5KYSNo longer used8NAME2Name 2nvarchar300
TOPClinical System
62N1DOKEMPFIS-H*MED: Recipient of the Documents16NAME2First Name / Second Namenvarchar350
63N1LSTEAMIS-H*MED: Tasks/Employees for a Service20NAME2First Name / Second Namenvarchar350
64N1PRPATIS-H*MED: PATREG: Patientenstammdatentabelle13NAME2IS-H: Takma ad, siparis adinvarchar300
65N1PRTMPPATIS-H*MED: PATREG: Temporäre Patientenstammdatentabelle14NAME2IS-H: Takma ad, siparis adinvarchar300
66N1PRTMPPATLOCIS-H*MED: PATREG: NPAT umgeschlüsselt auf N1PRPAT lokal14NAME2IS-H: Takma ad, siparis adinvarchar300
67N2DLV_RECEIVERi.s.h.med: Dispatch - Recipient13NAME2First Name / Second Namenvarchar350
68N2MV_DISREQDispatch Request Data Table19NAME2Dispatch Control: First Name / 2nd Namenvarchar400
69N2MV_VSDATRecipient Data Table18NAME2Dispatch Control: First Name / 2nd Namenvarchar400
TOPCollectionsDisbursements
70VVSCPOSESRPayment Plan Item: ISR Attachment10NAME2Name 2 (Continuation of NAME 1)nvarchar400
TOPCompany Pension Scheme Germany
71PA0746HR Master Record for Infotype 074631NAME2Name at Birth of Investornvarchar350
72T5DC3Pension Organization for Company Pension Scheme6NAME2Extended Namenvarchar400
TOPConsolidation
73TF162Consolidation Unit Correspondence5NAME2Name 2nvarchar500
TOPContract Accounts Receivable and Payable
74DFKKESRPOR Payment Supplement8NAME2Name 2 (Continuation of NAME 1)nvarchar400
75DFKKGP_SHORTData Extract: BP Data19NAME2Name field 2 (name2/first name)nvarchar400
76DFKKZAXRepayment Request (Address Data for Check)4NAME2Name field 2 (name2/first name)nvarchar400
77FKK_GPSHADData Extract: Business Partner Data (Faster Access)36NAME2Name field 2 (name2/first name)nvarchar400
TOPContract Billing
78TE187Utility Company3NAME2Name 2nvarchar300
TOPControlling
79CSKSCost Center Master Data36NAME2Name 2nvarchar350
TOPCross-Application Components
80/OPT/VPR_ADDRVendor Address for Registered Vendor and Partner5NAME2Name 2nvarchar350
81BC490KKNA1General data in customer master5NAME2Name 2nvarchar350
82KKNA1General Data in Customer Master5NAME2Name 2nvarchar350
83SKNA1Customer Master table for BC417 Course5NAME2Name 2nvarchar350
84T001W_EXTPlants (Company's Own and External)5NAME2Name 2nvarchar300
TOPCross-Application Objects in HR
85HRP5582DB Table for Infotype 558223NAME2Name at Birthnvarchar400
86HRP5583DB Table for Infotype 558319NAME2Contact Namenvarchar400
TOPCustomer Master
87KNA1General Data in Customer Master5NAME2Name 2nvarchar350
TOPData Modeler
88TDM31Check Table for Owner3NAME2Text (30 Characters)nvarchar300
TOPData Retention Tool
89TXW_S_BSEGRetrieve BSEG from archive119NAME2Name 2nvarchar350
TOPDocument Management Services
90SDOKPROFSDOK: Profiles4NAME2SDOK: Secondary key for profilesnvarchar800
TOPDownloadUpload
91/DSD/HH_RACADDSD Route Settlement: Customer Address Data (One-Time Only)5NAME2Name 2nvarchar350
TOPDSD Connector
92/DSD/ME_CUST_CPDDSD CN: One-time Customer5NAME2DSD Connector: Namenvarchar350
93/DSD/ME_CUST_HDDSD CN: Customer Details75NAME2DSD Connector: Namenvarchar350
TOPFinancial Accounting
94AC400ADRCP01 Adressen für Programm AC400DEBITOR8NAME2Name 2nvarchar400
95J_1UF_REEII_XMLXML table for J_1UF_REEII13NAME2Name 2nvarchar400
96J_1UF_REEI_XMLXML table for J_1UF_REEI15NAME2Name 2nvarchar400
97LFA1Vendor Master (General Section)5NAME2Name 2nvarchar350
98VBSECDocument Parking One-Time Data Document Segment7NAME2Name 2nvarchar350
TOPFSCM In-House Cash
99IHC_DB_PN_BPIHC: Address Data of Bus. Partners Involved in Payment Order9NAME2Name 2nvarchar350
TOPFunds Management
100FMFCTRFunds Center Master Record25NAME2Name 2nvarchar350
TOPFunds Management-Specific Postings
101PAYRCAdditional Header Data for Recovery Order15NAME2Name 2nvarchar350
102PSOSECRecurring Request Document Segment, One-Time Data9NAME2Name 2nvarchar350
TOPGL Account Posting
103TCJ_CPDFBCJ: One-Time Account Data of Cash Journal Document Items8NAME2Name 2nvarchar350
TOPGlobal Trade Services
104/SAPSLL/PREVDAUDSLL: Preference: Vend.Decl. for Customer Purp.: Audit15NAME2Name 2nvarchar400
105/SAPSLL/SPLAUDLegal Control - SPL - Audit48NAME2Name 2nvarchar400
TOPHong Kong
106PA0344HR Master Record: Infotype 0344 (Familiy members HK)24NAME2C/O Namenvarchar250
TOPInformation System
107DKKOSBalance Audit Trail10NAME2Name 2nvarchar300
108DKOKSOpen Item Account Balance Audit Trail Master Record11NAME2Name 2nvarchar300
109QSTREFI/HR Withholding Tax Report for Spain14NAME2Name 2nvarchar350
TOPInvoice Verification
110RBKPDocument Header: Invoice Receipt82NAME2Name 2nvarchar350
TOPLoans Management
111VDAUSZDrawings on Disbursement19NAME2Name 2nvarchar350
112VDZNB_USAGEPayment Postprocessing: Usage of a Payment Postpr. Activity33NAME2Name 2nvarchar350
113VZFZE_VDAUSZCentral Entry Table for Release Procedure21NAME2Name 2nvarchar350
114VZFZE_VDNBZECentral Entry Table for Release Procedure53NAME2Name 2nvarchar350
TOPLocalization
115J_1BNFCPDNota Fiscal one-time accounts5NAME2Name 2nvarchar350
116J_1BNFDOCNota Fiscal Header69NAME2Name 2nvarchar350
117J_1BNFNADNota Fiscal partners9NAME2Name 2nvarchar350
118J_3RBUE_BK_HTABLTable head for EXTRACT18NAME2Name 2nvarchar400
TOPLocations Location Structure
119EHFNDD_LOC_REVLocation - Revisions25NAME2Line 2 of Address Namenvarchar400
TOPLogistics Basic Data
120DMF_D_T001WTransferred Sites8NAME2Name 2nvarchar300
TOPMalaysia
121PA0213Additional family information - Malaysia42NAME2C/O Namenvarchar250
TOPMaster Data
122EFISELField Selection Control for Address Data5NAME2Name 2nvarchar10
123JGTSADRIS-M: Extended Address Management16NAME2IS-M: First Name of Business Partnernvarchar350
TOPOrganizational Management
124HRP1032Infotype 1032 DB Table19NAME2SAPoffice user namenvarchar120
TOPOverhead Cost Controlling
125CMDT_ADRGeneric Master Record: Address9NAME2Name 2nvarchar350
TOPPatient Accounting
126NEHC_INSIS-H: Health Insurance Card (Insurance Data)86NAME2nvarchar400
TOPPatient Management
127NPATIS-H: Patient Master Data (General)12NAME2Pseudonym, Order Namenvarchar300
TOPPayment Transactions
128REGUHSettlement data from payment program15NAME2Name 2nvarchar350
TOPPayroll
129PA0773Personel ana verileri: Bilgi tipi 077326NAME2Ad 2nvarchar300
130PA0885Personel ana verileri: Bilgi tipi 088525NAME2Ad 2nvarchar300
131PB0885Basvuru verileri bilgi tipi 0885 (örnek)25NAME2Ad 2nvarchar300
132T5HPBS06Technikai azonosító (1) - Közigazgatási szerv4NAME22. névnvarchar400
133T7TRG01General information about company.17NAME2Name 2nvarchar300
TOPPendulum List Indirect Sales
134/BEV4/PLDUMKDNConversion Table Customer/Object Numbers11NAME2Name 2nvarchar350
TOPPeriodical Sales and Distribution
135JKWWWTEMP_BPIS-M/SD: WWW, Temporary Table for BP Data from Internet7NAME2IS-M: First Name of Business Partnernvarchar350
136JKWWWTEMP_GIFTIS-M: Internet Temporary Table: Gift Data25NAME2IS-M: First Name of Business Partnernvarchar350
137JKWWWTEMP_REDIRIS-M: Temporary Internet Table: Redirection Data25NAME2IS-M: First Name of Business Partnernvarchar350
138JKWWWTEMP_SERVIS-M: Temporary Table for Changes from Internet6NAME2IS-M: First Name of Business Partnernvarchar350
TOPPersonnel Administration
139PA0002HR Master Record: Infotype 0002 (Personal Data)26NAME2Name at Birthnvarchar400
140PA0006HR Master Record: Infotype 0006 (Addresses)25NAME2Contact Namenvarchar400
141T500PPersonnel Areas6NAME2Name 2nvarchar300
TOPPlant Master
142T001WPlants/Branches8NAME2Name 2nvarchar300
TOPPortfolio Management
143/RPM/ACT_GRP_C_TText for Activity Groups for Column Sets Chart6NAME2Activity Name Textnvarchar400
144/RPM/ACT_GRP_G_TText table for activity groups for Gantt Set Chart6NAME2Activity Name Textnvarchar400
TOPProduct Cost Planning
145CKBSBase Planning Object - Unit Costing26NAME2Name 2nvarchar350
TOPProfit Center Accounting
146CEPCProfit Center Master Data Table17NAME2Name 2nvarchar350
TOPPublic Sector
147P01ZFA_NN_DATAZfA: Notifications Not Assigned19NAME2Name at Birth of Investornvarchar400
148P01ZFA_NN_KIDSZfA: Notifications Not Assigned - Child Data13NAME2Birth Name of Child Allowance Beneficiarynvarchar400
TOPPurchasing
149EKANVendor Address: Purchasing Document4NAME2Name 1nvarchar350
TOPReal Estate Localization Czech Republic
150/CEERE/RIZENIPT settings for company code27NAME2Business Name of Legal Personnvarchar400
TOPReal Estate Management
151S401RE standard analysis partner29NAME2Name 2 (Continuation of NAME 1)nvarchar400
152VIAKBSEGDocument Line Item from SCS for Interface71NAME2Employee's last namenvarchar350
TOPRecruitment
153PB0002HR Master Record: Infotype 0002 (Personal Data)26NAME2Name at Birthnvarchar400
154PB0006HR Master Record: Infotype 0006 (Addresses)25NAME2Contact Namenvarchar400
TOPRecycling Administration Core Functions
155J_7LE01REA Partner Master Record: General Data (Country-Dependent)6NAME2Name 2nvarchar350
156J_7LSADRAddress Management: Company Data6NAME2Name 2nvarchar350
TOPRemaining Beverage - Obsolete Objects
157/BEV1/CLDEBCustomer Information5NAME2Name 2nvarchar350
158/BEV1/RSQUSEQuick Settlement6NAME2Name 2nvarchar300
TOPReuse Services for Country Development
159PA0865HR Master Record: Infotype 086553NAME2ID for Sub-Route in Mobility Recordnvarchar50
TOPSales Promotions
160SADLSTRECBDynamic Part of Address List (Record Body)18NAME2Name 2nvarchar350
TOPSAP Healthcare - Industry-Specific Components for Hospitals
161NLVERZF_010Aufmachung patient name in Vektis format7NAME2IS-H: Pseudoniem, orde-naamnvarchar10
162TNWATSCDIS-H AT: Systeminformationen für EDI-Scoring9NAME2IS-H AT: EDV-Firma - Kontaktperson-Namenvarchar300
TOPSAP Media
163J_1SFSPEDIS-M/SD CH/V: Addresses, Orders for Third-Party Shipping13NAME2IS-M: First Name of Business Partnernvarchar350
TOPSchedule Manager
164T880Global Company Data (for KONS Ledger)5NAME2Name of company 2nvarchar300
TOPSecurity
165LAW_RESULTResult of License Measurement Consolidation4NAME2Name of user within the companynvarchar300
TOPShipping
166DVK01R/2-R/3 Link: Delivery Header Data R2 -> R38NAME2Name 2nvarchar350
TOPSocial Insurance
167P01BD_DBKAData Module Different Correspondence Address4NAME2Name/Description of Company - Part 2nvarchar300
168P01BD_DSBDBusiness Data Maintenance Data Record16NAME2Name/Description of Company - Part 2nvarchar300
169T5D32_UVWorkers' Compensation Associations6NAME2Worker's Compensation Association: Name of Institutionnvarchar350
TOPTax
170P01T_LSTETStmt: General Employment Tax Data21NAME2ETStmt: Name at Birthnvarchar300
TOPTransfer Postings
171J_1AAWAYBLWay Bills for asset movements28NAME2Name 2nvarchar350
TOPTreasury
172VZKNA1Collector for batch input KNA1 from RF-VV17NAME2Name 2nvarchar350
TOPUser and Authorization Management
173USR03User address data4NAME2Name of user within the companynvarchar300
TOPWaste Management
174EHSWAT_APPBPMD: Waste Permit Partner29NAME2Name 2nvarchar400
175EHSWAT_MNBPWaste Manifest/Delivery Note: Partners26NAME2Name 2nvarchar400
176EPROP_ADRFLD_SELField Selection Control for Address Screen of Property5NAME2Name 2nvarchar10
177EROB_ADDRFLD_SELField Selection Control for Add. Screen of Cleaning Object5NAME2Name 2nvarchar10
TOPWorkbench Tools Editors, Painters, Modelers
178BEISPIELRepository Infosystem: Sample Table for Template Report2NAME230 Charactersnvarchar300