0IFW_INVOICE

IFW Invoice forecast data | #TRAN | Extraction method: F1 | Delta: NEWE | Component: Agency Business
Column Name Description
ROOT_DOC_TYPE Source Document Type Show values
ROOT_DOC Source Document
ROOT_DOC_ITEM Source Document Item
INV_TYPE Invoice Reference Type Show values
INV_NR Invoice Reference Number
INV_ITEM Invoice Item
Column Name Description
💲 SD Document Currency (DOC_CUKY):
NET_VAL Net Value in Document Currency
TAX_VAL Tax Amount in Document Currency
💲 Condition Currency (for Cumulation Fields) (PRCUR):
PRICE Condition Value
💲 Currency of Net Price for Source Document Item (PRCUR_RD):
PRICE_RD Net Price of Source Document Item
Column Name Description
📏 Base Unit of Measure (MEINS):
QUANTITY Actual billed quantity
Column Name Description
LAST_CALC Date of Last Invoice Forecast
FKDAT Billing Date
INV_DUE_DATE Invoice Due Date
PAY_DUE_DATE Payment Due Date
PR_START_DATE Pricing Start Date
PR_END_DATE Pricing End Date
FX_START_DATE Foreign Exchange Rate Start Date
FX_END_DATE Foreign Exchange Rate End Date
INV_DUE_DATE_PRO Invoice Due Date
INV_DUE_DATE_FIN Invoice Due Date
PAY_DUE_DATE_PRO Payment Due Date
PAY_DUE_DATE_FIN Payment Due Date
Column Name Description
ROOT_DOC_TYPE Source Document Type Show values
INV_TYPE Invoice Reference Type Show values
WL_STATUS Status of Record in Invoice Forecasting Worklist Show values
CANCELLED Billing document is canceled Show values
PRED_INV_TYPE Invoice Reference Type Show values
OUTDATED Invoice Data Obsolete Show values
INV_CAT Invoice Category Show values
ITEM_CANCELLED Item Cancelled Show values
REF_TYPE Type of Invoice Reference Object Show values
Column Name Description Domain name
BUKRS Company Code BUKRS
EKORG Purchasing organization EKORG
EKGRP Purchasing Group EKGRP
VKORG Sales Organization VKORG
VTWEG Distribution Channel VTWEG
SPART Division SPART
KUNAG Sold-to Party KUNNR
LIFNR Account Number of Supplier LIFNR
XBLNR Reference Document Number IFW_DO_XBLNR
BILL_TYPE Billing Document Type IFW_DO_BILL_TYPE
PRED_INV_NR Invoice Reference Number IFW_DO_INV_NR
PAIR_ITEM Pair item (Negative of item from predecessor invoice) POSNR
REF_OBJ Invoice Reference Object IFW_DO_REF_OBJ
FX_RATE Exchange rate KURSF
PR_CONDTYPE Condition Type KSCHL
PR_STATUS Status of Evaluation for Pricing NUMC2
PRUNI Condition Pricing Unit KPEIN
PRUNI_RD Price Unit of Net Price for Source Document Item DEC5
WERKS Plant WERKS
MATNR Material Number MATNR
TIMESTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS