P_Supplier_Fs

Private Factsheet - Supplier | view: PSUPPLIERFS | Extraction: Not supported | Component: Material Master
Tables used: EKKOEKPOADCPADRCADR6ADR3ADR2T005TT001WEINAT005UT077YT016TBUT000CVI_VEND_LINKLFA1LFA1TTZ5Z
Column Name Description
Supplier Account Number of Supplier
Column Name Description
Column Name Description
Column Name Description
Column Name Description
PostingIsBlocked Central posting block Show values
PurchasingIsBlockedForSupplier Centrally imposed purchasing block Show values
Column Name Description Domain name
RoleOwnerEmailAddress E-Mail Address Search Field CHAR20
InternationalFaxNumber Fax number: dialling code+number CHAR30
InternationalPhoneNumber Complete Number: Dialling Code+Number+Extension CHAR30
InternationalMobilePhoneNumber Mobile number CHAR30
RegionName Supplier Region Name TEXT20
PlantName Plant Name TEXT30
BusinessPartner Business Partner Number BU_PARTNER
CountryName Country/Region Name TEXT50
SupplierCityName City TEXT35
SupplierIndustryName Description of the Industry Key TEXT20
AddressID Address ADRNR
InternationalLocationNumber3 Check digit for the international location number NUM01
FaxNumber Fax Number TEXT31
SupplierCorporateGroup Group key KONZS
InternationalLocationNumber1 International location number (part 1) NUM07
InternationalLocationNumber2 International location number (Part 2) NUM05
SupplierName Name 1 NAME
AdditionalName Supplier Additional Name NAME
PhoneNumber2 Second telephone number TEXT16
Plant Plant (Own or External) WERKS
POBox PO Box PFACH
StreetAddressName Street and House Number TEXT35
SupplierTaxID1 Tax Number 1 STCD1
UniformResourceLocator Uniform resource locator TEXT132
SupplierVATRegistration VAT Registration Number STCEG
AccountGroupName Name of Account Group TEXT30
FormattedName null
DocumentKeyForUnitCnvrsn Search term for matchcode search CHAR25
PostalCode Postal Code PSTLZ
Master Data Relations Join Conditions
Country/Region Key
  • Country/Region Key
  • Client
  • P_SUPPLIER_FS.COUNTRY == T005.LAND1
  • P_SUPPLIER_FS.MANDT == T005.MANDT
Customer Number
  • Customer Number
  • Client
  • P_SUPPLIER_FS.CUSTOMER == KNA1.KUNNR
  • P_SUPPLIER_FS.MANDT == KNA1.MANDT
Language Key P_SUPPLIER_FS.LANGUAGE == T002.SPRAS
Time zone
  • Time Zone
  • Client
  • P_SUPPLIER_FS.LOCATIONTIMEZONE == TTZZ.TZONE
  • P_SUPPLIER_FS.MANDT == TTZZ.CLIENT
Material Number
  • Material Number
  • Client
  • P_SUPPLIER_FS.MATERIAL == MARA.MATNR
  • P_SUPPLIER_FS.MANDT == MARA.MANDT
Vendor account group
  • Vendor account group
  • Client
  • P_SUPPLIER_FS.SUPPLIERACCOUNTGROUP == T077K.KTOKK
  • P_SUPPLIER_FS.MANDT == T077K.MANDT
Industry key
  • Industry key
  • Client
  • P_SUPPLIER_FS.SUPPLIERINDUSTRY == T016.BRSCH
  • P_SUPPLIER_FS.MANDT == T016.MANDT
Region (State, Province, County)
  • Country/Region Key
  • Client
  • Region (State, Province, County)
  • P_SUPPLIER_FS.COUNTRY == T005S.LAND1
  • P_SUPPLIER_FS.MANDT == T005S.MANDT
  • P_SUPPLIER_FS.SUPPLIERREGION == T005S.BLAND