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  | /BEV1/RBWE
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
Sales and Distribution :: Sales :: Part Load Lift Orders :: Remaining Beverage - Obsolete Objects
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0/BEV1/RBWE631Itemized Proof Rebate SettlementRemaining Beverage - Obsolete Objects
SQL:  selectupdate insert create

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

SELECT MANDT, KNUMH, KUNWE, MATNR, VBELN, POSNR, BUTYP, SIMKEY, BONEM, VKORG, VTWEG, SPART, KNUMA_BO, KSCHL, VAKEY, KOPOS, BOART, BOMAT, KBETR, KONWA, KPEIN, KMEIN, KUMZA, KUMNE, MEINS, KRECH, KWAEH, WAERS, STFKZ, KZBZG, KONMS, KONWS, KBRUE, BEGAB, ENDAB, FKDAT, KWERT, ZBONBA, ZMENG, KAWRT_A, KMENG_A, KSTBS_A, RUWRT_A, KWERT_A, KBETS, KSTBS, KSTBM, AUBEL, BELNR, GJAHR, PERDE, FKART, HERKUNFT, ABRKZ, MODUS, STORKZ, ARCHKZ, ERNAM, ERZET, ERDAT, AENAM, AEZET, AEDAT FROM /BEV1/RBWE
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2KNUMHCondition record numbernvarchar100CHAR(N' ')NoKNUMH Allow NULL? 
3KUNWECustomer Numbernvarchar100CHAR(N' ')NoKNA1KUNNR Allow NULL? 
4MATNRMaterial Numbernvarchar180CHAR(N' ')NoMARAMATNR Allow NULL? 
5VBELNBilling Documentnvarchar100CHAR(N' ')NoVBUKVBELN_VF Allow NULL? 
6POSNRBilling itemnvarchar60NUMC(N'000000')NoVBUPPOSNR_VF Allow NULL? 
7BUTYPType Posting CO-PA/Rebatechar10CHAR(N' ')No/BEV1/RBBUTYP Allow NULL? 
8SIMKEYKey Simulation Rebate/Allocation CO-PAnvarchar100CHAR(N' ')No/BEV1/RBSIMKY Allow NULL? 
9BONEMRebate recipientnvarchar100CHAR(N' ')No*BONEM Allow NULL? 
10VKORGSales Organizationnvarchar40CHAR(N' ')No*VKORG Allow NULL? 
11VTWEGDistribution Channelnvarchar20CHAR(N' ')No*VTWEG Allow NULL? 
12SPARTDivisionnvarchar20CHAR(N' ')No*SPART Allow NULL? 
13KNUMA_BOAgreement (various conditions grouped together)nvarchar100CHAR(N' ')No*KNUMA Allow NULL? 
14KSCHLCondition typenvarchar40CHAR(N' ')No*KSCHA Allow NULL? 
15VAKEYVariable key 100 bytesnvarchar1000CHAR(N' ')NoVAKEY Allow NULL? 
16KOPOSSequential number of the conditionnvarchar20NUMC(N'00')NoKOPOS Allow NULL? 
17BOARTAgreement typenvarchar40CHAR(N' ')No*BOART Allow NULL? 
18BOMATMaterial for rebate settlementnvarchar180CHAR(N' ')No*BOMAT Allow NULL? 
19KBETRRate (condition amount or percentage) where no scale existsdecimal112CURR((0))NoKBETR_KOND
20KONWARate unit (currency or percentage)nvarchar50CUKY(N' ')Yes*KONWA Allow NULL? 
21KPEINCondition pricing unitdecimal50DEC((0))YesKPEIN
22KMEINCondition unitnvarchar30UNIT(N' ')Yes*KMEIN Allow NULL? 
23KUMZANumerator for converting condition units to base unitsdecimal50DEC((0))YesKUMZA
24KUMNEDenominator for converting condition units to base unitsdecimal50DEC((0))YesKUMNE
25MEINSBase Unit of Measurenvarchar30UNIT(N' ')Yes*MEINS Allow NULL? 
26KRECHCalculation type for conditionchar10CHAR(N' ')YesKRECH Allow NULL? 
27KWAEHCondition currency (for cumulation fields)nvarchar50CUKY(N' ')Yes*KWAEH Allow NULL? 
28WAERSCurrency Keynvarchar50CUKY(N' ')Yes*WAERS Allow NULL? 
29STFKZScale Typechar10CHAR(N' ')YesSTFKZ Allow NULL? 
30KZBZGScale basis indicatorchar10CHAR(N' ')YesKZBZG Allow NULL? 
31KONMSCondition scale unit of measurenvarchar30UNIT(N' ')Yes*KONMS Allow NULL? 
32KONWSScale currencynvarchar50CUKY(N' ')Yes*KONWS Allow NULL? 
33KBRUEAccrual Amountdecimal112CURR((0))YesKBRUE
34BEGABValid-From Datenvarchar80DATS(N'00000000')YesDATAB Allow NULL? 
35ENDABValid To Datenvarchar80DATS(N'00000000')YesDATBI Allow NULL? 
36FKDATBilling date for billing index and printoutnvarchar80DATS(N'00000000')YesFKDAT Allow NULL? 
37KWERTCondition valuenvarchar190CHAR(N' ')Yes/BEV1/RBKWERT Allow NULL? 
38ZBONBARebate: Accumulated sales volume in local currencydecimal192CURR((0))YesMC_BONBA
39ZMENGTarget quantity in sales unitsdecimal133QUAN((0))YesDZMENG
40KAWRT_ACondition base valuedecimal152CURR((0))YesKAWRT
41KMENG_ASales quantitydecimal153QUAN((0))YesMC_UMMENGE
42KSTBS_AScale base value of the conditiondecimal152CURR((0))YesKSTBS
43RUWRT_ARebate: Accrued value in local currencydecimal192CURR((0))YesMC_RUWRT
44KWERT_ACondition base valuedecimal152CURR((0))YesKAWRT
45KBETSRate (condition amount or percentage) where no scale existsdecimal112CURR((0))YesKBETR_KOND
46KSTBSRebate: Accrued value in local currencydecimal192CURR((0))YesMC_RUWRT
47KSTBMCondition scale quantitydecimal153QUAN((0))YesKSTBM
48AUBELSales Documentnvarchar100CHAR(N' ')YesVBUKVBELN_VA Allow NULL? 
49BELNRDocument number of line item in Profitability Analysisnvarchar100CHAR(N' ')YesRKE_BELNR Allow NULL? 
50GJAHRFiscal Yearnvarchar40NUMC(N'0000')YesGJAHR Allow NULL? 
51PERDEPeriodnvarchar30NUMC(N'000')YesPERIODE Allow NULL? 
52FKARTBilling Typenvarchar40CHAR(N' ')YesTVFKFKART Allow NULL? 
53HERKUNFTOrigin Rebate Basis/Rebate Planningnvarchar40CHAR(N' ')Yes/BEV1/RBHRKFT Allow NULL? 
54ABRKZSettlement Indicatorchar10CHAR(N' ')Yes/BEV1/RBABRKZ Allow NULL? 
55MODUSModechar10CHAR(N' ')Yes/BEV1/RBMODUS Allow NULL? 
56STORKZIndicator Rebate Cancellationchar10CHAR(N' ')Yes/BEV1/RBSTORN Allow NULL? 
57ARCHKZStatus Archiving Log Table Rebatechar10CHAR(N' ')Yes/BEV1/RBARCH Allow NULL? 
58ERNAMName of Person who Created the Objectnvarchar120CHAR(N' ')YesERNAM Allow NULL? 
59ERZETEntry timenvarchar60TIMS(N'000000')YesERZET Allow NULL? 
60ERDATDate on Which Record Was Creatednvarchar80DATS(N'00000000')YesERDAT Allow NULL? 
61AENAMName of Person Who Changed Objectnvarchar120CHAR(N' ')YesAENAM Allow NULL? 
62AEZETTime last change was madenvarchar60TIMS(N'000000')YesAEZET Allow NULL? 
63AEDATChanged Onnvarchar80DATS(N'00000000')YesAEDAT Allow NULL? 
NamePrimaryUniqueTypeColumns
/BEV1/RBWE~0YesYesCLUSTEREDSIMKEY, BUTYP, POSNR, VBELN, MATNR, KUNWE, KNUMH, 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