C_ExcessRqmtQtyAcctAssgdItm

Excess Requirement Quantity per Acct Assigned Sales Doc Item | view: CEXRQMTACCITM | 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, TVTWT, TSPAT, TVEP, MARC, TVAK, TINCT, MARA, T023T, MAKT, T001W, WRF_CHARVALT, T171T, TVAPT, TVAKT, TVKOT, TVAUT, TVSTT, SIT_DEF, SIT_T_DEF, T001L, USR21
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
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
TotalCreditCheckStatus Overall Status of Credit Checks Show values
SDDocumentCategory SD Document Category 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
CreatedByUser Name of Person Responsible for Creating the Object USNAM
UserDescription User Description SUIDTECHDESC
SitnNumberOfInstances Number of Situations
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
SalesOrganizationName Sales Organization Description TEXT20
DistributionChannelName Distribution Channel Description TEXT20
DivisionName Division Description TEXT20
SDDocumentReasonText Description TEXT40
SalesDistrictName Name of the district TEXT20
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
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
ItemGeneralIncompletionStatus Incompletion Status (Item)
ItemBillingIncompletionStatus Billing Incompletion Status (Item)
ItemDeliveryIncompletionStatus Delivery Incompletion Status (Item)
RqmtIsSupAssgmtRelevant Supply Assignment (ARun)
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_EXCESSRQMTQTYACCTASSGDITM.MANDT == TVM1.MANDT
  • C_EXCESSRQMTQTYACCTASSGDITM.ADDITIONALMATERIALGROUP1 == TVM1.MVGR1
Material Group 2
  • Client
  • Material Group 2
  • C_EXCESSRQMTQTYACCTASSGDITM.MANDT == TVM2.MANDT
  • C_EXCESSRQMTQTYACCTASSGDITM.ADDITIONALMATERIALGROUP2 == TVM2.MVGR2
Material Group 3
  • Client
  • Material Group 3
  • C_EXCESSRQMTQTYACCTASSGDITM.MANDT == TVM3.MANDT
  • C_EXCESSRQMTQTYACCTASSGDITM.ADDITIONALMATERIALGROUP3 == TVM3.MVGR3
Material Group 4
  • Material Group 4
  • Client
  • C_EXCESSRQMTQTYACCTASSGDITM.ADDITIONALMATERIALGROUP4 == TVM4.MVGR4
  • C_EXCESSRQMTQTYACCTASSGDITM.MANDT == TVM4.MANDT
Material Group 5
  • Client
  • Material Group 5
  • C_EXCESSRQMTQTYACCTASSGDITM.MANDT == TVM5.MANDT
  • C_EXCESSRQMTQTYACCTASSGDITM.ADDITIONALMATERIALGROUP5 == TVM5.MVGR5
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • C_EXCESSRQMTQTYACCTASSGDITM.BASEUNIT == T006.MSEHI
  • C_EXCESSRQMTQTYACCTASSGDITM.MANDT == T006.MANDT
Batch Number
  • Batch Number
  • Client
  • Material Number
  • Plant (Own or External)
  • C_EXCESSRQMTQTYACCTASSGDITM.BATCH == MCHA.CHARG
  • C_EXCESSRQMTQTYACCTASSGDITM.MANDT == MCHA.MANDT
  • C_EXCESSRQMTQTYACCTASSGDITM.MATERIAL == MCHA.MATNR
  • C_EXCESSRQMTQTYACCTASSGDITM.PLANT == MCHA.WERKS
Company Code to Be Billed
  • Client
  • Company Code to Be Billed
  • C_EXCESSRQMTQTYACCTASSGDITM.MANDT == T001.MANDT
  • C_EXCESSRQMTQTYACCTASSGDITM.BILLINGCOMPANYCODE == T001.BUKRS
Cross-Plant Configurable Material
  • Client
  • Cross-Plant Configurable Material
  • C_EXCESSRQMTQTYACCTASSGDITM.MANDT == MARA.MANDT
  • C_EXCESSRQMTQTYACCTASSGDITM.CROSSPLANTCONFIGURABLEPRODUCT == MARA.MATNR
Customer Group
  • Customer Group
  • Client
  • C_EXCESSRQMTQTYACCTASSGDITM.CUSTOMERGROUP == T151.KDGRP
  • C_EXCESSRQMTQTYACCTASSGDITM.MANDT == T151.MANDT
Delivery Priority
  • Client
  • Delivery Priority
  • C_EXCESSRQMTQTYACCTASSGDITM.MANDT == TPRIO.MANDT
  • C_EXCESSRQMTQTYACCTASSGDITM.DELIVERYPRIORITY == TPRIO.LPRIO
Distribution channel in order header
  • Client
  • Distribution Channel
  • Sales Organization
  • C_EXCESSRQMTQTYACCTASSGDITM.MANDT == TVKOV.MANDT
  • C_EXCESSRQMTQTYACCTASSGDITM.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • C_EXCESSRQMTQTYACCTASSGDITM.SALESORGANIZATION == TVKOV.VKORG
Division
  • Client
  • Division
  • Division
  • C_EXCESSRQMTQTYACCTASSGDITM.MANDT == TSPA.MANDT
  • C_EXCESSRQMTQTYACCTASSGDITM.DIVISION == TSPA.SPART
  • C_EXCESSRQMTQTYACCTASSGDITM.ORGANIZATIONDIVISION == TSPA.SPART
Incoterms (Part 1)
  • Client
  • Incoterms (Part 1)
  • C_EXCESSRQMTQTYACCTASSGDITM.MANDT == TINC.MANDT
  • C_EXCESSRQMTQTYACCTASSGDITM.INCOTERMSCLASSIFICATION == TINC.INCO1
Material: order item
  • Client
  • Material Number
  • C_EXCESSRQMTQTYACCTASSGDITM.MANDT == MARA.MANDT
  • C_EXCESSRQMTQTYACCTASSGDITM.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • C_EXCESSRQMTQTYACCTASSGDITM.MANDT == T023.MANDT
  • C_EXCESSRQMTQTYACCTASSGDITM.MATERIALGROUP == T023.MATKL
Division in order header
  • Client
  • Distribution Channel
  • Division
  • Division
  • Sales Organization
  • C_EXCESSRQMTQTYACCTASSGDITM.MANDT == TVTA.MANDT
  • C_EXCESSRQMTQTYACCTASSGDITM.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • C_EXCESSRQMTQTYACCTASSGDITM.DIVISION == TVTA.SPART
  • C_EXCESSRQMTQTYACCTASSGDITM.ORGANIZATIONDIVISION == TVTA.SPART
  • C_EXCESSRQMTQTYACCTASSGDITM.SALESORGANIZATION == TVTA.VKORG
Fashion Collection
  • Client
  • Fashion Collection
  • Season
  • Season Year
Season
  • Client
  • Season
  • Season Year
  • C_EXCESSRQMTQTYACCTASSGDITM.MANDT == FSH_SEASONS.MANDT
  • C_EXCESSRQMTQTYACCTASSGDITM.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON
  • C_EXCESSRQMTQTYACCTASSGDITM.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR
Season Year
  • Client
  • Season
  • Season Year
  • C_EXCESSRQMTQTYACCTASSGDITM.MANDT == FSH_SEASONS.MANDT
  • C_EXCESSRQMTQTYACCTASSGDITM.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON
  • C_EXCESSRQMTQTYACCTASSGDITM.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR
Fashion Theme
  • Fashion Theme
  • Client
  • Fashion Collection
  • Season
  • Season Year
  • C_EXCESSRQMTQTYACCTASSGDITM.PRODUCTTHEME == FSH_THEMES.FSH_THEME
  • C_EXCESSRQMTQTYACCTASSGDITM.MANDT == FSH_THEMES.MANDT
  • C_EXCESSRQMTQTYACCTASSGDITM.PRODUCTCOLLECTION == FSH_THEMES.FSH_COLLECTION
  • C_EXCESSRQMTQTYACCTASSGDITM.PRODUCTSEASON == FSH_THEMES.FSH_SEASON
  • C_EXCESSRQMTQTYACCTASSGDITM.PRODUCTSEASONYEAR == FSH_THEMES.FSH_SEASON_YEAR
Sales District
  • Client
  • Sales District
  • C_EXCESSRQMTQTYACCTASSGDITM.MANDT == T171.MANDT
  • C_EXCESSRQMTQTYACCTASSGDITM.SALESDISTRICT == T171.BZIRK
Sales document item category
  • Sales document item category
  • Client
  • C_EXCESSRQMTQTYACCTASSGDITM.SALESDOCUMENTITEMCATEGORY == TVPT.PSTYV
  • C_EXCESSRQMTQTYACCTASSGDITM.MANDT == TVPT.MANDT
Reason for Rejection of Sales Documents
  • Reason for Rejection of Sales Documents
  • Client
  • C_EXCESSRQMTQTYACCTASSGDITM.SALESDOCUMENTRJCNREASON == TVAG.ABGRU
  • C_EXCESSRQMTQTYACCTASSGDITM.MANDT == TVAG.MANDT
Order type in order header
  • Client
  • Sales Document Type
  • C_EXCESSRQMTQTYACCTASSGDITM.MANDT == TVAK.MANDT
  • C_EXCESSRQMTQTYACCTASSGDITM.SALESDOCUMENTTYPE == TVAK.AUART
Sales organization in order header
  • Client
  • Sales Organization
  • C_EXCESSRQMTQTYACCTASSGDITM.MANDT == TVKO.MANDT
  • C_EXCESSRQMTQTYACCTASSGDITM.SALESORGANIZATION == TVKO.VKORG
Order Reason (Reason for the Business Transaction)
  • Order Reason (Reason for the Business Transaction)
  • Client
  • C_EXCESSRQMTQTYACCTASSGDITM.SDDOCUMENTREASON == TVAU.AUGRU
  • C_EXCESSRQMTQTYACCTASSGDITM.MANDT == TVAU.MANDT
Shipping Point / Receiving Point
  • Shipping Point / Receiving Point
  • Client
  • C_EXCESSRQMTQTYACCTASSGDITM.SHIPPINGPOINT == TVST.VSTEL
  • C_EXCESSRQMTQTYACCTASSGDITM.MANDT == TVST.MANDT
Sold-to Party
  • Sold-to Party
  • Client
  • C_EXCESSRQMTQTYACCTASSGDITM.SOLDTOPARTY == KNA1.KUNNR
  • C_EXCESSRQMTQTYACCTASSGDITM.MANDT == KNA1.MANDT
Storage location
  • Storage location
  • Client
  • Plant (Own or External)
  • C_EXCESSRQMTQTYACCTASSGDITM.STORAGELOCATION == T001L.LGORT
  • C_EXCESSRQMTQTYACCTASSGDITM.MANDT == T001L.MANDT
  • C_EXCESSRQMTQTYACCTASSGDITM.PLANT == T001L.WERKS
SD Document Currency
  • Client
  • SD Document Currency
  • C_EXCESSRQMTQTYACCTASSGDITM.MANDT == TCURC.MANDT
  • C_EXCESSRQMTQTYACCTASSGDITM.TRANSACTIONCURRENCY == TCURC.WAERS