RFM_SCC_SALESDOCUMENTS

CDS view to Select Sales Docs for Manage Season Completeness | view: RFMSCCSDORD | TRAN | Extraction: Not supported | Component: Season
Tables used: VBAP, VBKD, VEDA, VBAK, VBAK, VBAP, VBKD, VEDA, VBEP, VBPA, VBPA, CVI_CUST_CT_LINK, BUT000, CVI_CUST_LINK, CVI_VEND_LINK, RFM_SEASONS
Column Name Description
SalesDocument FK Sales Document
SalesDocumentItem Sales Document Item
Column Name Description
Column Name Description
Column Name Description
RequestedDeliveryDate Schedule line date
SalesDocumentDate Document Date (Date Received/Sent)
Column Name Description
Column Name Description Domain name
RequirementSegment Requirement Segment SGT_SRCA
Plant Plant (Own or External) WERKS
PartnerShipToParty Ship-to Party KUNNR
PartnerMarkFor Mark-For Partner KUNNR
PartnerPayer Payer KUNNR
PartnerBillToParty Bill-to Party KUNNR
PartnerFunction Partner Function PARVW
Customer Customer Number KUNNR
rfm_sea_group_id Season Completeness Group RFM_SEASON_COMPLETNESS
rfm_priority Priority RFM_PRIORITY
Master Data Relations Join Conditions
Customer Group 1
  • Customer Group 1
  • Client
  • RFM_SCC_SALESDOCUMENTS.ADDITIONALCUSTOMERGROUP1 == TVV1.KVGR1
  • RFM_SCC_SALESDOCUMENTS.MANDT == TVV1.MANDT
Customer Group 2
  • Client
  • Customer Group 2
  • RFM_SCC_SALESDOCUMENTS.MANDT == TVV2.MANDT
  • RFM_SCC_SALESDOCUMENTS.ADDITIONALCUSTOMERGROUP2 == TVV2.KVGR2
Customer Group 3
  • Customer Group 3
  • Client
  • RFM_SCC_SALESDOCUMENTS.ADDITIONALCUSTOMERGROUP3 == TVV3.KVGR3
  • RFM_SCC_SALESDOCUMENTS.MANDT == TVV3.MANDT
Customer Group 4
  • Customer Group 4
  • Client
  • RFM_SCC_SALESDOCUMENTS.ADDITIONALCUSTOMERGROUP4 == TVV4.KVGR4
  • RFM_SCC_SALESDOCUMENTS.MANDT == TVV4.MANDT
Customer Group 5
  • Client
  • Customer Group 5
  • RFM_SCC_SALESDOCUMENTS.MANDT == TVV5.MANDT
  • RFM_SCC_SALESDOCUMENTS.ADDITIONALCUSTOMERGROUP5 == TVV5.KVGR5
Material Group 1
  • Client
  • Material Group 1
  • RFM_SCC_SALESDOCUMENTS.MANDT == TVM1.MANDT
  • RFM_SCC_SALESDOCUMENTS.ADDITIONALMATERIALGROUP1 == TVM1.MVGR1
Material Group 2
  • Material Group 2
  • Client
  • RFM_SCC_SALESDOCUMENTS.ADDITIONALMATERIALGROUP2 == TVM2.MVGR2
  • RFM_SCC_SALESDOCUMENTS.MANDT == TVM2.MANDT
Material Group 3
  • Material Group 3
  • Client
  • RFM_SCC_SALESDOCUMENTS.ADDITIONALMATERIALGROUP3 == TVM3.MVGR3
  • RFM_SCC_SALESDOCUMENTS.MANDT == TVM3.MANDT
Material Group 4
  • Client
  • Material Group 4
  • RFM_SCC_SALESDOCUMENTS.MANDT == TVM4.MANDT
  • RFM_SCC_SALESDOCUMENTS.ADDITIONALMATERIALGROUP4 == TVM4.MVGR4
Material Group 5
  • Client
  • Material Group 5
  • RFM_SCC_SALESDOCUMENTS.MANDT == TVM5.MANDT
  • RFM_SCC_SALESDOCUMENTS.ADDITIONALMATERIALGROUP5 == TVM5.MVGR5
Distribution channel in order header
  • Client
  • Sales Organization
  • Distribution Channel
  • RFM_SCC_SALESDOCUMENTS.MANDT == TVKOV.MANDT
  • RFM_SCC_SALESDOCUMENTS.SALESORGANIZATION == TVKOV.VKORG
  • RFM_SCC_SALESDOCUMENTS.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Material: order item
  • Material Number
  • Client
  • RFM_SCC_SALESDOCUMENTS.MATERIAL == MARA.MATNR
  • RFM_SCC_SALESDOCUMENTS.MANDT == MARA.MANDT
Material Group
  • Client
  • Material Group
  • RFM_SCC_SALESDOCUMENTS.MANDT == T023.MANDT
  • RFM_SCC_SALESDOCUMENTS.MATERIALGROUP == T023.MATKL
Division
  • Division
  • Client
  • RFM_SCC_SALESDOCUMENTS.ORGANIZATIONDIVISION == TSPA.SPART
  • RFM_SCC_SALESDOCUMENTS.MANDT == TSPA.MANDT
Fashion Collection
  • Season
  • Season Year
  • Fashion Collection
  • Client
Season
  • Season
  • Season Year
  • Client
  • RFM_SCC_SALESDOCUMENTS.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON
  • RFM_SCC_SALESDOCUMENTS.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR
  • RFM_SCC_SALESDOCUMENTS.MANDT == FSH_SEASONS.MANDT
Season Year
  • Season
  • Season Year
  • Client
  • RFM_SCC_SALESDOCUMENTS.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON
  • RFM_SCC_SALESDOCUMENTS.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR
  • RFM_SCC_SALESDOCUMENTS.MANDT == FSH_SEASONS.MANDT
Fashion Theme
  • Season
  • Season Year
  • Fashion Collection
  • Fashion Theme
  • Client
  • RFM_SCC_SALESDOCUMENTS.PRODUCTSEASON == FSH_THEMES.FSH_SEASON
  • RFM_SCC_SALESDOCUMENTS.PRODUCTSEASONYEAR == FSH_THEMES.FSH_SEASON_YEAR
  • RFM_SCC_SALESDOCUMENTS.PRODUCTCOLLECTION == FSH_THEMES.FSH_COLLECTION
  • RFM_SCC_SALESDOCUMENTS.PRODUCTTHEME == FSH_THEMES.FSH_THEME
  • RFM_SCC_SALESDOCUMENTS.MANDT == FSH_THEMES.MANDT
Order type in order header
  • Client
  • Sales Document Type
  • RFM_SCC_SALESDOCUMENTS.MANDT == TVAK.MANDT
  • RFM_SCC_SALESDOCUMENTS.SALESDOCUMENTTYPE == TVAK.AUART
Sales organization in order header
  • Client
  • Sales Organization
  • RFM_SCC_SALESDOCUMENTS.MANDT == TVKO.MANDT
  • RFM_SCC_SALESDOCUMENTS.SALESORGANIZATION == TVKO.VKORG
Season Category
  • Season Category
  • Client
Shipping Point / Receiving Point
  • Shipping Point / Receiving Point
  • Client
  • RFM_SCC_SALESDOCUMENTS.SHIPPINGPOINT == TVST.VSTEL
  • RFM_SCC_SALESDOCUMENTS.MANDT == TVST.MANDT
Sold-to Party
  • Sold-to Party
  • Client
  • RFM_SCC_SALESDOCUMENTS.SOLDTOPARTY == KNA1.KUNNR
  • RFM_SCC_SALESDOCUMENTS.MANDT == KNA1.MANDT
Storage location
  • Plant (Own or External)
  • Client
  • Storage location
  • RFM_SCC_SALESDOCUMENTS.PLANT == T001L.WERKS
  • RFM_SCC_SALESDOCUMENTS.MANDT == T001L.MANDT
  • RFM_SCC_SALESDOCUMENTS.STORAGELOCATION == T001L.LGORT