C_NotInCoCodeCntrySupplier

Supplier not registered in CountryRegion | view: CGRCSUPCNTRY | Extraction: Not supported | Component: Information System
Tables used: T001TKA02LFA1LFB1
Column Name Description
Supplier FK Account Number of Supplier
CompanyCode FK Company Code
Column Name Description
Column Name Description
Column Name Description
CreationDate Date on which the Record Was Created
Column Name Description
PostingIsBlocked Central posting block Show values
IsOneTimeAccount Indicator: Is the account a one-time account? Show values
DeletionIndicator Central Deletion Flag for Master Record Show values
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
Column Name Description Domain name
SupplierName Name of Supplier TEXT80
CompanyCodeName Name of Company Code or Company TEXT25
CreatedByUser Name of Person who Created the Object USNAM
VATRegistration VAT Registration Number STCEG
AddressID Address ADRNR
OrganizationBPName1 Name 1 NAME
OrganizationBPName2 Name 2 NAME
CityName City TEXT35
PostalCode Postal Code PSTLZ
StreetName Street and House Number TEXT35
AuthorizationGroup Authorization Group BRGRU
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • C_NOTINCOCODECNTRYSUPPLIER.COMPANYCODE == T001.BUKRS
  • C_NOTINCOCODECNTRYSUPPLIER.MANDT == T001.MANDT
Company Code Country/Region
  • Company Code Country/Region
  • Supplier Country/Region
  • Client
  • C_NOTINCOCODECNTRYSUPPLIER.COMPANYCODECOUNTRY == T005.LAND1
  • C_NOTINCOCODECNTRYSUPPLIER.SUPPLIERCOUNTRY == T005.LAND1
  • C_NOTINCOCODECNTRYSUPPLIER.MANDT == T005.MANDT
Customer Number
  • Customer Number
  • Client
  • C_NOTINCOCODECNTRYSUPPLIER.CUSTOMER == KNA1.KUNNR
  • C_NOTINCOCODECNTRYSUPPLIER.MANDT == KNA1.MANDT
Region (State, Province, County)
  • Company Code Country/Region
  • Supplier Country/Region
  • Client
  • Region (State, Province, County)
  • C_NOTINCOCODECNTRYSUPPLIER.COMPANYCODECOUNTRY == T005S.LAND1
  • C_NOTINCOCODECNTRYSUPPLIER.SUPPLIERCOUNTRY == T005S.LAND1
  • C_NOTINCOCODECNTRYSUPPLIER.MANDT == T005S.MANDT
  • C_NOTINCOCODECNTRYSUPPLIER.REGION == T005S.BLAND
Account Number of Supplier
  • Account Number of Supplier
  • Client
  • C_NOTINCOCODECNTRYSUPPLIER.SUPPLIER == LFA1.LIFNR
  • C_NOTINCOCODECNTRYSUPPLIER.MANDT == LFA1.MANDT
Vendor account group
  • Vendor account group
  • Client
  • C_NOTINCOCODECNTRYSUPPLIER.SUPPLIERACCOUNTGROUP == T077K.KTOKK
  • C_NOTINCOCODECNTRYSUPPLIER.MANDT == T077K.MANDT
Supplier Country/Region
  • Company Code Country/Region
  • Supplier Country/Region
  • Client
  • C_NOTINCOCODECNTRYSUPPLIER.COMPANYCODECOUNTRY == T005.LAND1
  • C_NOTINCOCODECNTRYSUPPLIER.SUPPLIERCOUNTRY == T005.LAND1
  • C_NOTINCOCODECNTRYSUPPLIER.MANDT == T005.MANDT