I_ExciseTaxMatlDocItem

MatlDocItem for Industry Extensions | view: IET_MATLDOCITM | Extraction: Not supported | Component: Excise Tax S/4 Integration
Tables used: VBAPLIKPLIPSAFKOMATDOCAFPOEKKOEKBEEKPOEKBEHVBKDVEDAVBAKVBAKVBAPVBKDVEDAEKKOEKPOT001TKA02KNA1T156AUFKTPAREKPAT001LLFA1
Column Name Description
MaterialDocument Number of Material Document
MaterialDocumentYear Material Document Year
MaterialDocumentItem Material Document Item
Column Name Description
Column Name Description
📏 Unit of entry (EntryUnit):
QuantityInEntryUnit Quantity in unit of entry
📏 Base Unit of Measure (MaterialBaseUnit):
QuantityInBaseUnit Quantity
Column Name Description
PostingDate Posting Date in the Document
DocumentDate Document Date in Document
CreationDate Day On Which Accounting Document Was Entered
CreationTime Time of Entry
Column Name Description
IsReversalMovementType Reversal movement type Show values
GoodsMovementRefDocType Goods movement ref doc type Show values
DebitCreditCode Debit/Credit Indicator Show values
IsAutomaticallyCreated Item Automatically Created Indicator Show values
OrderCategory Manufacturing Order Category Show values
PurchaseOrderSubtype Control indicator for purchasing document type Show values
PurchaseOrderCategory Purchasing Document Category Show values
IsStorLocAuthznCheckActive Storage location authorization for goods movements active Show values
IsIssgOrRcvgStorLocAuthChkActv Storage location authorization for goods movements active Show values
Column Name Description Domain name
CompanyCode Company Code BUKRS
Plant Plant WERKS
StorageLocation Storage location LGORT
CostCenter Cost Center KOSTL
Material Material Number MATNR
Batch Batch Number CHARG
GoodsMovementType Movement type (inventory management) BWART
GoodsMovementReasonCode Reason for Movement MB_GRBEW
Supplier Vendor's account number LIFNR
Customer Account number of customer KUNNR
GoodsRecipientName null
IssuingOrReceivingPlant Transfer Plant WERKS
IssuingOrReceivingStorageLoc Receiving/issuing storage location LGORT
IssgOrRcvgMaterial Transfer Material MATNR
IssgOrRcvgBatch Transfer Batch CHARG
OriginalMaterialDocumentItem Original line in material document MBLPO
ReferenceDocument Reference Document Number XBLNR1
ReversedMaterialDocument Reversed Material Document BELNR
ReversedMaterialDocumentItem Reversed Material Document Item MBLPO
ReversedMaterialDocumentYear Reversed Material Document Year GJAHR
DeliveryDocument Delivery VBELN
DeliveryDocumentItem Delivery Document Item POSNR
PurchaseOrder Purchase order number EBELN
PurchaseOrderItem Item Number of Purchasing Document EBELP
SalesOrder Sales Order Number VBELN
SalesOrderItem Sales Order Item POSNR
OrderID Order Number AUFNR
OrderItem Order Item CO_POSNR
SalesOrderType null
SalesDocumentItemCategory Sales document item category PSTYV
SupplierAuthznGrp Authorization Group BRGRU
CustomerAuthznGrp Authorization Group BRGRU
Master Data Relations Join Conditions
Manufacturing Order Type
  • Manufacturing Order Type
  • Client
  • I_EXCISETAXMATLDOCITEM.ORDERTYPE == T003O.AUART
  • I_EXCISETAXMATLDOCITEM.MANDT == T003O.CLIENT
Item category in purchasing document
  • Item category in purchasing document
  • Client
  • I_EXCISETAXMATLDOCITEM.PURCHASEORDERITEMCATEGORY == T163.PSTYP
  • I_EXCISETAXMATLDOCITEM.MANDT == T163.MANDT
Purchase Order Type
  • Purchasing Document Category
  • Purchase Order Type
  • Client
  • I_EXCISETAXMATLDOCITEM.PURCHASEORDERCATEGORY == T161.BSTYP
  • I_EXCISETAXMATLDOCITEM.PURCHASEORDERTYPE == T161.BSART
  • I_EXCISETAXMATLDOCITEM.MANDT == T161.MANDT
Supplying (issuing) plant in case of stock transport order
  • Supplying (issuing) plant in case of stock transport order
  • Client
  • I_EXCISETAXMATLDOCITEM.SUPPLYINGPLANT == T001W.WERKS
  • I_EXCISETAXMATLDOCITEM.MANDT == T001W.MANDT
Account Number of Supplier
  • Account Number of Supplier
  • Client
  • I_EXCISETAXMATLDOCITEM.SUPPLYINGSUPPLIER == LFA1.LIFNR
  • I_EXCISETAXMATLDOCITEM.MANDT == LFA1.MANDT