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  | IFW_ITEM
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 :: Agency Business Global Trade :: Invoice Forecasting
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0IFW_ITEM451Invoice forecasting itemInvoice Forecasting
SQL:  selectupdate insert create

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

SELECT CLIENT, ROOT_DOC_TYPE, ROOT_DOC, ROOT_DOC_ITEM, INV_TYPE, INV_NR, INV_ITEM, INV_CAT, BILL_SCEN, BILL_BLOCK, PAIR_ITEM, ITEM_CANCELLED, REF_TYPE, REF_OBJ, NET_VAL, TAX_VAL, DOC_CUKY, FX_RATE, QUANTITY, MEINS, PR_CONDTYPE, PR_STATUS, PRICE, PRCUR, PRUNI, PRUOM, PR_START_DATE, PR_END_DATE, FX_START_DATE, FX_END_DATE, PRICE_RD, PRCUR_RD, PRUNI_RD, PRUOM_RD, WERKS, MATNR, INV_DUE_DATE_PRO, INV_DUE_DATE_FIN, PAY_DUE_DATE_PRO, PAYDD_DET_PRO, PAY_DUE_DATE_FIN, PAYDD_DET_FIN, INVDD_DET_FIN, OUTDATED, TIMESTAMP FROM IFW_ITEM
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1CLIENTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2ROOT_DOC_TYPESource Document Typenvarchar20CHAR(N' ')NoIFW_HEADERCIWB_DE_ROOT_DOC_TYPE Allow NULL? 
3ROOT_DOCSource Documentnvarchar200CHAR(N' ')NoIFW_HEADERIFW_DE_ROOT_DOC Allow NULL? 
4ROOT_DOC_ITEMSource Document Itemnvarchar60NUMC(N'000000')No*IFW_DE_ROOT_ITEM Allow NULL? 
5INV_TYPEInvoice Reference Typenvarchar20CHAR(N' ')NoIFW_HEADERIFW_DE_INV_TYPE Allow NULL? 
6INV_NRInvoice Reference Numbernvarchar160CHAR(N' ')NoIFW_HEADERIFW_DE_INV_NR Allow NULL? 
7INV_ITEMInvoice Itemnvarchar60NUMC(N'000000')No*IFW_DE_INV_ITEM Allow NULL? 
8INV_CATInvoice Categorychar10CHAR(N' ')YesIFW_DE_INV_CAT Allow NULL? 
9BILL_SCENSD Billing Scenariochar10CHAR(N' ')YesIFW_DE_BILL_SCEN Allow NULL? 
10BILL_BLOCKBilling: Blocking Reason for Document Itemsnvarchar20CHAR(N' ')YesIFW_DE_BILL_BLOCK Allow NULL? 
11PAIR_ITEMPair item (Negative of item from predecessor invoice)nvarchar60NUMC(N'000000')Yes*IFW_DE_INV_PAIR_ITEM Allow NULL? 
12ITEM_CANCELLEDItem Cancelledchar10CHAR(N' ')YesIFW_DE_ITEM_CANCELLED Allow NULL? 
13REF_TYPEType of Invoice Reference Objectnvarchar20CHAR(N' ')YesIFW_DE_REF_TYPE Allow NULL? 
14REF_OBJInvoice Reference Objectnvarchar160CHAR(N' ')YesIFW_DE_REF_OBJ Allow NULL? 
15NET_VALNet Value in Document Currencydecimal152CURR((0))YesNETWR
16TAX_VALTax amount in document currencydecimal132CURR((0))YesMWSBP
17DOC_CUKYSD Document Currencynvarchar50CUKY(N' ')Yes*WAERK Allow NULL? 
18FX_RATEExchange ratedecimal95DEC((0))YesKURSF
19QUANTITYActual Invoiced Quantitydecimal133QUAN((0))YesFKIMG
20MEINSBase Unit of Measurenvarchar30UNIT(N' ')Yes*MEINS Allow NULL? 
21PR_CONDTYPECondition Typenvarchar40CHAR(N' ')Yes*KSCHL Allow NULL? 
22PR_STATUSStatus of Evaluation for Pricingnvarchar20NUMC(N'00')YesIFW_DE_PR_STATUS Allow NULL? 
23PRICECondition Value for Basic Net Pricedecimal132CURR((0))YesIFW_DE_PRICE
24PRCURCondition currency (for cumulation fields)nvarchar50CUKY(N' ')Yes*KWAEH Allow NULL? 
25PRUNICondition pricing unitdecimal50DEC((0))YesKPEIN
26PRUOMCondition unit in the documentnvarchar30UNIT(N' ')Yes*KVMEI Allow NULL? 
27PR_START_DATEPricing Start Datenvarchar80DATS(N'00000000')YesIFW_DE_PR_START_DATE Allow NULL? 
28PR_END_DATEPricing End Datenvarchar80DATS(N'00000000')YesIFW_DE_PR_END_DATE Allow NULL? 
29FX_START_DATEForeign Exchange Rate Start Datenvarchar80DATS(N'00000000')YesIFW_DE_FX_START_DATE Allow NULL? 
30FX_END_DATEForeign Exchange Rate End Datenvarchar80DATS(N'00000000')YesIFW_DE_FX_END_DATE Allow NULL? 
31PRICE_RDNet Price of Source Document Itemdecimal112CURR((0))YesIFW_DE_PRICE_RD
32PRCUR_RDCurrency of Net Price for Source Document Itemnvarchar50CUKY(N' ')Yes*IFW_DE_PRCUR_RD Allow NULL? 
33PRUNI_RDPrice Unit of Net Price for Source Document Itemdecimal50DEC((0))YesIFW_DE_PRUNI_RD
34PRUOM_RDUnit of Measure of Net Price for Source Document Itemnvarchar30UNIT(N' ')Yes*IFW_DE_PRUOM_RD Allow NULL? 
35WERKSPlantnvarchar40CHAR(N' ')Yes*WERKS_D Allow NULL? 
36MATNRMaterial Numbernvarchar180CHAR(N' ')Yes*MATNR Allow NULL? 
37INV_DUE_DATE_PROProvisional Invoice Due Datenvarchar80DATS(N'00000000')YesIFW_DE_INV_DATE_PRO Allow NULL? 
38INV_DUE_DATE_FINFinal Invoice Due Datenvarchar80DATS(N'00000000')YesIFW_DE_INV_DATE_FIN Allow NULL? 
39PAY_DUE_DATE_PROPayment Due Datenvarchar80DATS(N'00000000')YesIFW_DE_PAY_DATE Allow NULL? 
40PAYDD_DET_PROPayment Due Date Controlchar10CHAR(N' ')YesIFW_DE_PAYDD_DET Allow NULL? 
41PAY_DUE_DATE_FINPayment Due Datenvarchar80DATS(N'00000000')YesIFW_DE_PAY_DATE Allow NULL? 
42PAYDD_DET_FINPayment Due Date Controlchar10CHAR(N' ')YesIFW_DE_PAYDD_DET Allow NULL? 
43INVDD_DET_FINInvoice due date controlchar10CHAR(N' ')YesIFW_DE_INVDD_DET Allow NULL? 
44OUTDATEDInvoice Data Obsoletechar10CHAR(N' ')YesIFW_DE_OUTDATED Allow NULL? 
45TIMESTAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150DEC((0))YesTIMESTAMP
NamePrimaryUniqueTypeColumns
IFW_ITEM~0YesYesCLUSTEREDINV_ITEM, INV_NR, INV_TYPE, ROOT_DOC_ITEM, ROOT_DOC, ROOT_DOC_TYPE, CLIENT

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