I_ExcessRqmtQtyAcctAssgdItm

Excess Requirement Quantity per Acct Assigned Sales Doc Item | view: IEXRQMTACCITM | TRAN | Extraction: Not supported | Component: Cross Application Functionality

Tables used: VBAP, VBAK, VBAP, VBKD, VBPA, VBKD, VEDA, VBAK, VBAK, VBAP, VBKD, VEDA, VBEP, VBFA, ARUN_BDBS, KNA1, TVEP, MARC, TVAK, MARA

🔑 Keys (3)
💰 Amounts (1)
∑ Quantities (4)
📅 Dates (3)
☰ Categorical (6)
Other (14)
🔗 Relations (34)

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
AlignedPurOrdItmQtyInBaseUoM	null
OpenAcctAssgdPurReqnQtyInBsUnt	null
OpnAcctPurReqnReqdQtyRatioPct	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 Client Material Group 1	`I_EXCESSRQMTQTYACCTASSGDITM.MANDT == TVM1.MANDT` `I_EXCESSRQMTQTYACCTASSGDITM.ADDITIONALMATERIALGROUP1 == TVM1.MVGR1`
Material Group 2 Client Material Group 2	`I_EXCESSRQMTQTYACCTASSGDITM.MANDT == TVM2.MANDT` `I_EXCESSRQMTQTYACCTASSGDITM.ADDITIONALMATERIALGROUP2 == TVM2.MVGR2`
Material Group 3 Client Material Group 3	`I_EXCESSRQMTQTYACCTASSGDITM.MANDT == TVM3.MANDT` `I_EXCESSRQMTQTYACCTASSGDITM.ADDITIONALMATERIALGROUP3 == TVM3.MVGR3`
Material Group 4 Client Material Group 4	`I_EXCESSRQMTQTYACCTASSGDITM.MANDT == TVM4.MANDT` `I_EXCESSRQMTQTYACCTASSGDITM.ADDITIONALMATERIALGROUP4 == TVM4.MVGR4`
Material Group 5 Client Material Group 5	`I_EXCESSRQMTQTYACCTASSGDITM.MANDT == TVM5.MANDT` `I_EXCESSRQMTQTYACCTASSGDITM.ADDITIONALMATERIALGROUP5 == TVM5.MVGR5`
Base Unit of Measure Client Base Unit of Measure	`I_EXCESSRQMTQTYACCTASSGDITM.MANDT == T006.MANDT` `I_EXCESSRQMTQTYACCTASSGDITM.BASEUNIT == T006.MSEHI`
Batch Number Client Batch Number Material Number Plant (Own or External)	`I_EXCESSRQMTQTYACCTASSGDITM.MANDT == MCHA.MANDT` `I_EXCESSRQMTQTYACCTASSGDITM.BATCH == MCHA.CHARG` `I_EXCESSRQMTQTYACCTASSGDITM.MATERIAL == MCHA.MATNR` `I_EXCESSRQMTQTYACCTASSGDITM.PLANT == MCHA.WERKS`
Company Code to Be Billed Client Company Code to Be Billed	`I_EXCESSRQMTQTYACCTASSGDITM.MANDT == T001.MANDT` `I_EXCESSRQMTQTYACCTASSGDITM.BILLINGCOMPANYCODE == T001.BUKRS`
Cross-Plant Configurable Material Client Cross-Plant Configurable Material	`I_EXCESSRQMTQTYACCTASSGDITM.MANDT == MARA.MANDT` `I_EXCESSRQMTQTYACCTASSGDITM.CROSSPLANTCONFIGURABLEPRODUCT == MARA.MATNR`
Customer Group Client Customer Group	`I_EXCESSRQMTQTYACCTASSGDITM.MANDT == T151.MANDT` `I_EXCESSRQMTQTYACCTASSGDITM.CUSTOMERGROUP == T151.KDGRP`
Delivery Priority Client Delivery Priority	`I_EXCESSRQMTQTYACCTASSGDITM.MANDT == TPRIO.MANDT` `I_EXCESSRQMTQTYACCTASSGDITM.DELIVERYPRIORITY == TPRIO.LPRIO`
Distribution channel in order header Client Sales Organization Distribution Channel	`I_EXCESSRQMTQTYACCTASSGDITM.MANDT == TVKOV.MANDT` `I_EXCESSRQMTQTYACCTASSGDITM.SALESORGANIZATION == TVKOV.VKORG` `I_EXCESSRQMTQTYACCTASSGDITM.DISTRIBUTIONCHANNEL == TVKOV.VTWEG`
Division Client Division Division	`I_EXCESSRQMTQTYACCTASSGDITM.MANDT == TSPA.MANDT` `I_EXCESSRQMTQTYACCTASSGDITM.ORGANIZATIONDIVISION == TSPA.SPART` `I_EXCESSRQMTQTYACCTASSGDITM.DIVISION == TSPA.SPART`
Incoterms (Part 1) Client Incoterms (Part 1)	`I_EXCESSRQMTQTYACCTASSGDITM.MANDT == TINC.MANDT` `I_EXCESSRQMTQTYACCTASSGDITM.INCOTERMSCLASSIFICATION == TINC.INCO1`
Material: order item Client Material Number	`I_EXCESSRQMTQTYACCTASSGDITM.MANDT == MARA.MANDT` `I_EXCESSRQMTQTYACCTASSGDITM.MATERIAL == MARA.MATNR`
Material Group Client Material Group	`I_EXCESSRQMTQTYACCTASSGDITM.MANDT == T023.MANDT` `I_EXCESSRQMTQTYACCTASSGDITM.MATERIALGROUP == T023.MATKL`
Division in order header Client Division Division Sales Organization Distribution Channel	`I_EXCESSRQMTQTYACCTASSGDITM.MANDT == TVTA.MANDT` `I_EXCESSRQMTQTYACCTASSGDITM.ORGANIZATIONDIVISION == TVTA.SPART` `I_EXCESSRQMTQTYACCTASSGDITM.DIVISION == TVTA.SPART` `I_EXCESSRQMTQTYACCTASSGDITM.SALESORGANIZATION == TVTA.VKORG` `I_EXCESSRQMTQTYACCTASSGDITM.DISTRIBUTIONCHANNEL == TVTA.VTWEG`
Fashion Collection Client Fashion Collection Season Season Year	`I_EXCESSRQMTQTYACCTASSGDITM.MANDT == FSH_COLLECTIONS.MANDT` `I_EXCESSRQMTQTYACCTASSGDITM.PRODUCTCOLLECTION == FSH_COLLECTIONS.FSH_COLLECTION` `I_EXCESSRQMTQTYACCTASSGDITM.PRODUCTSEASON == FSH_COLLECTIONS.FSH_SEASON` `I_EXCESSRQMTQTYACCTASSGDITM.PRODUCTSEASONYEAR == FSH_COLLECTIONS.FSH_SEASON_YEAR`
Season Client Season Season Year	`I_EXCESSRQMTQTYACCTASSGDITM.MANDT == FSH_SEASONS.MANDT` `I_EXCESSRQMTQTYACCTASSGDITM.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON` `I_EXCESSRQMTQTYACCTASSGDITM.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR`
Season Year Client Season Season Year	`I_EXCESSRQMTQTYACCTASSGDITM.MANDT == FSH_SEASONS.MANDT` `I_EXCESSRQMTQTYACCTASSGDITM.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON` `I_EXCESSRQMTQTYACCTASSGDITM.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR`
Fashion Theme Client Fashion Collection Season Season Year Fashion Theme	`I_EXCESSRQMTQTYACCTASSGDITM.MANDT == FSH_THEMES.MANDT` `I_EXCESSRQMTQTYACCTASSGDITM.PRODUCTCOLLECTION == FSH_THEMES.FSH_COLLECTION` `I_EXCESSRQMTQTYACCTASSGDITM.PRODUCTSEASON == FSH_THEMES.FSH_SEASON` `I_EXCESSRQMTQTYACCTASSGDITM.PRODUCTSEASONYEAR == FSH_THEMES.FSH_SEASON_YEAR` `I_EXCESSRQMTQTYACCTASSGDITM.PRODUCTTHEME == FSH_THEMES.FSH_THEME`
Sales District Client Sales District	`I_EXCESSRQMTQTYACCTASSGDITM.MANDT == T171.MANDT` `I_EXCESSRQMTQTYACCTASSGDITM.SALESDISTRICT == T171.BZIRK`
Sales document item category Client Sales document item category	`I_EXCESSRQMTQTYACCTASSGDITM.MANDT == TVPT.MANDT` `I_EXCESSRQMTQTYACCTASSGDITM.SALESDOCUMENTITEMCATEGORY == TVPT.PSTYV`
Reason for Rejection of Sales Documents Client Reason for Rejection of Sales Documents	`I_EXCESSRQMTQTYACCTASSGDITM.MANDT == TVAG.MANDT` `I_EXCESSRQMTQTYACCTASSGDITM.SALESDOCUMENTRJCNREASON == TVAG.ABGRU`
Order type in order header Client Sales Document Type	`I_EXCESSRQMTQTYACCTASSGDITM.MANDT == TVAK.MANDT` `I_EXCESSRQMTQTYACCTASSGDITM.SALESDOCUMENTTYPE == TVAK.AUART`
Sales organization in order header Client Sales Organization	`I_EXCESSRQMTQTYACCTASSGDITM.MANDT == TVKO.MANDT` `I_EXCESSRQMTQTYACCTASSGDITM.SALESORGANIZATION == TVKO.VKORG`
Order Reason (Reason for the Business Transaction) Client Order Reason (Reason for the Business Transaction)	`I_EXCESSRQMTQTYACCTASSGDITM.MANDT == TVAU.MANDT` `I_EXCESSRQMTQTYACCTASSGDITM.SDDOCUMENTREASON == TVAU.AUGRU`
Shipping Point / Receiving Point Client Shipping Point / Receiving Point	`I_EXCESSRQMTQTYACCTASSGDITM.MANDT == TVST.MANDT` `I_EXCESSRQMTQTYACCTASSGDITM.SHIPPINGPOINT == TVST.VSTEL`
Customer - Document Customer Client Customer Number Sold-to Party	`I_EXCESSRQMTQTYACCTASSGDITM.MANDT == KNA1.MANDT` `I_EXCESSRQMTQTYACCTASSGDITM.SHIPTOPARTY == KNA1.KUNNR` `I_EXCESSRQMTQTYACCTASSGDITM.SOLDTOPARTY == KNA1.KUNNR`
Sold-to Party Client Customer Number Sold-to Party	`I_EXCESSRQMTQTYACCTASSGDITM.MANDT == KNA1.MANDT` `I_EXCESSRQMTQTYACCTASSGDITM.SHIPTOPARTY == KNA1.KUNNR` `I_EXCESSRQMTQTYACCTASSGDITM.SOLDTOPARTY == KNA1.KUNNR`
Storage location Client Storage location Plant (Own or External)	`I_EXCESSRQMTQTYACCTASSGDITM.MANDT == T001L.MANDT` `I_EXCESSRQMTQTYACCTASSGDITM.STORAGELOCATION == T001L.LGORT` `I_EXCESSRQMTQTYACCTASSGDITM.PLANT == T001L.WERKS`
SD Document Currency Client SD Document Currency	`I_EXCESSRQMTQTYACCTASSGDITM.MANDT == TCURC.MANDT` `I_EXCESSRQMTQTYACCTASSGDITM.TRANSACTIONCURRENCY == TCURC.WAERS`

Other Relations \| to Master Data Relations ↑	Join Conditions
Sales office Client Division Division Sales office Sales Organization Distribution Channel	`I_EXCESSRQMTQTYACCTASSGDITM.MANDT == TVKBZ.MANDT` `I_EXCESSRQMTQTYACCTASSGDITM.ORGANIZATIONDIVISION == TVKBZ.SPART` `I_EXCESSRQMTQTYACCTASSGDITM.DIVISION == TVKBZ.SPART` `I_EXCESSRQMTQTYACCTASSGDITM.SALESOFFICE == TVKBZ.VKBUR` `I_EXCESSRQMTQTYACCTASSGDITM.SALESORGANIZATION == TVKBZ.VKORG` `I_EXCESSRQMTQTYACCTASSGDITM.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG`