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

58 columns | Print definition?ERP 6.0  | ADDRESS

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/DSCSAG/EVENTHEvent Header Table4ADDRESSEvent Addressnvarchar320
2COPC_ACCOUNTCash Account36ADDRESSContact Person's Addressnvarchar1280
3J_1GWTR0Vendor Tax Data10ADDRESSHouse number and streetnvarchar350
4SIMDQ_MTC_POLICYIM in HANA match policy settings8ADDRESSIM in HANA Address component in Match Policy settingnvarchar10
5SWWBCSSTATUSWorkflow: Demo for BCS Status - Confirmations8ADDRESSCommunication Address (for INT, FAX, SMS, and so on)ntext10737418230
6T5V2QNorwegian NAV offices and post codes4ADDRESSNAV office addressnvarchar400
7TIVXCITF24PYMNTF24 Payment Data14ADDRESSFiscal Addressnvarchar500
TOPAgency Business Global Trade
8WBPAAgency Business: Business Partner Assignment13ADDRESSAddressnvarchar100
TOPClaims Management
9ICLITEMREDamaged Real Estate10ADDRESSAddress (CAM) of Buildingnvarchar100
10ICLNOLPNotice of Loss Participant4ADDRESSAddress Number of Person Reporting Lossnvarchar100
11ICLPOLOREInsured Building11ADDRESSAddress (CAM) of Buildingnvarchar100
12ICLPOLOSIInsured Site10ADDRESSAddress of environmental sitenvarchar100
13ICSITEMREDamaged Real Estate10ADDRESSAddress (CAM) of Buildingnvarchar100
14ICSPOLOREInsured Building11ADDRESSAddress (CAM) of Buildingnvarchar100
15ICSPOLOSIInsured Site10ADDRESSAddress of environmental sitenvarchar100
TOPCommunication Services Mail, Fax, SMS, Telephony
16BCSD_RQSTBCS: Status Requests for Specific Address Area2ADDRESSBCS: Address Area with Specific Requested Status Settingnvarchar800
17BCSD_STMLBCS: Status Confirmation by E-Mail for Specific Address Area2ADDRESSBCS: Address Area with Specific Settings for E-Mail Notif.nvarchar800
18SRIRSCENDEBCOM Internal Router: Scenario Destinations6ADDRESSE-Mail Addressnvarchar2410
19SRSCENDESTRouting Scenario: Destinations5ADDRESSE-Mail Addressnvarchar2410
20SRSDESTRouting Server: Description Table6ADDRESSE-Mail Addressnvarchar2410
TOPCross-Application Components
21LWM_CC_LOCATIONlocation of issue5ADDRESSAddress String Composed by Mobile Appntext10737418230
TOPData Retention Tool
22TXW_DIRSEGData file segment directory (replaced by txw_dirsg2: uuids)8ADDRESSFile offset in bytesnvarchar100
23TXW_DIRSG2Data file segment directory8ADDRESSFile offset in bytesnvarchar100
24TXW_INDEXTemporary table for data segment index6ADDRESSNatural Numberint100
25TXW_INDEX_01Temporary table for data segment index6ADDRESSNatural Numberint100
26TXW_INDEX_02Temporary table for data segment index6ADDRESSNatural Numberint100
27TXW_INDEX_03Temporary table for data segment index6ADDRESSNatural Numberint100
28TXW_INDEX_04Temporary table for data segment index6ADDRESSNatural Numberint100
29TXW_INDEX_05Temporary table for data segment index6ADDRESSNatural Numberint100
TOPDSD Connector
30/DSD/ME_CUST_CPDDSD CN: One-time Customer6ADDRESSDSD Connector: Addressnvarchar400
31/DSD/ME_CUST_HDDSD CN: Customer Details7ADDRESSDSD Connector: Addressnvarchar400
TOPEmployee Self-Service
32T77WWW_SRVESS Service3ADDRESSESS Address (URL) or Logical Address of Servicenvarchar2000
TOPFinancial Accounting
33J_1GWTC0Withholding tax certificates data8ADDRESSHouse number and streetnvarchar350
34J_3KBANKBank accounts in ZAP6ADDRESSBank addressnvarchar300
TOPLocations Location Structure
35EHFNDD_LOC_PARTNLocation - Partners12ADDRESSBusiness Partner Address for Locationnvarchar800
TOPOLAP Technology
36RSDDTREXEMAILE-Mail-Addresses = Recipient for Canceled HPA Queries1ADDRESSE-Mail Addressnvarchar2410
TOPPayroll
37T7ROG5EE register - ER history11ADDRESSText field length 200nvarchar2000
TOPPerformance Monitors TCC
38GVD_SQLCopy of GV$SQL (currently not provided with snapshots)28ADDRESSOracle Monitoring: ADDRESS: @ of Handle to Parent Cursorvarbinary80
39GVD_SQLAREACopy of GV$SQLAREA (currently not provided with snapshots)3ADDRESSOracle monitoring: ADDRvarbinary80
40GVD_SQLTEXTCopy of GV$SQLTEXT (currently not provided with snapshots)3ADDRESSOracle monitoring: ADDRESS: Address of a cursorvarbinary80
41GVD_SQL_WORKAREAOracle Monitoring: Copy of GV$SQL_WORKAREA4ADDRESSOracle Monitoring: ADDRESS: @ of Handle to Parent Cursorvarbinary80
TOPPeriodical Sales and Distribution
42JVSOPIS-M/SD Shipping Order Item8ADDRESSIS-M: Address Numbernvarchar100
TOPPost Processing Framework
43PPFTSFMLRUPPF: Medium Smart Forms Mail (Runtime)22ADDRESSPPF: Address of a Mail Recipient (SMTP, Distribution List..)nvarchar500
44PPFTSFMLT2PPF: Medium Smart Forms Mail (Template)13ADDRESSPPF: Address of a Mail Recipient (SMTP, Distribution List..)nvarchar500
45PPFTSFMLTEPPF: Medium Smart Forms Mail (Template)13ADDRESSPPF: Address of a Mail Recipient (SMTP, Distribution List..)nvarchar500
TOPProcess Management
46CMX_DA_REGManufacturing Data Access: Registration Entries5ADDRESSManufacturing Data Access: Addressnvarchar2420
TOPProcess Monitoring Infrastructure
47SSPIPSADDRProcess Step Addresses4ADDRESSProcess Step Addressnvarchar320
TOPReusable Components of Business Suite Foundation
48/BOBF/DM_CST_HDRCustomer Header13ADDRESSAddress (Text)ntext10737418230
TOPReuse Services for Country Development
49T50F0HR-FORMS: Assignment of Standard Texts to Forms6ADDRESSHR-FORMS: Standard text for addressnvarchar300
TOPSAP Business Workflow
50SWFWSPPORTWebFlow XML Cache: Web Service Ports7ADDRESSPort Addressnvarchar2550
51SWRWEBSERVCustomizing Web Server3ADDRESSAddress Web Servernvarchar1320
TOPService Station Retailing
52OIRC_PRCHKSSR Pricing - Price check30ADDRESSCharacter field length 57nvarchar570
TOPTaiwan
53T7TW2IReported data of Tax withdrawal report20ADDRESSStreet and House Numbernvarchar600
TOPTranslation Tools
54LXE_MAILMail addresses2ADDRESSE-Mail Addressnvarchar2410
TOPTravel Planning
55FTPT_CARTravel Request Item - Car Rental Service17ADDRESSAddress of car rental branch office for pickupnvarchar400
56FTPT_HOTELTravel Request Item - Hotel Service15ADDRESSHotel Address (address string separated by #)nvarchar1320
57FTPT_PNR_ADDRESSPNR delivery / billing addresses10ADDRESSStreet and numbernvarchar600
TOPUse Subcomponents
58SADRUSAPoffice: Table for storing UNIX addresses5ADDRESSSAPoffice: UNIX addressnvarchar2410