P_PH_StrpCompanyCodeQ

PH Company Code | view: PHCSRCOMPCODEQ | Extraction: Not supported | Component: Withholding Tax Reporting
Tables used: ADCPADRCADR6T001TKA02
Column Name Description
CompanyCode Company Code
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
CompanyCodeName Name of Company Code or Company TEXT25
BusinessPartnerName1 Name 1 TEXT40
BusinessPartnerName2 Name 2 TEXT40
BusinessPartnerName3 Name 3 TEXT40
BusinessPartnerName4 Name 4 TEXT40
HouseNumber House Number TEXT10
StreetPrefixName Street 2 TEXT40
StreetName Street TEXT60
CityName City TEXT40
HomeCityName City (different from postal city) TEXT40
PostalCode City postal code CHAR10
District District TEXT40
AdditionalStreetPrefixName Street 3 TEXT40
StreetSuffixName Street 4 TEXT40
Building Building (Number or Code) TEXT20
Floor Floor in building TEXT10
RoomNumber Room or Apartment Number TEXT10
EmailAddress E-Mail Address AD_SMTPADR
VATRegistration VAT Registration Number STCEG
CompanyCodeAddress null
BusinessPartnerFullName null
PhoneNumber First telephone no.: dialling code+number CHAR30
AddressID Address ADRNR
Master Data Relations Join Conditions
Currency Key
  • Client
  • Currency Key
  • P_PH_STRPCOMPANYCODEQ.MANDT == TCURC.MANDT
  • P_PH_STRPCOMPANYCODEQ.COMPANYCODECURRENCY == TCURC.WAERS
Country key
  • Client
  • Country/Region Key
  • P_PH_STRPCOMPANYCODEQ.MANDT == T005.MANDT
  • P_PH_STRPCOMPANYCODEQ.COUNTRY == T005.LAND1
Region code
  • Client
  • Region (State, Province, County)
  • Country/Region Key
  • P_PH_STRPCOMPANYCODEQ.MANDT == T005S.MANDT
  • P_PH_STRPCOMPANYCODEQ.REGION == T005S.BLAND
  • P_PH_STRPCOMPANYCODEQ.COUNTRY == T005S.LAND1