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

104 columns | Print definition?ERP 6.0  | ALAND

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1A053Taxes Using Jurisdiction Code4ALANDDeparture country (country from which the goods are sent)nvarchar30
2A965Country/Plant/TaxCl.Mat/TaxCl1Cust4ALANDDeparture country (country from which the goods are sent)nvarchar30
3A966Country/Plant/TaxCl.2Mat/TaxCl2Cust4ALANDDeparture country (country from which the goods are sent)nvarchar30
4P2RA_STPayroll Result: Tax (Austria)44ALANDISO Code of Country or DTCnvarchar20
TOPAdvertising Management
5A212IS-M: DelCtry/BP Tax Classification4ALANDDeparture country (country from which the goods are sent)nvarchar30
6A260IS-M: DelCtry/TaxC14ALANDDeparture country (country from which the goods are sent)nvarchar30
7A261IS-M: VAT Country/RecLand/Cust.Tax Classification4ALANDDeparture country (country from which the goods are sent)nvarchar30
8A262IS-M: VAT Country/RecCountry/CustTaxCl/TaxClass4ALANDDeparture country (country from which the goods are sent)nvarchar30
9A263IS-M: DelCtry/Mat.Tax Class.4ALANDDeparture country (country from which the goods are sent)nvarchar30
10JHAPDIS-M/AM: OPM Service Item26ALANDDeparture country (country from which the goods are sent)nvarchar30
11JHTFPIS-M/AM: Billing/Settlement Documents - Item144ALANDDeparture country (country from which the goods are sent)nvarchar30
12JJTDISKIS-M/AM Tax Classification for Service3ALANDCountry is relevant for taxesnvarchar30
TOPAustria
13PA0042HR Master Record: Infotype 0042 (Fiscal Data - Austria)143ALANDISO Code of Country or DTCnvarchar20
14T5A71L16 Consolidation File131ALANDISO Code of Country or DTCnvarchar20
TOPBasic Functions
15A121Legal Control: Values for Calculating Foreign Percentage4ALANDDeparture country (country from which the goods are sent)nvarchar30
16A340Foreign Trade: CAP: Restitution rates4ALANDDeparture country (country from which the goods are sent)nvarchar30
17EIKPForeign Trade: Export/Import Header Data3ALANDDelivering countrynvarchar30
18T604SPreference: Determine Preference Zone in Export2ALANDDeparture country (country from which the goods are sent)nvarchar30
19T604UForeign Trade: Convert Commodity Code/Import Code No.2ALANDDeparture country (country from which the goods are sent)nvarchar30
20T605UForeign Trade: Convert Export/Import Bus. Trans. Type2ALANDDeparture country (country from which the goods are sent)nvarchar30
21T606ALegal Control: Departure Country / Legal Regulations2ALANDDeparture country (country from which the goods are sent)nvarchar30
22T606OLegal Control: Embargo - Dependent on Departure Country3ALANDDeparture country (country from which the goods are sent)nvarchar30
23T615UForeign Trade: Import/Export Customs Office Conversion2ALANDDeparture country (country from which the goods are sent)nvarchar30
24T616UForeign Trade: Import/Export Procedure Conversion2ALANDDeparture country (country from which the goods are sent)nvarchar30
25T617Foreign Trade: Proposal for Foreign Trade Header Data3ALANDCountry Keynvarchar30
26T618UForeign Trade: Conversion of Import/Export Mode of Transport2ALANDDeparture country (country from which the goods are sent)nvarchar30
27TROAZRoutes: Determination in Sales Documents2ALANDDeparture country (country from which the goods are sent)nvarchar30
TOPBilling
28A399Withholding tax code - country-specific4ALANDDeparture country (country from which the goods are sent)nvarchar30
29KNVICustomer Master Tax Indicator3ALANDDeparture country (country from which the goods are sent)nvarchar30
30KNVLCustomer Master Licenses3ALANDDeparture country (country from which the goods are sent)nvarchar30
31VBRPBilling Document: Item Data44ALANDDeparture country (country from which the goods are sent)nvarchar30
TOPConditions
32A002Country/Customer Classification/Material Classification4ALANDDeparture country (country from which the goods are sent)nvarchar30
33A003Tax Classification4ALANDDeparture country (country from which the goods are sent)nvarchar30
34A011Country/Country of Dest./Customer Classif./Material Classif.4ALANDDeparture country (country from which the goods are sent)nvarchar30
35A040Country/State/Customer Classif.1/Material Classification 14ALANDDeparture country (country from which the goods are sent)nvarchar30
36A041Country/State/County/Customer Classif.2/Material Classif.24ALANDDeparture country (country from which the goods are sent)nvarchar30
37A042Country/State/City/Customer Classif.3/Material Classif.34ALANDDeparture country (country from which the goods are sent)nvarchar30
38A078Departure Country / Destination Country4ALANDDeparture country (country from which the goods are sent)nvarchar30
39A156Country of Departure/Destination Country/Del. Country4ALANDDeparture country (country from which the goods are sent)nvarchar30
40A180Country/Preference Zone/Cross-Plant Grouping4ALANDDeparture country (country from which the goods are sent)nvarchar30
41A354Country/Region/PlntRegion4ALANDDeparture country (country from which the goods are sent)nvarchar30
42A356Country/PlntRegion/ST Code/TaxCl1Cust/TaxCl.Mat4ALANDDeparture country (country from which the goods are sent)nvarchar30
43A357Country/Plant/Ctrl code4ALANDDeparture country (country from which the goods are sent)nvarchar30
44A358Country/Plant/Ctrl code/Material4ALANDDeparture country (country from which the goods are sent)nvarchar30
45A362Country/NBM-NCM Code4ALANDDeparture country (country from which the goods are sent)nvarchar30
46A367Country/Plant/Region/Material4ALANDDeparture country (country from which the goods are sent)nvarchar30
47A368Country/PlntRegion/Region/TaxCl1Cust/TaxCl.Mat4ALANDDeparture country (country from which the goods are sent)nvarchar30
48A369Country/Plant/Ctrl code/TaxCl1Cust4ALANDDeparture country (country from which the goods are sent)nvarchar30
49A371Country/Plant/Ctrl code/Ship-to4ALANDDeparture country (country from which the goods are sent)nvarchar30
50A390Brazil: 100% reversals4ALANDDeparture country (country from which the goods are sent)nvarchar30
51A602Condition Table for Pricing A6024ALANDDeparture country (country from which the goods are sent)nvarchar30
52A940Condition Table for Pricing A9404ALANDDeparture country (country from which the goods are sent)nvarchar30
TOPContract Accounts Receivable and Payable
53FKK_JFRP_SHORTItem Data for IS-M/SD Billing Document - Extracts18ALANDDeparture country (country from which the goods are sent)nvarchar30
TOPData Collection
54S050Shipment11ALANDCountry: shipment startnvarchar30
55S050ES050 - Structural Information6ALANDCountry: shipment startnvarchar30
TOPFinancial Accounting
56A395Arg.: Country/Fisc.Type4ALANDDeparture country (country from which the goods are sent)nvarchar30
57A396Arg.: Country/Fisc.Type/Material4ALANDDeparture country (country from which the goods are sent)nvarchar30
58A397Arg.: Tax relevant classification4ALANDDeparture country (country from which the goods are sent)nvarchar30
59T007VTax Codes to be Transported3ALANDDeparture country (country from which the goods are sent)nvarchar30
TOPInventory Management
60A133Mixed Taxes, Domestic4ALANDDeparture country (country from which the goods are sent)nvarchar30
TOPLease Accounting
61TFILA_RE_CAT_CAssign Sales Tax Flag and Clearing Account to Refi. Categ.12ALANDDeparture country (country from which the goods are sent)nvarchar30
TOPLocalization
62A291Land/SteuKennz.4ALANDLieferndes Land (Land aus dem die Ware versandt wird)nvarchar30
63A292BR: ISS from SD: Ship-to-City4ALANDLieferndes Land (Land aus dem die Ware versandt wird)nvarchar30
64A293Land/StKla2-Kd4ALANDLieferndes Land (Land aus dem die Ware versandt wird)nvarchar30
65A341Land/StKla3-Kd4ALANDLieferndes Land (Land aus dem die Ware versandt wird)nvarchar30
66A342Land/StKla2-Mat4ALANDLieferndes Land (Land aus dem die Ware versandt wird)nvarchar30
67A343BR: Substituiçao Tributária from SD4ALANDLieferndes Land (Land aus dem die Ware versandt wird)nvarchar30
68A344BR: ICMS base reduction carrier: Land/St. Basis/Belegart4ALANDLieferndes Land (Land aus dem die Ware versandt wird)nvarchar30
69A346Land/Dyn.Schlüssel1/Dyn.Schlüssel2/Dyn.Schlüssel3/St.-Grp.4ALANDLieferndes Land (Land aus dem die Ware versandt wird)nvarchar30
70A347Land/SF/ST/Schlüssel1/Schlüssel2/Schlüssel3/St.-Grp.4ALANDLieferndes Land (Land aus dem die Ware versandt wird)nvarchar30
71A348Land/SF/ST/XSUBT/Schlüssel1/Schlüssel2/Schlüssel3/St.-Grp.4ALANDLieferndes Land (Land aus dem die Ware versandt wird)nvarchar30
72A349Land/ST/MATNR4ALANDLieferndes Land (Land aus dem die Ware versandt wird)nvarchar30
73A373Country/Plant/Material4ALANDDeparture country (country from which the goods are sent)nvarchar30
74A374Country/Sales org./Region/PlntRegion/TaxCl3Cust/TaxCl.3Mat4ALANDDeparture country (country from which the goods are sent)nvarchar30
75A375Country/Sales org./Region/PlntRegion/TaxCl2Cust/TaxCl.2Mat4ALANDDeparture country (country from which the goods are sent)nvarchar30
76A376Country/Sales org./Region/PlntRegion/TaxCl4Cust/TaxCl.4Mat4ALANDDeparture country (country from which the goods are sent)nvarchar30
77A382Land/Belegart/SF/ST/Schlüssel1/Schlüssel2/Schlüssel3/St.-Grp4ALANDLieferndes Land (Land aus dem die Ware versandt wird)nvarchar30
78A392Land4ALANDLieferndes Land (Land aus dem die Ware versandt wird)nvarchar30
79A393Land/Lieferant4ALANDLieferndes Land (Land aus dem die Ware versandt wird)nvarchar30
80A394Land/Empfänger4ALANDLieferndes Land (Land aus dem die Ware versandt wird)nvarchar30
81IDGT_CODE_LCTax Catalog Code2ALANDCountry Keynvarchar30
82J_1INEWJCODEVAT Transition Dummy Jurisdiction Code2ALANDDeparture country (country from which the goods are sent)nvarchar30
83J_1ITCJCMAPTax code and Jurisdiction code mapping2ALANDDeparture country (country from which the goods are sent)nvarchar30
TOPLogistics - General
84A190Condition Table for Pricing A1904ALANDDeparture country (country from which the goods are sent)nvarchar30
85A191Condition Table for Pricing A1914ALANDDeparture country (country from which the goods are sent)nvarchar30
86A192Country/Goods Rec./StCla-Mat4ALANDDeparture country (country from which the goods are sent)nvarchar30
87A193Condition Table for Pricing A1934ALANDDeparture country (country from which the goods are sent)nvarchar30
TOPMaterial Maintenance
88TVSTOrganizational Unit: Shipping Points6ALANDDeparture country (country from which the goods are sent)nvarchar30
TOPMaterial Master
89MAEXMaterial Master: Legal Control3ALANDDeparture country (country from which the goods are sent)nvarchar30
90MLANTax Classification for Material3ALANDDeparture country (country from which the goods are sent)nvarchar30
91MVANTax Classification for Material3ALANDDeparture country (country from which the goods are sent)nvarchar30
92STEUMM_TMPFile for Incorrect Data in Direct Input6ALANDDeparture country (country from which the goods are sent)nvarchar30
93STEU_TMPFile for Incorrect Data in Direct Input6ALANDDeparture country (country from which the goods are sent)nvarchar30
TOPPatient Accounting
94NVBRPIS-H: Billing document item data19ALANDDeparture country (country from which the goods are sent)nvarchar30
TOPPeriodical Sales and Distribution
95JDTMLANIS-M/SD: Tax Code for Publication3ALANDCountry is relevant for taxesnvarchar30
96JFRPIS-M/SD: Billing Document - Item Data16ALANDDeparture country (country from which the goods are sent)nvarchar30
TOPRecycling Administration Core Functions
97J_7LVBRPOSNON-SD Interface: Billing: Item Data15ALANDDeparture country (country from which the goods are sent)nvarchar30
TOPRemaining Beverage - Obsolete Objects
98/BEV1/BO_VATSettlement Materials for the VAT Adjustment2ALANDDeparture country (country from which the goods are sent)nvarchar30
99/BEV1/RBVATSettlement Materials Value-Added Tax Rates2ALANDDeparture country (country from which the goods are sent)nvarchar30
TOPTransportation
100TROIZRoute Determination: By Country and Zone2ALANDDeparture country (country from which the goods are sent)nvarchar30
101TROLZRoutes: Determination in Deliveries2ALANDDeparture country (country from which the goods are sent)nvarchar30
TOPUSA
102PA0566HR Master Record: Infotype 056644ALANDCountry Keynvarchar30
TOPWarranty Claim Processing
103A388Country/Tax Class.-Customer4ALANDDeparture country (country from which the goods are sent)nvarchar30
104A389Country/Partner/Tax Class.-Customer4ALANDDeparture country (country from which the goods are sent)nvarchar30