C_ExcessRqmtQtySTOItm

Excess Requirement Quantity per Stock Transport Order Item | view: CEXRQMTSTOITM | TRAN | Extraction: Not supported | Component: Cross Application Functionality

Tables used: EKKO, EKPO, EKKO, EKPO, EKPV, EKET, ARUN_BDBS, KNA1, KNVV, TPRIT, TVTWT, TSPAT, MARC, TINCT, MARA, T023T, MAKT, T001W, T161, T161T, WRF_CHARVALT, T171T, TVKOT, TVSTT, T001L, LFA1, USR21

🔑 Keys (3)
💰 Amounts (1)
∑ Quantities (10)
📅 Dates (2)
☰ Categorical (2)
Other (35)
🔗 Relations (23)

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
📏 Base Unit of Measure (BaseUnit):
RequestedQuantityInBaseUnit	null
ConfirmedRqmtQtyInBaseUnit	null
OpenForConfQtyInBaseUnit	null
AssignedQuantityInBaseUnit	null
OpenForAssignmentQtyInBsUnt	null
DeliveredQuantityInBaseUnit	null
OpenForDeliveryQtyInBsUnt	null
OpenForConfReqdQtyRatioPct	null
OpenForAssgmtReqdQtyRatioPct	null
OpenForDeliveryReqdQtyRatioPct	null

Column Name	Description
CreationDate	Creation Date of Purchasing Document
RequestedDeliveryDate	null

Column Name	Description
ExcessRqmtDocumentType	RFM document type for manage excess requirement	Show values
ExcessRqmtQtyRejectionType	RFM rejection type for manage excess requirements	Show values

Column Name	Description	Domain name
FormattedPurchaseOrderItem	Purchase Order Item
DocumentItemConcatenatedID	Purchase Order Item
CreatedByUser	User of person who created a purchasing document	USNAM
UserDescription	User Description	SUIDTECHDESC
MaterialName	Material Description	TEXT40
CrsPlntConfigurableProductName	Material Description	TEXT40
MaterialGroupName	Product Group Description	TEXT20
PlantName	Plant Name	TEXT30
StorageLocationName	Storage Location Name	TEXT16
RequirementSegment	Requirement Segment	SGT_SRCA
SalesOrganizationName	Sales Organization Description	TEXT20
DistributionChannelName	Distribution Channel Description	TEXT20
DivisionName	Division Description	TEXT20
SalesDistrictName	Name of the district	TEXT20
PurchasingDocumentTypeName	Short Description of Purchasing Document Type	TEXT20
DeliveryPriorityDesc	Description	TEXT20
IncotermsClassificationName	Description	TEXT30
ProductSeasonYear	Season Year	FSH_CJAHR
ProductSeason	Season	RFM_SAISO
ProductCollection	Fashion Collection	FSH_COLLECTION
ProductTheme	Fashion Theme	FSH_THEME
ProductCharacteristic1	Characteristic Value 1
ProductCharacteristic1Desc	Characteristic value description	ATWRT
ProductCharacteristic2	Characteristic Value 2
ProductCharacteristic2Desc	Characteristic value description	ATWRT
ProductCharacteristic3	Characteristic Value 3
ProductCharacteristic3Desc	Characteristic value description	ATWRT
Batch	null
ShippingPointName	Description	TEXT30
RqmtIsSupAssgmtRelevant	Supply Assignment (ARun)
ApplicationJobDescription	Application Job Text	APJ_TEXT
SalesDocument	Sales and Distribution Document Number	VBELN
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
Base Unit of Measure Base Unit of Measure Client	`C_EXCESSRQMTQTYSTOITM.BASEUNIT == T006.MSEHI` `C_EXCESSRQMTQTYSTOITM.MANDT == T006.MANDT`
Company Code Client Company Code	`C_EXCESSRQMTQTYSTOITM.MANDT == T001.MANDT` `C_EXCESSRQMTQTYSTOITM.COMPANYCODE == T001.BUKRS`
Cross-Plant Configurable Material Client Cross-Plant Configurable Material	`C_EXCESSRQMTQTYSTOITM.MANDT == MARA.MANDT` `C_EXCESSRQMTQTYSTOITM.CROSSPLANTCONFIGURABLEPRODUCT == MARA.MATNR`
Delivery Priority Delivery Priority Client	`C_EXCESSRQMTQTYSTOITM.DELIVERYPRIORITY == TPRIO.LPRIO` `C_EXCESSRQMTQTYSTOITM.MANDT == TPRIO.MANDT`
Distribution Channel Distribution Channel Client	`C_EXCESSRQMTQTYSTOITM.DISTRIBUTIONCHANNEL == TVTW.VTWEG` `C_EXCESSRQMTQTYSTOITM.MANDT == TVTW.MANDT`
Currency Key Currency Key Client	`C_EXCESSRQMTQTYSTOITM.DOCUMENTCURRENCY == TCURC.WAERS` `C_EXCESSRQMTQTYSTOITM.MANDT == TCURC.MANDT`
Incoterms (Part 1) Incoterms (Part 1) Client	`C_EXCESSRQMTQTYSTOITM.INCOTERMSCLASSIFICATION == TINC.INCO1` `C_EXCESSRQMTQTYSTOITM.MANDT == TINC.MANDT`
Material Number Client Material Number	`C_EXCESSRQMTQTYSTOITM.MANDT == MARA.MANDT` `C_EXCESSRQMTQTYSTOITM.MATERIAL == MARA.MATNR`
Material Group Material Group Client	`C_EXCESSRQMTQTYSTOITM.MATERIALGROUP == T023.MATKL` `C_EXCESSRQMTQTYSTOITM.MANDT == T023.MANDT`
Division Client Division	`C_EXCESSRQMTQTYSTOITM.MANDT == TSPA.MANDT` `C_EXCESSRQMTQTYSTOITM.ORGANIZATIONDIVISION == TSPA.SPART`
Purchase Order Type ? Client Purchase Order Type	`C_EXCESSRQMTQTYSTOITM.[column in domain "BSTYP"] == T161.BSTYP` `C_EXCESSRQMTQTYSTOITM.MANDT == T161.MANDT` `C_EXCESSRQMTQTYSTOITM.PURCHASEORDERTYPE == T161.BSART`
Purchasing Group Purchasing Group Client	`C_EXCESSRQMTQTYSTOITM.PURCHASINGGROUP == T024.EKGRP` `C_EXCESSRQMTQTYSTOITM.MANDT == T024.MANDT`
Reason for Ordering Reason for Ordering Client	`C_EXCESSRQMTQTYSTOITM.PURCHASINGORDERREASON == TBSG.BSGRU` `C_EXCESSRQMTQTYSTOITM.MANDT == TBSG.MANDT`
Purchasing organization Client Purchasing organization	`C_EXCESSRQMTQTYSTOITM.MANDT == T024E.MANDT` `C_EXCESSRQMTQTYSTOITM.PURCHASINGORGANIZATION == T024E.EKORG`
Plant Client Plant	`C_EXCESSRQMTQTYSTOITM.MANDT == T001W.MANDT` `C_EXCESSRQMTQTYSTOITM.RECEIVINGPLANT == T001W.WERKS`
Storage Location Storage Location Client Plant	`C_EXCESSRQMTQTYSTOITM.RECEIVINGSTORAGELOCATION == T001L.LGORT` `C_EXCESSRQMTQTYSTOITM.MANDT == T001L.MANDT` `C_EXCESSRQMTQTYSTOITM.RECEIVINGPLANT == T001L.WERKS`
Sales District Sales District Client	`C_EXCESSRQMTQTYSTOITM.SALESDISTRICT == T171.BZIRK` `C_EXCESSRQMTQTYSTOITM.MANDT == T171.MANDT`
Sales Organization Client Sales Organization	`C_EXCESSRQMTQTYSTOITM.MANDT == TVKO.MANDT` `C_EXCESSRQMTQTYSTOITM.SALESORGANIZATION == TVKO.VKORG`
Shipping Point / Receiving Point Shipping Point / Receiving Point Client	`C_EXCESSRQMTQTYSTOITM.SHIPPINGPOINT == TVST.VSTEL` `C_EXCESSRQMTQTYSTOITM.MANDT == TVST.MANDT`
Customer Number Customer Number Client	`C_EXCESSRQMTQTYSTOITM.SHIPTOPARTY == KNA1.KUNNR` `C_EXCESSRQMTQTYSTOITM.MANDT == KNA1.MANDT`
Sold-to Party Sold-to Party Client	`C_EXCESSRQMTQTYSTOITM.SOLDTOPARTY == KNA1.KUNNR` `C_EXCESSRQMTQTYSTOITM.MANDT == KNA1.MANDT`
Supplying (issuing) plant in case of stock transport order Supplying (issuing) plant in case of stock transport order Client	`C_EXCESSRQMTQTYSTOITM.SUPPLYINGPLANT == T001W.WERKS` `C_EXCESSRQMTQTYSTOITM.MANDT == T001W.MANDT`