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  | RMIO
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
Production Planning and Control :: Repetitive Manufacturing
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0RMIO1171Input Structure of Repetitive Manufacturing ConfirmationRepetitive Manufacturing
SQL:  selectupdate insert create

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

SELECT MANDT, PRTNR, MATNR, WERKS, ALORT, BWAWA, BWAWE, VERID, ADATU, BDATU, MDV01, MDV02, AUFNR, BUDAT, BLDAT, BKTXT, ERFMG, ERFME, AUSMG, STLHELL, STLDARK, KKORR, KORRZ, KORRNZ, REVLV, LBOFF, LBSTD_P, GRUND, VORPER, AKTPER, FLGPER, OVPMG, OAPMG, OFPMG, IVPMG, IAPMG, OMGTX, IMGTX, MAKTX, MMGTX, ACHARG, PLNUM, ZPUNKT, BWASC, BWACO, BWAWEM, PKNUM, PKPOS, POS, SELEK, BWAWAM, ZPKNB, BWACR, REFMG, POSTA, POSTZ, POSTN, POWAA, POWAZ, POWAN, BDENR, USR01, SCHIV, UZEIT, UNAME, MHDAT, BWAWES, BWAWAS, BWASCS, BWACOS, BWAWEMS, BWAWAMS, BWACRS, SCRZ, SCRZB, SCRZZ, RADIOFR, RADIOQU, RADIOSP, PWAUS, PKOST, PKAPA, OBART, OBNUM, KSTLF, PLWERK, PSPNR, SCRAP, RB_BAUGR, RB_KOMPO, RB_LEIST, BOM_ON, BOM_OFF, ROUT_ON, ROUT_OFF, PRODDATE, EXPIRDATE, REP_POINTS, MB_GRUND, PERNR, GRUNR, LOART, LOGRP, LSTYP, USER1, USER2, REWORK_RELEVANT, REASON, COST_CENTER, NOTIF_NUMBER, D_BATCH_KEY, D_BATCH_CONTROL, D_BATCH_CHARG, D_BATCH_MULT_E, BF_MODE, WE, REPTP FROM RMIO
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2PRTNRConfirmation numbernvarchar100NUMC(N'0000000000')No*PRTNR Allow NULL? 
3MATNRMaterial Numbernvarchar180CHAR(N' ')No*MATNR Allow NULL? 
4WERKSPlantnvarchar40CHAR(N' ')No*WERKS_D Allow NULL? 
5ALORTReceiving storage location for repetitive manufacturingnvarchar40CHAR(N' ')No*ALORT Allow NULL? 
6BWAWAMovement type for goods issuenvarchar30CHAR(N' ')No*SA_BWARTWA Allow NULL? 
7BWAWEMovement type for goods receiptnvarchar30CHAR(N' ')No*SA_BWARTWE Allow NULL? 
8VERIDProduction Versionnvarchar40CHAR(N' ')No*VERID Allow NULL? 
9ADATUValid-from date of production versionnvarchar80DATS(N'00000000')NoADATM Allow NULL? 
10BDATURun-time end: production versionnvarchar80DATS(N'00000000')NoBDATM Allow NULL? 
11MDV01Production line for repetitive manufacturingnvarchar80CHAR(N' ')NoSA_LINE1 Allow NULL? 
12MDV02Planning identificationnvarchar80CHAR(N' ')No*MDV Allow NULL? 
13AUFNRRun schedule header numbernvarchar120CHAR(N' ')No*SA_AUFNR Allow NULL? 
14BUDATPosting Date in the Documentnvarchar80DATS(N'00000000')NoBUDAT Allow NULL? 
15BLDATDocument Date in Documentnvarchar80DATS(N'00000000')NoBLDAT Allow NULL? 
16BKTXTDocument Header Textnvarchar250CHAR(N' ')NoBKTXT Allow NULL? 
17ERFMGBackflush quantity in repetitive manufacturingdecimal133QUAN((0))NoSA_ERFMG
18ERFMEUnit of measure for backflush quantity and for actual scrapnvarchar30UNIT(N' ')No*SA_ERFME Allow NULL? 
19AUSMGScrap quantitydecimal133QUAN((0))NoSA_MNG04
20STLHELLIndicator: Post backflush in dialogchar10CHAR(N' ')NoSA_STLHELL Allow NULL? 
21STLDARKIndicator: display component withdrawal/ w/o change optionchar10CHAR(N' ')NoSA_STLDARK Allow NULL? 
22KKORRIndicator: no correction of discrepancieschar10CHAR(N' ')NoSA_KKORR Allow NULL? 
23KORRZIndicator: correct discrepancieschar10CHAR(N' ')NoSA_KORRZ Allow NULL? 
24KORRNZIndicator: correction of discrepancies optionalchar10CHAR(N' ')NoSA_KORRNZ Allow NULL? 
25REVLVRevision Levelnvarchar20CHAR(N' ')NoREVLV Allow NULL? 
26LBOFFNo activity postingchar10CHAR(N' ')NoSA_LBOFF Allow NULL? 
27LBSTD_PPost standard activities according to standard cost estimatechar10CHAR(N' ')NoSA_LBSTD_P Allow NULL? 
28GRUNDReason for scrapnvarchar40CHAR(N' ')No*SA_GRUND Allow NULL? 
29VORPERPeriod informationnvarchar100CHAR(N' ')NoSA_PER_Z Allow NULL? 
30AKTPERPeriod informationnvarchar100CHAR(N' ')NoSA_PER_Z Allow NULL? 
31FLGPERPeriod informationnvarchar100CHAR(N' ')NoSA_PER_Z Allow NULL? 
32OVPMGPlanned quantity still open from previous perioddecimal133QUAN((0))NoSA_OVPMG
33OAPMGPlanned quantity still open in the current perioddecimal133QUAN((0))NoSA_OAPMG
34OFPMGPlanned quantity still open in the following perioddecimal133QUAN((0))NoSA_OFPMG
35IVPMGActuals for the previous perioddecimal133QUAN((0))NoSA_IVPMG
36IAPMGActuals for the current perioddecimal133QUAN((0))NoSA_IAPMG
37OMGTXText: open planned quantitynvarchar100CHAR(N' ')NoSA_OMGTX Allow NULL? 
38IMGTXText: actualsnvarchar100CHAR(N' ')NoSA_IMGTX Allow NULL? 
39MAKTXMaterial Description (Short Text)nvarchar400CHAR(N' ')NoMAKTX Allow NULL? 
40MMGTXText: backflush quantitynvarchar100CHAR(N' ')NoSA_MMGTX Allow NULL? 
41ACHARGReceiving batch for repetitive manufacturingnvarchar100CHAR(N' ')No*SA_CHARG Allow NULL? 
42PLNUMPlanned order numbernvarchar100CHAR(N' ')No*PLNUM Allow NULL? 
43ZPUNKTReporting Pointnvarchar40CHAR(N' ')NoSA_ZPUNKT Allow NULL? 
44BWASCMovement type for scrapnvarchar30CHAR(N' ')No*SA_BWARTSC Allow NULL? 
45BWACOMovement type for by-productnvarchar30CHAR(N' ')No*SA_BWARTCO Allow NULL? 
46BWAWEMMovement type for GR for individual sales ordernvarchar30CHAR(N' ')No*SA_BWAWEM Allow NULL? 
47PKNUMControl cycle numbernvarchar70CHAR(N' ')No*PKNUM Allow NULL? 
48PKPOSKanban item number / control cycle itemnvarchar30NUMC(N'000')NoPKPOS Allow NULL? 
49POSItem in a collective backflushnvarchar40NUMC(N'0000')NoSA_POS Allow NULL? 
50SELEKSelection indicatorchar10CHAR(N' ')NoSA_SELEK Allow NULL? 
51BWAWAMMovement type for GI - individual stock of sales ordernvarchar30CHAR(N' ')No*SA_BWAWAM Allow NULL? 
52ZPKNBFollow-up posting of previous reporting point quantitieschar10CHAR(N' ')NoSA_ZPKNB Allow NULL? 
53BWACRMvmt type for GI from plant stock for sales ordernvarchar30CHAR(N' ')No*SA_BWACR Allow NULL? 
54REFMGReference quantitydecimal133QUAN((0))NoSA_REFMG
55POSTAComplete activity postingchar10CHAR(N' ')NoSA_POSTA Allow NULL? 
56POSTZPost activities for reporting pointchar10CHAR(N' ')NoSA_POSTZ Allow NULL? 
57POSTNPost activities after last reporting pointchar10CHAR(N' ')NoSA_POSTN Allow NULL? 
58POWAAIndicator: Total GI postingchar10CHAR(N' ')NoSA_POWAA Allow NULL? 
59POWAZPost components for reporting pointchar10CHAR(N' ')NoSA_POWAZ Allow NULL? 
60POWANPost components after last reporting pointchar10CHAR(N' ')NoSA_POWAN Allow NULL? 
61BDENRPDC number (specific ID for all PDC systems)nvarchar120CHAR(N' ')NoSA_BDENR Allow NULL? 
62USR01User group in backflushingnvarchar120CHAR(N' ')NoSA_USR01 Allow NULL? 
63SCHIVShift number of the available capacitychar10NUMC(N'0')NoSCHICHTNR Allow NULL? 
64UZEITTimenvarchar60TIMS(N'000000')NoUZEIT Allow NULL? 
65UNAMEUser Namenvarchar120CHAR(N' ')NoUNAME Allow NULL? 
66MHDATSLED/Best-Before Date or Date of Productionnvarchar80DATS(N'00000000')NoTMHHD Allow NULL? 
67BWAWESMovement type for reversing goods receiptnvarchar30CHAR(N' ')No*SA_BWRTWES Allow NULL? 
68BWAWASMovement type for reversing goods issuenvarchar30CHAR(N' ')No*SA_BWRTWAS Allow NULL? 
69BWASCSMovement type for reversing scrapnvarchar30CHAR(N' ')No*SA_BWRTSCS Allow NULL? 
70BWACOSMovement type for reversing by-productnvarchar30CHAR(N' ')No*SA_BWRTCOS Allow NULL? 
71BWAWEMSMovement type for reversing GR of individual sales ordernvarchar30CHAR(N' ')No*SA_BWAWEMS Allow NULL? 
72BWAWAMSMtype f. reversing GI of individual stock of sales ordernvarchar30CHAR(N' ')No*SA_BWAWAMS Allow NULL? 
73BWACRSMovmt type for reversing GI from plnt stock for sales ordernvarchar30CHAR(N' ')No*SA_BWACRS Allow NULL? 
74SCRZInd.: Post scrap at reporting pointchar10CHAR(N' ')NoSA_SCRPZ Allow NULL? 
75SCRZBInd.: Post scrap up to RP currently being backflushedchar10CHAR(N' ')NoSA_SCRPZB Allow NULL? 
76SCRZZIndicator: Only post component scrap at reporting pointchar10CHAR(N' ')NoSA_SCRPZZ Allow NULL? 
77RADIOFRData element for radio buttonchar10CHAR(N' ')NoJ_RADIOB Allow NULL? 
78RADIOQUData element for radio buttonchar10CHAR(N' ')NoJ_RADIOB Allow NULL? 
79RADIOSPData element for radio buttonchar10CHAR(N' ')NoJ_RADIOB Allow NULL? 
80PWAUSControl confirmation process "Backflushing"char10CHAR(N' ')NoCO_PWAUS Allow NULL? 
81PKOSTControl confirmation procedure "Calculate actual costs"char10CHAR(N' ')NoCO_PKOST Allow NULL? 
82PKAPAControl confirmation procedure "Adjust remaining capacity"char10CHAR(N' ')NoCO_PKAPA Allow NULL? 
83OBARTObject type for reference in document log - repetitive mfgchar10CHAR(N' ')NoSA_OBART Allow NULL? 
84OBNUMObject reference: Document log - repetitive manufacturingnvarchar200CHAR(N' ')NoOBNUM Allow NULL? 
85KSTLFPost ordering costschar10CHAR(N' ')NoKSTLF Allow NULL? 
86PLWERKPlanning plantnvarchar40CHAR(N' ')No*WERKS_PL Allow NULL? 
87PSPNRProduction lot (WBS element)nvarchar80NUMC(N'00000000')No*REM_PSPNR Allow NULL? 
88SCRAPInclude component scrapchar10CHAR(N' ')NoSCRAP Allow NULL? 
89RB_BAUGRAssembly backflushchar10CHAR(N' ')NoRB_BAUGR Allow NULL? 
90RB_KOMPOComponent backflushchar10CHAR(N' ')NoRB_KOMPO Allow NULL? 
91RB_LEISTActivity backflushchar10CHAR(N' ')NoRB_LEIST Allow NULL? 
92BOM_ONNo BOM explosion or propose comps according to BOMchar10CHAR(N' ')NoRB_BOM Allow NULL? 
93BOM_OFFNo BOM explosion or propose comps according to BOMchar10CHAR(N' ')NoRB_BOM Allow NULL? 
94ROUT_ONPlanned activities from routingchar10CHAR(N' ')NoRB_ROUT Allow NULL? 
95ROUT_OFFPlanned activities from routingchar10CHAR(N' ')NoRB_ROUT Allow NULL? 
96PRODDATEDate of Manufacturenvarchar80DATS(N'00000000')NoHSDAT Allow NULL? 
97EXPIRDATEShelf Life Expiration or Best-Before Datenvarchar80DATS(N'00000000')NoVFDAT Allow NULL? 
98REP_POINTSReporting point backflushchar10CHAR(N' ')NoCB_REP_POINTS Allow NULL? 
99MB_GRUNDReason for Movementnvarchar40NUMC(N'0000')YesT157DMB_GRBEW Allow NULL? 
100PERNRPersonnel numbernvarchar80NUMC(N'00000000')YesCO_PERNR Allow NULL? 
101GRUNRGroup numbernvarchar80NUMC(N'00000000')Yes*PW_GRUNR Allow NULL? 
102LOARTWage Typenvarchar40CHAR(N' ')YesLOHNART Allow NULL? 
103LOGRPWage groupnvarchar30CHAR(N' ')Yes*LOHNGRP Allow NULL? 
104LSTYPTime ticket typenvarchar20CHAR(N' ')Yes*PW_LSTYP Allow NULL? 
105USER1User Field for HR Backflush Datanvarchar120CHAR(N' ')YesBF_USR Allow NULL? 
106USER2User Field for HR Backflush Datanvarchar120CHAR(N' ')YesBF_USR Allow NULL? 
107REWORK_RELEVANTRelevant for Reworkchar10CHAR(N' ')YesFCO_REWORK_RELEVANT Allow NULL? 
108REASONReason for Variancenvarchar40CHAR(N' ')YesTRUGFCO_REASON Allow NULL? 
109COST_CENTERCost Centernvarchar100CHAR(N' ')Yes*KOSTL Allow NULL? 
110NOTIF_NUMBERNotification Nonvarchar120CHAR(N' ')YesQMELQMNUM Allow NULL? 
111D_BATCH_KEYDocumentary Batch - Keynvarchar200CHAR(N' ')NoDOCUBATCH_KEY Allow NULL? 
112D_BATCH_CONTROLDefine Documentary Batches per Material Typechar10CHAR(N' ')NoDOCUBATCH_CONTROL Allow NULL? 
113D_BATCH_CHARGDocumentary Batch - Batch Numbernvarchar100CHAR(N' ')NoDOCUBATCH_CHARG Allow NULL? 
114D_BATCH_MULT_ECheckboxchar10CHAR(N' ')NoXFELD Allow NULL? 
115BF_MODECheckboxchar10CHAR(N' ')NoXFELD Allow NULL? 
116WECheckboxchar10CHAR(N' ')NoXFELD Allow NULL? 
117REPTPProduction typenvarchar20CHAR(N' ')NoREPTP Allow NULL? 
NamePrimaryUniqueTypeColumns
RMIO~0YesYesCLUSTEREDPRTNR, 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