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  | AFRP0
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.0AFRP01002Table of planned changes for confirmation (PDC)Confirmations
SQL:  selectupdate insert create

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

SELECT MANDT, PDSNR, COUNTER, ERNAM, ERTSTAMPS, RU_PCOUNT, RU_ORINA, RU_ORINI, RU_VSWBN, WEBLNR, RUECK, AUFNR, APLFL, VORNR, UVORN, KAPAR, SPLIT, AUERU, AUSOR, BUDAT, GRUND, LTXA1, EXNAM, EXERD, EXERZ, MEINH, LMNGA, XMNGA, RMNGA, ISDD, ISDZ, IERD, IERZ, ISBD, ISBZ, IEBD, IEBZ, ISAD, ISAZ, IEDD, IEDZ, PEDD, PEDZ, WERKS, ARBPL, SATZA, ILE01, ISM01, LEK01, ILE02, ISM02, LEK02, ILE03, ISM03, LEK03, ILE04, ISM04, LEK04, ILE05, ISM05, LEK05, ILE06, ISM06, LEK06, IPRZ1, IPRE1, IPRK1, ABARB, OFE01, OFM01, OFE02, OFM02, OFE03, OFM03, OFE04, OFM04, OFE05, OFM05, OFE06, OFM06, OPRZ1, OPRE1, PERNR, ZAUSW, LOART, QUALF, ANZMA, LOGRP, ZEIER, ISERH, SLK01, SLK02, SLK03, SLK04, SLK05, SLK06, SPRK1, EXTID, LDATE, LTIME FROM AFRP0
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2PDSNRSequential number for PDC messagesnvarchar120NUMC(N'000000000000')No*PDSNR_D Allow NULL? 
3COUNTERInternal counternvarchar80NUMC(N'00000000')NoCIM_COUNT Allow NULL? 
4ERNAMEntered bynvarchar120CHAR(N' ')YesAUFERFNAM Allow NULL? 
5ERTSTAMPSUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150DEC((0))YesTZNTSTMPS
6RU_PCOUNTNumber of failed attempts at a confirmationint100INT4((0))YesRU_PCOUNT Allow NULL? 
7RU_ORINAOrigin indicator: Confirmation applicationchar10CHAR(N' ')YesRU_ORINA Allow NULL? 
8RU_ORINIOrigin indicator: Confirmation interfacechar10CHAR(N' ')YesRU_ORINI Allow NULL? 
9RU_VSWBNIndicator: Goods movements are already determinedchar10CHAR(N' ')YesVSWBN Allow NULL? 
10WEBLNRNumber of a document from a goods movement with errorsnvarchar100CHAR(N' ')YesAFFWWEBLNR Allow NULL? 
11RUECKCompletion confirmation number for the operationnvarchar100NUMC(N'0000000000')YesCO_RUECK Allow NULL? 
12AUFNROrder Numbernvarchar120CHAR(N' ')Yes*AUFNR Allow NULL? 
13APLFLSequencenvarchar60CHAR(N' ')YesPLNFOLGE Allow NULL? 
14VORNROperation/Activity Numbernvarchar40CHAR(N' ')YesVORNR Allow NULL? 
15UVORNSuboperationnvarchar40CHAR(N' ')YesUVORN Allow NULL? 
16KAPARCapacity categorynvarchar30CHAR(N' ')Yes*KAPART Allow NULL? 
17SPLITSplit numbertinyint30INT1((0))YesCY_SPLIT
18AUERUPartial/Final Confirmationchar10CHAR(N' ')YesAUERU_VS Allow NULL? 
19AUSORClear Open Reservationschar10CHAR(N' ')YesAUSBU Allow NULL? 
20BUDATPosting datenvarchar80DATS(N'00000000')YesBUCHDATUM Allow NULL? 
21GRUNDReason for Variancenvarchar40CHAR(N' ')Yes*CO_AGRND Allow NULL? 
22LTXA1Confirmation textnvarchar400CHAR(N' ')YesCO_RTEXT Allow NULL? 
23EXNAMExternal creator of confirmationnvarchar120CHAR(N' ')YesRU_EXNAM Allow NULL? 
24EXERDExternal date of entry for confirmationnvarchar80DATS(N'00000000')YesRU_EXERD Allow NULL? 
25EXERZExternal time of entry for confirmationnvarchar60TIMS(N'000000')YesRU_EXERZ Allow NULL? 
26MEINHConfirmation unit of measurenvarchar30UNIT(N' ')Yes*RU_VORME Allow NULL? 
27LMNGAYield to Be Confirmeddecimal133QUAN((0))YesRU_LMNGA
28XMNGAScrap to Be Confirmeddecimal133QUAN((0))YesRU_XMNGA
29RMNGACurrent rework quantity to be confirmeddecimal133QUAN((0))YesRU_RMNGA
30ISDDConfirmed date for start of executionnvarchar80DATS(N'00000000')YesRU_ISDD Allow NULL? 
31ISDZConfirmed time for 'Execution start'nvarchar60TIMS(N'000000')YesRU_ISDZ Allow NULL? 
32IERDConfirmed date for 'Setup finish'nvarchar80DATS(N'00000000')YesRU_IERD Allow NULL? 
33IERZConfirmed time for 'Setup finish'nvarchar60TIMS(N'000000')YesRU_IERZ Allow NULL? 
34ISBDConfirmed date for 'Processing start'nvarchar80DATS(N'00000000')YesRU_ISBD Allow NULL? 
35ISBZConfirmed time for 'Processing start'nvarchar60TIMS(N'000000')YesRU_ISBZ Allow NULL? 
36IEBDConfirmed date for 'processing finish'nvarchar80DATS(N'00000000')YesRU_IEBD Allow NULL? 
37IEBZConfirmed time for 'processing finish'nvarchar60TIMS(N'000000')YesRU_IEBZ Allow NULL? 
38ISADConfirmed date for 'teardown start'nvarchar80DATS(N'00000000')YesRU_ISAD Allow NULL? 
39ISAZConfirmed time for 'teardown start'nvarchar60TIMS(N'000000')YesRU_ISAZ Allow NULL? 
40IEDDConfirmed date for execution finishnvarchar80DATS(N'00000000')YesRU_IEDD Allow NULL? 
41IEDZConfirmed time for 'Execution finish'nvarchar60TIMS(N'000000')YesRU_IEDZ Allow NULL? 
42PEDDForecast finish date of operation from confirmationnvarchar80DATS(N'00000000')YesCO_PEDD Allow NULL? 
43PEDZForecast finish time of operation from confirmationnvarchar60TIMS(N'000000')YesCO_PEDZ Allow NULL? 
44WERKSPlantnvarchar40CHAR(N' ')Yes*WERKS_D Allow NULL? 
45ARBPLWork centernvarchar80CHAR(N' ')YesARBPL Allow NULL? 
46SATZARecord type for confirmationnvarchar30CHAR(N' ')YesCO_SATZA Allow NULL? 
47ILE01Unit of measure for the activity to be confirmednvarchar30UNIT(N' ')Yes*CO_ISMNGEH Allow NULL? 
48ISM01Activity Currently to be Confirmeddecimal133QUAN((0))YesRU_ISMNG
49LEK01Indicator: No remaining activity expectedchar10CHAR(N' ')YesCO_LEIKZ Allow NULL? 
50ILE02Unit of measure for the activity to be confirmednvarchar30UNIT(N' ')Yes*CO_ISMNGEH Allow NULL? 
51ISM02Activity Currently to be Confirmeddecimal133QUAN((0))YesRU_ISMNG
52LEK02Indicator: No remaining activity expectedchar10CHAR(N' ')YesCO_LEIKZ Allow NULL? 
53ILE03Unit of measure for the activity to be confirmednvarchar30UNIT(N' ')Yes*CO_ISMNGEH Allow NULL? 
54ISM03Activity Currently to be Confirmeddecimal133QUAN((0))YesRU_ISMNG
55LEK03Indicator: No remaining activity expectedchar10CHAR(N' ')YesCO_LEIKZ Allow NULL? 
56ILE04Unit of measure for the activity to be confirmednvarchar30UNIT(N' ')Yes*CO_ISMNGEH Allow NULL? 
57ISM04Activity Currently to be Confirmeddecimal133QUAN((0))YesRU_ISMNG
58LEK04Indicator: No remaining activity expectedchar10CHAR(N' ')YesCO_LEIKZ Allow NULL? 
59ILE05Unit of measure for the activity to be confirmednvarchar30UNIT(N' ')Yes*CO_ISMNGEH Allow NULL? 
60ISM05Activity Currently to be Confirmeddecimal133QUAN((0))YesRU_ISMNG
61LEK05Indicator: No remaining activity expectedchar10CHAR(N' ')YesCO_LEIKZ Allow NULL? 
62ILE06Unit of measure for the activity to be confirmednvarchar30UNIT(N' ')Yes*CO_ISMNGEH Allow NULL? 
63ISM06Activity Currently to be Confirmeddecimal133QUAN((0))YesRU_ISMNG
64LEK06Indicator: No remaining activity expectedchar10CHAR(N' ')YesCO_LEIKZ Allow NULL? 
65IPRZ1Current quantity to be confirmed for the business processdecimal133QUAN((0))YesRU_IPRZS
66IPRE1Unit of measurement for conf. quantity for business processnvarchar30UNIT(N' ')Yes*RU_IPRZE Allow NULL? 
67IPRK1No remaining quantity expected for business processchar10CHAR(N' ')YesRU_IPRZK Allow NULL? 
68ABARBConfirmation: Degree of processingnvarchar30NUMC(N'000')YesCO_ABARB Allow NULL? 
69OFE01Unit of measure for the standard valuenvarchar30UNIT(N' ')Yes*VGWRTEH Allow NULL? 
70OFM01Forecast value used to update the standard valuedecimal93QUAN((0))YesCO_SCHAETZ
71OFE02Unit of measure for the standard valuenvarchar30UNIT(N' ')Yes*VGWRTEH Allow NULL? 
72OFM02Forecast value used to update the standard valuedecimal93QUAN((0))YesCO_SCHAETZ
73OFE03Unit of measure for the standard valuenvarchar30UNIT(N' ')Yes*VGWRTEH Allow NULL? 
74OFM03Forecast value used to update the standard valuedecimal93QUAN((0))YesCO_SCHAETZ
75OFE04Unit of measure for the standard valuenvarchar30UNIT(N' ')Yes*VGWRTEH Allow NULL? 
76OFM04Forecast value used to update the standard valuedecimal93QUAN((0))YesCO_SCHAETZ
77OFE05Unit of measure for the standard valuenvarchar30UNIT(N' ')Yes*VGWRTEH Allow NULL? 
78OFM05Forecast value used to update the standard valuedecimal93QUAN((0))YesCO_SCHAETZ
79OFE06Unit of measure for the standard valuenvarchar30UNIT(N' ')Yes*VGWRTEH Allow NULL? 
80OFM06Forecast value used to update the standard valuedecimal93QUAN((0))YesCO_SCHAETZ
81OPRZ1Remaining quantity for business processdecimal133QUAN((0))YesOPRZ1
82OPRE1Unit for remaining quantity of business processnvarchar30UNIT(N' ')Yes*OPRE1 Allow NULL? 
83PERNRPersonnel numbernvarchar80NUMC(N'00000000')YesCO_PERNR Allow NULL? 
84ZAUSWTime Recording ID Numbernvarchar80NUMC(N'00000000')YesDZAUSW Allow NULL? 
85LOARTWage Typenvarchar40CHAR(N' ')YesLOHNART Allow NULL? 
86QUALFSuitabilitynvarchar20CHAR(N' ')Yes*QUALF Allow NULL? 
87ANZMANumber of employeesdecimal52DEC((0))YesANZMS
88LOGRPWage groupnvarchar30CHAR(N' ')Yes*LOHNGRP Allow NULL? 
89ZEIERUnit for the break timenvarchar30UNIT(N' ')Yes*DZEIER Allow NULL? 
90ISERHConfirmed break timedecimal93QUAN((0))YesISERH
91SLK01Indicator: Determine target activitychar10CHAR(N' ')YesRU_TARGET_ACTIVITY Allow NULL? 
92SLK02Indicator: Determine target activitychar10CHAR(N' ')YesRU_TARGET_ACTIVITY Allow NULL? 
93SLK03Indicator: Determine target activitychar10CHAR(N' ')YesRU_TARGET_ACTIVITY Allow NULL? 
94SLK04Indicator: Determine target activitychar10CHAR(N' ')YesRU_TARGET_ACTIVITY Allow NULL? 
95SLK05Indicator: Determine target activitychar10CHAR(N' ')YesRU_TARGET_ACTIVITY Allow NULL? 
96SLK06Indicator: Determine target activitychar10CHAR(N' ')YesRU_TARGET_ACTIVITY Allow NULL? 
97SPRK1Indicator: Determine target qty for business transactionchar10CHAR(N' ')YesRU_TARGET_BUS_PROC Allow NULL? 
98EXTIDExternal Key for Confirmation (for example, from PDC System)varbinary160RAWYesRU_EXTID
99LDATELogical Datenvarchar80DATS(N'00000000')YesLDATE Allow NULL? 
100LTIMELogical timenvarchar60TIMS(N'000000')YesLTIME Allow NULL? 
NamePrimaryUniqueTypeColumns
AFRP0~0YesYesCLUSTEREDCOUNTER, PDSNR, MANDT
AFRP0~RNoNoNONCLUSTEREDRUECK

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