C_SSPSupplierPurgOrgVH

Supplier value for SSP PR with Purchasing Organization | view: CSSPSUPLRPORG_VH | Extraction: Not supported | Component: Purchase Requisitions
Tables used: ADCPADRCADR6BUT000LFA1LFM1CVI_VEND_LINK
Column Name Description
Supplier FK Vendor's account number
PurchasingOrganization FK Purchasing organization
ProcurementHubSourceSystem null
Column Name Description
Column Name Description
Column Name Description
Column Name Description
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
Column Name Description Domain name
SupplierName Name of Supplier TEXT80
CityName City TEXT40
PostalCode City postal code CHAR10
FirstName First name of business partner (person) BU_NAME
LastName Last name of business partner (person) BU_NAME
OrganizationBPName1 Name 1 of organization BU_NAME
OrganizationBPName2 Name 2 of organization BU_NAME
SupplierVATRegistration VAT Registration Number STCEG
EmailAddress E-Mail Address AD_SMTPADR
AuthorizationGroup Authorization Group BRGRU
Master Data Relations Join Conditions
Country key
  • Client
  • Country/Region Key
  • C_SSPSUPPLIERPURGORGVH.MANDT == T005.MANDT
  • C_SSPSUPPLIERPURGORGVH.COUNTRY == T005.LAND1
Purchasing organization
  • Client
  • Purchasing organization
  • C_SSPSUPPLIERPURGORGVH.MANDT == T024E.MANDT
  • C_SSPSUPPLIERPURGORGVH.PURCHASINGORGANIZATION == T024E.EKORG
Region code
  • Client
  • Region (State, Province, County)
  • Country/Region Key
  • C_SSPSUPPLIERPURGORGVH.MANDT == T005S.MANDT
  • C_SSPSUPPLIERPURGORGVH.REGION == T005S.BLAND
  • C_SSPSUPPLIERPURGORGVH.COUNTRY == T005S.LAND1
Vendor's account number
  • Client
  • Vendor's account number
  • C_SSPSUPPLIERPURGORGVH.MANDT == LFA1.MANDT
  • C_SSPSUPPLIERPURGORGVH.SUPPLIER == LFA1.LIFNR