C_CN_TaxInvcSupplier

China Tax Supplier | view: CCNTXISUPPLIER | Extraction: Not supported | Component: Tax Invoice Management China
Tables used: T001TKA02LFA1LFB1
Column Name Description
Supplier 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
SuplrQltyInProcmtCertfnValidTo Validity Date of Certification
BirthDate Date of Birth of the Person Subject to Withholding Tax
Column Name Description
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
IsOneTimeAccount Indicator: Is the account a one-time account? Show values
AccountIsBlockedForPosting Central posting block Show values
PostingIsBlocked Central posting block Show values
PurchasingIsBlocked Centrally imposed purchasing block Show values
IsNaturalPerson Natural Person Show values
UK_ContractorBusinessType Subcontractor's Business Type Show values
UK_VerificationStatus Verification Status Show values
UK_VerifiedTaxStatus Tax Status of the Verified Subcontractor Show values
Column Name Description Domain name
SupplierName Name of Supplier TEXT80
SupplierFullName Supplier Full Name TEXT220
CreatedByUser Name of Person who Created the Object USNAM
AuthorizationGroup Authorization Group BRGRU
VATRegistration VAT Registration Number STCEG
SupplierCorporateGroup Group key KONZS
TaxNumber1 Tax Number 1 STCD1
TaxNumber2 Tax Number 2 STCD2
TaxNumber3 Tax Number 3 CHAR18
TaxNumber4 Tax Number 4 CHAR18
TaxNumber5 Tax Number 5 CHAR60
InternationalLocationNumber1 International location number (part 1) NUM07
InternationalLocationNumber2 International location number (Part 2) NUM05
InternationalLocationNumber3 Check digit for the international location number NUM01
AddressID Address ADRNR
OrganizationBPName1 Name 1 NAME
OrganizationBPName2 Name 2 NAME
CityName City TEXT35
PostalCode Postal Code PSTLZ
StreetName Street and House Number TEXT35
ConcatenatedInternationalLocNo Cocatenated International Location Number TEXT20
PhoneNumber1 First telephone number TEXT16
FaxNumber Fax Number TEXT31
TaxNumberResponsible Tax Number at Responsible Tax Authority CHAR18
UK_PartnerTradingName Partner's Trading Name TEXT30
UK_PartnerTaxReference Partner's Unique Tax Reference (UTR) CHAR20
UK_VerificationNumber Verification Number CHAR20
UK_CompanyRegistrationNumber Companies House Registration Number
Master Data Relations Join Conditions
Account Number of the Alternative Payee
  • Client
  • Account Number of the Alternative Payee
  • C_CN_TAXINVCSUPPLIER.MANDT == LFA1.MANDT
  • C_CN_TAXINVCSUPPLIER.ALTERNATIVEPAYEEACCOUNTNUMBER == LFA1.LIFNR
Company Code
  • Client
  • Company Code
  • C_CN_TAXINVCSUPPLIER.MANDT == T001.MANDT
  • C_CN_TAXINVCSUPPLIER.COMPANYCODE == T001.BUKRS
Country/Region Key
  • Country/Region Key
  • Client
  • C_CN_TAXINVCSUPPLIER.COUNTRY == T005.LAND1
  • C_CN_TAXINVCSUPPLIER.MANDT == T005.MANDT
Customer Number
  • Client
  • Customer Number
  • C_CN_TAXINVCSUPPLIER.MANDT == KNA1.MANDT
  • C_CN_TAXINVCSUPPLIER.CUSTOMER == KNA1.KUNNR
Account number of the master record with fiscal address
  • Account number of the master record with fiscal address
  • Client
  • C_CN_TAXINVCSUPPLIER.FISCALADDRESS == LFA1.LIFNR
  • C_CN_TAXINVCSUPPLIER.MANDT == LFA1.MANDT
Industry key
  • Client
  • Industry key
  • C_CN_TAXINVCSUPPLIER.MANDT == T016.MANDT
  • C_CN_TAXINVCSUPPLIER.INDUSTRY == T016.BRSCH
Tax Type
  • ?
  • Tax type
  • Client
  • C_CN_TAXINVCSUPPLIER.[column in domain "KOART"] == J_1AFITP.KOART
  • C_CN_TAXINVCSUPPLIER.RESPONSIBLETYPE == J_1AFITP.J_1AFITP
  • C_CN_TAXINVCSUPPLIER.MANDT == J_1AFITP.MANDT
Supplier's QM System
  • Supplier's QM System
  • Client
  • C_CN_TAXINVCSUPPLIER.SUPLRQUALITYMANAGEMENTSYSTEM == TQ02B.QSSYSFAM
  • C_CN_TAXINVCSUPPLIER.MANDT == TQ02B.MANDT
Vendor account group
  • Vendor account group
  • Client
  • C_CN_TAXINVCSUPPLIER.SUPPLIERACCOUNTGROUP == T077K.KTOKK
  • C_CN_TAXINVCSUPPLIER.MANDT == T077K.MANDT
Language Key C_CN_TAXINVCSUPPLIER.SUPPLIERLANGUAGE == T002.SPRAS
Function That Will Be Blocked
  • Client
  • Function That Will Be Blocked
  • C_CN_TAXINVCSUPPLIER.MANDT == TQ04A.MANDT
  • C_CN_TAXINVCSUPPLIER.SUPPLIERPROCUREMENTBLOCK == TQ04A.SPERRFKT
Tax Jurisdiction
  • ?
  • Client
  • Tax Jurisdiction
  • C_CN_TAXINVCSUPPLIER.[column in domain "TAX_KALSM"] == TTXJ.KALSM
  • C_CN_TAXINVCSUPPLIER.MANDT == TTXJ.MANDT
  • C_CN_TAXINVCSUPPLIER.TAXJURISDICTION == TTXJ.TXJCD
Possible Checks for Tax Number 1
  • Client
  • Tax Number Type
  • C_CN_TAXINVCSUPPLIER.MANDT == J_1ATODC.MANDT
  • C_CN_TAXINVCSUPPLIER.TAXNUMBERTYPE == J_1ATODC.J_1ATODC