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

Home | ERP 6.0  | T005
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
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Basis Components :: Basis Services Communication Interfaces :: Address ManagementBusiness Address
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0T005651CountriesAddress ManagementBusiness Address
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, LAND1, LANDK, LNPLZ, PRPLZ, ADDRS, XPLZS, XPLPF, SPRAS, XLAND, XADDR, NMFMT, XREGS, XPLST, INTCA, INTCA3, INTCN3, XEGLD, XSKFN, XMWSN, LNBKN, PRBKN, LNBLZ, PRBLZ, LNPSK, PRPSK, XPRBK, BNKEY, LNBKS, PRBKS, XPRSO, PRUIN, UINLN, LNST1, PRST1, LNST2, PRST2, LNST3, PRST3, LNST4, PRST4, LNST5, PRST5, LANDD, KALSM, LANDA, WECHF, LKVRZ, INTCN, XDEZP, DATFM, CURIN, CURHA, WAERS, KURST, AFAPL, GWGWRT, UMRWRT, KZRBWB, XANZUM, CTNCONCEPT, KZSRV, XXINVE, SUREG, LANDGRP_VP FROM T005
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2LAND1Country Keynvarchar30CHAR(N' ')NoLAND1 Allow NULL? 
3LANDKVehicle country keynvarchar30CHAR(N' ')NoLANDK Allow NULL? 
4LNPLZPostal code lengthnvarchar20NUMC(N'00')NoLNPLZ_005 Allow NULL? 
5PRPLZRule for the postal code field checkchar10CHAR(N' ')NoPRUEF_005 Allow NULL? 
6ADDRSFormatting routine key for printing addressesnvarchar30CHAR(N' ')NoT005AADDRS_005 Allow NULL? 
7XPLZSFlag: Street address postal code required entry?char10CHAR(N' ')NoXPLZS_005 Allow NULL? 
8XPLPFFlag: PO Box postal code required?char10CHAR(N' ')NoXPLPF_005 Allow NULL? 
9SPRASLanguage Keychar10LANG(N' ')NoT002SPRAS Allow NULL? 
10XLANDCountry version flagchar10CHAR(N' ')NoXLAND_005 Allow NULL? 
11XADDRFlag: Print country name in foreign addresses?char10CHAR(N' ')YesXADDR_005 Allow NULL? 
12NMFMTStandard name formatnvarchar20CHAR(N' ')YesT005NNMFMT_005 Allow NULL? 
13XREGSFlag: City file address checkchar10CHAR(N' ')YesXREGS_005 Allow NULL? 
14XPLSTFlag: Street-specific postal code? (City file)char10CHAR(N' ')YesXPLST_005 Allow NULL? 
15INTCACountry ISO codenvarchar20CHAR(N' ')YesINTCA Allow NULL? 
16INTCA3ISO country code 3 charnvarchar30CHAR(N' ')YesINTCA3 Allow NULL? 
17INTCN3ISO Country Code Numeric 3-Charactersnvarchar30NUMC(N'000')YesINTCN3 Allow NULL? 
18XEGLDIndicator: European Union Member?char10CHAR(N' ')YesXEGLD Allow NULL? 
19XSKFNIndicator: Discount base amount is the net valuechar10CHAR(N' ')YesXSKFN Allow NULL? 
20XMWSNIndicator: Base amount for tax is net of discount ?char10CHAR(N' ')YesXMWSN Allow NULL? 
21LNBKNBank account number lengthnvarchar20NUMC(N'00')YesLNBKN_005 Allow NULL? 
22PRBKNRule for checking bank account number fieldchar10CHAR(N' ')YesPRBKN_005 Allow NULL? 
23LNBLZBank number lengthnvarchar20NUMC(N'00')YesLNBLZ_005 Allow NULL? 
24PRBLZRule for checking bank number fieldchar10CHAR(N' ')YesPRBLZ_005 Allow NULL? 
25LNPSKPost office bank current account number lengthnvarchar20NUMC(N'00')YesLNPSK_005 Allow NULL? 
26PRPSKRule for checking postal check account number fieldchar10CHAR(N' ')YesPRPSK_005 Allow NULL? 
27XPRBKIndicator: Use check module for bank fields ?char10CHAR(N' ')YesXPRBK_005 Allow NULL? 
28BNKEYName of the bank keychar10CHAR(N' ')YesBNKEY Allow NULL? 
29LNBKSLength of Bank Keynvarchar20NUMC(N'00')YesLNBKS_005 Allow NULL? 
30PRBKSRule for checking bank key fieldchar10CHAR(N' ')YesPRBKS_005 Allow NULL? 
31XPRSOIndicator: Use check module for tax fields etc. ?char10CHAR(N' ')YesXPRSO_005 Allow NULL? 
32PRUINRule for checking VAT registration number fieldchar10CHAR(N' ')YesPRUIN_005 Allow NULL? 
33UINLNVAT registration number lengthnvarchar20NUMC(N'00')YesUINLN Allow NULL? 
34LNST1Permitted Input Length for Tax Numbre 1nvarchar20NUMC(N'00')YesLNST1_005 Allow NULL? 
35PRST1Rule for checking tax code 1 fieldchar10CHAR(N' ')YesPRST1_005 Allow NULL? 
36LNST2Permitted Input Length for Tax Number 2nvarchar20NUMC(N'00')YesLNST2_005 Allow NULL? 
37PRST2Rule for checking tax code 2 fieldchar10CHAR(N' ')YesPRST2_005 Allow NULL? 
38LNST3Permitted Input Length for Tax Number 3nvarchar20NUMC(N'00')YesLNST3_005 Allow NULL? 
39PRST3Rule for checking tax code 3 fieldchar10CHAR(N' ')YesPRST3_005 Allow NULL? 
40LNST4Permitted Input Length for Tax Number 4nvarchar20NUMC(N'00')YesLNST4_005 Allow NULL? 
41PRST4Rule for checking tax code 4 fieldchar10CHAR(N' ')YesPRST4_005 Allow NULL? 
42LNST5Permitted Input Length for Tax Number 5nvarchar20NUMC(N'00')YesLNST5_005 Allow NULL? 
43PRST5Rule for checking tax code 5 fieldchar10CHAR(N' ')YesPRST5_005 Allow NULL? 
44LANDDDUEVO: Nationalitynvarchar30CHAR(N' ')YesT5D4EDUSTA Allow NULL? 
45KALSMProcedure (Pricing, Output Control, Acct. Det., Costing,...)nvarchar60CHAR(N' ')YesT683KALSM_D Allow NULL? 
46LANDAAlternative Country Keynvarchar30CHAR(N' ')NoLANDA Allow NULL? 
47WECHFPayment period for bill of exchangenvarchar30NUMC(N'000')NoWECHF Allow NULL? 
48LKVRZShort Name for Foreign Trade Statisticsnvarchar70CHAR(N' ')NoLKVRZ Allow NULL? 
49INTCNIntrastat Codenvarchar30NUMC(N'000')NoINTCN Allow NULL? 
50XDEZPDecimal point formatchar10CHAR(N' ')NoXDEZP Allow NULL? 
51DATFMDate Formatchar10CHAR(N' ')NoDATFM Allow NULL? 
52CURINCurrency Key of the Index-Based Currencynvarchar50CUKY(N' ')NoTCURCCURIN Allow NULL? 
53CURHACurrency Key of the Hard Currencynvarchar50CUKY(N' ')NoTCURCCURHA Allow NULL? 
54WAERSCountry currencynvarchar50CUKY(N' ')YesTCURCWAERS_005 Allow NULL? 
55KURSTExchange Rate Type for Translation into Country Currencynvarchar40CHAR(N' ')YesTCURVKURST_005 Allow NULL? 
56AFAPLChart of depreciaton for asset valuationnvarchar40CHAR(N' ')YesT096AFAPL Allow NULL? 
57GWGWRTMaximum low-value asset amountdecimal132CURR((0))YesGWGWRT
58UMRWRTNet book value for changeover of depreciation methoddecimal132CURR((0))YesUMRWRT
59KZRBWBIndicator post net book value for retirementchar10CHAR(N' ')YesKZRBWB Allow NULL? 
60XANZUMIndicator transfer down payments from previous yearschar10CHAR(N' ')YesXANZUM Allow NULL? 
61CTNCONCEPTWithholding tax certificate numbering: Conceptsnvarchar40CHAR(N' ')YesWITH_CTNCOKEYCTNCONCEPT Allow NULL? 
62KZSRVTaxes at individual service levelchar10CHAR(N' ')YesKZSRV Allow NULL? 
63XXINVEIndicator: Display Capital Goods Indicator?char10CHAR(N' ')YesXXINVE Allow NULL? 
64SUREGSuper region per countrynvarchar80CHAR(N' ')YesTBKSPRQ_SUREG Allow NULL? 
65LANDGRP_VPCountry grouping for shipping schedulenvarchar20CHAR(N' ')YesTJG94LANDGRP_VP Allow NULL? 
NamePrimaryUniqueTypeColumns
T005~0YesYesCLUSTEREDLAND1, MANDT

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy