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  | AFRU
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 :: Production Orders :: Order Processing :: Confirmations
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0AFRU1441Order ConfirmationsConfirmations
SQL:  selectupdate insert create

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

SELECT MANDT, RUECK, RMZHL, ERSDA, ERNAM, LAEDA, AENAM, BUDAT, ARBID, WERKS, LTXA1, TXTSP, ISERH, ZEIER, ILE01, ISM01, ILE02, ISM02, ILE03, ISM03, ILE04, ISM04, ILE05, ISM05, ILE06, ISM06, ABARB, ISMNW, ISMNE, LEARR, IDAUR, IDAUE, ZCODE, LOART, QUALF, ANZMA, LOGRP, GMNGA, LMNGA, XMNGA, GMEIN, MEINH, GRUND, PERNR, ISDD, ISDZ, IERD, IERZ, ISBD, ISBZ, IEBD, IEBZ, ISAD, ISAZ, IEDD, IEDZ, PEDD, PEDZ, WABLNR, WEBLNR, AUERU, AUSOR, STNDR, MANUR, MEILR, AUFPL, APLZL, AUFNR, APLFL, VORNR, SUMNR, OFM01, OFE01, LEK01, OFM02, OFE02, LEK02, OFM03, OFE03, LEK03, OFM04, OFE04, LEK04, OFM05, OFE05, LEK05, OFM06, OFE06, LEK06, OFMNW, OFMNE, LEKNW, ODAUR, ODAUE, STOKZ, STZHL, SMENG, RUECK_MST, RMZHL_MST, PDSNR, KAPID, SPLIT, ZAUSW, ORIND, ORIGF, CANUM, BELNR_IST, BELNR_UMB, RMNGA, CATSBELNR, SATZA, ERZET, CATSPRICE, CATSTCURR, CATSPEINH, BEMOT, IPRZ1, IPRE1, IPRK1, EXNAM, EXERD, EXERZ, PRZ01, OPRZ1, OPRE1, SKOKRS, SKOSTL, NODAT, ISMNU, OFMNU, PACKNO, EXTID, SCHGRUP, KAPTPROG, OBMAT, OBCHA, LICHA, MYEAR, ME_SFCID, ME_2ND_CONF_QTY, ROLE_ID, UCMAT, UCCHA, WTY_IND FROM AFRU
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2RUECKCompletion confirmation number for the operationnvarchar100NUMC(N'0000000000')NoCO_RUECK Allow NULL? 
3RMZHLConfirmation counternvarchar80NUMC(N'00000000')NoCO_RMZHL Allow NULL? 
4ERSDAConfirmation entry datenvarchar80DATS(N'00000000')YesRU_ERSDA Allow NULL? 
5ERNAMName of the person who entered the confirmationnvarchar120CHAR(N' ')YesRU_ERNAM Allow NULL? 
6LAEDADate of Last Changenvarchar80DATS(N'00000000')YesLAEDA Allow NULL? 
7AENAMName of Person Who Changed Objectnvarchar120CHAR(N' ')YesAENAM Allow NULL? 
8BUDATPosting datenvarchar80DATS(N'00000000')YesBUCHDATUM Allow NULL? 
9ARBIDObject IDnvarchar80NUMC(N'00000000')YesOBJEKTID Allow NULL? 
10WERKSPlantnvarchar40CHAR(N' ')YesT001WWERKS_D Allow NULL? 
11LTXA1Confirmation textnvarchar400CHAR(N' ')YesCO_RTEXT Allow NULL? 
12TXTSPLanguage Keychar10LANG(N' ')YesT002SPRAS Allow NULL? 
13ISERHConfirmed break timedecimal93QUAN((0))YesISERH
14ZEIERUnit for the break timenvarchar30UNIT(N' ')YesT006DZEIER Allow NULL? 
15ILE01Unit of measure for the activity to be confirmednvarchar30UNIT(N' ')YesT006CO_ISMNGEH Allow NULL? 
16ISM01Activity Currently to be Confirmeddecimal133QUAN((0))YesRU_ISMNG
17ILE02Unit of measure for the activity to be confirmednvarchar30UNIT(N' ')YesT006CO_ISMNGEH Allow NULL? 
18ISM02Activity Currently to be Confirmeddecimal133QUAN((0))YesRU_ISMNG
19ILE03Unit of measure for the activity to be confirmednvarchar30UNIT(N' ')YesT006CO_ISMNGEH Allow NULL? 
20ISM03Activity Currently to be Confirmeddecimal133QUAN((0))YesRU_ISMNG
21ILE04Unit of measure for the activity to be confirmednvarchar30UNIT(N' ')YesT006CO_ISMNGEH Allow NULL? 
22ISM04Activity Currently to be Confirmeddecimal133QUAN((0))YesRU_ISMNG
23ILE05Unit of measure for the activity to be confirmednvarchar30UNIT(N' ')YesT006CO_ISMNGEH Allow NULL? 
24ISM05Activity Currently to be Confirmeddecimal133QUAN((0))YesRU_ISMNG
25ILE06Unit of measure for the activity to be confirmednvarchar30UNIT(N' ')YesT006CO_ISMNGEH Allow NULL? 
26ISM06Activity Currently to be Confirmeddecimal133QUAN((0))YesRU_ISMNG
27ABARBConfirmation: Degree of processingnvarchar30NUMC(N'000')YesCO_ABARB Allow NULL? 
28ISMNWActual workdecimal71QUAN((0))YesISMNW
29ISMNEUnit for worknvarchar30UNIT(N' ')YesT006ARBEITE Allow NULL? 
30LEARRActivity Type for Confirmationnvarchar60CHAR(N' ')YesCSLALEARR Allow NULL? 
31IDAURActual Duration for Confirmationdecimal51QUAN((0))YesIDAUR
32IDAUEUnit for actual durationnvarchar30UNIT(N' ')YesT006IDAURE Allow NULL? 
33ZCODEReference number for standard value codenvarchar60CHAR(N' ')YesDZCODE Allow NULL? 
34LOARTWage Typenvarchar40CHAR(N' ')YesLOHNART Allow NULL? 
35QUALFSuitabilitynvarchar20CHAR(N' ')YesT423QUALF Allow NULL? 
36ANZMANumber of employeesdecimal52DEC((0))YesANZMS
37LOGRPWage groupnvarchar30CHAR(N' ')YesT421LOHNGRP Allow NULL? 
38GMNGAPreviously confirmed yield in order unit of measuredecimal133QUAN((0))YesRU_GMNGA
39LMNGAYield to Be Confirmeddecimal133QUAN((0))YesRU_LMNGA
40XMNGAScrap to Be Confirmeddecimal133QUAN((0))YesRU_XMNGA
41GMEINBase Unit of Measurenvarchar30UNIT(N' ')YesT006MEINS Allow NULL? 
42MEINHConfirmation unit of measurenvarchar30UNIT(N' ')YesT006RU_VORME Allow NULL? 
43GRUNDReason for Variancenvarchar40CHAR(N' ')YesTRUGCO_AGRND Allow NULL? 
44PERNRPersonnel numbernvarchar80NUMC(N'00000000')YesCO_PERNR Allow NULL? 
45ISDDConfirmed date for start of executionnvarchar80DATS(N'00000000')YesRU_ISDD Allow NULL? 
46ISDZConfirmed time for 'Execution start'nvarchar60TIMS(N'000000')YesRU_ISDZ Allow NULL? 
47IERDConfirmed date for 'Setup finish'nvarchar80DATS(N'00000000')YesRU_IERD Allow NULL? 
48IERZConfirmed time for 'Setup finish'nvarchar60TIMS(N'000000')YesRU_IERZ Allow NULL? 
49ISBDConfirmed date for 'Processing start'nvarchar80DATS(N'00000000')YesRU_ISBD Allow NULL? 
50ISBZConfirmed time for 'Processing start'nvarchar60TIMS(N'000000')YesRU_ISBZ Allow NULL? 
51IEBDConfirmed date for 'processing finish'nvarchar80DATS(N'00000000')YesRU_IEBD Allow NULL? 
52IEBZConfirmed time for 'processing finish'nvarchar60TIMS(N'000000')YesRU_IEBZ Allow NULL? 
53ISADConfirmed date for 'teardown start'nvarchar80DATS(N'00000000')YesRU_ISAD Allow NULL? 
54ISAZConfirmed time for 'teardown start'nvarchar60TIMS(N'000000')YesRU_ISAZ Allow NULL? 
55IEDDConfirmed date for execution finishnvarchar80DATS(N'00000000')YesRU_IEDD Allow NULL? 
56IEDZConfirmed time for 'Execution finish'nvarchar60TIMS(N'000000')YesRU_IEDZ Allow NULL? 
57PEDDForecast finish date of operation from confirmationnvarchar80DATS(N'00000000')YesCO_PEDD Allow NULL? 
58PEDZForecast finish time of operation from confirmationnvarchar60TIMS(N'000000')YesCO_PEDZ Allow NULL? 
59WABLNRNumber of Material Documentnvarchar100CHAR(N' ')YesMBLNR Allow NULL? 
60WEBLNRNumber of a document from a goods movement with errorsnvarchar100CHAR(N' ')YesWEBLNR Allow NULL? 
61AUERUPartial/Final Confirmationchar10CHAR(N' ')YesAUERU_VS Allow NULL? 
62AUSORClear Open Reservationschar10CHAR(N' ')YesAUSBU Allow NULL? 
63STNDRIndicator: Standard confirmationchar10CHAR(N' ')YesSTNDR Allow NULL? 
64MANURIndicator for type of confirmationchar10CHAR(N' ')YesMANUR Allow NULL? 
65MEILRIndicator: Milestone confirmation carried outchar10CHAR(N' ')YesMEILR Allow NULL? 
66AUFPLRouting number of operations in the ordernvarchar100NUMC(N'0000000000')YesCO_AUFPL Allow NULL? 
67APLZLGeneral counter for ordernvarchar80NUMC(N'00000000')YesAFVCCO_APLZL Allow NULL? 
68AUFNROrder Numbernvarchar120CHAR(N' ')YesAUFKAUFNR Allow NULL? 
69APLFLSequencenvarchar60CHAR(N' ')YesPLNFOLGE Allow NULL? 
70VORNROperation/Activity Numbernvarchar40CHAR(N' ')YesVORNR Allow NULL? 
71SUMNRNode number of the superior operationnvarchar80NUMC(N'00000000')YesSUMKNTNR Allow NULL? 
72OFM01Forecast value used to update the standard valuedecimal93QUAN((0))YesCO_SCHAETZ
73OFE01Unit of measurement for the forecast standard valuenvarchar30UNIT(N' ')YesT006RU_PROGVGE Allow NULL? 
74LEK01Indicator: No remaining activity expectedchar10CHAR(N' ')YesCO_LEIKZ Allow NULL? 
75OFM02Forecast value used to update the standard valuedecimal93QUAN((0))YesCO_SCHAETZ
76OFE02Unit of measurement for the forecast standard valuenvarchar30UNIT(N' ')YesT006RU_PROGVGE Allow NULL? 
77LEK02Indicator: No remaining activity expectedchar10CHAR(N' ')YesCO_LEIKZ Allow NULL? 
78OFM03Forecast value used to update the standard valuedecimal93QUAN((0))YesCO_SCHAETZ
79OFE03Unit of measurement for the forecast standard valuenvarchar30UNIT(N' ')YesT006RU_PROGVGE Allow NULL? 
80LEK03Indicator: No remaining activity expectedchar10CHAR(N' ')YesCO_LEIKZ Allow NULL? 
81OFM04Forecast value used to update the standard valuedecimal93QUAN((0))YesCO_SCHAETZ
82OFE04Unit of measurement for the forecast standard valuenvarchar30UNIT(N' ')YesT006RU_PROGVGE Allow NULL? 
83LEK04Indicator: No remaining activity expectedchar10CHAR(N' ')YesCO_LEIKZ Allow NULL? 
84OFM05Forecast value used to update the standard valuedecimal93QUAN((0))YesCO_SCHAETZ
85OFE05Unit of measurement for the forecast standard valuenvarchar30UNIT(N' ')YesT006RU_PROGVGE Allow NULL? 
86LEK05Indicator: No remaining activity expectedchar10CHAR(N' ')YesCO_LEIKZ Allow NULL? 
87OFM06Forecast value used to update the standard valuedecimal93QUAN((0))YesCO_SCHAETZ
88OFE06Unit of measurement for the forecast standard valuenvarchar30UNIT(N' ')YesT006RU_PROGVGE Allow NULL? 
89LEK06Indicator: No remaining activity expectedchar10CHAR(N' ')YesCO_LEIKZ Allow NULL? 
90OFMNWRemaining workdecimal71QUAN((0))YesREMNW
91OFMNEUnit of measure for remaining worknvarchar30UNIT(N' ')YesT006OFMNE Allow NULL? 
92LEKNWIndicator: No Remaining Work Expectedchar10CHAR(N' ')YesLEKNW Allow NULL? 
93ODAURRemaining duration of activitydecimal51QUAN((0))YesODAUR
94ODAUEUnit for remaining durationnvarchar30UNIT(N' ')YesT006ODAUE Allow NULL? 
95STOKZIndicator: Document Has Been Reversedchar10CHAR(N' ')YesCO_STOKZ Allow NULL? 
96STZHLConfirmation counter of cancelled confirmationnvarchar80NUMC(N'00000000')YesCO_STZHL Allow NULL? 
97SMENGOperation Quantitydecimal133QUAN((0))YesMGVRG
98RUECK_MSTCompletion confirmation number for the operationnvarchar100NUMC(N'0000000000')YesCO_RUECK Allow NULL? 
99RMZHL_MSTConfirmation counternvarchar80NUMC(N'00000000')YesCO_RMZHL Allow NULL? 
100PDSNRSequential number for PDC messagesnvarchar120NUMC(N'000000000000')Yes*PDSNR_D Allow NULL? 
101KAPIDCapacity IDnvarchar80NUMC(N'00000000')YesKAKOKAPID Allow NULL? 
102SPLITSplit numbertinyint30INT1((0))YesCY_SPLIT
103ZAUSWTime Recording ID Numbernvarchar80NUMC(N'00000000')YesDZAUSW Allow NULL? 
104ORINDOrigin Indicator of PDC Message (Application)char10CHAR(N' ')YesORIND Allow NULL? 
105ORIGFOrigin Indicator of PDC Messagechar10CHAR(N' ')YesORIGF Allow NULL? 
106CANUMCounters for cap. rqmts. records (various caps. + indiv.capsnvarchar40NUMC(N'0000')YesKBEDCY_COUNT Allow NULL? 
107BELNR_ISTDocument Numbernvarchar100CHAR(N' ')Yes*CO_BELNR Allow NULL? 
108BELNR_UMBDocument Numbernvarchar100CHAR(N' ')Yes*CO_BELNR Allow NULL? 
109RMNGACurrent rework quantity to be confirmeddecimal133QUAN((0))YesRU_RMNGA
110CATSBELNRDocument Numbernvarchar100CHAR(N' ')YesCATSBELNR Allow NULL? 
111SATZARecord type for confirmationnvarchar30CHAR(N' ')YesCO_SATZA Allow NULL? 
112ERZETConfirmation entry timenvarchar60TIMS(N'000000')YesRU_ERZET Allow NULL? 
113CATSPRICEPrice in Transaction Currencydecimal112CURR((0))YesCATSPRICE
114CATSTCURRTransaction Currencynvarchar50CUKY(N' ')Yes*TWAER Allow NULL? 
115CATSPEINHPrice Unitdecimal50DEC((0))YesPEINH
116BEMOTAccounting Indicatornvarchar20CHAR(N' ')YesTBMOTBEMOT Allow NULL? 
117IPRZ1Current quantity to be confirmed for the business processdecimal133QUAN((0))YesRU_IPRZS
118IPRE1Unit of measurement for conf. quantity for business processnvarchar30UNIT(N' ')YesT006RU_IPRZE Allow NULL? 
119IPRK1No remaining quantity expected for business processchar10CHAR(N' ')YesRU_IPRZK Allow NULL? 
120EXNAMExternal creator of confirmationnvarchar120CHAR(N' ')YesRU_EXNAM Allow NULL? 
121EXERDExternal date of entry for confirmationnvarchar80DATS(N'00000000')YesRU_EXERD Allow NULL? 
122EXERZExternal time of entry for confirmationnvarchar60TIMS(N'000000')YesRU_EXERZ Allow NULL? 
123PRZ01Business Processnvarchar120CHAR(N' ')Yes*CO_PRZNR Allow NULL? 
124OPRZ1Remaining quantity for business processdecimal133QUAN((0))YesOPRZ1
125OPRE1Unit for remaining quantity of business processnvarchar30UNIT(N' ')YesT006OPRE1 Allow NULL? 
126SKOKRSControlling Areanvarchar40CHAR(N' ')Yes*KOKRS Allow NULL? 
127SKOSTLSender Cost Centernvarchar100CHAR(N' ')Yes*SKOSTL Allow NULL? 
128NODATDo not update actual date in the operationchar10CHAR(N' ')YesNODAT Allow NULL? 
129ISMNUUnit for worknvarchar30UNIT(N' ')YesT006ARBEITE Allow NULL? 
130OFMNUUnit for worknvarchar30UNIT(N' ')YesT006ARBEITE Allow NULL? 
131PACKNOPackage numbernvarchar100NUMC(N'0000000000')Yes*PACKNO Allow NULL? 
132EXTIDExternal Key for Confirmation (for example, from PDC System)varbinary160RAWYesRU_EXTID
133SCHGRUPGrouping for Shift Definitions and Shift Sequencesnvarchar20CHAR(N' ')Yes*SCHGRUP Allow NULL? 
134KAPTPROGShift definitionnvarchar40CHAR(N' ')Yes*KAPTPROG Allow NULL? 
135OBMATMaterial from Original Batchnvarchar180CHAR(N' ')Yes*UCMAT Allow NULL? 
136OBCHAOriginal Batchnvarchar100CHAR(N' ')Yes*UCCHA Allow NULL? 
137LICHAVendor Batch Numbernvarchar150CHAR(N' ')YesLICHN Allow NULL? 
138MYEARMaterial Document Yearnvarchar40NUMC(N'0000')YesMJAHR Allow NULL? 
139ME_SFCIDSFC Number from the ME Systemnvarchar600CHAR(N' ')YesCO_MES_INT_SFCID Allow NULL? 
140ME_2ND_CONF_QTYRework Quantity Confirmed from SAP MEdecimal133QUAN((0))YesCO_MES_SECOND_CONF_QTY
141ROLE_IDRole ID for Confirmation in Portalchar10CHAR(N' ')YesRMAN_PRSP_ROLEID Allow NULL? 
142UCMATMill: Material in Process Batchnvarchar180CHAR(N' ')Yes*MILL_PCMAT Allow NULL? 
143UCCHAMill: Process batchnvarchar100CHAR(N' ')Yes*MILL_PCCHA Allow NULL? 
144WTY_INDWarranty indicatorchar10CHAR(N' ')YesWTYSC_WTY_INDICATOR Allow NULL? 
NamePrimaryUniqueTypeColumns
AFRU~0YesYesCLUSTEREDRMZHL, RUECK, 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