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  | S483
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)
8BSEG345Accounting Document Segment
9/1RA/0SD010MI170Items for Class SD01 - Raw Data
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
1ORCT154Incoming Payment
2OITM249Items
3OINV268A/R Invoice
4OIVL77Whse Journal
5OINM101Whse Journal
6OVPM154Outgoing Payments
7OPCH268A/P Invoice
8JDT1110Journal Entry - Rows
9OOCR9Loading Factors
10OSRN20Serial Numbers Master Data
Industry Specific :: SAP Media :: Advertising Management
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0S483831IS-M/AM: Agent AssignmentAdvertising Management
SQL:  selectupdate insert create

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

SELECT MANDT, SSOUR, VRSIO, SPMON, SPTAG, SPWOC, SPBUP, GPAG, REGULIERER, VERM, INSERENT, VKORG, VTWEG, SPART, UR_BELEINH, BELEGEINH, PERIV, VWDAT, STWAE, VZA_UMBRT, VZA_UMNET, VZA_KZWI1, VZA_KZWI2, VZA_KZWI3, VZA_KZWI4, VZA_KZWI5, VZA_KZWI6, VZ_UMBRT, VZ_UMNET, VZ_KZWI1, VZ_KZWI2, VZ_KZWI3, VZ_KZWI4, VZ_KZWI5, VZ_KZWI6, VZA_GUBRT, VZA_GUNET, VZA_KZWI1G, VZA_KZWI2G, VZA_KZWI3G, VZA_KZWI4G, VZA_KZWI5G, VZA_KZWI6G, VZ_GUBRT, VZ_GUNET, VZ_KZWI1G, VZ_KZWI2G, VZ_KZWI3G, VZ_KZWI4G, VZ_KZWI5G, VZ_KZWI6G, VFA_UMBRT, VFA_UMNET, VFA_KZWI1, VFA_KZWI2, VFA_KZWI3, VFA_KZWI4, VFA_KZWI5, VFA_KZWI6, VF_UMBRT, VF_UMNET, VF_KZWI1, VF_KZWI2, VF_KZWI3, VF_KZWI4, VF_KZWI5, VF_KZWI6, VFA_GUBRT, VFA_GUNET, VFA_KZWI1G, VFA_KZWI2G, VFA_KZWI3G, VFA_KZWI4G, VFA_KZWI5G, VFA_KZWI6G, VF_GUBRT, VF_GUNET, VF_KZWI1G, VF_KZWI2G, VF_KZWI3G, VF_KZWI4G, VF_KZWI5G, VF_KZWI6G FROM S483
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2SSOURStatistic(s) originnvarchar40CHAR(N' ')NoSSOUR Allow NULL? 
3VRSIOVersion number in the information structurenvarchar30CHAR(N' ')No*VRSIO Allow NULL? 
4SPMONPeriod to analyze - monthnvarchar60NUMC(N'000000')NoSPMON Allow NULL? 
5SPTAGPeriod to analyze - current datenvarchar80DATS(N'00000000')NoSPTAG Allow NULL? 
6SPWOCPeriod to analyze - weeknvarchar60NUMC(N'000000')NoSPWOC Allow NULL? 
7SPBUPPeriod to analyze - posting periodnvarchar60NUMC(N'000000')NoSPBUP Allow NULL? 
8GPAGBusiness Partner: Sold-to Partynvarchar100CHAR(N' ')NoJGTGPNRGPAG Allow NULL? 
9REGULIERERIS-M: Payernvarchar100CHAR(N' ')NoJGTGPNRREGULIERER Allow NULL? 
10VERMIS-M: Sales Agent with ID Code for Screennvarchar100CHAR(N' ')No*VERMK Allow NULL? 
11INSERENTIS-M: Advertisernvarchar100CHAR(N' ')NoJGTGPNRINSERENT Allow NULL? 
12VKORGSales Organizationnvarchar40CHAR(N' ')NoTVKOVKORG Allow NULL? 
13VTWEGDistribution Channelnvarchar20CHAR(N' ')NoTVKOVVTWEG Allow NULL? 
14SPARTDivisionnvarchar20CHAR(N' ')NoTVTASPART Allow NULL? 
15UR_BELEINHIS-M: Initial Booking Unit for the OPM Itemnvarchar100CHAR(N' ')NoJJTBEUR_BELEINH Allow NULL? 
16BELEGEINHIS-M/AM: Booking Unitnvarchar100CHAR(N' ')NoJJTBEBELEGEINH Allow NULL? 
17PERIVFiscal Year Variantnvarchar20CHAR(N' ')Yes*PERIV Allow NULL? 
18VWDATPointer to administrative datanvarchar100NUMC(N'0000000000')YesVWDAT Allow NULL? 
19STWAEStatistics currencynvarchar50CUKY(N' ')YesTCURCSTWAE Allow NULL? 
20VZA_UMBRTIS-M/AM: LIS Order SAShare SVol Gross Totaldecimal192CURR((0))YesVZA_UMBRT
21VZA_UMNETIS-M/AM: LIS Order SA Share SVol Net Totaldecimal192CURR((0))YesVZA_UMNET
22VZA_KZWI1IS-M: LIS order SAShare SVol ST1 Totaldecimal172CURR((0))YesVZA_KZWI1
23VZA_KZWI2IS-M: LIS order SAShare SVOl. ST2 Totaldecimal172CURR((0))YesVZA_KZWI2
24VZA_KZWI3IS-M: LIS order SAShare SVol ST3 Totaldecimal172CURR((0))YesVZA_KZWI3
25VZA_KZWI4IS-M: LIS order SAShare SVol ST4 Totaldecimal172CURR((0))YesVZA_KZWI4
26VZA_KZWI5IS-M: LIS order SAShare SVolume ST5 Totaldecimal172CURR((0))YesVZA_KZWI5
27VZA_KZWI6IS-M: LIS order SAShare SVolume ST6 Totaldecimal172CURR((0))YesVZA_KZWI6
28VZ_UMBRTIS-M/AM: LIS order SA total gross sales volumedecimal192CURR((0))YesVZ_UMBRT
29VZ_UMNETIS-M/AM: LIS order SA total net sales volumedecimal192CURR((0))YesVZ_UMNET
30VZ_KZWI1IS-M/AM: LIS Order SA SVOL ST1 Totaldecimal172CURR((0))YesVZ_KZWI1
31VZ_KZWI2IS-M/AM: LIS Order SA SVol ST2 Totaldecimal172CURR((0))YesVZ_KZWI2
32VZ_KZWI3IS-M/AM: LIS Order SA SVol. ST3 Totaldecimal172CURR((0))YesVZ_KZWI3
33VZ_KZWI4IS-M/AM: LIS Order SA SVol ST4 Totaldecimal172CURR((0))YesVZ_KZWI4
34VZ_KZWI5IS-M/AM: LIS Order SA SVol ST5 Totaldecimal172CURR((0))YesVZ_KZWI5
35VZ_KZWI6IS-M/AM: LIS Order SA SVol. ST6 Totaldecimal172CURR((0))YesVZ_KZWI6
36VZA_GUBRTIS-M/AM: LIS Order SAShare SVol Gross Total Credit Memodecimal192CURR((0))YesVZA_GUBRT
37VZA_GUNETIS-M/AM: LIS Order SAShare SVol Net Total Credit Memodecimal192CURR((0))YesVZA_GUNET
38VZA_KZWI1GIS-M: LIS order SAShare SVol ST1 Tital Credit Memodecimal172CURR((0))YesVZA_KZWI1G
39VZA_KZWI2GIS-M: LIS order SAShare SVol. ST2 Total Credit Memodecimal172CURR((0))YesVZA_KZWI2G
40VZA_KZWI3GIS-M: LIS order SAShare SVol ST3 Total Credit Memodecimal172CURR((0))YesVZA_KZWI3G
41VZA_KZWI4GIS-M: LIS order SAgtAssShare SVol ST4 Total credit memodecimal172CURR((0))YesVZA_KZWI4G
42VZA_KZWI5GIS-M: LIS order SAShare SVol ST5 Total Credit Memodecimal172CURR((0))YesVZA_KZWI5G
43VZA_KZWI6GIS-M: LIS order SAShare SVol ST6 Total Credit Memodecimal172CURR((0))YesVZA_KZWI6G
44VZ_GUBRTIS-M/AM: LIS Order SA SVol Gross Total Credit Memodecimal192CURR((0))YesVZ_GUBRT
45VZ_GUNETIS-M/AM: LIS Order SA SVol Net Total Credit Memodecimal192CURR((0))YesVZ_GUNET
46VZ_KZWI1GIS-M/AM: LIS Order SA SVol ST1 Total Credit Memodecimal172CURR((0))YesVZ_KZWI1G
47VZ_KZWI2GIS-M/AM: LIS Order SA SVol. ST2 Total Credit Memodecimal172CURR((0))YesVZ_KZWI2G
48VZ_KZWI3GIS-M/AM: LIS Order SA SVol ST3.Total Credit Memodecimal172CURR((0))YesVZ_KZWI3G
49VZ_KZWI4GIS-M/AM: LIS Order SA SVol ST4 Total Credit Memodecimal172CURR((0))YesVZ_KZWI4G
50VZ_KZWI5GIS-M/AM: LIS Order SA SVol. ST5 Total Credit Memodecimal172CURR((0))YesVZ_KZWI5G
51VZ_KZWI6GIS-M/AM: LIS Order SA SVol. ST6 Total Credit Memodecimal172CURR((0))YesVZ_KZWI6G
52VFA_UMBRTIS-M/AM: LIS billing SAShare total gross sales volumedecimal192CURR((0))YesVFA_UMBRT
53VFA_UMNETIS-M/AM: LIS billing SA share total net sales volumedecimal192CURR((0))YesVFA_UMNET
54VFA_KZWI1IS-M: LIS billing SAShare SVol ST1 totaldecimal172CURR((0))YesVFA_KZWI1
55VFA_KZWI2IS-M: LIS billing SAShare SVol ST2 totaldecimal172CURR((0))YesVFA_KZWI2
56VFA_KZWI3IS-M: LIS billing SAShare SVol ST3 totaldecimal172CURR((0))YesVFA_KZWI3
57VFA_KZWI4IS-M: LIS billing SAShare SVol ST4 totaldecimal172CURR((0))YesVFA_KZWI4
58VFA_KZWI5IS-M: LIS billing SAShare SVol ST5 totaldecimal172CURR((0))YesVFA_KZWI5
59VFA_KZWI6IS-M: LIS billing SAShare Sales vol.ST6 totaldecimal172CURR((0))YesVFA_KZWI6
60VF_UMBRTIS-M/AM: LIS billing SA total gross sales volumedecimal192CURR((0))YesVF_UMBRT
61VF_UMNETIS-M/AM: LIS billing SA total net sales volumedecimal192CURR((0))YesVF_UMNET
62VF_KZWI1IS-M: LIS billing SA SVol ST1 totaldecimal172CURR((0))YesVF_KZWI1
63VF_KZWI2IS-M: LIS billing SA SVol ST2 totaldecimal172CURR((0))YesVF_KZWI2
64VF_KZWI3IS-M: LIS billing SA SVol ST3 totaldecimal172CURR((0))YesVF_KZWI3
65VF_KZWI4IS-M: LIS billing SA SVol ST4 totaldecimal172CURR((0))YesVF_KZWI4
66VF_KZWI5IS-M: LIS billing SA SVol ST5 totaldecimal172CURR((0))YesVF_KZWI5
67VF_KZWI6IS-M: LIS billing SA SVol.ST6 totaldecimal172CURR((0))YesVF_KZWI6
68VFA_GUBRTIS-M/AM: LIS billing SAAShare gross SVol.total credit memodecimal192CURR((0))YesVFA_GUBRT
69VFA_GUNETIS-M/AM: LIS billing SAAShare net SVol total credit memodecimal192CURR((0))YesVFA_GUNET
70VFA_KZWI1GIS-M: LIS billing SAShare SVol ST1 total credit memodecimal172CURR((0))YesVFA_KZWI1G
71VFA_KZWI2GIS-M: LIS billing SAShare SVol ST2 total credit memodecimal172CURR((0))YesVFA_KZWI2G
72VFA_KZWI3GIS-M: LIS billing SAShare SVol ST3 total credit memodecimal172CURR((0))YesVFA_KZWI3G
73VFA_KZWI4GIS-M: LIS billing SAShare SVol ST4 total credit memodecimal172CURR((0))YesVFA_KZWI4G
74VFA_KZWI5GIS-M: LIS billing SAShare SVol. ST5 total credit memodecimal172CURR((0))YesVFA_KZWI5G
75VFA_KZWI6GIS-M: LIS billing SAShare SVol ST6 total credit memodecimal172CURR((0))YesVFA_KZWI6G
76VF_GUBRTIS-M/AM: LIS billing AA gross sales volume total credit memodecimal192CURR((0))YesVF_GUBRT
77VF_GUNETIS-M/AM: LIS billing SA SVol net total credit memodecimal192CURR((0))YesVF_GUNET
78VF_KZWI1GIS-M: LIS billing SA SVol ST1 total credit memodecimal172CURR((0))YesVF_KZWI1G
79VF_KZWI2GIS-M: LIS billing SA SVol ST2 total credit memodecimal172CURR((0))YesVF_KZWI2G
80VF_KZWI3GIS-M: LIS billing SA SVol ST3 total credit memodecimal172CURR((0))YesVF_KZWI3G
81VF_KZWI4GIS-M: LIS billing SA SVol ST4 total credit memodecimal172CURR((0))YesVF_KZWI4G
82VF_KZWI5GIS-M: LIS billing SA SVol ST5 total credit memodecimal172CURR((0))YesVF_KZWI5G
83VF_KZWI6GIS-M: LIS billing SA SVol ST6 total credit memodecimal172CURR((0))YesVF_KZWI6G
NamePrimaryUniqueTypeColumns
S483~0YesYesCLUSTEREDBELEGEINH, UR_BELEINH, SPART, VTWEG, VKORG, INSERENT, VERM, REGULIERER, GPAG, SPBUP, SPWOC, SPTAG, SPMON, VRSIO, SSOUR, 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