FIEUD_GOODS_ITEM

SAFT-XML:PT:Goods Movement Line Items | #itemdata | Component: Country/Region-Specific Application Interface Objects
Column Name Description
MANDT FK Client
BUKRS FK Company Code
VBELN FK Delivery
MJAHR FK Material Document Year
POSNR Delivery Item
BLDAT Document Date in Document
DELV_NUM Reference Document Number
Column Name Description
💲 Currency Key (WAERS):
UNITPRICE Net Price
DEBITAMOUNT 9(17)-character value field with 2 decimal places
CREDITAMOUNT 9(17)-character value field with 2 decimal places
SETTLEAMOUNT 9(17)-character value field with 2 decimal places
UNITPRICE_NEW Currency Field with 4 Decimal Places (Obsolete)
UNITPRICE_EXT Currency Field with 12 Decimal Places
DEBITAMOUNT_EXT Currency Field with 12 Decimal Places
CREDITAMOUNT_EXT Currency Field with 12 Decimal Places
IECAMOUNT Currency Field with 12 Decimal Places
Column Name Description
📏 Sales unit (UOM):
QUANTITY Cumulative batch quantity of all split items (in StckUnit)
Column Name Description
BLDAT Document Date in Document
Column Name Description
Column Name Description Domain name
LINENUM Item in Material Document MBLPO
ORDREF Reference Document Number XBLNR_LIKP
ORDERDATE Order date CHAR20
PRODUCTID SAF-T: Product ID
PRODUCT_DESC Short text for sales order item TEXT40
DESCRIPTION Short text for sales order item TEXT40
TAXTYPE Tax Type TEXT3
TAXREGION Country/Region PT_REGION
TAXRATE Rate (condition amount or percentage) CHAR16
TAXREASON Tax Exemption Reason EXEMPTREASON
TAXCODE_OFFICIA Official Tax Code
PRODUCT_SERNO SAFT : Product Serial Number
TAXEXEMPTIONCODE SAFT : Tax Exemption code
ARCNO SAFT : ARC Number TEXT21
Master Data Relations Join Conditions
Company Code
  • FIEUD_GOODS_ITEM.MANDT == T001.MANDT
  • FIEUD_GOODS_ITEM.BUKRS == T001.BUKRS
Client FIEUD_GOODS_ITEM.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • FIEUD_GOODS_ITEM.PRODUCT == MARA.MATNR
  • FIEUD_GOODS_ITEM.MANDT == MARA.MANDT
Tax on sales/purchases code
  • ?
  • Tax on sales/purchases code
  • FIEUD_GOODS_ITEM.MANDT == T007A.MANDT
  • FIEUD_GOODS_ITEM.[column in domain "KALSM_D"] == T007A.KALSM
  • FIEUD_GOODS_ITEM.TAXCODE == T007A.MWSKZ
Sales unit
  • FIEUD_GOODS_ITEM.MANDT == T006.MANDT
  • FIEUD_GOODS_ITEM.UOM == T006.MSEHI
Currency Key
  • FIEUD_GOODS_ITEM.MANDT == TCURC.MANDT
  • FIEUD_GOODS_ITEM.WAERS == TCURC.WAERS
Plant
  • FIEUD_GOODS_ITEM.MANDT == T001W.MANDT
  • FIEUD_GOODS_ITEM.WERKS == T001W.WERKS