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

35 columns | Print definition?ERP 6.0  | POST_CODE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/CCEE/FISC_BSFiscalization Croatia: Business Space Master Data7POST_CODEPostal Codenvarchar120
2VIXCCHEGIDLocalization Switzerland: EGID8POST_CODECity postal codenvarchar100
TOPAddress ManagementBusiness Address
3ADRCITYPRTPostal districts5POST_CODEPostal Codenvarchar100
4ADRDIF_CPDistrict Difference Table for Quarterly Adjustment12POST_CODEPostal Codenvarchar100
5ADRDIF_PCPostal Code Difference Table for Quarterly Adjustment11POST_CODEPostal Codenvarchar100
6ADRDIF_POPO Box Difference Table for Quarterly Adjustment14POST_CODEPostal Codenvarchar100
7ADRDIF_STStreet Difference Table for Quarterly Adjustment22POST_CODEPostal Codenvarchar100
8ADRPCDCITYPostal code/city: Assignment table3POST_CODEPostal Codenvarchar100
9ADRPOBOXPO Boxes7POST_CODEPostal Codenvarchar100
10ADRPSTCODEPostal codes3POST_CODEPostal Codenvarchar100
11ADRSTRPCDStreet (section)/postal code: Assignment9POST_CODEPostal Codenvarchar100
TOPClaims Management
12ICLCCEVENTZClaim Bundle - Postal Code - Assignment5POST_CODEPostal Codenvarchar100
13ICSCCEVENTZClaim Bundle - Postal Code - Assignment5POST_CODEPostal Codenvarchar100
TOPFinancial Accounting
14FOTRFDITMVAT Refund Items49POST_CODECity postal codenvarchar100
15FOTRFDITMCHGChange Documents, VAT Refund Item23POST_CODECity postal codenvarchar100
TOPIntegration Customer Relationship Management
16ESALES_PRODAVAILAvailability of a Product4POST_CODECity postal codenvarchar100
TOPInterfaces
17VRTCPRouting Info per Carrier/Country/Zip Code4POST_CODEPostal Codenvarchar100
TOPJapan
18T7JPCP_EXTINSTDefine External Institution4POST_CODEPostal Codenvarchar100
19T7JPCP_PENSIONCorporate Pension Plan20POST_CODEPostal Codenvarchar100
TOPLoans Management
20VDCBR_RES_PARTPartner Data Reported to Credit Bureau (Pro Loan)25POST_CODEPostal Code (Metro2 Format)nvarchar90
TOPMaintenance Orders
21/MRSS/D_ADDRESSStores Primary/Secondary address9POST_CODECity postal codenvarchar100
22/MRSS/D_GEO_ZIPPostal Codes for Georeferencing3POST_CODECity postal codenvarchar100
TOPMaster Data
23EBP_ADDR_SERVICESearch Index for Business Partner Service Addresses10POST_CODECity postal codenvarchar100
TOPPeriodical Sales and Distribution
24JVSOPIS-M/SD Shipping Order Item10POST_CODEIS-M: Postal Codenvarchar100
TOPPortfolio Management
25RPM_PROJ_LOCATProject Location8POST_CODEPostal Codenvarchar100
TOPProcessing
26EWA_WDOC_WA_PCSelection Data from Work Area for Regional Structure4POST_CODEPostal Codenvarchar100
TOPProject Management
27DPR_LOCATIONLocation8POST_CODEPostal Codenvarchar100
TOPStakeholder Relationship Management
28USC_CONT_ADDSRM Contact: Event Info14POST_CODECity postal codenvarchar100
TOPStructures Workbench
29/ISDFPS/CMDZONDTRelocation Zone Determination5POST_CODECity postal codenvarchar100
TOPTravel Expenses
30PTRV_VATDETAILSupplier Data for VAT Refund in Travel Management13POST_CODECity postal codenvarchar100
31T706_VAT_FLDSCountry-Dependent Field Control for Receipt Data16POST_CODECity Postal Codenvarchar10
TOPTravel Management
32TA23ADRPredefined Addresses in Travel Management7POST_CODECity postal codenvarchar100
TOPTravel Planning
33FTPT_HOTEL_DATAHotel Data11POST_CODECity postal codenvarchar100
34FTPT_REQUESTTravel Plan Requests28POST_CODECity postal codenvarchar100
35TA23HOTELSHotel Data11POST_CODECity postal codenvarchar100