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

149 columns | Print definition?ERP 6.0  | REMARK

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/FLDQ/AD_CHKSTATTable to temporarily hold the check status values54REMARKAddress notesnvarchar500
2/FLDQ/HNACLNSOUTDQM for SAP output table for transactional cleanse TASK55REMARKAddress notesnvarchar500
3/FLDQ/HNACLNSTSKDQM for SAP input table for transactional cleanse TASK55REMARKAddress notesnvarchar500
4CNVMBTRFCCCKMSGError messages from the latest RFC check19REMARKnvarchar800
5DB6_OPTPROFILEOptimizer Profiles for SQL Statements6REMARKntext10737418230
6EHFNDD_AMNS_HISTAmounts - History9REMARKAmounts Remarknvarchar2550
7EHFNDD_AMNS_ROOTAmounts - Root16REMARKAmounts Remarknvarchar2550
8EHFNDD_CHA_STEPChemical Approval - Step11REMARKChemical Approval - Step Remarkntext10737418230
9EHFNDD_REQC_BASBasic Data for Request Chemical18REMARKRemarksntext10737418230
10EHFNDD_VEN_EMCONVendor - Emergency Contact13REMARKVendor - Contact Person Remarknvarchar2550
11EHFNDD_VEN_SDSCOVendor - SDS Contact13REMARKVendor - Contact Person Remarknvarchar2550
12EHHSSD_CINSP_RCControl Inspection - Risk Control12REMARKRemark from Control Inspectorntext10737418230
13EHPRCD_CMP_ROOTCampaign Root22REMARKRemarknvarchar2550
14EHPRCD_COD_REQRRequirement Revision18REMARKRequirement Revision Remarknvarchar2550
15EHPRCD_DEC_INObsolete26REMARKRemarknvarchar800
16EHPRCD_ICH4ADChapter4: OrgID dependent data24REMARKAdditional Comment (Only Used for Renault)nvarchar2550
17EHPRCI_MIGRATEDefinition of data migration (source table -> dest table)5REMARKConversion Remarknvarchar1280
18EHPRCI_PHSETPhrase sets REACH Compliance4REMARKNotenvarchar600
19EPIC_BRS_SEGMENTEPIC: Bank Reconciliation Statement15REMARKRemarknvarchar2550
20EPIC_CB_PLANEPIC: Cash Budgeting planning DB Table9REMARKRemark About Budget Planning Itemnvarchar600
21EPIC_DUM_TRANSACTransactions of Dummy Bank20REMARKChar255nvarchar2550
22NSTREMReasons and Comments for Status of a Case6REMARKComment on Reason for a Statusnvarchar500
23NWS_EXT_ADFA2Transfer structure for fax numbers (central address admin.)14REMARKCommunication link notesnvarchar500
24NWS_EXT_ADFAXTransfer structure for fax numbers (central address admin.)14REMARKCommunication link notesnvarchar500
25NWS_EXT_ADPA2Transfer Structure for Page Numbers (Centr. Addr. Mgmnt)13REMARKCommunication link notesnvarchar500
26NWS_EXT_ADPAGTransfer Structure for Page Numbers (Centr. Addr. Mgmnt)13REMARKCommunication link notesnvarchar500
27NWS_EXT_ADPR2Transfer Structure for PRT Addresses (Centr. Address Mgmnt)8REMARKCommunication link notesnvarchar500
28NWS_EXT_ADPRTTransfer Structure for PRT Addresses (Centr. Address Mgmnt)8REMARKCommunication link notesnvarchar500
29NWS_EXT_ADR2Texts for Communication Data (Central Address Management)7REMARKCommunication link notesnvarchar500
30NWS_EXT_ADRC2Texts for Addresses (Central Address Management)5REMARKAddress notesnvarchar500
31NWS_EXT_ADRCTTexts for Addresses (Central Address Management)5REMARKAddress notesnvarchar500
32NWS_EXT_ADRF2Transfer Structure for RFC Addresses (Centr. Addr. Mgmnt)9REMARKCommunication link notesnvarchar500
33NWS_EXT_ADRFCTransfer Structure for RFC Addresses (Centr. Addr. Mgmnt)9REMARKCommunication link notesnvarchar500
34NWS_EXT_ADRM2Transfer Structure for RML Addresses (Centr. Addr. Mgmnt)12REMARKCommunication link notesnvarchar500
35NWS_EXT_ADRMLTransfer Structure for RML Addresses (Centr. Addr. Mgmnt)12REMARKCommunication link notesnvarchar500
36NWS_EXT_ADRTTexts for Communication Data (Central Address Management)7REMARKCommunication link notesnvarchar500
37NWS_EXT_ADSM2Transfer Structure for SMTP Addresses (Centr. Addr. Mgmnt)12REMARKCommunication link notesnvarchar500
38NWS_EXT_ADSMTTransfer Structure for SMTP Addresses (Centr. Addr. Mgmnt)12REMARKCommunication link notesnvarchar500
39NWS_EXT_ADSS2Transfer Structure for SSF Addresses (Centr. Addr. Mgmnt)11REMARKCommunication link notesnvarchar500
40NWS_EXT_ADSSFTransfer Structure for SSF Addresses (Centr. Addr. Mgmnt)11REMARKCommunication link notesnvarchar500
41NWS_EXT_ADTE2Transfer Structure for Telephone Nos (Centr. Addr. Mgmnt)13REMARKCommunication link notesnvarchar500
42NWS_EXT_ADTELTransfer Structure for Telephone Nos (Centr. Addr. Mgmnt)13REMARKCommunication link notesnvarchar500
43NWS_EXT_ADTL2Transfer Structure for Telex Nos (Centr. Addr. Mgmnt)10REMARKCommunication link notesnvarchar500
44NWS_EXT_ADTLXTransfer Structure for Telex Nos (Centr. Addr. Mgmnt)10REMARKCommunication link notesnvarchar500
45NWS_EXT_ADTT2Transfer Structure for Teletex Numbers (Centr. Addr. Mgmnt)10REMARKCommunication link notesnvarchar500
46NWS_EXT_ADTTXTransfer Structure for Teletex Numbers (Centr. Addr. Mgmnt)10REMARKCommunication link notesnvarchar500
47NWS_EXT_ADUR2URI address transfer structure (central address management)8REMARKCommunication link notesnvarchar500
48NWS_EXT_ADURIURI address transfer structure (central address management)8REMARKCommunication link notesnvarchar500
49NWS_EXT_ADX40Transfer Structure for X.400 Addresses (Centr. Addr. Mgmnt)34REMARKCommunication link notesnvarchar500
50NWS_EXT_ADX42Transfer Structure for X.400 Addresses (Centr. Addr. Mgmnt)34REMARKCommunication link notesnvarchar500
51T5UPBSNOARMKNature of Actions Remarks Codes3REMARK3-Byte fieldnvarchar30
52T5UPBSNOARMKRNoA Code Remarks Table2REMARKNoa Remarknvarchar30
53T5UPBSNOARMKSNature of Actions Remarks Codes4REMARKNoa Remarknvarchar30
54T7EHS00_PROTEHSMProposed Health Surveillance Protocols from EHSM9REMARKAdditional Informationnvarchar2550
55T7INTRNS_METADATIPS: Temp tab to monitor transactional data changes11REMARKCommentnvarchar2000
56T7INTRNS_META_DTLog changes to status of transactional data12REMARKApprover's Commentnvarchar2000
57T7UNPF_FI_MISCEFinancial Interface Misc. Transactions10REMARKRemarknvarchar1000
58T7UNPF_FI_TRANSAdditional Details33REMARKRemarknvarchar1000
59TLRT_TARO_ADMTrade Repository Object Administrative Data20REMARKTARO remark in administrative datanvarchar500
TOPAddress ManagementBusiness Address
60ADRCTAddress Texts (Business Address Services)6REMARKAddress notesnvarchar500
61ADRCTSShadow Table: Texts for Addresses (Business Addr. Services)7REMARKAddress notesnvarchar500
62ADRCTS2Shadow Table 2: Address Texts (Business Address Services)8REMARKAddress notesnvarchar500
63ADRTCommunication Data Text (Business Address Services)8REMARKCommunication link notesnvarchar500
64ADRTSShadow Table: Texts for Communications Data (BAS)9REMARKCommunication link notesnvarchar500
65ADRTS2Shadow Table 2: Communication Data Texts (BAS)9REMARKCommunication link notesnvarchar500
66TSAPPLSUBTTexts for TSAPPLSUB (BAS)3REMARKComments on Filter Valuenvarchar500
TOPBank Customer Accounts
67BKKCORRITEMAuxiliary Table: Payment Items for Adjustments44REMARKComment on Order/Itemnvarchar500
TOPBasic Data
68NC301CEXIS-H: EDI - Cases Excluded From Data Exchange Process5REMARKIS-H: EDI - Comment on excluded case (user-defined text)nvarchar1000
TOPBasic Functions
69TPARAMS_SDAllgemeine SD Parametertabelle9REMARKBemerkungnvarchar800
TOPBRFplus - ABAP-Based Business Rules
70FDTRESERVEDFDT: Reserved ID Patterns2REMARKnvarchar2550
TOPClassification Toolset
71CLS_ASSIGNMENTAssignment of an attribute value to an object10REMARKRemarkntext10737418230
72CLS_LINKED_OBJAssignment of an attribute value to a linked object14REMARKRemarkntext10737418230
73CLS_RE_CONDITIONCondition of classificationsreport9REMARKRemarkntext10737418230
TOPClientServer Technology
74GUI_E2E_TRACESGui Epp Traces7REMARKCommentnvarchar500
TOPCollections Management
75UDM_STR_RULEAssignment of Rules to Strategies7REMARKCommentnvarchar600
76UDM_STR_RULE_VAssignment of Rules to Collection Strategies8REMARKCommentnvarchar600
TOPCommunication Services Mail, Fax, SMS, Telephony
77SPH_USNOLISAPphone: Telephone number list for each user8REMARKSAPphone: Commentsnvarchar550
78SXDOMAINSSAPconnect: Management of Internet Mail Addresses Domains4REMARKCommentnvarchar500
79SXTELMOINSAPconnect: Telephone number modification (incoming)4REMARKCommentnvarchar500
80SXTELMOOUTSAPconnect: Telephone number modification (outgoing)5REMARKCommentnvarchar500
TOPCustomer Scheduling Agreement
81ESD_TOPRMaintenance of Tolerance Profiles17REMARKText Field for Commentsnvarchar300
TOPDirect Store Delivery
82/DSD/DX_CSTRUC_TDEX Customizing - Structures of segments (text table)8REMARKRemarknvarchar500
TOPDocument Builder
83/IPRO/TVARCHANGELog of variable changes12REMARKRemark Regarding Change to Variable Attributenvarchar1320
TOPEnvironment, Health and Safety
84/TDAG/CPA_ICH4ADChapter4: OrgID dependent data23REMARKAdditional Comment (Only Used for Renault)nvarchar2550
85/TDAG/CPT_DECSUBCP: Declarable Substances27REMARKRemarknvarchar800
86/TDAG/CPT_DEC_INCP: Declarable Substances, Independent attributes26REMARKRemarknvarchar800
87/TDAG/RCSA_COSTCost Monitoring25REMARKBemerkung - Kostennvarchar2550
88/TDAG/RCSA_EPRECEndpoint data records40REMARKRemark for Endpoint Data Recordnvarchar2550
89/TDAG/RCSW_PHSETPhrase sets REACH Compliance4REMARKNotenvarchar600
TOPError and Conflict Handler
90FEHT_MESS_PERSPersistence of the Payload and other Data Relevant to FEH9REMARKFree Comment for a Payload Versionnvarchar700
91FEH_MESS_PERSPersistence of the Payload and other Data Relevant to FEH11REMARKFree Comment for a Payload Versionnvarchar700
TOPForce Element
92/ISDFPS/FORBEAttributes of HR - BE Relationship16REMARKCommentnvarchar1240
93/ISDFPS/FORCEMAuthorized Materials16REMARKCommentnvarchar1240
94/ISDFPS/FORCEPMaterial Packages10REMARKCommentnvarchar1240
95/ISDFPS/FORCNAttributes of REC - HR Relationship15REMARKCommentnvarchar1240
96/ISDFPS/FOREPAAttributes of the Force Element - EPA Relationships16REMARKCommentnvarchar1240
97/ISDFPS/FORIPOFORCER: Authorized Infrastructure: Attributes15REMARKCommentnvarchar1240
98/ISDFPS/FORMCAttributes of the Material Container-Force Element Relatshp17REMARKCommentnvarchar1240
99/ISDFPS/FORMCHAttributes of the Material Container - HR Relationship17REMARKCommentnvarchar1240
100/ISDFPS/FORMPHAttributes of the HR - MPO Relationship22REMARKCommentnvarchar1240
101/ISDFPS/FORMPOAttributes of the Force Element - MPO Relationship22REMARKCommentnvarchar1240
102/ISDFPS/FORRICAttributes of the Force Element - RIC Relationship16REMARKCommentnvarchar1240
103/ISDFPS/FORRRFORCER: RE Search Request: Attributes15REMARKCommentnvarchar1240
104/ISDFPS/FORVPAAttributes of the Force Element - PPA Relationships18REMARKCommentnvarchar1240
TOPGlobal Trade Services
105/SAPSLL/PREGPMAPMapping: Item-Specific Conditions for Rule Groups8REMARKText (20 Characters)nvarchar200
106/SAPSLL/PREVDAUDSLL: Preference: Vend.Decl. for Customer Purp.: Audit69REMARKAddress notesnvarchar500
107/SAPSLL/SPLAUDLegal Control - SPL - Audit102REMARKAddress notesnvarchar500
TOPLanguage Transport
108TLSYTABLanguage supplement control table3REMARKnvarchar400
TOPLine Maintenance
109/ISDFPS/LMEQEXTEnhancements to the Equipment Tables for Line Maintenance4REMARKRemarknvarchar600
110/ISDFPS/LMSITEEQSite Equipment in Line Maintenance Process4REMARKRemarknvarchar600
TOPLocalization
111IDIN_FIAA_ADJUSTAdjustment values for the block and opening WDV - India9REMARKAdjustment Remarknvarchar2550
112J_1BNFCPDNota Fiscal one-time accounts82REMARKAddress notesnvarchar500
TOPMaster Data
113EFISELField Selection Control for Address Data36REMARKAddress notesnvarchar10
TOPMaterial Categories
114/ISDFPS/MPO_PROTLog of Data Transfers into MPO47REMARKCommentnvarchar1240
115/ISDFPS/PAMPOAttributes of BOM Alternatives7REMARKCommentnvarchar1240
116/ISDFPS/PRMPOAttributes of BOM Relationships7REMARKCommentnvarchar1240
TOPMedia Product Sales and Distribution
117JKSDCOLLECTBAGRecall Dates By Business Partner12REMARKComment on Collectionnvarchar500
118JKSDCOLLECTISSUERecall Dates for Issues13REMARKComment on Collectionnvarchar500
TOPMonitors for Automotive
119ESDMSGDefinition of Message Groups DI 3.0 ESD3REMARK30 Charactersnvarchar300
TOPMove-InOut
120ECAMIOPRTELIS-U: Pre-entry Document: Telephone Numbers10REMARKCommunication link notesnvarchar500
TOPOccupational Health
121T7EHS00_SUGGPERSProposal: Assign Person to Health Surveillance Protocol6REMARKAdditional Informationnvarchar2550
TOPPatient Accounting
122NMSTORIS-H MM: Closet7REMARKIS-H MM: Comment on Closetnvarchar250
123NMSTORLIS-H MM: Storage Location in Closet12REMARKIS-H MM: Comment on Closet Storage Binnvarchar250
TOPPayment Item
124BKKITPayment Item44REMARKComment on Order/Itemnvarchar500
125BKKITENQBlocked Payment Items44REMARKComment on Order/Itemnvarchar500
126BKKITRELPayment Item44REMARKComment on Order/Itemnvarchar500
127BKKITTMPPlanned Payment Items45REMARKComment on Order/Itemnvarchar500
128BKKITTMP_DELPlanned Payment Items - Completed45REMARKComment on Order/Itemnvarchar500
TOPPayment Order
129BKKPOHDPayment Order, Header Data14REMARKComment on Order/Itemnvarchar500
130BKKPOHD_TMPPlanned Payment Order, Header Data15REMARKComment on Order/Itemnvarchar500
131BKKPOHD_TMP_DELPlanned Payment Order, Header Data15REMARKComment on Order/Itemnvarchar500
TOPPrint and Output Management
132TSPOPIMANPrinter manufacturers3REMARKRemarknvarchar2400
133TSPOPIPPrinter / device type repations10REMARKRemarknvarchar2400
134TSPOPIPRNPrinter / device type relations10REMARKRemarknvarchar2400
135TSPOPIPRN_WORKPrinter / device type relations10REMARKRemarknvarchar2400
TOPProduct and Process Modeling
136RLMFWOLRelease Order - Items15REMARKCommentnvarchar1280
TOPProduct Safety
137CCGLT_AUDHEHS: Audit Data Header Entry25REMARKAdditional Comments on Change Loggingnvarchar1320
TOPProgress Tracking
138TXPDATExpediting Data19REMARKComment on Eventnvarchar400
TOPReportReport Interface
139TEQUIVDOMTComments on Equivalent Domains3REMARKCommentsnvarchar700
140TVIRTDOMTText Table for the Virtual Domains3REMARKCommentsnvarchar700
TOPSAP Healthcare - Industry-Specific Components for Hospitals
141NLVERPRechnungregister-position16REMARKOpmerkingnvarchar1280
TOPTransaction Manager
142RDPT_REDEMPTIONRedemption Records15REMARKCommentnvarchar600
143RDPT_RED_BCKUPTreasury: Backup for Converting Currency of Redemption Sch.16REMARKCommentnvarchar600
TOPTranslation Tools
144LXE_TCS_TTX_REGHolds information on invalid TTXs7REMARKTextntext10737418230
145TSKTYTranslation environment presettings: Editor5REMARKSingle-Character Indicatornvarchar10
TOPWaste Management
146EPROP_ADRFLD_SELField Selection Control for Address Screen of Property36REMARKAddress notesnvarchar10
147EROB_ADDRFLD_SELField Selection Control for Add. Screen of Cleaning Object36REMARKAddress notesnvarchar10
TOPWeb Service and SOAP - ABAP
148SRT_SEQ_RESPONSEOBSOLETE Excerpt from Response to Selection (Query Sequence)22REMARKChar255nvarchar2550
TOPWork Clearance Management
149WCC0STWCM: Subscreens for View Profiles (Texts)4REMARKComment for Subscreennvarchar300