P_SupAssgmtDmndDets

Supply Assignment Demand Order Item Details | view: PSADEMANDDETS | TRAN | Extraction: Not supported | Component: Order Allocation Run
Tables used: EKKO, EKPO, EKPV, RESB, VBAK, VBAP, VBKD, VBPA, LIPS, VBEP, EKET, CVI_CUST_CT_LINK, BUT000, CVI_CUST_LINK, T161T, TVAKT, MARA, MARC, KNA1, KNVV, CVI_VEND_LINK, VBBE
Column Name Description
Column Name Description
💲 SD Document Currency (DocumentCurrency):
NetPriceAmount Net Price
Column Name Description
RequestedRqmtQtyInBaseUnit null
ConfirmedRqmtQtyInBaseUnit null
DeliveredQuantityInBaseUnit null
OpenDemandQuantity null
Column Name Description
RequestedDeliveryDate null
FashionCancelDate Cancellation Date
Column Name Description
RequirementType Requirement Type Show values
Column Name Description Domain name
RequirementDocumentItem Sales Document Item POSNR
Plant Plant (Own or External) WERKS
SoldToParty Sold-to Party KUNNR
ShipToParty Customer Number KUNNR
RequirementSegment Requirement Segment SGT_SRCA
OrderTypeName Sales Document Type Description TEXT20
SupAssgmtOrdStatus null
FashionCancelDateHorizon null
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
PurchasingDocumentItem Item Number of Purchasing Document EBELP
Supplier Account Number of Supplier LIFNR
Master Data Relations Join Conditions
Release Rule
  • Client
  • Release Rule
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • P_SUPASSGMTDMNDDETS.MANDT == T006.MANDT
  • P_SUPASSGMTDMNDDETS.BASEUNIT == T006.MSEHI
Company Code to Be Billed
  • Company Code to Be Billed
  • Client
  • P_SUPASSGMTDMNDDETS.COMPANYCODE == T001.BUKRS
  • P_SUPASSGMTDMNDDETS.MANDT == T001.MANDT
Cross-Plant Configurable Material
  • Client
  • Cross-Plant Configurable Material
  • P_SUPASSGMTDMNDDETS.MANDT == MARA.MANDT
  • P_SUPASSGMTDMNDDETS.CROSSPLANTCONFIGURABLEPRODUCT == MARA.MATNR
Customer Group
  • Client
  • Customer Group
  • P_SUPASSGMTDMNDDETS.MANDT == T151.MANDT
  • P_SUPASSGMTDMNDDETS.CUSTOMERGROUP == T151.KDGRP
Delivery Block (Document Header)
  • Delivery Block (Document Header)
  • Client
  • P_SUPASSGMTDMNDDETS.DELIVERYBLOCKREASON == TVLS.LIFSP
  • P_SUPASSGMTDMNDDETS.MANDT == TVLS.MANDT
Distribution channel in order header
  • Client
  • Sales Organization
  • Distribution Channel
  • P_SUPASSGMTDMNDDETS.MANDT == TVKOV.MANDT
  • P_SUPASSGMTDMNDDETS.SALESORGANIZATION == TVKOV.VKORG
  • P_SUPASSGMTDMNDDETS.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Division
  • Client
  • Division
  • P_SUPASSGMTDMNDDETS.MANDT == TSPA.MANDT
  • P_SUPASSGMTDMNDDETS.DIVISION == TSPA.SPART
SD Document Currency
  • Client
  • SD Document Currency
  • P_SUPASSGMTDMNDDETS.MANDT == TCURC.MANDT
  • P_SUPASSGMTDMNDDETS.DOCUMENTCURRENCY == TCURC.WAERS
Billing Block for Item
  • Billing Block for Item
  • Client
  • P_SUPASSGMTDMNDDETS.ITEMBILLINGBLOCKREASON == TVFS.FAKSP
  • P_SUPASSGMTDMNDDETS.MANDT == TVFS.MANDT
Material: order item
  • Client
  • Material Number
  • P_SUPASSGMTDMNDDETS.MANDT == MARA.MANDT
  • P_SUPASSGMTDMNDDETS.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • P_SUPASSGMTDMNDDETS.MANDT == T023.MANDT
  • P_SUPASSGMTDMNDDETS.MATERIALGROUP == T023.MATKL
Order type in order header
  • Client
  • Sales Document Type
  • P_SUPASSGMTDMNDDETS.MANDT == TVAK.MANDT
  • P_SUPASSGMTDMNDDETS.ORDERTYPE == TVAK.AUART
Partner function - Document partner
  • Client
  • Partner Function
  • P_SUPASSGMTDMNDDETS.MANDT == TPAR.MANDT
  • P_SUPASSGMTDMNDDETS.PARTNERFUNCTION == TPAR.PARVW
Fashion Collection
  • Season Year
  • Client
  • Fashion Collection
  • Season
Season
  • Season Year
  • Client
  • Season
  • P_SUPASSGMTDMNDDETS.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR
  • P_SUPASSGMTDMNDDETS.MANDT == FSH_SEASONS.MANDT
  • P_SUPASSGMTDMNDDETS.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON
Season Year
  • Season Year
  • Client
  • Season
  • P_SUPASSGMTDMNDDETS.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR
  • P_SUPASSGMTDMNDDETS.MANDT == FSH_SEASONS.MANDT
  • P_SUPASSGMTDMNDDETS.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON
Fashion Theme
  • Season Year
  • Fashion Theme
  • Client
  • Fashion Collection
  • Season
  • P_SUPASSGMTDMNDDETS.PRODUCTSEASONYEAR == FSH_THEMES.FSH_SEASON_YEAR
  • P_SUPASSGMTDMNDDETS.PRODUCTTHEME == FSH_THEMES.FSH_THEME
  • P_SUPASSGMTDMNDDETS.MANDT == FSH_THEMES.MANDT
  • P_SUPASSGMTDMNDDETS.PRODUCTCOLLECTION == FSH_THEMES.FSH_COLLECTION
  • P_SUPASSGMTDMNDDETS.PRODUCTSEASON == FSH_THEMES.FSH_SEASON
Sales District
  • Sales District
  • Client
  • P_SUPASSGMTDMNDDETS.SALESDISTRICT == T171.BZIRK
  • P_SUPASSGMTDMNDDETS.MANDT == T171.MANDT
Sales document item category
  • Client
  • Sales document item category
  • P_SUPASSGMTDMNDDETS.MANDT == TVPT.MANDT
  • P_SUPASSGMTDMNDDETS.SALESDOCUMENTITEMCATEGORY == TVPT.PSTYV
Sales organization in order header
  • Client
  • Sales Organization
  • P_SUPASSGMTDMNDDETS.MANDT == TVKO.MANDT
  • P_SUPASSGMTDMNDDETS.SALESORGANIZATION == TVKO.VKORG
Shipping Conditions
  • Client
  • Shipping Conditions
  • P_SUPASSGMTDMNDDETS.MANDT == TVSB.MANDT
  • P_SUPASSGMTDMNDDETS.SHIPPINGCONDITION == TVSB.VSBED
Shipping Point / Receiving Point
  • Client
  • Shipping Point / Receiving Point
  • P_SUPASSGMTDMNDDETS.MANDT == TVST.MANDT
  • P_SUPASSGMTDMNDDETS.SHIPPINGPOINT == TVST.VSTEL
Storage location
  • Client
  • Storage location
  • Plant (Own or External)
  • P_SUPASSGMTDMNDDETS.MANDT == T001L.MANDT
  • P_SUPASSGMTDMNDDETS.STORAGELOCATION == T001L.LGORT
  • P_SUPASSGMTDMNDDETS.PLANT == T001L.WERKS