IFW_ITEM

Invoice forecasting item | #transactional | Component: Invoice Forecasting
Column Name Description
CLIENT FK Client
ROOT_DOC_TYPE FK Source Document Type Show values
ROOT_DOC FK Source Document
ROOT_DOC_ITEM Source Document Item
INV_TYPE FK Invoice Reference Type Show values
INV_NR FK 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 for Basic Net Price
💲 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
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 Provisional Invoice Due Date
INV_DUE_DATE_FIN Final Invoice Due Date
PAY_DUE_DATE_PRO Payment Due Date
PAY_DUE_DATE_FIN Payment Due Date
Column Name Description
INV_CAT Invoice Category Show values
BILL_SCEN SD Billing Scenario Show values
ITEM_CANCELLED Item Cancelled Show values
REF_TYPE Type of Invoice Reference Object Show values
PAYDD_DET_PRO Payment Due Date Control Show values
PAYDD_DET_FIN Payment Due Date Control Show values
INVDD_DET_FIN Invoice due date control Show values
OUTDATED Invoice Data Obsolete Show values
Column Name Description Domain name
BILL_BLOCK Billing: Blocking Reason for Document Items IFW_DO_BILL_BLOCK
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
Master Data Relations Join Conditions
Client IFW_ITEM.CLIENT == T000.MANDT