C_ExcessRqmtQtySDDocItm

Manage Excess Requirements | view: CEXRQMTSDITM | TRAN | Extraction: Not supported | Component: Cross Application Functionality

Tables used: VBAP, VBAK, VBAP, VBKD, VBPA, VBKD, VEDA, VBAK, VBAK, VBAP, VBKD, VEDA, VBEP, VBFA, SIT_INST, SIT_INST_QUEUE, SIT_INST_QUEUE, TVM1T, TVM2T, TVM3T, TVM4T, TVM5T, ARUN_BDBS, KNA1, T151T, TVZBT, TPRIT, TVEP, MARC, TVAK, TINCT, MARA, T023T, MAKT, T001W, WRF_CHARVALT, T171T, TVAPT, TVAKT, TVAUT, TVSTT, SIT_DEF, SIT_T_DEF, T001L, USR21

🔑 Keys (3)
💰 Amounts (1)
∑ Quantities (10)
📅 Dates (3)
☰ Categorical (4)
Other (46)
🔗 Relations (33)

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
📏 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	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
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
FormattedSalesDocumentItem	Sales Document Item	CHAR17
DocumentItemConcatenatedID	Sales Document Item	CHAR17
SitnNumberOfInstances	Number of Situations
CreatedByUser	Name of Person Responsible for Creating the Object	USNAM
UserDescription	User Description	SUIDTECHDESC
MaterialName	Material Description	TEXT40
CrsPlntConfigurableProductName	Material Description	TEXT40
MaterialGroupName	Product Group Description	TEXT20
AdditionalMaterialGroup1Name	Description	TEXT40
AdditionalMaterialGroup2Name	Description	TEXT40
AdditionalMaterialGroup3Name	Description	TEXT40
AdditionalMaterialGroup4Name	Description	TEXT40
AdditionalMaterialGroup5Name	Description	TEXT40
SalesDocumentTypeName	Sales Document Type Description	TEXT20
SalesDistrictName	Name of the district	TEXT20
SDDocumentReasonText	Description	TEXT40
SalesDocumentItemCategoryName	Description	TEXT20
Plant	Plant (Own or External)	WERKS
PlantName	Plant Name	TEXT30
CustomerGroupName	Name	TEXT20
StorageLocationName	Storage Location Name	TEXT16
RequirementSegment	Requirement Segment	SGT_SRCA
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
DeliveryPriorityDesc	Description	TEXT20
ShippingPointName	Description	TEXT30
CustomerPaymentTerms	Terms of payment key	ZTERM
CustomerPaymentTermsName	Description of terms of payment	TEXT30
IncotermsClassificationName	Description	TEXT30
ApplicationJobDescription	Application Job Text	APJ_TEXT
ItemGeneralIncompletionStatus	Incompletion Status (Item)
ItemBillingIncompletionStatus	Billing Incompletion Status (Item)
ItemDeliveryIncompletionStatus	Delivery Incompletion Status (Item)
RqmtIsSupAssgmtRelevant	Supply Assignment (ARun)
PurchaseOrder	Purchasing Document Number
PurchasingOrganization	Purchasing organization
PurchasingGroup	Purchasing Group	EKGRP
PurchaseOrderType	Order Type (Purchasing)
SupplyingPlant	Supplying (issuing) plant in case of stock transport order
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	`C_EXCESSRQMTQTYSDDOCITM.MANDT == TVM1.MANDT` `C_EXCESSRQMTQTYSDDOCITM.ADDITIONALMATERIALGROUP1 == TVM1.MVGR1`
Material Group 2 Material Group 2 Client	`C_EXCESSRQMTQTYSDDOCITM.ADDITIONALMATERIALGROUP2 == TVM2.MVGR2` `C_EXCESSRQMTQTYSDDOCITM.MANDT == TVM2.MANDT`
Material Group 3 Material Group 3 Client	`C_EXCESSRQMTQTYSDDOCITM.ADDITIONALMATERIALGROUP3 == TVM3.MVGR3` `C_EXCESSRQMTQTYSDDOCITM.MANDT == TVM3.MANDT`
Material Group 4 Material Group 4 Client	`C_EXCESSRQMTQTYSDDOCITM.ADDITIONALMATERIALGROUP4 == TVM4.MVGR4` `C_EXCESSRQMTQTYSDDOCITM.MANDT == TVM4.MANDT`
Material Group 5 Client Material Group 5	`C_EXCESSRQMTQTYSDDOCITM.MANDT == TVM5.MANDT` `C_EXCESSRQMTQTYSDDOCITM.ADDITIONALMATERIALGROUP5 == TVM5.MVGR5`
Base Unit of Measure Client Base Unit of Measure	`C_EXCESSRQMTQTYSDDOCITM.MANDT == T006.MANDT` `C_EXCESSRQMTQTYSDDOCITM.BASEUNIT == T006.MSEHI`
Batch Number Batch Number Client Material Number Plant (Own or External)	`C_EXCESSRQMTQTYSDDOCITM.BATCH == MCHA.CHARG` `C_EXCESSRQMTQTYSDDOCITM.MANDT == MCHA.MANDT` `C_EXCESSRQMTQTYSDDOCITM.MATERIAL == MCHA.MATNR` `C_EXCESSRQMTQTYSDDOCITM.PLANT == MCHA.WERKS`
Company Code to Be Billed Company Code to Be Billed Client	`C_EXCESSRQMTQTYSDDOCITM.BILLINGCOMPANYCODE == T001.BUKRS` `C_EXCESSRQMTQTYSDDOCITM.MANDT == T001.MANDT`
Cross-Plant Configurable Material Cross-Plant Configurable Material Client	`C_EXCESSRQMTQTYSDDOCITM.CROSSPLANTCONFIGURABLEPRODUCT == MARA.MATNR` `C_EXCESSRQMTQTYSDDOCITM.MANDT == MARA.MANDT`
Customer Group Customer Group Client	`C_EXCESSRQMTQTYSDDOCITM.CUSTOMERGROUP == T151.KDGRP` `C_EXCESSRQMTQTYSDDOCITM.MANDT == T151.MANDT`
Delivery Priority Delivery Priority Client	`C_EXCESSRQMTQTYSDDOCITM.DELIVERYPRIORITY == TPRIO.LPRIO` `C_EXCESSRQMTQTYSDDOCITM.MANDT == TPRIO.MANDT`
Distribution channel in order header Sales Organization Client Distribution Channel	`C_EXCESSRQMTQTYSDDOCITM.SALESORGANIZATION == TVKOV.VKORG` `C_EXCESSRQMTQTYSDDOCITM.MANDT == TVKOV.MANDT` `C_EXCESSRQMTQTYSDDOCITM.DISTRIBUTIONCHANNEL == TVKOV.VTWEG`
Division Division Division Client	`C_EXCESSRQMTQTYSDDOCITM.DIVISION == TSPA.SPART` `C_EXCESSRQMTQTYSDDOCITM.ORGANIZATIONDIVISION == TSPA.SPART` `C_EXCESSRQMTQTYSDDOCITM.MANDT == TSPA.MANDT`
Incoterms (Part 1) Incoterms (Part 1) Client	`C_EXCESSRQMTQTYSDDOCITM.INCOTERMSCLASSIFICATION == TINC.INCO1` `C_EXCESSRQMTQTYSDDOCITM.MANDT == TINC.MANDT`
Material: order item Client Material Number	`C_EXCESSRQMTQTYSDDOCITM.MANDT == MARA.MANDT` `C_EXCESSRQMTQTYSDDOCITM.MATERIAL == MARA.MATNR`
Material Group Material Group Client	`C_EXCESSRQMTQTYSDDOCITM.MATERIALGROUP == T023.MATKL` `C_EXCESSRQMTQTYSDDOCITM.MANDT == T023.MANDT`
Division in order header Sales Organization Division Division Client Distribution Channel	`C_EXCESSRQMTQTYSDDOCITM.SALESORGANIZATION == TVTA.VKORG` `C_EXCESSRQMTQTYSDDOCITM.DIVISION == TVTA.SPART` `C_EXCESSRQMTQTYSDDOCITM.ORGANIZATIONDIVISION == TVTA.SPART` `C_EXCESSRQMTQTYSDDOCITM.MANDT == TVTA.MANDT` `C_EXCESSRQMTQTYSDDOCITM.DISTRIBUTIONCHANNEL == TVTA.VTWEG`
Fashion Collection Season Fashion Collection Season Year Client	`C_EXCESSRQMTQTYSDDOCITM.PRODUCTSEASON == FSH_COLLECTIONS.FSH_SEASON` `C_EXCESSRQMTQTYSDDOCITM.PRODUCTCOLLECTION == FSH_COLLECTIONS.FSH_COLLECTION` `C_EXCESSRQMTQTYSDDOCITM.PRODUCTSEASONYEAR == FSH_COLLECTIONS.FSH_SEASON_YEAR` `C_EXCESSRQMTQTYSDDOCITM.MANDT == FSH_COLLECTIONS.MANDT`
Season Season Season Year Client	`C_EXCESSRQMTQTYSDDOCITM.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON` `C_EXCESSRQMTQTYSDDOCITM.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR` `C_EXCESSRQMTQTYSDDOCITM.MANDT == FSH_SEASONS.MANDT`
Season Year Season Season Year Client	`C_EXCESSRQMTQTYSDDOCITM.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON` `C_EXCESSRQMTQTYSDDOCITM.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR` `C_EXCESSRQMTQTYSDDOCITM.MANDT == FSH_SEASONS.MANDT`
Fashion Theme Season Fashion Collection Fashion Theme Season Year Client	`C_EXCESSRQMTQTYSDDOCITM.PRODUCTSEASON == FSH_THEMES.FSH_SEASON` `C_EXCESSRQMTQTYSDDOCITM.PRODUCTCOLLECTION == FSH_THEMES.FSH_COLLECTION` `C_EXCESSRQMTQTYSDDOCITM.PRODUCTTHEME == FSH_THEMES.FSH_THEME` `C_EXCESSRQMTQTYSDDOCITM.PRODUCTSEASONYEAR == FSH_THEMES.FSH_SEASON_YEAR` `C_EXCESSRQMTQTYSDDOCITM.MANDT == FSH_THEMES.MANDT`
Sales District Sales District Client	`C_EXCESSRQMTQTYSDDOCITM.SALESDISTRICT == T171.BZIRK` `C_EXCESSRQMTQTYSDDOCITM.MANDT == T171.MANDT`
Sales document item category Sales document item category Client	`C_EXCESSRQMTQTYSDDOCITM.SALESDOCUMENTITEMCATEGORY == TVPT.PSTYV` `C_EXCESSRQMTQTYSDDOCITM.MANDT == TVPT.MANDT`
Reason for Rejection of Sales Documents Reason for Rejection of Sales Documents Client	`C_EXCESSRQMTQTYSDDOCITM.SALESDOCUMENTRJCNREASON == TVAG.ABGRU` `C_EXCESSRQMTQTYSDDOCITM.MANDT == TVAG.MANDT`
Order type in order header Sales Document Type Client	`C_EXCESSRQMTQTYSDDOCITM.SALESDOCUMENTTYPE == TVAK.AUART` `C_EXCESSRQMTQTYSDDOCITM.MANDT == TVAK.MANDT`
Sales organization in order header Sales Organization Client	`C_EXCESSRQMTQTYSDDOCITM.SALESORGANIZATION == TVKO.VKORG` `C_EXCESSRQMTQTYSDDOCITM.MANDT == TVKO.MANDT`
Order Reason (Reason for the Business Transaction) Order Reason (Reason for the Business Transaction) Client	`C_EXCESSRQMTQTYSDDOCITM.SDDOCUMENTREASON == TVAU.AUGRU` `C_EXCESSRQMTQTYSDDOCITM.MANDT == TVAU.MANDT`
Shipping Point / Receiving Point Shipping Point / Receiving Point Client	`C_EXCESSRQMTQTYSDDOCITM.SHIPPINGPOINT == TVST.VSTEL` `C_EXCESSRQMTQTYSDDOCITM.MANDT == TVST.MANDT`
Sold-to Party Sold-to Party Client	`C_EXCESSRQMTQTYSDDOCITM.SOLDTOPARTY == KNA1.KUNNR` `C_EXCESSRQMTQTYSDDOCITM.MANDT == KNA1.MANDT`
Storage location Storage location Client Plant (Own or External)	`C_EXCESSRQMTQTYSDDOCITM.STORAGELOCATION == T001L.LGORT` `C_EXCESSRQMTQTYSDDOCITM.MANDT == T001L.MANDT` `C_EXCESSRQMTQTYSDDOCITM.PLANT == T001L.WERKS`
SD Document Currency SD Document Currency Client	`C_EXCESSRQMTQTYSDDOCITM.TRANSACTIONCURRENCY == TCURC.WAERS` `C_EXCESSRQMTQTYSDDOCITM.MANDT == TCURC.MANDT`