I_SupAssgmtDmndDetsCube

Supply Assignment Demand Order Item Details | view: ISUPASSGMTDMNDC | TRAN | Extraction: Not supported | Component: Order Allocation Run
Tables used: EKKO, EKPO, EKPV, SIT_INST, SIT_INST_QUEUE, SIT_INST_QUEUE, RESB, VBAK, VBAP, VBKD, EKKO, EKPO, EKPV, VBPA, VBPA, LIPS, VBAK, VBAP, VBEP, EKET, EKKO, EKPO, EKPV, ARUN_BDBS, CVI_CUST_CT_LINK, BUT000, CVI_CUST_LINK, T161T, TVAKT, SIT_DEF, SIT_T_DEF, MARA, MARC, KNA1, KNA1, T001K, T001W, KNVV, CVI_VEND_LINK, VBBE
Column Name Description
RequirementDocumentNumber FK Sales Document
RequirementDocumentItem Sales Document Item
RequirementType Requirement Type
Column Name Description
💲 SD Document Currency (DocumentCurrency):
ActlAmt Net Value in Document Currency
NetPriceAmount Net Price
💲 Display Currency (DisplayCurrency):
TotActualAmtInDisplayCurrency Net Value in Display Currency
Column Name Description
📏 Base Unit of Measure (SupAssgmtAggrgQtyUnit):
RequestedRqmtQtyInBaseUnit null
ConfirmedRqmtQtyInBaseUnit null
DeliveredQuantityInBaseUnit null
OpenDemandQuantity null
AssignedQuantityInBaseUnit null
FixedQuantityInBaseUnit null
SupAssgmtReservedQtyInBaseUnit null
ReadyForReleaseQtyInBaseUnit null
OnHoldQuantityInBaseUnit null
InboundAssignedQuantityInBsUnt null
Column Name Description
RequestedDeliveryDate null
FashionCancelDate Cancellation Date
Column Name Description
IsSalesDocument Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') Show values
Issue Issue Show values
Column Name Description Domain name
ARunDocumentItemUniqueID Unique Identification for Supply Assignment Document Item
DocumentItemConcatenatedID Unique Identification for Supply Assignment Document Item CHAR17
ARunReqdRqmtQtyFlfmtPercent null
ARunConfdRqmtQtyFlfmtPercent null
SupAssgmtSupAvailySts null
SupAssgmtSource null
StatusCriticality null
SitnNumberOfInstances Number of Situations INT4
SitnRowCriticalityCode Row Criticality
Plant Plant (Own or External) WERKS
SalesOrganization Sales Organization VKORG
DistributionChannel Distribution Channel VTWEG
Division Division SPART
SalesDistrict Sales District BZIRK
CompanyCode Company Code to Be Billed BUKRS
Customer Sold-to Party KUNNR
ShippingPoint Shipping Point / Receiving Point VSTEL
ShipToParty Customer Number KUNNR
FashionCancelDateHorizon null
SupAssgmtOrdStatus null
RequirementSegment Requirement Segment SGT_SRCA
OrderTypeName Sales Document Type Description TEXT20
ShippingGroupRule PSST Grouping Rule RFM_PSST_RULE
ShippingGroupNumber PSST Group RFM_PSST_GROUP_ID
DeliveryGroup Delivery Group (Items are delivered together) GRKOR
PurchasingDocument Purchasing Document Number EBELN
Supplier Account Number of Supplier LIFNR
Master Data Relations Join Conditions
Release Rule
  • Release Rule
  • Client
  • I_SUPASSGMTDMNDDETSCUBE.ARUNSUPPLYASSGMTRELEASERULE == ARUN_RELEASE.REREG
  • I_SUPASSGMTDMNDDETSCUBE.MANDT == ARUN_RELEASE.MANDT
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • I_SUPASSGMTDMNDDETSCUBE.MANDT == T006.MANDT
  • I_SUPASSGMTDMNDDETSCUBE.BASEUNIT == T006.MSEHI
Cross-Plant Configurable Material
  • Client
  • Cross-Plant Configurable Material
  • I_SUPASSGMTDMNDDETSCUBE.MANDT == MARA.MANDT
  • I_SUPASSGMTDMNDDETSCUBE.CROSSPLANTCONFIGURABLEPRODUCT == MARA.MATNR
Customer Group
  • Client
  • Customer Group
  • I_SUPASSGMTDMNDDETSCUBE.MANDT == T151.MANDT
  • I_SUPASSGMTDMNDDETSCUBE.CUSTOMERGROUP == T151.KDGRP
SD Document Currency
  • Client
  • SD Document Currency
  • I_SUPASSGMTDMNDDETSCUBE.MANDT == TCURC.MANDT
  • I_SUPASSGMTDMNDDETSCUBE.DOCUMENTCURRENCY == TCURC.WAERS
Billing Block for Item
  • Client
  • Billing Block for Item
  • I_SUPASSGMTDMNDDETSCUBE.MANDT == TVFS.MANDT
  • I_SUPASSGMTDMNDDETSCUBE.ITEMBILLINGBLOCKREASON == TVFS.FAKSP
Material: order item
  • Client
  • Material Number
  • I_SUPASSGMTDMNDDETSCUBE.MANDT == MARA.MANDT
  • I_SUPASSGMTDMNDDETSCUBE.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • I_SUPASSGMTDMNDDETSCUBE.MANDT == T023.MANDT
  • I_SUPASSGMTDMNDDETSCUBE.MATERIALGROUP == T023.MATKL
Order type in order header
  • Client
  • Sales Document Type
  • I_SUPASSGMTDMNDDETSCUBE.MANDT == TVAK.MANDT
  • I_SUPASSGMTDMNDDETSCUBE.ORDERTYPE == TVAK.AUART
Partner function - Document partner
  • Client
  • Partner Function
  • I_SUPASSGMTDMNDDETSCUBE.MANDT == TPAR.MANDT
  • I_SUPASSGMTDMNDDETSCUBE.PARTNERFUNCTION == TPAR.PARVW
Fashion Collection
  • Fashion Collection
  • Season
  • Season Year
  • Client
Season
  • Season
  • Season Year
  • Client
  • I_SUPASSGMTDMNDDETSCUBE.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON
  • I_SUPASSGMTDMNDDETSCUBE.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR
  • I_SUPASSGMTDMNDDETSCUBE.MANDT == FSH_SEASONS.MANDT
Season Year
  • Season
  • Season Year
  • Client
  • I_SUPASSGMTDMNDDETSCUBE.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON
  • I_SUPASSGMTDMNDDETSCUBE.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR
  • I_SUPASSGMTDMNDDETSCUBE.MANDT == FSH_SEASONS.MANDT
Fashion Theme
  • Fashion Collection
  • Season
  • Season Year
  • Client
  • Fashion Theme
  • I_SUPASSGMTDMNDDETSCUBE.PRODUCTCOLLECTION == FSH_THEMES.FSH_COLLECTION
  • I_SUPASSGMTDMNDDETSCUBE.PRODUCTSEASON == FSH_THEMES.FSH_SEASON
  • I_SUPASSGMTDMNDDETSCUBE.PRODUCTSEASONYEAR == FSH_THEMES.FSH_SEASON_YEAR
  • I_SUPASSGMTDMNDDETSCUBE.MANDT == FSH_THEMES.MANDT
  • I_SUPASSGMTDMNDDETSCUBE.PRODUCTTHEME == FSH_THEMES.FSH_THEME
Sales document item category
  • Client
  • Sales document item category
  • I_SUPASSGMTDMNDDETSCUBE.MANDT == TVPT.MANDT
  • I_SUPASSGMTDMNDDETSCUBE.SALESDOCUMENTITEMCATEGORY == TVPT.PSTYV
Shipping Conditions
  • Client
  • Shipping Conditions
  • I_SUPASSGMTDMNDDETSCUBE.MANDT == TVSB.MANDT
  • I_SUPASSGMTDMNDDETSCUBE.SHIPPINGCONDITION == TVSB.VSBED
Storage location
  • Storage location
  • Client
  • Plant (Own or External)
  • I_SUPASSGMTDMNDDETSCUBE.STORAGELOCATION == T001L.LGORT
  • I_SUPASSGMTDMNDDETSCUBE.MANDT == T001L.MANDT
  • I_SUPASSGMTDMNDDETSCUBE.PLANT == T001L.WERKS