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

133 columns | Print definition?ERP 6.0  | CITY

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/AIF/TEST_BP_IDXStandard index table33CITYCitynvarchar250
2/CCEE/FISC_BSFiscalization Croatia: Business Space Master Data8CITYCitynvarchar400
3/IXOS/DC_EX_ADDRAddresses of a customer4CITYCity of the Customernvarchar400
4/SAPQUERY/TA02Flight customers8CITYCitynvarchar250
5/SAPQUERY/TA03Geographical position of a city2CITYCitynvarchar200
6ACMTST_DB_ADACMTST: Address (DB-Table)6CITYnvarchar400
7BBP_PCPOSProcurement Card Statement: Position Data12CITYCitynvarchar400
8BBP_SUS_STG_ADRStaging address table5CITYCitynvarchar400
9BBP_TMP_ZA_ASPTemporary: Request 'Bidder', Contact Addresses6CITYCitynvarchar400
10BBP_TMP_ZA_ORGTemporary: Request 'Bidder', Company Address6CITYCitynvarchar400
11DSH_GEOCITYCheck table for GEOCITY stuff1CITYCitynvarchar200
12EHFNDD_VEN_DETLSVendor - Details13CITYVendor - Citynvarchar400
13EHPRCD_ORGIDSOrganisation9CITYCitynvarchar500
14HRP1660DB Table for Infotype 166022CITYDuty Station Citynvarchar40
15J_1GWTR0Vendor Tax Data12CITYCitynvarchar350
16PA0623HR Master Record: Infotype 062327CITYCitynvarchar400
17PB0623HR Master Record: Infotype 062327CITYCitynvarchar400
18REQADDRESSDelivery Address for Requirement Coverage Request Lines48CITYCitynvarchar400
19T5UPBSDSCITYUS Duty Station Cities4CITYDuty Station Citynvarchar40
20T5UPBSDSCITYTUS Federal Duty Station City Texts5CITYDuty Station Citynvarchar40
21T7OM08Table for Employer Registration Number for Social Insurance11CITYCitynvarchar400
22T7UNPF_HR_ADDRAddress11CITYCitynvarchar400
23TIVXCESPTDISCHRGMunicipal Property Tax - Discharges2CITYMunicipality Codenvarchar220
24TIVXCESPTDISCHRTMunicipal Property Tax - Discharges2CITYMunicipality Codenvarchar220
25TIVXCESPTTAXRATEMunicipal Property Tax Rate3CITYMunicipality Codenvarchar220
26TIVXCITF24PYMNTF24 Payment Data12CITYCitynvarchar400
27TIVXCITTASIRATETASI City rates3CITYCitynvarchar400
28VERGEOCITYContext-Veri: Geographische Lage einer Stadt2CITYOrtnvarchar200
29VIXCCHEGIDLocalization Switzerland: EGID9CITYCitynvarchar400
30VIXCESIBIDATAIBI master data9CITYMunicipality Codenvarchar50
31VIXCITCADAOTemporary architectural object data98CITYCitynvarchar400
32ZAIF_D01_SIDX_01Single index table for DEMO BUPA_IN34CITYCitynvarchar250
33ZEHPRC_SMELTERSSmelters6CITYLocationnvarchar250
34ZZIPZIP Codes USA2CITYOrtnvarchar400
35PIQDB_NL_ADDRMaintain GBA Address8CITYCitynvarchar400
TOPABAP Workbench, Java IDE and Infrastructure
36SCITAIRPCity-Airport assignment2CITYCitynvarchar200
37SCUSTOMFlight customers8CITYCitynvarchar250
38SGEOCITYGeographical position of a city2CITYCitynvarchar200
39STRAVELAGTravel agency7CITYCitynvarchar250
TOPBasic Functions
40LECI_EVENT_DATAActivity Data Within the Check-in/Check-out Process25CITYCitynvarchar400
41T850KCompany correspondence data12CITYCity where company is locatednvarchar300
TOPBasis Components
42/XFT/INV_QInvoice receipt queue: Header96CITYCitynvarchar350
43/XFT/INV_Q_SInvoice receipt queue: Header96CITYCitynvarchar350
44ZDS400_PLNTTabelle für Beispielprogramm des ZDS4004CITYAnkunftstadtnvarchar200
45ZDS400_TAB1Exercise table4CITYCHAR20 for SYSTnvarchar200
TOPBusiness Objects, Common Components
46EHDMOD_ADR_ROOTAddress - Root10CITYCitynvarchar400
TOPBusiness Server Pages
47AUUSERUser Table for the eRhine Auction House8CITYString 20 -> Name, Usrname, pwd, ... - use STRING for formsnvarchar400
TOPBW Service API
48ROVERCUSTAAttributes for Customers in Verification Scenario3CITYLocation in Verification Scenarionvarchar350
TOPClaims Management
49ICLCCEVENTRClaim Bundle - Region - Assignment7CITYCity Code for City/Street Filenvarchar120
50ICSCCEVENTRClaim Bundle - Region - Assignment7CITYCity Code for City/Street Filenvarchar120
TOPConsolidation
51TF162Consolidation Unit Correspondence8CITYCitynvarchar300
TOPCross-Application Components
52/OPT/VPR_ADDRVendor Address for Registered Vendor and Partner9CITYName of different postal city for city/street filenvarchar400
TOPDealer Portal
53/SAPDII/SPPSHIPAMaintaining Alternate shipping locations7CITYnvarchar350
TOPDownloadUpload
54/DSD/HH_RACADDSD Route Settlement: Customer Address Data (One-Time Only)6CITYCitynvarchar350
TOPDSD Connector
55/DSD/ME_CONTACTDSD Connector: Contact Person18CITYDSD Connector: Citynvarchar350
56/DSD/ME_CUST_CPDDSD CN: One-time Customer8CITYDSD Connector: Citynvarchar350
57/DSD/ME_CUST_HDDSD CN: Customer Details9CITYDSD Connector: Citynvarchar350
TOPE-Recruiting
58HRP5103DB Table for Infotype 510319CITYCitynvarchar400
59HRP5104DB Table for Infotype 510421CITYCitynvarchar400
60HRP5107DB Table for Infotype 510720CITYDesired Work Location - Citynvarchar400
61HRP5126DB Table for Infotype 512624CITYCity of Branchnvarchar400
62HRP9901eQuest Posting Information48CITYCity of Branchnvarchar400
TOPeCATT Extended Computer Aided Test Tool
63DEMO_SCUSTOMCreate Control Table Flight Customers8CITYCitynvarchar250
TOPEnvironment, Health and Safety
64/TDAG/CPT_ORGIDSIMDS Organisation9CITYCitynvarchar500
TOPExcise Duty
65/BEV2/CS_BPEMCS Process: Partners9CITYEMCS: Citynvarchar400
66/BEV2/CS_BP_HEMCS Process: Partners - History10CITYEMCS: Citynvarchar400
TOPFast Search Infrastructure
67SFSRFW_TEST_TRIGTabelle zum Testen von DB Trigger6CITYOrtnvarchar250
TOPFinancial Accounting
68FOTRFDITMVAT Refund Items50CITYCitynvarchar400
69FOTRFDITMCHGChange Documents, VAT Refund Item24CITYCitynvarchar400
70J_1GMYF0MYF data9CITYCitynvarchar100
71J_1GWTC0Withholding tax certificates data10CITYCitynvarchar350
TOPFlexible Real Estate Management
72TIVXCITICIPARAMICI/IMU City parameter2CITYCitynvarchar400
73TIVXCITICIRATEICI City rate3CITYCitynvarchar400
74VIXCITICIDATAICI master data8CITYCitynvarchar400
TOPFunctions for U.S. Federal Government
75FMCCRTVENDORCCR Vendor Table14CITYnvarchar350
76FMCCRTVENDORPOCCCR Vendor Points of Contact9CITYnvarchar350
TOPGeneral Object Relations
77SFLITPASSAttribute Table: Transit Passenger9CITYCitynvarchar250
TOPGL transfer
78TBKKC_BUKRSBCA Locally Duplicated Values for Corresponding FI4CITYCitynvarchar250
TOPIncident Recording
79EHHSSD_INC_BINFAIncident - Basic Information All29CITYCity of Incidentnvarchar400
80EHHSSD_INC_PROPIncident - Property16CITYCity of Involved Propertynvarchar400
TOPIntercompany Data Exchange
81EIDESWTMSGDATAMessage Data for Switch Document18CITYCitynvarchar400
82EIDESWTMSGTMPTemporary Switch Document Message Data17CITYCitynvarchar400
TOPLoans Management
83VDCBR_RES_DATATable of Data Reported to Credit Bureau (Per Loan)49CITYCity (Metro2 Format)nvarchar200
84VDCBR_RES_PARTPartner Data Reported to Credit Bureau (Pro Loan)23CITYCity (Metro2 Format)nvarchar200
TOPLocalization
85TIVXCPTPTTAXRATEMunicipal Property Tax Rate3CITYMunicipality Codenvarchar220
86TIVXCPTTAXRATEMunicipal Property Tax Rate for Portugal (obsolete)3CITYHierarchical Locationnvarchar220
87VIXCPTIMIDATAIMI Master Data7CITYMunicipality Codenvarchar40
TOPMaintenance Orders
88/MRSS/D_ADDRESSStores Primary/Secondary address7CITYCitynvarchar400
89/MRSS/D_GEO_ZIPPostal Codes for Georeferencing4CITYCitynvarchar400
TOPNetWeaver Demonstration
90SDEMO_BP_ADSAP NetWeaver Demo Model - Business Partner Address3CITYCitynvarchar400
91SNWD_ADEPM: Address Table3CITYEPM: Citynvarchar400
TOPNetWeaver Enterprise Search
92ESH_TST_CUST_ADRES Test Object Customer Address8CITYES Test Object: Citynvarchar350
TOPPatient Accounting
93NEHC_PATIS-H: Health Insurance Card (Patient Data)18CITYCitynvarchar400
TOPPayment Transactions
94TFIBLFFPVAROnline Payment: Variants17CITYCitynvarchar350
TOPPayroll
95PA0773Personel ana verileri: Bilgi tipi 077329CITYIl (devlet, il, ilçe, mahalle)nvarchar30
96T7TRG01General information about company.20CITYProvincenvarchar30
97T7UA1656Infotype 1656 Fields: Legal properties (Ukraine)8CITYAddress Citynvarchar300
TOPPersonnel Administration
98T7GR1HR10TEmployer Department (Texts)10CITYCitynvarchar500
TOPPortfolio
99VDBILL_RES_HEADBill Results Header31CITYCitynvarchar400
TOPPrint Workbench
100EFG_FLIGHT_DATAData by Data Dispatch5CITYCitynvarchar250
TOPPublic Sector Contract Accounts Receivable and Payable
101DFMCA_BRF650BRF: Business Partner Reading31CITYBRF: Expressionnvarchar200
102DFMCA_BRF890BRF: Business Partner Determination from Form32CITYBRF: Expressionnvarchar200
103DFMCA_TF_WHT_LLine Item Table of Withholding Tax19CITYCitynvarchar250
TOPSales and Distribution
104ZZDEA_MSTDrug Enforcement Administration (DEA)11CITYCitynvarchar400
TOPSchedule Manager
105T880Global Company Data (for KONS Ledger)10CITYCity where company is locatednvarchar300
TOPSingapore
106PA0412HR Master Record: Infotype 0412 [View to I0021] (SG)37CITYCitynvarchar250
TOPStructures Workbench
107/ISDFPS/CMDZONDTRelocation Zone Determination4CITYCitynvarchar400
TOPTalent Management
108HRP7402Internal Work Experience25CITYCitynvarchar400
109HRP7403External Work Experience19CITYCitynvarchar400
110HRP7404Education21CITYCitynvarchar400
TOPTariffs, Duties and Permits
111OIH_J1B_COPBrazil: Controled prices table4CITYCity Codenvarchar40
112OIH_J_1BTXIS1Tax calc.: ISS rules for sales exeptions5CITYCity Codenvarchar40
113OIH_J_1BTXIX1Tax calc.: ISS rules for sales and purchasing exeptions5CITYCity Codenvarchar40
TOPTransaction Tax Engine
114TTED_ACQUISI_COMAcquisition12CITYCitynvarchar300
115TTED_PARTNER_COMPartner18CITYCitynvarchar300
116TTED_PARTN_O_COMPartner in OutputDocument18CITYCitynvarchar300
117TTEPD3_PARTNERPartner17CITYCitynvarchar300
118TTEPDT_ITEMPARTPersistency TTE Document item partner9CITYCitynvarchar300
119TTEPDT_PARTNERPersistency TTE Document business partner7CITYCitynvarchar300
120TTESDT_ITEMPARTDocument item partner9CITYCitynvarchar300
121TTESDT_PARTNERDocument business partner7CITYCitynvarchar300
TOPTravel Expenses
122PTRV_VATDETAILSupplier Data for VAT Refund in Travel Management14CITYCitynvarchar400
123T706_VAT_FLDSCountry-Dependent Field Control for Receipt Data17CITYCitynvarchar10
TOPTravel Management
124TA23ADRPredefined Addresses in Travel Management6CITYCitynvarchar400
TOPTravel Planning
125FTPT_HOTEL_DATAHotel Data10CITYCitynvarchar400
126FTPT_REQUESTTravel Plan Requests27CITYCitynvarchar400
127TA23HOTELSHotel Data10CITYCitynvarchar400
128TA23OFFICE_ADRSales Office Addresses7CITYSales Office Address: Citynvarchar600
TOPUSA
129T5UP2Establishment/stores for tip processing10CITYCitynvarchar250
TOPWeb Dynpro ABAP
130WDR_TEST_SCIRP7City-Airport assignment2CITYCitynvarchar200
131WDR_TEST_SCIRP8City-Airport assignment2CITYCitynvarchar200
TOPWorkbench Utilities
132CUSTOMERSABAP Book: Customers5CITYCitynvarchar250
133GEOCITYABAP/4 book: Geographical position of a city2CITYCitynvarchar200