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

210 columns | Print definition?ERP 6.0  | LAND

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/GSINS/NLG_CTR_CGBA Interface: Countries codes6LANDCountry Keynvarchar30
2/OPT/VIM_CA_TAXTax Code Determination Configuration for Canada2LANDCountry Keynvarchar30
3/OPT/VIM_CTRYCountry Determination2LANDCountry Keynvarchar30
4/OPT/VIM_FLD_SCHFind Text for Field at Header and Line Item Level2LANDCountry Keynvarchar30
5/OPT/VIM_STG_LIFTable: Staging data - Vendor master for ICC8LANDCountry Keynvarchar30
6/OPT/VIM_STR_DETShip-To-Region Maintenance2LANDCountry Keynvarchar30
7/OPT/VIM_TAX_PROCountry Specific Tax - Province Relationship2LANDCountry Keynvarchar30
8/OPT/X110Tax Code Determination Configuration2LANDCountry Keynvarchar30
9/OPT/Y110Tax Code Determination Configuration2LANDCountry Keynvarchar30
10/OPT/Z110Tax Code Determination Configuration2LANDCountry Keynvarchar30
11CNV_LICENCE_HWURequested License Keys12LANDNot More Closely Defined Area, Possibly Used for Patchlevelsnvarchar40
12DFKKODNCHRODN: Chronological numbering last assigned number2LANDCountrynvarchar20
13DFKKODNREPOfficial Document Number for Reporting15LANDCountrynvarchar20
14DFKKSAFTINV_RULESAF-T source document extraction rule2LANDFICA SAF-T Countrynvarchar20
15DFKKSAFTSALObsolete!2LANDCountry Keynvarchar30
16DFKKSAFTSAL_BPSAF-T Balances2LANDCountry Keynvarchar30
17EDOCOUNTRYSOLeDocument: Settings per Country1LANDCountry ISO codenvarchar20
18EDOCOUNTRYTCHeDocument: Technical Settings per Country1LANDCountry ISO Code (2 Characters stored in 3 Characters)nvarchar30
19EDOCUMENTeDocument5LANDCountry of companynvarchar30
20EDOCUMENTHISTORYeDocument: History5LANDCountry of companynvarchar30
21EDOFILETYPEeDocument: File Types per Country1LANDCountry ISO codenvarchar20
22EDOFILETYPETeDocument File Type Description2LANDCountry ISO codenvarchar20
23FIEUC_SALESOFCSAFT : Sales offices for SAF-T Reporting2LANDCountry Keynvarchar30
24FIKZD_REGINV_INIncoming Invoice Registration Journal45LANDPartner country of registrationnvarchar30
25FIKZD_REGINV_OUTOutgoing Invoice Registration Journal44LANDPartner country of registrationnvarchar30
26FIWTKWC_WITHDefinition of used tax code and tax type for div. WHT4LANDCountry Keynvarchar30
27J_1GPUTITIR doc. & L-IR item to PU account correspondence6LANDIndicator: Country Originnvarchar10
28P2KZ_TAXTax10LANDCountry Keynvarchar30
29P2UA_TAXUkrainian Tax10LANDCountry Keynvarchar30
30P2UR_TAXRussian Tax10LANDCountry Keynvarchar30
31PA0618HR Master Record: Infotype 061833LANDCountry Keynvarchar30
32T003EDOCeDocument: Accounting Document Type2LANDCountry of companynvarchar30
33T005XCountries - decimal point and date format (SET COUNTRY)2LANDCountry Keynvarchar30
34T160IControl of Intrastat Reports2LANDCountry Keynvarchar30
35T160JText Table for Intrastat Reports3LANDCountry Keynvarchar30
36T5GPBSH_ISHESA: Institution Identifier6LANDCountry Keynvarchar30
37T5GPBSH_NAHESA: Mapping of Nationality to HESA Code2LANDNationalitynvarchar30
38T5GPBSQ_PROProfessional Body4LANDCountry Keynvarchar30
39T77KZT1_PRIOPriority of Wage Type processing in Tax Class2LANDCountry Keynvarchar30
40T77PADRU_TAXPRI1Tax privileges for the given tax class2LANDCountry Keynvarchar30
41T77PADRU_TAXPRIVTax privileges for given tax class4LANDCountry Keynvarchar30
42T77PAYRU_TAXWTAlternative tax wage types to tax classes2LANDCountry Keynvarchar30
43T7RUG2OBSOLETE Garnishmetn Document Category (Russia)2LANDCountry Keynvarchar30
44T7RUG2TOBSOLETE: Garnishmetn Document Category (Russia): Texts3LANDCountry Keynvarchar30
45T7RUN7Tax Privileges3LANDCountry Keynvarchar30
46T7RUT1_EXTTaxes and netto payments Russian extension4LANDCountry Keynvarchar30
47T7RU_558D_TAXSplit Indicator Tax for Transfered Wage Types7LANDCountry Keynvarchar30
48TFE02BDF: Countries1LANDCountry of companynvarchar30
49TFE19BDF: Accts Subj. to Report.6LANDCountry of companynvarchar30
50TFK003EDOCeDocument: Contract Accounting Document Type2LANDCountry Keynvarchar30
51TFK_DOCCLSDefinition of Document Classes2LANDCountrynvarchar20
52TFK_DOCCLS_DETAssign Document Classes to Document Type sand Origin Keys2LANDCountrynvarchar20
53TFK_DOCCLS_TDocument Classes for Official Document Numbering (Text)2LANDCountrynvarchar20
54TFK_EXT_PROCTYPAssign customer extension Modules/Classes to Process Types3LANDCountrynvarchar20
55TFK_INT_PROCTYPAssign Countries to Process Types (internal only)2LANDCountrynvarchar20
56TFK_INT_SAFTSAF-T processing modules2LANDCountry Keynvarchar30
57TFK_ODNFRMTCHGFormat Change of Official Document Numbers for Process Types3LANDCountrynvarchar20
58TFK_ODNFRMTRESFormat Restrictions for Official Document Numbers3LANDCountrynvarchar20
59TFK_ODNNROAllowed Number Range Objects for Official Document Number2LANDCountrynvarchar20
60TFK_ODNNRO_DETAssign Number Range Objects to Countries2LANDCountrynvarchar20
61TFK_ODNNR_DETAssign Number Range Numbers to Document Classes2LANDCountrynvarchar20
62TFK_ODN_CONFODN: Main Processing Configuration (internal)2LANDCountrynvarchar20
63TFK_ODN_CONFEXTODN: Customer Specific Main Processing Configuration2LANDCountrynvarchar20
64TFK_ODN_EVT_CLAssign Countries to Class Repository Objects (internal only)2LANDCountrynvarchar20
65TFK_ODN_LANDODN: Standard ODN Countries2LANDCountrynvarchar20
66TFK_ODN_SID_DETODN: Sub-ID Determination3LANDCountrynvarchar20
67TFK_ODN_SID_SCHODN: Sub-ID Define Schema3LANDCountrynvarchar20
68TFK_ODN_SID_SCHTODN: Sub-ID Define Schema (Text)3LANDCountrynvarchar20
69TFK_ODN_SUBIDODN: Sub-ID2LANDCountrynvarchar20
70TFK_ODN_SUBIDTODN: Sub-ID (Text)2LANDCountrynvarchar20
71TFK_SAFT_GENSAF-T general settings - company code level2LANDFICA SAF-T Countrynvarchar20
72TFK_SAFT_SOLCNTCustom Logic for SAF-T2LANDFICA SAF-T Countrynvarchar20
73TFK_VATCODE_HUVAT code for Domestic Sales Hungary2LANDCountry Keynvarchar30
74TVFKEDOCeDocument Billing Type2LANDCountry of companynvarchar30
75TVLKEDOCeDocument Delivery Types2LANDCountry of companynvarchar30
76ZARTJRT Article Table for Data Generation2LANDCountry Keynvarchar30
77ZDG00Data generation time control2LANDCountry Keynvarchar30
78ZDG10MM data generation table2LANDCountry Keynvarchar30
79ZDG20SD data generation table2LANDCountry Keynvarchar30
80ZDG30SD data generation table2LANDCountry Keynvarchar30
81ZDG40Table for Data Generation (Repetitive Manufacturing)2LANDCountry Keynvarchar30
82ZDG50Table ZDG50 for Data Gen. in RT Area (Monthly via ZARTJ)2LANDCountry Keynvarchar30
83ZDG60Table ZDG60 for Data Gen. in RT Area (Monthly via ZARTJ)2LANDCountry Keynvarchar30
84ZMAMMMM-Material Table for Data Generation2LANDCountry Keynvarchar30
85ZMAPPSD-Material Table for Data Generation2LANDCountry Keynvarchar30
86ZMASDSD-Material Table for Data Generation2LANDCountry Keynvarchar30
TOPAdvertising Management
87JJTPRDH_DACHPRIS-M/AM Product Hierarchy (S&P): Umbrella Products7LANDIS-M/AM: Country Codenvarchar20
88JJTPRDH_PRFAMIS-M/AM Product Hierarchy (S&P): Product Families6LANDIS-M/AM: Country Codenvarchar20
89JJTPRDH_PRGRIS-M/AM Product Hierarchy (S&P): Product Groups5LANDIS-M/AM: Country Codenvarchar20
90JJTPRDH_PRODIS-M/AM: Products (S&P Product Hierarchy)4LANDIS-M/AM: Country Codenvarchar20
91JJTPRDH_WBIS-M/AM (S&P Product Hierarchy): Economic Sectors4LANDIS-M/AM: Country Codenvarchar20
TOPBasic Data
92NC301PIS-H EDI Data Collection Points15LANDIS-H: Country of Business Partnernvarchar30
93NGPAIS-H: Business Partners17LANDIS-H: Country of Business Partnernvarchar30
94NORGIS-H: Organizational Units10LANDCountry Keynvarchar30
95TN01IS-H: Institutions7LANDCountry Keynvarchar30
96TNS27IS-H: Variable Totaling of Geog. Statistics4LANDIS-H: Country for geographical areasnvarchar30
TOPBasic Functions
97T604PPreference: Preference Zone/Rule2LANDCountry for which preference determination rule is validnvarchar30
TOPBasis-Related Help Functions, Appl. Log, Formula Intepreter
98TBE31Publish&Subscribe BTE: SAP Enhancement2LANDCountry ISO codenvarchar30
99TBE32Publish&Subscribe BTE: Customer Enhancements5LANDCountry ISO codenvarchar30
100TBE32TP&S BTE: Partner Function Module Descriptions6LANDCountry ISO codenvarchar30
101TBE34Publish&Subscribe BTE: Customer Enhancements4LANDCountry ISO codenvarchar30
102TBEPRIPriority for Additional Components5LANDCountry Keynvarchar30
103TPS31Process BTE: Alternative Function Modules from SAP2LANDCountry ISO codenvarchar30
104TPS32Process BTE: Partner Enhancements2LANDCountry ISO codenvarchar30
105TPS34Process BTE: Customer Enhancements3LANDCountry ISO codenvarchar30
TOPClinical System
106N1DOKEMPFIS-H*MED: Recipient of the Documents19LANDIS-H: Countrynvarchar30
107N1PRPATIS-H*MED: PATREG: Patientenstammdatentabelle36LANDIS-H: Hasta adresinin bulundugu ülkenvarchar30
108N1PRTMPPATIS-H*MED: PATREG: Temporäre Patientenstammdatentabelle37LANDIS-H: Hasta adresinin bulundugu ülkenvarchar30
109N1PRTMPPATLOCIS-H*MED: PATREG: NPAT umgeschlüsselt auf N1PRPAT lokal37LANDIS-H: Hasta adresinin bulundugu ülkenvarchar30
110N2DLV_RECEIVERi.s.h.med: Dispatch - Recipient18LANDIS-H: Country of Business Partnernvarchar30
111N2MV_DISREQDispatch Request Data Table24LANDIS-H: Country of Business Partnernvarchar30
112N2MV_VSDATRecipient Data Table23LANDIS-H: Country of Business Partnernvarchar30
TOPContract Accounts Receivable and Payable
113FKK_EBS_EXT_TAXIDoc with Revenue Items - Tax Data Determination5LANDCountry Keynvarchar30
114TFK007FOther Tax Codes2LANDCountry of companynvarchar30
115TFK007FKTax Item Categories for Other Tax Code2LANDCountry of companynvarchar30
116TFK007FKTTax Item Categories for Other Tax Code3LANDCountry of companynvarchar30
117TFK007FTOther Tax Codes (Texts)3LANDCountry of companynvarchar30
TOPCountry-Specific Objects
118TAXNUMCHKRules for checking tax codes1LANDCountry Keynvarchar30
119TAXNUMCHKPOSRules for Checking Tax Numbers - Positions1LANDCountry Keynvarchar30
TOPDefault Risk and Limit System
120KLLR01Assignment of Country - Rating/Recovery Rate Determination2LANDCountry Keynvarchar30
121KLLR02Assignment of Country - VaR%3LANDCountry Keynvarchar30
TOPFinancial Accounting
122/OPT/VIM_TAX_CFGTax Code Determination Configuration2LANDCountry Keynvarchar30
TOPFunds Management-Specific Postings
123FMBGAHHSTTax Code for Budget Account Assignments2LANDCountry Keynvarchar30
TOPGeneral Ledger Accounting
124FMPEB_RATE_DEFAssign Input Tax Deduction Rates2LANDCountry of companynvarchar30
125FMPEB_TAXINDAssign Tax Codes to Exempt Organizations2LANDCountry of companynvarchar30
TOPGlobal Organization Customizing
126TCUSCCUSC: Customizing Country Version, New Field Contents2LANDCountry of companynvarchar30
127TCUSFCountry version external routines1LANDCountry of companynvarchar30
128TCUSICountry version customizing - new field contents1LANDCountry of companynvarchar30
TOPImplementation Guide
129CUSALIMG attribute table: Country settings3LANDCountry Keynvarchar30
TOPLocalization
130GLOFAACNTRLCountry-Specific Master Records2LANDCountry Keynvarchar30
131GLOFAACNTRLCCountry-Specific Master Records2LANDCountry Keynvarchar30
132GLOFAACNTRLTCountry-Specific Table Name3LANDCountry Keynvarchar30
133J_3RNKS_LANDVAT in a capital construction (Country specific settings)2LANDCountry of companynvarchar30
134TIVXCCORRALLCNTRAll Allowed Countries for Correction/Reversal invoices1LANDCountry Keynvarchar30
135TIVXCCORRCNTRYCountry assignment for Correction/Reversal invoices2LANDCountry Keynvarchar30
136TIVXCPTINSTLIMITInstallment limit for the Municipal Property Tax2LANDCountry Keynvarchar30
TOPMaster Data
137JST_PD_OBJTYPAllowed Postal Data Object Types1LANDCountry Keynvarchar30
138JST_PD_RULE_IDValidity Rules for Postal Data Object Types1LANDCountry Keynvarchar30
139TJGAFUBCNYIS-M/SD: Country-Specific Function Modules for Address Modif1LANDIS-M: Country versionsnvarchar30
140TJGM7IS-M: Address Formatting2LANDCountry Keynvarchar30
TOPMaterial Categories
141/ISDFPS/MPO_PROTLog of Data Transfers into MPO37LANDCountry Keynvarchar30
TOPMaterials Management
142J_1GPURULESSource / Target G/L Accounts6LANDIndicator: Country Originnvarchar10
TOPNorway
143PA0419HR Master record: Manual tax reporting information - Norway28LANDCountry Keynvarchar30
TOPPatient Management
144NADRIS-H: Addresses (Central Address Management)5LANDIS-H: Countrynvarchar30
145NPATIS-H: Patient Master Data (General)28LANDIS-H: Country of patient's place of residencenvarchar30
146NWANIS-H: Bad Debt Parties12LANDIS-H: Country of bad debt party's place of residencenvarchar30
TOPPayment Transactions
147T042OFIEvents for MT100 and other DME Formats2LANDCountry ISO codenvarchar30
TOPPayroll
148T7UAG0HR-UA: Garnishment orders addition table2LANDCountry Keynvarchar30
149T7UAT1_ADDObsolete4LANDCountry Keynvarchar30
150T7UAT1_PRIOPriority of Wage Type processing in Tax Class2LANDCountry Keynvarchar30
151T7UAT3CConnected taxes (same privileges)4LANDCountry Keynvarchar30
152T7UAT9Tax scale according to feature 36TXU4LANDCountry Keynvarchar30
TOPPeriodical Sales and Distribution
153JKTWBZINIS-M/SD: Clipboard for WBZ Records for Processing33LANDVehicle country keynvarchar30
154JKTWBZOUTIS-M/SD: Clipboard for Processed WBZ Records21LANDVehicle country keynvarchar30
155TJCNY185VIS-M/SD: Excluding Func.Codes, International Version3LANDIS-M: Country versionsnvarchar30
156TJI32Exploded Geographical Hierarchy for Statistics3LANDCountry Keynvarchar30
157TJYCNYIS-M: Country Version1LANDIS-M: Country versionsnvarchar30
158TJYCNYFTXTIS-M/SD: Texts for Country-Specific Function Codes3LANDIS-M: Country versionsnvarchar30
159TJYCNYSSCRIS-M: Country-Specific Subscreen Numbers4LANDIS-M: Country versionsnvarchar30
160TJYCNYTXTIS-M: Texts for Country Version1LANDIS-M: Country versionsnvarchar30
161TJYFUBCTRYIS-M/SD: Function Modules, Country Versions3LANDIS-M: Country versionsnvarchar30
TOPProcessing
162EWA_WDOC_WA_PCSelection Data from Work Area for Regional Structure3LANDCountry Keynvarchar30
TOPProduction and Revenue Accounting
163OIU_CM_SCHDCDSchool district code4LANDCountry of companynvarchar30
164OIU_RV_TCLDTax Class16LANDCountry of companynvarchar30
TOPPublic Sector
165PA0592HR Master Record: Infotype 0592 (Foreign Public Sector)24LANDCountry Keynvarchar30
166T5D93Employment Locations2LANDCountry Keynvarchar30
167T5D93TEmployment Locations (Texts)3LANDCountry Keynvarchar30
168T5D94Assignment of Country Level to Employment Location2LANDCountry Keynvarchar30
169T5D96Basic Amounts: Bonus for Foreign Service Bonus2LANDCountry Keynvarchar30
TOPRemaining Beverage - Obsolete Objects
170/BEV1/RPTZKDAssignment Customer-Transportation Zone-Sequence No. (RPlan)2LANDCountry Keynvarchar30
171/BEV1/RPTZZEITTimes at Transportation Zone Level (Dyn.Transport.Planning)2LANDCountry Keynvarchar30
TOPRussia
172T7RUG0HR: Garnishment Order Types2LANDCountry Keynvarchar30
173T7RUG1Garnishment Document Category3LANDCountry Keynvarchar30
174T7RUGXHR: Garnishmetn Document Category (Russia) - TEXT table4LANDCountry Keynvarchar30
175T7RUGYHR: Garnishment Order Types3LANDCountry Keynvarchar30
176T7RUP1Tax's schema5LANDCountry Keynvarchar30
177T7RUT0Name of taxes/netto payments4LANDCountry Keynvarchar30
178T7RUT1Taxes and netto payments4LANDCountry Keynvarchar30
179T7RUT1_CETaxes and netto payments - addition for CE4LANDCountry Keynvarchar30
180T7RUT2Name of Tax Privileges4LANDCountry Keynvarchar30
181T7RUT3Tax privileges4LANDCountry Keynvarchar30
182T7RUT3_CETax privileges4LANDCountry Keynvarchar30
183T7RUT4Values of Minimum Pay2LANDCountry Keynvarchar30
184T7RUT5Social Insurance2LANDCountry Keynvarchar30
185T7RUT5_PAIDSocial Insurance - Paid days of illness2LANDCountry Keynvarchar30
186T7RUT6Text for Social group SI3LANDCountry Keynvarchar30
187T7RUT8Conversion of Social Insurance Group2LANDCountry Keynvarchar30
TOPSAP Healthcare - Industry-Specific Components for Hospitals
188NAKR1IS-H AT: LKF - Grunddaten9LANDIS-H: Land des Patientenwohnortesnvarchar30
189NPNTCASIS-H: Patient Master Data at Case Level (CV IT)14LANDIS-H: Countrynvarchar30
190TN50ADefault Values for ASL and ISTAT Code3LANDIS-H: Countrynvarchar30
191TNNL4IS-H NL: Country code LMR3LANDIS-H: Country of patient's place of residencenvarchar30
TOPSAP Media
192J_1SGEWAULIS-M/SD CH: No.Taxable Issues by Weight Groups - Foreign6LANDCountry of companynvarchar30
193J_1SWEMF00IS-M/SD CH/W: Daily WEMF Statistics5LANDCountry Key for Country Relevant for Auditingnvarchar30
194J_1SWEMF02IS-M/SD CH/W: Monthly WEMF Statistics3LANDCountry Key for Country Relevant for Auditingnvarchar30
TOPSAP NetWeaver Mobile - Use subcomponents
195MEREP_ADDRESSAddress (Sample Application)9LANDCountry (Sample Application)nvarchar30
196MEREP_COUNTRYCountry (Sample Application)2LANDCountry (Sample Application)nvarchar30
197MEREP_COUNTRYTCountry Short Description (Sample Application)3LANDCountry (Sample Application)nvarchar30
TOPSession Manager
198SMEN_CONEWMenu: country-dependent transactions/reports/...3LANDCountry Keynvarchar30
199SMEN_COUNTMenu: country-dependent transactions/reports/...4LANDCountry Keynvarchar30
TOPShipping
200VARZDelivery Plan: Zone-Specific Itinerary5LANDCountry Keynvarchar30
201VAWZDelivery Plan: Itinerary Determination, Zone-Specific3LANDCountry Keynvarchar30
TOPSingapore
202PA0412HR Master Record: Infotype 0412 [View to I0021] (SG)39LANDCountry Keynvarchar30
TOPTravel Expenses
203PTRV_REDUCTIONDecision Fields: Change of Statutory Trip Type for Reduction1LANDIdentification of Country or Federal Statenvarchar60
TOPTravel Planning
204TA20OFFICEReservation System-Specific Sales Offices4LANDCountry Keynvarchar30
TOPValuation
205OIURV_TAXCONFDState tax configuration detail6LANDCountry of companynvarchar30
206OIURV_TAXCONFHState tax configuration header6LANDCountry of companynvarchar30
207OIUVL_MTAHMarketing Cost Tax Exemption - Header10LANDCountry Keynvarchar30
208OIUVL_TCJVTax Class - Venture DOI's11LANDCountry of companynvarchar30
209OIUVL_TCMPTax Class Measurement Points9LANDCountry of companynvarchar30
210OIUVL_TCWCTax Class - Well Completion8LANDCountry of companynvarchar30