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  | S122BIW1
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
Logistics - General :: Logistics Information System LIS :: Data Collection
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0S122BIW1621S122BIW1 * CashierData Collection
SQL:  selectupdate insert create

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

SELECT MANDT, SPMON, WERKS, KBDNR, KASNR, KSKRS, KSCHL, KVORG, VRSIO, SPTAG, SPWOC, SPBUP, SSOUR, PERIV, VWDAT, WAERK, WRUMS, UMSGVO, PRSNLS, PDIFF, KBSOL, KBIST, KDNEG, KDPOS, AZBON, AZPOS, AZBST, ANZCOND, WRBST, AZSST, WRSST, AZZST, WRZST, AZSCA, AZWGV, AZABB, WRABB, AZABS, UMABS, AZSUL, WRSUL, AMDZT, REGZT, AZBRT, WRSCA, WRWGV, AZKSB, AZFAV, BNKUMS, KASNAM, KKENN, BZIRK, VKORG, VTWEG, UMSGVP, UMSGVO_01, PRSNLS_02, PDIFF_03, ZMUMS, ANZPOS, AZBON_04, ANZCOND_05 FROM S122BIW1
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2SPMONPeriod to analyze - monthnvarchar60NUMC(N'000000')NoSPMON Allow NULL? 
3WERKSPlantnvarchar40CHAR(N' ')NoT001WWERKS_D Allow NULL? 
4KBDNRCashier numbernvarchar80NUMC(N'00000000')NoW_KBDNR Allow NULL? 
5KASNRPOS numbernvarchar100NUMC(N'0000000000')NoW_KASNR Allow NULL? 
6KSKRSPOS controllernvarchar50NUMC(N'00000')NoW_KSKRS Allow NULL? 
7KSCHLCondition type, salesnvarchar40CHAR(N' ')NoT685V_KSCHA Allow NULL? 
8KVORGTransact. typenvarchar40CHAR(N' ')NoTWPPBPOSUVORG Allow NULL? 
9VRSIOVersion number in the information structurenvarchar30CHAR(N' ')No*VRSIO Allow NULL? 
10SPTAGPeriod to analyze - current datenvarchar80DATS(N'00000000')NoSPTAG Allow NULL? 
11SPWOCPeriod to analyze - weeknvarchar60NUMC(N'000000')NoSPWOC Allow NULL? 
12SPBUPPeriod to analyze - posting periodnvarchar60NUMC(N'000000')NoSPBUP Allow NULL? 
13SSOURStatistic(s) originnvarchar40CHAR(N' ')NoSSOUR Allow NULL? 
14PERIVFiscal Year Variantnvarchar20CHAR(N' ')No*PERIV Allow NULL? 
15VWDATPointer to administrative datanvarchar100NUMC(N'0000000000')NoVWDAT Allow NULL? 
16WAERKSD Document Currencynvarchar50CUKY(N' ')YesTCURCWAERK Allow NULL? 
17WRUMSRetail price with tax from cashier statisticsdecimal192CURR((0))YesC_UMSVPM
18UMSGVORetail price without tax from cashier statisticsdecimal192CURR((0))YesC_UMSVPO
19PRSNLSPrice reduction based on cashier statisticsdecimal192CURR((0))YesC_PRSNLS
20PDIFFCashier: price difference between R/3 -> and POS rtl pricedecimal192CURR((0))YesC_PDIFF
21KBSOLMeans of payment target amountdecimal192CURR((0))YesW_KBSOL
22KBISTMeans of payment actual amountdecimal192CURR((0))YesW_KBIST
23KDNEGNegative till differencedecimal192CURR((0))YesW_KDNEG
24KDPOSPositive till differencedecimal192CURR((0))YesW_KDPOS
25AZBONNumber of transactions based on cashier statisticsdecimal110DEC((0))YesC_ANZBON
26AZPOSNumber of items based on cashier statisticsdecimal110DEC((0))YesC_ANZPOS
27AZBSTNumber of canceled transactions (till receipts)decimal70DEC((0))YesW_AZBST
28ANZCONDNumber of conditions based on cashier statisticsdecimal110DEC((0))YesC_ANZCOND
29WRBSTValue of canceled transactions (till receipts)decimal192CURR((0))YesW_WRBST
30AZSSTNumber of immediate cancellationsdecimal70DEC((0))YesW_AZSST
31WRSSTValue of immediate cancellationsdecimal192CURR((0))YesW_WRSST
32AZZSTNumber of line cancelationsdecimal70DEC((0))YesW_AZZST
33WRZSTValue of cancelled linesdecimal192CURR((0))YesW_WRZST
34AZSCANumber of materials scanneddecimal70DEC((0))YesW_AZSCA
35AZWGVNumber of material group salesdecimal70DEC((0))YesW_AZWGV
36AZABBNumber of terminationsdecimal70DEC((0))YesW_AZABB
37WRABBValue of terminationsdecimal192CURR((0))YesW_WRABB
38AZABSNumber of times till has been emptied (cash removals)decimal70DEC((0))YesW_AZABS
39UMABSCash removeddecimal192CURR((0))YesW_UMABS
40AZSULNumber of checks over limitdecimal70DEC((0))YesW_AZSUL
41WRSULValue of checks over the limitdecimal192CURR((0))YesW_WRSUL
42AMDZTLogon timedecimal175DEC((0))YesW_AMDZT
43REGZTRegister timedecimal175DEC((0))YesW_REGZT
44AZBRTNumber of reportsdecimal70DEC((0))YesW_AZBRT
45WRSCAValue of scanned materialdecimal192CURR((0))YesW_WRSCA
46WRWGVValue of material group salesdecimal192CURR((0))YesW_WRWGV
47AZKSBNumber of times till drawer was openeddecimal70DEC((0))YesW_AZKSB
48AZFAVNumber of failed logon attemptsdecimal70DEC((0))YesW_AZFAV
49BNKUMSBank business volumedecimal192CURR((0))YesW_BNKUMS
50KASNAMCashier namenvarchar350CHAR(N' ')YesW_KASNAM Allow NULL? 
51KKENNCondition type identificationchar10CHAR(N' ')YesW_KKENN Allow NULL? 
52BZIRKSales districtnvarchar60CHAR(N' ')YesT171W_BEZIRK Allow NULL? 
53VKORGSales Organizationnvarchar40CHAR(N' ')YesTVKOVKORG Allow NULL? 
54VTWEGDistribution Channelnvarchar20CHAR(N' ')YesTVTWVTWEG Allow NULL? 
55UMSGVPRetail price w/tax from sales as per receipts/aggreg.salesdecimal192CURR((0))YesW_UMSVPM
56UMSGVO_01Rtl price from sales as per receipts/aggreg.salesdecimal192CURR((0))YesW_UMSVPO
57PRSNLS_02Price reduction from sales as per receipts/aggregated salesdecimal192CURR((0))YesW_PRSNLS
58PDIFF_03Trnsctn price diff. between R/3 -> and sales price at POSdecimal192CURR((0))YesW_PDIFF
59ZMUMSMeans of payment sales from sales as per receipts/aggr.salesdecimal192CURR((0))YesW_ZMUMS
60ANZPOSNumber of items from sales as per receipts/aggregated salesdecimal110DEC((0))YesW_ANZPOS
61AZBON_04Number of transactions from sales as per till receiptsdecimal110DEC((0))YesW_AZBON
62ANZCOND_05Number of conditions from sales as per receipt/aggregateddecimal110DEC((0))YesW_ANZCOND
NamePrimaryUniqueTypeColumns
S122BIW1~0YesYesCLUSTEREDSSOUR, SPBUP, SPWOC, SPTAG, VRSIO, KVORG, KSCHL, KSKRS, KASNR, KBDNR, WERKS, SPMON, 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