C_RFM_MaSaDoSlsItmCustBasic

Sales Document Item and Customer Details | view: CRFMMASADOITMBSC | TRAN | Extraction: Not supported | Component: Retail & Fashion Sales and Distribution
Tables used: VBAK, VBAP, VBKD, VBPA, CVI_CUST_CT_LINK, BUT000, KNA1, CVI_CUST_LINK, KNVV, CVI_VEND_LINK
Column Name Description
SalesDocument FK Sales Document
SalesDocumentItem Sales Document Item
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
ShipToParty Customer Number KUNNR
MarkFor Customer Number KUNNR
FormattedSalesDocumentItem Sales Document Item CHAR17
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
  • Customer Group
  • Customer Group
  • Client
  • C_RFM_MASADOSLSITMCUSTBASIC.CUSTOMERGROUP == T151.KDGRP
  • C_RFM_MASADOSLSITMCUSTBASIC.SALESORDERCUSTOMERGROUP == T151.KDGRP
  • C_RFM_MASADOSLSITMCUSTBASIC.MANDT == T151.MANDT
Customer Price Group
  • Customer Price Group
  • Customer Price Group
  • Client
  • C_RFM_MASADOSLSITMCUSTBASIC.SALESORDERCUSTOMERPRICEGROUP == T188.KONDA
  • C_RFM_MASADOSLSITMCUSTBASIC.CUSTOMERPRICEGROUP == T188.KONDA
  • C_RFM_MASADOSLSITMCUSTBASIC.MANDT == T188.MANDT
Delivery Priority
  • Delivery Priority
  • Delivery Priority
  • Client
  • C_RFM_MASADOSLSITMCUSTBASIC.SALESORDERDELIVERYPRIORITY == TPRIO.LPRIO
  • C_RFM_MASADOSLSITMCUSTBASIC.DELIVERYPRIORITY == TPRIO.LPRIO
  • C_RFM_MASADOSLSITMCUSTBASIC.MANDT == TPRIO.MANDT
Distribution channel in order header
  • Sales Organization
  • Distribution Channel
  • Client
  • C_RFM_MASADOSLSITMCUSTBASIC.SALESORGANIZATION == TVKOV.VKORG
  • C_RFM_MASADOSLSITMCUSTBASIC.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • C_RFM_MASADOSLSITMCUSTBASIC.MANDT == TVKOV.MANDT
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • C_RFM_MASADOSLSITMCUSTBASIC.INCOTERMSCLASSIFICATION == TINC.INCO1
  • C_RFM_MASADOSLSITMCUSTBASIC.SLSORDINCOTERMSCLASSIFICATION == TINC.INCO1
  • C_RFM_MASADOSLSITMCUSTBASIC.MANDT == TINC.MANDT
Division in order header
  • Division
  • Sales Organization
  • Distribution Channel
  • Client
  • C_RFM_MASADOSLSITMCUSTBASIC.ORGANIZATIONDIVISION == TVTA.SPART
  • C_RFM_MASADOSLSITMCUSTBASIC.SALESORGANIZATION == TVTA.VKORG
  • C_RFM_MASADOSLSITMCUSTBASIC.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • C_RFM_MASADOSLSITMCUSTBASIC.MANDT == TVTA.MANDT
Order type in order header
  • Sales Document Type
  • Client
  • C_RFM_MASADOSLSITMCUSTBASIC.SALESDOCUMENTTYPE == TVAK.AUART
  • C_RFM_MASADOSLSITMCUSTBASIC.MANDT == TVAK.MANDT
Customer Group
  • Customer Group
  • Customer Group
  • Client
  • C_RFM_MASADOSLSITMCUSTBASIC.CUSTOMERGROUP == T151.KDGRP
  • C_RFM_MASADOSLSITMCUSTBASIC.SALESORDERCUSTOMERGROUP == T151.KDGRP
  • C_RFM_MASADOSLSITMCUSTBASIC.MANDT == T151.MANDT
Customer Price Group
  • Customer Price Group
  • Customer Price Group
  • Client
  • C_RFM_MASADOSLSITMCUSTBASIC.SALESORDERCUSTOMERPRICEGROUP == T188.KONDA
  • C_RFM_MASADOSLSITMCUSTBASIC.CUSTOMERPRICEGROUP == T188.KONDA
  • C_RFM_MASADOSLSITMCUSTBASIC.MANDT == T188.MANDT
Delivery Priority
  • Delivery Priority
  • Delivery Priority
  • Client
  • C_RFM_MASADOSLSITMCUSTBASIC.SALESORDERDELIVERYPRIORITY == TPRIO.LPRIO
  • C_RFM_MASADOSLSITMCUSTBASIC.DELIVERYPRIORITY == TPRIO.LPRIO
  • C_RFM_MASADOSLSITMCUSTBASIC.MANDT == TPRIO.MANDT
Sales organization in order header
  • Sales Organization
  • Client
  • C_RFM_MASADOSLSITMCUSTBASIC.SALESORGANIZATION == TVKO.VKORG
  • C_RFM_MASADOSLSITMCUSTBASIC.MANDT == TVKO.MANDT
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • C_RFM_MASADOSLSITMCUSTBASIC.INCOTERMSCLASSIFICATION == TINC.INCO1
  • C_RFM_MASADOSLSITMCUSTBASIC.SLSORDINCOTERMSCLASSIFICATION == TINC.INCO1
  • C_RFM_MASADOSLSITMCUSTBASIC.MANDT == TINC.MANDT
Sold-to Party
  • Sold-to Party
  • Client
  • C_RFM_MASADOSLSITMCUSTBASIC.SOLDTOPARTY == KNA1.KUNNR
  • C_RFM_MASADOSLSITMCUSTBASIC.MANDT == KNA1.MANDT