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

71 columns | Print definition?ERP 6.0  | NATION

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/1CADMC/00000410ADCP8NATIONnvarchar10
2/1CADMC/00000415ADRC7NATIONnvarchar10
3/1CADMC/00000416ADRP7NATIONnvarchar10
4/FLDQ/AD_ERRLOCKTable to store errors during locking AD_MTCCODE records6NATIONVersion ID for International Addressesnvarchar10
5/FLDQ/AD_ERRQTRTable to store address errors generated during RSADRQU26NATIONVersion ID for International Addressesnvarchar10
6/FLDQ/AD_INI_ERRRecord records which encounter an error in RSADRINI6NATIONVersion ID for International Addressesnvarchar10
7/FLDQ/AD_INI_IDXCopy of Shadow Table /fldq/ad_mtc_sh6NATIONVersion ID for International Addressesnvarchar10
8/FLDQ/AD_MTCCODEFirstLogic Match Code Index Table6NATIONVersion ID for International Addressesnvarchar10
9/FLDQ/AD_MTCRSLTMatch Results table to store results from RSADRINI program5NATIONVersion ID for International Addressesnvarchar10
10/FLDQ/AD_MTC_SHFirstLogic Shadow table for /FLDQ/AD_MTCCODE6NATIONVersion ID for International Addressesnvarchar10
11/FLDQ/AD_MTC_SH2FirstLogic Shadow table for /FLDQ/AD_MTCCODE6NATIONVersion ID for International Addressesnvarchar10
12/FLDQ/AD_PUPDATEMatchcode Records pending to be updated6NATIONVersion ID for International Addressesnvarchar10
13/FLDQ/AD_QTRRVWCleansed addresses from RSADRQU2 to review before comitting4NATIONVersion ID for International Addressesnvarchar10
14/FLDQ/AD_QU_INDXQU2 Index Table11NATIONVersion ID for International Addressesnvarchar10
15/FLDQ/HNACLNSOUTDQM for SAP output table for transactional cleanse TASK4NATIONVersion ID for International Addressesnvarchar10
16/FLDQ/HNACLNSTSKDQM for SAP input table for transactional cleanse TASK4NATIONVersion ID for International Addressesnvarchar10
17/FLDQ/HNA_BM_INHANA task Batch Match Input Records6NATIONVersion ID for International Addressesnvarchar10
18/FLDQ/HNA_BM_OUTHANA task Batch Match Result Records5NATIONVersion ID for International Addressesnvarchar10
19/FLDQ/HNA_PREQU2staging table for RSADRQU2 report11NATIONVersion ID for International Addressesnvarchar10
20/FLDQ/HNA_PSTQU2Result Table for RSADRQU2 report11NATIONVersion ID for International Addressesnvarchar10
21/SAPSRM/SH_PLANTTable for ERP Search Help Plants13NATIONVersion ID for International Addressesnvarchar10
22/SMD/MD_____00KKSID-Tabelle fuer Address Version3NATIONVersion ID for International Addressesnvarchar10
23/SMD/MD_____00KZSID-Tabelle fuer Address number5NATIONVersion ID for International Addressesnvarchar10
24/SMD/MD_____00MKSID-Tabelle fuer Address Version3NATIONVersion ID for International Addressesnvarchar10
25/SMD/MD_____00MYSID-Tabelle fuer Address number5NATIONVersion ID for International Addressesnvarchar10
26NWS_EXT_ADRC2Texts for Addresses (Central Address Management)3NATIONVersion ID for International Addressesnvarchar10
27NWS_EXT_ADRCTTexts for Addresses (Central Address Management)3NATIONVersion ID for International Addressesnvarchar10
28PA0616HR Master Record: Infotype 061636NATIONHESA: Nationality codenvarchar40
29PAPBSGBH_13_PHESA: Person table (2012/13 onwards)31NATIONHESA: Nationalitynvarchar20
30PAPBSGB_HESA_PHESA: Archive table for NISR Person table12NATIONHESA: Nationality codenvarchar40
31T5GPBSH_NAHESA: Mapping of Nationality to HESA Code3NATIONHESA: Nationality codenvarchar40
TOPAddress ManagementBusiness Address
32ADCPPerson/Address Assignment (Business Address Services)5NATIONVersion ID for International Addressesnvarchar10
33ADCPSShadow Table: Assignment Person/Addr. (Bus. Addr. Services)6NATIONVersion ID for International Addressesnvarchar10
34ADRCAddresses (Business Address Services)4NATIONVersion ID for International Addressesnvarchar10
35ADRCSShadow Table: Addresses (Business Address Services)5NATIONVersion ID for International Addressesnvarchar10
36ADRCS2Shadow Table 2: Addresses (Business Address Services)6NATIONVersion ID for International Addressesnvarchar10
37ADRCTAddress Texts (Business Address Services)4NATIONVersion ID for International Addressesnvarchar10
38ADRCTSShadow Table: Texts for Addresses (Business Addr. Services)5NATIONVersion ID for International Addressesnvarchar10
39ADRCTS2Shadow Table 2: Address Texts (Business Address Services)6NATIONVersion ID for International Addressesnvarchar10
40ADRPPersons (Business Address Services)4NATIONVersion ID for International Addressesnvarchar10
41ADRPSShadow Table: Persons (Business Address Services)5NATIONVersion ID for International Addressesnvarchar10
42TSAD9VScreen Variants for Version-Specific Address Masks2NATIONVersion ID for International Addressesnvarchar10
43TSADVInternational versions of addresses1NATIONVersion ID for International Addressesnvarchar10
44TSADVCCustomizing international address versions1NATIONVersion ID for International Addressesnvarchar10
45TSADVC_CLIDEPInternational Address Version Customizing (Client-Specific)2NATIONVersion ID for International Addressesnvarchar10
46TSADVC_REGObsolete; Use Table TSADVC_REG22NATIONVersion ID for International Addressesnvarchar10
47TSADVC_REG2Version-Specific Control of Regional Structure3NATIONVersion ID for International Addressesnvarchar10
48TSADVTName of internationalen versions of addresses2NATIONVersion ID for International Addressesnvarchar10
TOPBasis Components
49/XFT/INV_Q_6PO details (header) for an invoice receipt process22NATIONVersion ID for International Addressesnvarchar10
50/XFT/INV_Q_6_SPO details (header) for an invoice receipt process22NATIONVersion ID for International Addressesnvarchar10
TOPBelgium
51T5B1VCorrespondence of customer entries in TSADV3NATIONVersion ID for International Addressesnvarchar10
TOPBusiness Partner Enhancements for Financial Services
52BP000Business Partner Master (General Data)41NATIONNationalitynvarchar30
TOPClinical System
53N1PDKNATIONPERINATAL: Table of Nationality Keys2NATIONnvarchar20
TOPCross-Application Components
54J_2GFIELDSCustomer/Vendor/Company - Field mappings6NATIONVersion ID for International Addressesnvarchar10
TOPFinancial Accounting
55/BGLOCS/FIADRCBG VAT internationalization3NATIONVersion ID for International Addressesnvarchar10
56AC400ADRCP01 Adressen für Programm AC400DEBITOR4NATIONVersionskennzeichen für internationale Adressennvarchar10
TOPGlobal Trade Services
57/SAPSLL/PREVDAUDSLL: Preference: Vend.Decl. for Customer Purp.: Audit9NATIONVersion ID for International Addressesnvarchar10
58/SAPSLL/TCOCMPSLL: Control Procedure for Address or String Comparison5NATIONInternational Address Version IDnvarchar10
TOPLOGFAS
59/ISDFPS/GEOLOCGeolocation Database Table4NATIONCountrynvarchar20
TOPMarketing Retail Network
60OIFSMCADDRLink Table Between OIFSPBL and ADRC for Matchcode5NATIONVersion ID for International Addressesnvarchar10
TOPOrganizational Management
61T77NICountry-Specific Infotypes2NATIONCountry Key for Country-Specific Infotypenvarchar30
TOPReal Estate Management
62S401RE standard analysis partner45NATIONNationalitynvarchar30
63VIAR02RE: REse@rch - RE Requests82NATIONNationalitynvarchar30
TOPReusable Components of Business Suite Foundation
64/BOFU/ADCPUUIDTable for ADCP-UUID (Downport 7.10 to 7.0)9NATIONVersion ID for International Addressesnvarchar10
65/BOFU/ADRCUUIDTable for ADRC-UUID (Downport 7.10 to 7.0)9NATIONVersion ID for International Addressesnvarchar10
66/BOFU/ADRPUUIDTable for ADRP-UUID (Downport 7.10 to 7.0)7NATIONVersion ID for International Addressesnvarchar10
TOPStructures Workbench
67HRP1952DB Table for Infotype 195220NATIONVersion ID for International Addressesnvarchar10
TOPUse AP-MD-BP Components
68BUT020BP: Addresses6NATIONVersion ID for International Addressesnvarchar10
69BUT020SShadow Table BP: Addresses7NATIONVersion ID for International Addressesnvarchar10
70BUT052BP Relationship: Addresses9NATIONVersion ID for International Addressesnvarchar10
71BUT052SShadow Table BP Relationship: Addresses10NATIONVersion ID for International Addressesnvarchar10