C_SalesOrderFlfmtContactQ

SOFM Sales Order Fulfillment Contact Query | view: CSOFCONTACTQ | Extraction: Not supported | Component: Sales Analytics
Column Name Description
SalesOrder Sales Document
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Issue Issue Show values
ContactIsInternal Internal contact Show values
ContactIsExternal External contact Show values
Column Name Description Domain name
DeliveryDocument Delivery VBELN
Personnel Personnel Number PERNR
PersonnelName Full Name TEXT80
CustomerName Full Name TEXT80
FirstName First name of business partner (person) BU_NAME
LastName Last name of business partner (person) BU_NAME
PartnerFunction Partner Function PARVW
PartnerFunctionName Name TEXT20
ContactPersonFunctionName Description TEXT30
InternationalPhoneNumber Complete Number: Dialling Code+Number+Extension CHAR30
PhoneNumber Telephone no.: dialling code+number CHAR30
PhoneNumberExtension Telephone no.: Extension CHAR10
InternationalMobilePhoneNumber Complete Number: Dialling Code+Number+Extension CHAR30
MobilePhoneNumber Telephone no.: dialling code+number CHAR30
EmailAddress E-Mail Address AD_SMTPADR
AddressID Address ADRNR
Master Data Relations Join Conditions
Function of partner
  • Client
  • Function of partner
  • C_SALESORDERFLFMTCONTACTQ.MANDT == TB912.CLIENT
  • C_SALESORDERFLFMTCONTACTQ.CONTACTPERSONFUNCTION == TB912.PAFKT
Business Partner Number
  • Business Partner Number
  • Client
  • C_SALESORDERFLFMTCONTACTQ.CUSTOMER == BUT000.PARTNER
  • C_SALESORDERFLFMTCONTACTQ.MANDT == BUT000.CLIENT
Distribution channel in order header
  • Client
  • Sales Organization
  • Distribution Channel
  • C_SALESORDERFLFMTCONTACTQ.MANDT == TVKOV.MANDT
  • C_SALESORDERFLFMTCONTACTQ.SALESORGANIZATION == TVKOV.VKORG
  • C_SALESORDERFLFMTCONTACTQ.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Division in order header
  • Division
  • Client
  • Sales Organization
  • Distribution Channel
  • C_SALESORDERFLFMTCONTACTQ.ORGANIZATIONDIVISION == TVTA.SPART
  • C_SALESORDERFLFMTCONTACTQ.MANDT == TVTA.MANDT
  • C_SALESORDERFLFMTCONTACTQ.SALESORGANIZATION == TVTA.VKORG
  • C_SALESORDERFLFMTCONTACTQ.DISTRIBUTIONCHANNEL == TVTA.VTWEG
Order type in order header
  • Sales Document Type
  • Client
  • C_SALESORDERFLFMTCONTACTQ.SALESORDERTYPE == TVAK.AUART
  • C_SALESORDERFLFMTCONTACTQ.MANDT == TVAK.MANDT
Sales organization in order header
  • Client
  • Sales Organization
  • C_SALESORDERFLFMTCONTACTQ.MANDT == TVKO.MANDT
  • C_SALESORDERFLFMTCONTACTQ.SALESORGANIZATION == TVKO.VKORG