I_ExcessRqmtQtySlsContrItm

Excess Requirement Quantity per Sales Contract Item | view: IEXRQMTCONTITM | TRAN | Extraction: Not supported | Component: Cross Application Functionality
Tables used: VBAP, VBAK, VBAK, VBAP, VBKD, VBPA, VBKD, VEDA, VBAK, VBAK, VBAP, VBKD, VEDA, VBEP, VBFA, ARUN_BDBS, KNA1, TVEP, MARC, TVAK, MARA
Column Name Description
SalesDocument FK Sales Document
SalesDocumentItem Sales Document Item
SalesDocumentItemUUID GUID in 'CHAR' Format in Uppercase
Column Name Description
💲 SD Document Currency (TransactionCurrency):
NetPriceAmount Net Price
Column Name Description
RequestedQuantityInBaseUnit null
ConfirmedRqmtQtyInBaseUnit null
AssignedQuantityInBaseUnit null
OpenForConfQtyInBaseUnit null
OpenForAssignmentQtyInBsUnt null
OpenContrRefQtyInBsUnt null
ContractItmCnsmdQtyInBsUnt null
OpenForConfReqdQtyRatioPct null
OpenForAssgmtReqdQtyRatioPct null
OpenContrRefReqdQtyRatioPct null
Column Name Description
CreationDate Date on which the record was created
RequestedDeliveryDate null
FashionCancelDate Cancellation Date
Column Name Description
SDDocumentCategory SD Document Category Show values
TotalCreditCheckStatus Overall Status of Credit Checks Show values
ItemGeneralIncompletionStatus Incompletion Status (Item) Show values
ItemBillingIncompletionStatus Billing Incompletion Status (Item) Show values
ItemDeliveryIncompletionStatus Delivery Incompletion Status (Item) Show values
RqmtIsSupAssgmtRelevant Supply Assignment (ARun) Show values
Column Name Description Domain name
FormattedSalesDocumentItem Sales Document Item CHAR17
DocumentItemConcatenatedID Sales Document Item CHAR17
CreatedByUser Name of Person Responsible for Creating the Object USNAM
Plant Plant (Own or External) WERKS
RequirementSegment Requirement Segment SGT_SRCA
OrderToBaseQuantityNmrtr Numerator (factor) for conversion of sales quantity into SKU UMBSZ
OrderToBaseQuantityDnmntr Denominator (divisor) for conversion of sales Qty into SKU UMBSN
ProductCharacteristic1 Characteristic Value 1 WRF_CHARSTC
ProductCharacteristic2 Characteristic Value 2 WRF_CHARSTC
ProductCharacteristic3 Characteristic Value 3 WRF_CHARSTC
CustomerPaymentTerms Terms of payment key ZTERM
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
Master Data Relations Join Conditions
Material Group 1
  • Material Group 1
  • Client
  • I_EXCESSRQMTQTYSLSCONTRITM.ADDITIONALMATERIALGROUP1 == TVM1.MVGR1
  • I_EXCESSRQMTQTYSLSCONTRITM.MANDT == TVM1.MANDT
Material Group 2
  • Material Group 2
  • Client
  • I_EXCESSRQMTQTYSLSCONTRITM.ADDITIONALMATERIALGROUP2 == TVM2.MVGR2
  • I_EXCESSRQMTQTYSLSCONTRITM.MANDT == TVM2.MANDT
Material Group 3
  • Material Group 3
  • Client
  • I_EXCESSRQMTQTYSLSCONTRITM.ADDITIONALMATERIALGROUP3 == TVM3.MVGR3
  • I_EXCESSRQMTQTYSLSCONTRITM.MANDT == TVM3.MANDT
Material Group 4
  • Client
  • Material Group 4
  • I_EXCESSRQMTQTYSLSCONTRITM.MANDT == TVM4.MANDT
  • I_EXCESSRQMTQTYSLSCONTRITM.ADDITIONALMATERIALGROUP4 == TVM4.MVGR4
Material Group 5
  • Client
  • Material Group 5
  • I_EXCESSRQMTQTYSLSCONTRITM.MANDT == TVM5.MANDT
  • I_EXCESSRQMTQTYSLSCONTRITM.ADDITIONALMATERIALGROUP5 == TVM5.MVGR5
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • I_EXCESSRQMTQTYSLSCONTRITM.BASEUNIT == T006.MSEHI
  • I_EXCESSRQMTQTYSLSCONTRITM.MANDT == T006.MANDT
Batch Number
  • Batch Number
  • Plant (Own or External)
  • Material Number
  • Client
  • I_EXCESSRQMTQTYSLSCONTRITM.BATCH == MCHA.CHARG
  • I_EXCESSRQMTQTYSLSCONTRITM.PLANT == MCHA.WERKS
  • I_EXCESSRQMTQTYSLSCONTRITM.MATERIAL == MCHA.MATNR
  • I_EXCESSRQMTQTYSLSCONTRITM.MANDT == MCHA.MANDT
Company Code to Be Billed
  • Company Code to Be Billed
  • Client
  • I_EXCESSRQMTQTYSLSCONTRITM.BILLINGCOMPANYCODE == T001.BUKRS
  • I_EXCESSRQMTQTYSLSCONTRITM.MANDT == T001.MANDT
Cross-Plant Configurable Material
  • Cross-Plant Configurable Material
  • Client
  • I_EXCESSRQMTQTYSLSCONTRITM.CROSSPLANTCONFIGURABLEPRODUCT == MARA.MATNR
  • I_EXCESSRQMTQTYSLSCONTRITM.MANDT == MARA.MANDT
Customer Group
  • Customer Group
  • Client
  • I_EXCESSRQMTQTYSLSCONTRITM.CUSTOMERGROUP == T151.KDGRP
  • I_EXCESSRQMTQTYSLSCONTRITM.MANDT == T151.MANDT
Delivery Priority
  • Delivery Priority
  • Client
  • I_EXCESSRQMTQTYSLSCONTRITM.DELIVERYPRIORITY == TPRIO.LPRIO
  • I_EXCESSRQMTQTYSLSCONTRITM.MANDT == TPRIO.MANDT
Distribution channel in order header
  • Distribution Channel
  • Client
  • Sales Organization
  • I_EXCESSRQMTQTYSLSCONTRITM.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • I_EXCESSRQMTQTYSLSCONTRITM.MANDT == TVKOV.MANDT
  • I_EXCESSRQMTQTYSLSCONTRITM.SALESORGANIZATION == TVKOV.VKORG
Division
  • Division
  • Division
  • Client
  • I_EXCESSRQMTQTYSLSCONTRITM.DIVISION == TSPA.SPART
  • I_EXCESSRQMTQTYSLSCONTRITM.ORGANIZATIONDIVISION == TSPA.SPART
  • I_EXCESSRQMTQTYSLSCONTRITM.MANDT == TSPA.MANDT
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • I_EXCESSRQMTQTYSLSCONTRITM.INCOTERMSCLASSIFICATION == TINC.INCO1
  • I_EXCESSRQMTQTYSLSCONTRITM.MANDT == TINC.MANDT
Material: order item
  • Material Number
  • Client
  • I_EXCESSRQMTQTYSLSCONTRITM.MATERIAL == MARA.MATNR
  • I_EXCESSRQMTQTYSLSCONTRITM.MANDT == MARA.MANDT
Material Group
  • Material Group
  • Client
  • I_EXCESSRQMTQTYSLSCONTRITM.MATERIALGROUP == T023.MATKL
  • I_EXCESSRQMTQTYSLSCONTRITM.MANDT == T023.MANDT
Division in order header
  • Distribution Channel
  • Division
  • Division
  • Client
  • Sales Organization
  • I_EXCESSRQMTQTYSLSCONTRITM.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • I_EXCESSRQMTQTYSLSCONTRITM.DIVISION == TVTA.SPART
  • I_EXCESSRQMTQTYSLSCONTRITM.ORGANIZATIONDIVISION == TVTA.SPART
  • I_EXCESSRQMTQTYSLSCONTRITM.MANDT == TVTA.MANDT
  • I_EXCESSRQMTQTYSLSCONTRITM.SALESORGANIZATION == TVTA.VKORG
Fashion Collection
  • Season
  • Fashion Collection
  • Season Year
  • Client
Season
  • Season
  • Season Year
  • Client
  • I_EXCESSRQMTQTYSLSCONTRITM.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON
  • I_EXCESSRQMTQTYSLSCONTRITM.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR
  • I_EXCESSRQMTQTYSLSCONTRITM.MANDT == FSH_SEASONS.MANDT
Season Year
  • Season
  • Season Year
  • Client
  • I_EXCESSRQMTQTYSLSCONTRITM.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON
  • I_EXCESSRQMTQTYSLSCONTRITM.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR
  • I_EXCESSRQMTQTYSLSCONTRITM.MANDT == FSH_SEASONS.MANDT
Fashion Theme
  • Season
  • Fashion Theme
  • Fashion Collection
  • Season Year
  • Client
  • I_EXCESSRQMTQTYSLSCONTRITM.PRODUCTSEASON == FSH_THEMES.FSH_SEASON
  • I_EXCESSRQMTQTYSLSCONTRITM.PRODUCTTHEME == FSH_THEMES.FSH_THEME
  • I_EXCESSRQMTQTYSLSCONTRITM.PRODUCTCOLLECTION == FSH_THEMES.FSH_COLLECTION
  • I_EXCESSRQMTQTYSLSCONTRITM.PRODUCTSEASONYEAR == FSH_THEMES.FSH_SEASON_YEAR
  • I_EXCESSRQMTQTYSLSCONTRITM.MANDT == FSH_THEMES.MANDT
Sales District
  • Sales District
  • Client
  • I_EXCESSRQMTQTYSLSCONTRITM.SALESDISTRICT == T171.BZIRK
  • I_EXCESSRQMTQTYSLSCONTRITM.MANDT == T171.MANDT
Sales document item category
  • Sales document item category
  • Client
  • I_EXCESSRQMTQTYSLSCONTRITM.SALESDOCUMENTITEMCATEGORY == TVPT.PSTYV
  • I_EXCESSRQMTQTYSLSCONTRITM.MANDT == TVPT.MANDT
Reason for Rejection of Sales Documents
  • Reason for Rejection of Sales Documents
  • Client
  • I_EXCESSRQMTQTYSLSCONTRITM.SALESDOCUMENTRJCNREASON == TVAG.ABGRU
  • I_EXCESSRQMTQTYSLSCONTRITM.MANDT == TVAG.MANDT
Order type in order header
  • Sales Document Type
  • Client
  • I_EXCESSRQMTQTYSLSCONTRITM.SALESDOCUMENTTYPE == TVAK.AUART
  • I_EXCESSRQMTQTYSLSCONTRITM.MANDT == TVAK.MANDT
Sales organization in order header
  • Client
  • Sales Organization
  • I_EXCESSRQMTQTYSLSCONTRITM.MANDT == TVKO.MANDT
  • I_EXCESSRQMTQTYSLSCONTRITM.SALESORGANIZATION == TVKO.VKORG
Order Reason (Reason for the Business Transaction)
  • Order Reason (Reason for the Business Transaction)
  • Client
  • I_EXCESSRQMTQTYSLSCONTRITM.SDDOCUMENTREASON == TVAU.AUGRU
  • I_EXCESSRQMTQTYSLSCONTRITM.MANDT == TVAU.MANDT
Shipping Point / Receiving Point
  • Shipping Point / Receiving Point
  • Client
  • I_EXCESSRQMTQTYSLSCONTRITM.SHIPPINGPOINT == TVST.VSTEL
  • I_EXCESSRQMTQTYSLSCONTRITM.MANDT == TVST.MANDT
Customer - Document Customer
  • Sold-to Party
  • Customer Number
  • Client
  • I_EXCESSRQMTQTYSLSCONTRITM.SOLDTOPARTY == KNA1.KUNNR
  • I_EXCESSRQMTQTYSLSCONTRITM.SHIPTOPARTY == KNA1.KUNNR
  • I_EXCESSRQMTQTYSLSCONTRITM.MANDT == KNA1.MANDT
Sold-to Party
  • Sold-to Party
  • Customer Number
  • Client
  • I_EXCESSRQMTQTYSLSCONTRITM.SOLDTOPARTY == KNA1.KUNNR
  • I_EXCESSRQMTQTYSLSCONTRITM.SHIPTOPARTY == KNA1.KUNNR
  • I_EXCESSRQMTQTYSLSCONTRITM.MANDT == KNA1.MANDT
Storage location
  • Plant (Own or External)
  • Storage location
  • Client
  • I_EXCESSRQMTQTYSLSCONTRITM.PLANT == T001L.WERKS
  • I_EXCESSRQMTQTYSLSCONTRITM.STORAGELOCATION == T001L.LGORT
  • I_EXCESSRQMTQTYSLSCONTRITM.MANDT == T001L.MANDT
SD Document Currency
  • SD Document Currency
  • Client
  • I_EXCESSRQMTQTYSLSCONTRITM.TRANSACTIONCURRENCY == TCURC.WAERS
  • I_EXCESSRQMTQTYSLSCONTRITM.MANDT == TCURC.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Sales office
  • Distribution Channel
  • Division
  • Division
  • Client
  • Sales Organization
  • I_EXCESSRQMTQTYSLSCONTRITM.SALESOFFICE == TVKBZ.VKBUR
  • I_EXCESSRQMTQTYSLSCONTRITM.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG
  • I_EXCESSRQMTQTYSLSCONTRITM.DIVISION == TVKBZ.SPART
  • I_EXCESSRQMTQTYSLSCONTRITM.ORGANIZATIONDIVISION == TVKBZ.SPART
  • I_EXCESSRQMTQTYSLSCONTRITM.MANDT == TVKBZ.MANDT
  • I_EXCESSRQMTQTYSLSCONTRITM.SALESORGANIZATION == TVKBZ.VKORG