C_RFM_MaSaDoSlsHdrCustBasic

Sales Document and Customer Details | view: CRFMMASADOBASIC | TRAN | Extraction: Not supported | Component: Retail & Fashion Sales and Distribution
Tables used: VBAK, VBKD, VBPA, VBPA, VBPA, CVI_CUST_CT_LINK, BUT000, KNA1, CVI_CUST_LINK, KNVV, CVI_VEND_LINK
Column Name Description
SalesDocument Sales Document
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
SlsOrdCustomerPaymentTerms Terms of payment key ZTERM
CustomerPaymentTerms Terms of payment key ZTERM
SlsOrdIncotermsLocation1 Incoterms Location 1 INCO_L
IncotermsLocation1 Incoterms Location 1 INCO_L
Master Data Relations Join Conditions
Customer Group 1
  • Customer Group 1
  • Customer Group 1
  • Client
  • C_RFM_MASADOSLSHDRCUSTBASIC.ADDITIONALCUSTOMERGROUP1 == TVV1.KVGR1
  • C_RFM_MASADOSLSHDRCUSTBASIC.SLSORDADDLCUSTOMERGROUP1 == TVV1.KVGR1
  • C_RFM_MASADOSLSHDRCUSTBASIC.MANDT == TVV1.MANDT
Customer Group 2
  • Customer Group 2
  • Customer Group 2
  • Client
  • C_RFM_MASADOSLSHDRCUSTBASIC.SLSORDADDLCUSTOMERGROUP2 == TVV2.KVGR2
  • C_RFM_MASADOSLSHDRCUSTBASIC.ADDITIONALCUSTOMERGROUP2 == TVV2.KVGR2
  • C_RFM_MASADOSLSHDRCUSTBASIC.MANDT == TVV2.MANDT
Customer Group 3
  • Customer Group 3
  • Customer Group 3
  • Client
  • C_RFM_MASADOSLSHDRCUSTBASIC.ADDITIONALCUSTOMERGROUP3 == TVV3.KVGR3
  • C_RFM_MASADOSLSHDRCUSTBASIC.SLSORDADDLCUSTOMERGROUP3 == TVV3.KVGR3
  • C_RFM_MASADOSLSHDRCUSTBASIC.MANDT == TVV3.MANDT
Customer Group 4
  • Customer Group 4
  • Customer Group 4
  • Client
  • C_RFM_MASADOSLSHDRCUSTBASIC.ADDITIONALCUSTOMERGROUP4 == TVV4.KVGR4
  • C_RFM_MASADOSLSHDRCUSTBASIC.SLSORDADDLCUSTOMERGROUP4 == TVV4.KVGR4
  • C_RFM_MASADOSLSHDRCUSTBASIC.MANDT == TVV4.MANDT
Customer Group 5
  • Customer Group 5
  • Customer Group 5
  • Client
  • C_RFM_MASADOSLSHDRCUSTBASIC.SLSORDADDLCUSTOMERGROUP5 == TVV5.KVGR5
  • C_RFM_MASADOSLSHDRCUSTBASIC.ADDITIONALCUSTOMERGROUP5 == TVV5.KVGR5
  • C_RFM_MASADOSLSHDRCUSTBASIC.MANDT == TVV5.MANDT
Customer Group
  • Customer Group
  • Customer Group
  • Client
  • C_RFM_MASADOSLSHDRCUSTBASIC.SALESORDERCUSTOMERGROUP == T151.KDGRP
  • C_RFM_MASADOSLSHDRCUSTBASIC.CUSTOMERGROUP == T151.KDGRP
  • C_RFM_MASADOSLSHDRCUSTBASIC.MANDT == T151.MANDT
Customer Price Group
  • Customer Price Group
  • Customer Price Group
  • Client
  • C_RFM_MASADOSLSHDRCUSTBASIC.SALESORDERCUSTOMERPRICEGROUP == T188.KONDA
  • C_RFM_MASADOSLSHDRCUSTBASIC.CUSTOMERPRICEGROUP == T188.KONDA
  • C_RFM_MASADOSLSHDRCUSTBASIC.MANDT == T188.MANDT
Distribution channel in order header
  • Distribution Channel
  • Client
  • Sales Organization
  • C_RFM_MASADOSLSHDRCUSTBASIC.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • C_RFM_MASADOSLSHDRCUSTBASIC.MANDT == TVKOV.MANDT
  • C_RFM_MASADOSLSHDRCUSTBASIC.SALESORGANIZATION == TVKOV.VKORG
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • C_RFM_MASADOSLSHDRCUSTBASIC.INCOTERMSCLASSIFICATION == TINC.INCO1
  • C_RFM_MASADOSLSHDRCUSTBASIC.SLSORDINCOTERMSCLASSIFICATION == TINC.INCO1
  • C_RFM_MASADOSLSHDRCUSTBASIC.MANDT == TINC.MANDT
Customer - Document Customer
  • Sold-to Party
  • Customer Number
  • Customer Number
  • Client
  • C_RFM_MASADOSLSHDRCUSTBASIC.SOLDTOPARTY == KNA1.KUNNR
  • C_RFM_MASADOSLSHDRCUSTBASIC.MARKFOR == KNA1.KUNNR
  • C_RFM_MASADOSLSHDRCUSTBASIC.SHIPTOPARTY == KNA1.KUNNR
  • C_RFM_MASADOSLSHDRCUSTBASIC.MANDT == KNA1.MANDT
Division in order header
  • Distribution Channel
  • Client
  • Division
  • Sales Organization
  • C_RFM_MASADOSLSHDRCUSTBASIC.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • C_RFM_MASADOSLSHDRCUSTBASIC.MANDT == TVTA.MANDT
  • C_RFM_MASADOSLSHDRCUSTBASIC.ORGANIZATIONDIVISION == TVTA.SPART
  • C_RFM_MASADOSLSHDRCUSTBASIC.SALESORGANIZATION == TVTA.VKORG
Customer Group 10
  • Customer Group 10
  • Customer Group 10
  • Client
  • Sales Organization
  • C_RFM_MASADOSLSHDRCUSTBASIC.SLSORDRETAILADDLCUSTOMERGRP10 == FSH_TVV10.KVGR10
  • C_RFM_MASADOSLSHDRCUSTBASIC.RETAILADDITIONALCUSTOMERGRP10 == FSH_TVV10.KVGR10
  • C_RFM_MASADOSLSHDRCUSTBASIC.MANDT == FSH_TVV10.MANDT
  • C_RFM_MASADOSLSHDRCUSTBASIC.SALESORGANIZATION == FSH_TVV10.VKORG
Customer Group 6
  • Customer Group 6
  • Customer Group 6
  • Client
  • Sales Organization
  • C_RFM_MASADOSLSHDRCUSTBASIC.RETAILADDITIONALCUSTOMERGRP6 == FSH_TVV6.KVGR6
  • C_RFM_MASADOSLSHDRCUSTBASIC.SLSORDRETAILADDLCUSTOMERGRP6 == FSH_TVV6.KVGR6
  • C_RFM_MASADOSLSHDRCUSTBASIC.MANDT == FSH_TVV6.MANDT
  • C_RFM_MASADOSLSHDRCUSTBASIC.SALESORGANIZATION == FSH_TVV6.VKORG
Customer Group 7
  • Customer Group 7
  • Customer Group 7
  • Client
  • Sales Organization
  • C_RFM_MASADOSLSHDRCUSTBASIC.RETAILADDITIONALCUSTOMERGRP7 == FSH_TVV7.KVGR7
  • C_RFM_MASADOSLSHDRCUSTBASIC.SLSORDRETAILADDLCUSTOMERGRP7 == FSH_TVV7.KVGR7
  • C_RFM_MASADOSLSHDRCUSTBASIC.MANDT == FSH_TVV7.MANDT
  • C_RFM_MASADOSLSHDRCUSTBASIC.SALESORGANIZATION == FSH_TVV7.VKORG
Customer Group 8
  • Customer Group 8
  • Customer Group 8
  • Client
  • Sales Organization
  • C_RFM_MASADOSLSHDRCUSTBASIC.RETAILADDITIONALCUSTOMERGRP8 == FSH_TVV8.KVGR8
  • C_RFM_MASADOSLSHDRCUSTBASIC.SLSORDRETAILADDLCUSTOMERGRP8 == FSH_TVV8.KVGR8
  • C_RFM_MASADOSLSHDRCUSTBASIC.MANDT == FSH_TVV8.MANDT
  • C_RFM_MASADOSLSHDRCUSTBASIC.SALESORGANIZATION == FSH_TVV8.VKORG
Customer Group 9
  • Customer Group 9
  • Customer Group 9
  • Client
  • Sales Organization
  • C_RFM_MASADOSLSHDRCUSTBASIC.SLSORDRETAILADDLCUSTOMERGRP9 == FSH_TVV9.KVGR9
  • C_RFM_MASADOSLSHDRCUSTBASIC.RETAILADDITIONALCUSTOMERGRP9 == FSH_TVV9.KVGR9
  • C_RFM_MASADOSLSHDRCUSTBASIC.MANDT == FSH_TVV9.MANDT
  • C_RFM_MASADOSLSHDRCUSTBASIC.SALESORGANIZATION == FSH_TVV9.VKORG
Sales District
  • Sales District
  • Sales District
  • Client
  • C_RFM_MASADOSLSHDRCUSTBASIC.SALESORDERSALESDISTRICT == T171.BZIRK
  • C_RFM_MASADOSLSHDRCUSTBASIC.SALESDISTRICT == T171.BZIRK
  • C_RFM_MASADOSLSHDRCUSTBASIC.MANDT == T171.MANDT
Order type in order header
  • Sales Document Type
  • Client
  • C_RFM_MASADOSLSHDRCUSTBASIC.SALESDOCUMENTTYPE == TVAK.AUART
  • C_RFM_MASADOSLSHDRCUSTBASIC.MANDT == TVAK.MANDT
Sales office
  • Sales office
  • Sales office
  • Client
  • C_RFM_MASADOSLSHDRCUSTBASIC.SALESOFFICE == TVBUR.VKBUR
  • C_RFM_MASADOSLSHDRCUSTBASIC.SLSORDSALESOFFICE == TVBUR.VKBUR
  • C_RFM_MASADOSLSHDRCUSTBASIC.MANDT == TVBUR.MANDT
Customer Group
  • Customer Group
  • Customer Group
  • Client
  • C_RFM_MASADOSLSHDRCUSTBASIC.SALESORDERCUSTOMERGROUP == T151.KDGRP
  • C_RFM_MASADOSLSHDRCUSTBASIC.CUSTOMERGROUP == T151.KDGRP
  • C_RFM_MASADOSLSHDRCUSTBASIC.MANDT == T151.MANDT
Customer Price Group
  • Customer Price Group
  • Customer Price Group
  • Client
  • C_RFM_MASADOSLSHDRCUSTBASIC.SALESORDERCUSTOMERPRICEGROUP == T188.KONDA
  • C_RFM_MASADOSLSHDRCUSTBASIC.CUSTOMERPRICEGROUP == T188.KONDA
  • C_RFM_MASADOSLSHDRCUSTBASIC.MANDT == T188.MANDT
Sales District
  • Sales District
  • Sales District
  • Client
  • C_RFM_MASADOSLSHDRCUSTBASIC.SALESORDERSALESDISTRICT == T171.BZIRK
  • C_RFM_MASADOSLSHDRCUSTBASIC.SALESDISTRICT == T171.BZIRK
  • C_RFM_MASADOSLSHDRCUSTBASIC.MANDT == T171.MANDT
Sales organization in order header
  • Client
  • Sales Organization
  • C_RFM_MASADOSLSHDRCUSTBASIC.MANDT == TVKO.MANDT
  • C_RFM_MASADOSLSHDRCUSTBASIC.SALESORGANIZATION == TVKO.VKORG
Shipping Conditions
  • Shipping Conditions
  • Shipping Conditions
  • Client
  • C_RFM_MASADOSLSHDRCUSTBASIC.SHIPPINGCONDITION == TVSB.VSBED
  • C_RFM_MASADOSLSHDRCUSTBASIC.SLSORDSHIPPINGCONDITION == TVSB.VSBED
  • C_RFM_MASADOSLSHDRCUSTBASIC.MANDT == TVSB.MANDT
Customer - Document Customer
  • Sold-to Party
  • Customer Number
  • Customer Number
  • Client
  • C_RFM_MASADOSLSHDRCUSTBASIC.SOLDTOPARTY == KNA1.KUNNR
  • C_RFM_MASADOSLSHDRCUSTBASIC.MARKFOR == KNA1.KUNNR
  • C_RFM_MASADOSLSHDRCUSTBASIC.SHIPTOPARTY == KNA1.KUNNR
  • C_RFM_MASADOSLSHDRCUSTBASIC.MANDT == KNA1.MANDT
Customer Group 1
  • Customer Group 1
  • Customer Group 1
  • Client
  • C_RFM_MASADOSLSHDRCUSTBASIC.ADDITIONALCUSTOMERGROUP1 == TVV1.KVGR1
  • C_RFM_MASADOSLSHDRCUSTBASIC.SLSORDADDLCUSTOMERGROUP1 == TVV1.KVGR1
  • C_RFM_MASADOSLSHDRCUSTBASIC.MANDT == TVV1.MANDT
Customer Group 2
  • Customer Group 2
  • Customer Group 2
  • Client
  • C_RFM_MASADOSLSHDRCUSTBASIC.SLSORDADDLCUSTOMERGROUP2 == TVV2.KVGR2
  • C_RFM_MASADOSLSHDRCUSTBASIC.ADDITIONALCUSTOMERGROUP2 == TVV2.KVGR2
  • C_RFM_MASADOSLSHDRCUSTBASIC.MANDT == TVV2.MANDT
Customer Group 3
  • Customer Group 3
  • Customer Group 3
  • Client
  • C_RFM_MASADOSLSHDRCUSTBASIC.ADDITIONALCUSTOMERGROUP3 == TVV3.KVGR3
  • C_RFM_MASADOSLSHDRCUSTBASIC.SLSORDADDLCUSTOMERGROUP3 == TVV3.KVGR3
  • C_RFM_MASADOSLSHDRCUSTBASIC.MANDT == TVV3.MANDT
Customer Group 4
  • Customer Group 4
  • Customer Group 4
  • Client
  • C_RFM_MASADOSLSHDRCUSTBASIC.ADDITIONALCUSTOMERGROUP4 == TVV4.KVGR4
  • C_RFM_MASADOSLSHDRCUSTBASIC.SLSORDADDLCUSTOMERGROUP4 == TVV4.KVGR4
  • C_RFM_MASADOSLSHDRCUSTBASIC.MANDT == TVV4.MANDT
Customer Group 5
  • Customer Group 5
  • Customer Group 5
  • Client
  • C_RFM_MASADOSLSHDRCUSTBASIC.SLSORDADDLCUSTOMERGROUP5 == TVV5.KVGR5
  • C_RFM_MASADOSLSHDRCUSTBASIC.ADDITIONALCUSTOMERGROUP5 == TVV5.KVGR5
  • C_RFM_MASADOSLSHDRCUSTBASIC.MANDT == TVV5.MANDT
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • C_RFM_MASADOSLSHDRCUSTBASIC.INCOTERMSCLASSIFICATION == TINC.INCO1
  • C_RFM_MASADOSLSHDRCUSTBASIC.SLSORDINCOTERMSCLASSIFICATION == TINC.INCO1
  • C_RFM_MASADOSLSHDRCUSTBASIC.MANDT == TINC.MANDT
Customer Group 10
  • Customer Group 10
  • Customer Group 10
  • Client
  • Sales Organization
  • C_RFM_MASADOSLSHDRCUSTBASIC.SLSORDRETAILADDLCUSTOMERGRP10 == FSH_TVV10.KVGR10
  • C_RFM_MASADOSLSHDRCUSTBASIC.RETAILADDITIONALCUSTOMERGRP10 == FSH_TVV10.KVGR10
  • C_RFM_MASADOSLSHDRCUSTBASIC.MANDT == FSH_TVV10.MANDT
  • C_RFM_MASADOSLSHDRCUSTBASIC.SALESORGANIZATION == FSH_TVV10.VKORG
Customer Group 6
  • Customer Group 6
  • Customer Group 6
  • Client
  • Sales Organization
  • C_RFM_MASADOSLSHDRCUSTBASIC.RETAILADDITIONALCUSTOMERGRP6 == FSH_TVV6.KVGR6
  • C_RFM_MASADOSLSHDRCUSTBASIC.SLSORDRETAILADDLCUSTOMERGRP6 == FSH_TVV6.KVGR6
  • C_RFM_MASADOSLSHDRCUSTBASIC.MANDT == FSH_TVV6.MANDT
  • C_RFM_MASADOSLSHDRCUSTBASIC.SALESORGANIZATION == FSH_TVV6.VKORG
Customer Group 7
  • Customer Group 7
  • Customer Group 7
  • Client
  • Sales Organization
  • C_RFM_MASADOSLSHDRCUSTBASIC.RETAILADDITIONALCUSTOMERGRP7 == FSH_TVV7.KVGR7
  • C_RFM_MASADOSLSHDRCUSTBASIC.SLSORDRETAILADDLCUSTOMERGRP7 == FSH_TVV7.KVGR7
  • C_RFM_MASADOSLSHDRCUSTBASIC.MANDT == FSH_TVV7.MANDT
  • C_RFM_MASADOSLSHDRCUSTBASIC.SALESORGANIZATION == FSH_TVV7.VKORG
Customer Group 8
  • Customer Group 8
  • Customer Group 8
  • Client
  • Sales Organization
  • C_RFM_MASADOSLSHDRCUSTBASIC.RETAILADDITIONALCUSTOMERGRP8 == FSH_TVV8.KVGR8
  • C_RFM_MASADOSLSHDRCUSTBASIC.SLSORDRETAILADDLCUSTOMERGRP8 == FSH_TVV8.KVGR8
  • C_RFM_MASADOSLSHDRCUSTBASIC.MANDT == FSH_TVV8.MANDT
  • C_RFM_MASADOSLSHDRCUSTBASIC.SALESORGANIZATION == FSH_TVV8.VKORG
Customer Group 9
  • Customer Group 9
  • Customer Group 9
  • Client
  • Sales Organization
  • C_RFM_MASADOSLSHDRCUSTBASIC.SLSORDRETAILADDLCUSTOMERGRP9 == FSH_TVV9.KVGR9
  • C_RFM_MASADOSLSHDRCUSTBASIC.RETAILADDITIONALCUSTOMERGRP9 == FSH_TVV9.KVGR9
  • C_RFM_MASADOSLSHDRCUSTBASIC.MANDT == FSH_TVV9.MANDT
  • C_RFM_MASADOSLSHDRCUSTBASIC.SALESORGANIZATION == FSH_TVV9.VKORG
Shipping Conditions
  • Shipping Conditions
  • Shipping Conditions
  • Client
  • C_RFM_MASADOSLSHDRCUSTBASIC.SHIPPINGCONDITION == TVSB.VSBED
  • C_RFM_MASADOSLSHDRCUSTBASIC.SLSORDSHIPPINGCONDITION == TVSB.VSBED
  • C_RFM_MASADOSLSHDRCUSTBASIC.MANDT == TVSB.MANDT
Sold-to Party
  • Sold-to Party
  • Customer Number
  • Customer Number
  • Client
  • C_RFM_MASADOSLSHDRCUSTBASIC.SOLDTOPARTY == KNA1.KUNNR
  • C_RFM_MASADOSLSHDRCUSTBASIC.MARKFOR == KNA1.KUNNR
  • C_RFM_MASADOSLSHDRCUSTBASIC.SHIPTOPARTY == KNA1.KUNNR
  • C_RFM_MASADOSLSHDRCUSTBASIC.MANDT == KNA1.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Sales office
  • Sales office
  • Distribution Channel
  • Client
  • Division
  • Sales Organization
  • C_RFM_MASADOSLSHDRCUSTBASIC.SALESOFFICE == TVKBZ.VKBUR
  • C_RFM_MASADOSLSHDRCUSTBASIC.SLSORDSALESOFFICE == TVKBZ.VKBUR
  • C_RFM_MASADOSLSHDRCUSTBASIC.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG
  • C_RFM_MASADOSLSHDRCUSTBASIC.MANDT == TVKBZ.MANDT
  • C_RFM_MASADOSLSHDRCUSTBASIC.ORGANIZATIONDIVISION == TVKBZ.SPART
  • C_RFM_MASADOSLSHDRCUSTBASIC.SALESORGANIZATION == TVKBZ.VKORG