I_ExcessRqmtQtySTOItm

Excess Requirement Quantity per Stock Transport Order Item | view: IEXRQMTSTOITM | TRAN | Extraction: Not supported | Component: Cross Application Functionality
Tables used: EKKO, EKPO, EKKO, EKPO, EKPV, EKET, ARUN_BDBS, KNA1, KNVV, MARC, MARA, LFA1
Column Name Description
PurchaseOrder FK Stock Transport Order
PurchaseOrderItem Stock Transport Order Item
PurchaseOrderItemUniqueID Concatenation of EBELN and EBELP
Column Name Description
💲 Currency Key (DocumentCurrency):
NetPriceAmount Net Price in Purchasing Document (in Document Currency)
Column Name Description
OrderQuantity Purchase Order Quantity
RequestedQuantityInBaseUnit null
ConfirmedRqmtQtyInBaseUnit null
DeliveredQuantityInBaseUnit null
AssignedQuantityInBaseUnit null
OpenForConfQtyInBaseUnit null
OpenForAssignmentQtyInBsUnt null
OpenForDeliveryQtyInBsUnt null
OpenForConfReqdQtyRatioPct null
OpenForAssgmtReqdQtyRatioPct null
OpenForDeliveryReqdQtyRatioPct null
Column Name Description
CreationDate Creation Date of Purchasing Document
RequestedDeliveryDate null
Column Name Description
RqmtIsSupAssgmtRelevant Supply Assignment (ARun) Show values
ProductCategory Material Category Show values
Column Name Description Domain name
RequirementDocumentItem null
FormattedPurchaseOrderItem Purchase Order Item
DocumentItemConcatenatedID Purchase Order Item
CreatedByUser User of person who created a purchasing document USNAM
ProdCharc1InternalNumber Internal Charactieristic Number for Color Characteristics ATINN
ProdCharc2InternalNumber Internal Char. Number for Characteristics for Main Sizes ATINN
ProdCharc3InternalNumber Internal Char. Number for Characteristics for Second Sizes ATINN
RequirementSegment Requirement Segment SGT_SRCA
OrderItemQtyToBaseQtyNmrtr Numerator for Conversion of Order Unit to Base Unit UMBSZ
OrderItemQtyToBaseQtyDnmntr Denominator for Conversion of Order Unit to Base Unit UMBSN
ProductSeasonYear Season Year FSH_CJAHR
ProductSeason Season RFM_SAISO
ProductCollection Fashion Collection FSH_COLLECTION
ProductTheme Fashion Theme FSH_THEME
ProductCharacteristic1 Characteristic Value 1 WRF_CHARSTC
ProductCharacteristic2 Characteristic Value 2 WRF_CHARSTC
ProductCharacteristic3 Characteristic Value 3 WRF_CHARSTC
Batch null
Master Data Relations Join Conditions
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • I_EXCESSRQMTQTYSTOITM.BASEUNIT == T006.MSEHI
  • I_EXCESSRQMTQTYSTOITM.MANDT == T006.MANDT
Company Code
  • Company Code
  • Client
  • I_EXCESSRQMTQTYSTOITM.COMPANYCODE == T001.BUKRS
  • I_EXCESSRQMTQTYSTOITM.MANDT == T001.MANDT
Cross-Plant Configurable Material
  • Cross-Plant Configurable Material
  • Client
  • I_EXCESSRQMTQTYSTOITM.CROSSPLANTCONFIGURABLEPRODUCT == MARA.MATNR
  • I_EXCESSRQMTQTYSTOITM.MANDT == MARA.MANDT
Customer
  • Customer Number
  • Customer
  • Client
  • I_EXCESSRQMTQTYSTOITM.SHIPTOPARTY == KNA1.KUNNR
  • I_EXCESSRQMTQTYSTOITM.CUSTOMER == KNA1.KUNNR
  • I_EXCESSRQMTQTYSTOITM.MANDT == KNA1.MANDT
Delivery Priority
  • Delivery Priority
  • Client
  • I_EXCESSRQMTQTYSTOITM.DELIVERYPRIORITY == TPRIO.LPRIO
  • I_EXCESSRQMTQTYSTOITM.MANDT == TPRIO.MANDT
Distribution Channel
  • Distribution Channel
  • Client
  • I_EXCESSRQMTQTYSTOITM.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • I_EXCESSRQMTQTYSTOITM.MANDT == TVTW.MANDT
Currency Key
  • Currency Key
  • Client
  • I_EXCESSRQMTQTYSTOITM.DOCUMENTCURRENCY == TCURC.WAERS
  • I_EXCESSRQMTQTYSTOITM.MANDT == TCURC.MANDT
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • I_EXCESSRQMTQTYSTOITM.INCOTERMSCLASSIFICATION == TINC.INCO1
  • I_EXCESSRQMTQTYSTOITM.MANDT == TINC.MANDT
Material Number
  • Material Number
  • Client
  • I_EXCESSRQMTQTYSTOITM.MATERIAL == MARA.MATNR
  • I_EXCESSRQMTQTYSTOITM.MANDT == MARA.MANDT
Material Group
  • Material Group
  • Client
  • I_EXCESSRQMTQTYSTOITM.MATERIALGROUP == T023.MATKL
  • I_EXCESSRQMTQTYSTOITM.MANDT == T023.MANDT
Division
  • Client
  • Division
  • I_EXCESSRQMTQTYSTOITM.MANDT == TSPA.MANDT
  • I_EXCESSRQMTQTYSTOITM.ORGANIZATIONDIVISION == TSPA.SPART
Purchase Order Type
  • ?
  • Purchase Order Type
  • Client
  • I_EXCESSRQMTQTYSTOITM.[column in domain "BSTYP"] == T161.BSTYP
  • I_EXCESSRQMTQTYSTOITM.PURCHASEORDERTYPE == T161.BSART
  • I_EXCESSRQMTQTYSTOITM.MANDT == T161.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • I_EXCESSRQMTQTYSTOITM.PURCHASINGGROUP == T024.EKGRP
  • I_EXCESSRQMTQTYSTOITM.MANDT == T024.MANDT
Reason for Ordering
  • Reason for Ordering
  • Client
  • I_EXCESSRQMTQTYSTOITM.PURCHASINGORDERREASON == TBSG.BSGRU
  • I_EXCESSRQMTQTYSTOITM.MANDT == TBSG.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • I_EXCESSRQMTQTYSTOITM.PURCHASINGORGANIZATION == T024E.EKORG
  • I_EXCESSRQMTQTYSTOITM.MANDT == T024E.MANDT
Plant
  • Client
  • Plant
  • I_EXCESSRQMTQTYSTOITM.MANDT == T001W.MANDT
  • I_EXCESSRQMTQTYSTOITM.RECEIVINGPLANT == T001W.WERKS
Storage Location
  • Storage Location
  • Client
  • Plant
  • I_EXCESSRQMTQTYSTOITM.RECEIVINGSTORAGELOCATION == T001L.LGORT
  • I_EXCESSRQMTQTYSTOITM.MANDT == T001L.MANDT
  • I_EXCESSRQMTQTYSTOITM.RECEIVINGPLANT == T001L.WERKS
Sales District
  • Sales District
  • Client
  • I_EXCESSRQMTQTYSTOITM.SALESDISTRICT == T171.BZIRK
  • I_EXCESSRQMTQTYSTOITM.MANDT == T171.MANDT
Sales Organization
  • Client
  • Sales Organization
  • I_EXCESSRQMTQTYSTOITM.MANDT == TVKO.MANDT
  • I_EXCESSRQMTQTYSTOITM.SALESORGANIZATION == TVKO.VKORG
Shipping Point / Receiving Point
  • Client
  • Shipping Point / Receiving Point
  • I_EXCESSRQMTQTYSTOITM.MANDT == TVST.MANDT
  • I_EXCESSRQMTQTYSTOITM.SHIPPINGPOINT == TVST.VSTEL
Customer Number
  • Customer Number
  • Customer
  • Client
  • I_EXCESSRQMTQTYSTOITM.SHIPTOPARTY == KNA1.KUNNR
  • I_EXCESSRQMTQTYSTOITM.CUSTOMER == KNA1.KUNNR
  • I_EXCESSRQMTQTYSTOITM.MANDT == KNA1.MANDT
Sold-to Party
  • Sold-to Party
  • Client
  • I_EXCESSRQMTQTYSTOITM.SOLDTOPARTY == KNA1.KUNNR
  • I_EXCESSRQMTQTYSTOITM.MANDT == KNA1.MANDT
Supplying (issuing) plant in case of stock transport order
  • Supplying (issuing) plant in case of stock transport order
  • Client
  • I_EXCESSRQMTQTYSTOITM.SUPPLYINGPLANT == T001W.WERKS
  • I_EXCESSRQMTQTYSTOITM.MANDT == T001W.MANDT