v_sd_ci_party

Party information of Customer Invoices | view: V_SD_PARTY | TRAN | Extraction: Not supported | Component: Billing
Tables used: VBRKVBPABUT000ADRCADRPTPART
Column Name Description
Document_ID Sales and Distribution Document Number
Partner_Function FK Partner Function
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Address_Type Address type (1=Organization, 2=Person, 3=Contact person) Show values
Column Name Description Domain name
Partner_Function_Description Name TEXT20
Party_ID Customer Number KUNNR
Party_Name1 Full Name TEXT80
Party_Name2 Name 2 TEXT40
Postal_Code City postal code CHAR10
City City TEXT40
Street_Name Street TEXT60
House_Number House Number TEXT10
Address_Number Address Number AD_ADDRNUM
Address_Person_Number Person Number AD_PERSNUM
Master Data Relations Join Conditions
Billing Type
  • Client
  • Billing Type
  • V_SD_CI_PARTY.MANDT == TVFK.MANDT
  • V_SD_CI_PARTY.BILLINGDOCUMENTTYPE == TVFK.FKART
Country key
  • Country/Region Key
  • Client
  • V_SD_CI_PARTY.COUNTRY_CODE == T005.LAND1
  • V_SD_CI_PARTY.MANDT == T005.MANDT
Partner Function
  • Client
  • Partner Function
  • V_SD_CI_PARTY.MANDT == TPAR.MANDT
  • V_SD_CI_PARTY.PARTNER_FUNCTION == TPAR.PARVW
Sales Organization
  • Client
  • Sales Organization
  • V_SD_CI_PARTY.MANDT == TVKO.MANDT
  • V_SD_CI_PARTY.SALESORGANIZATION == TVKO.VKORG