P_SupplierWithCompanyCode

Supplier extended by Company Code | view: PSUPPLIERCOCODE | Extraction: Not supported | Component: Fiori FXU Accounts Payable FI-FIO-AP
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
VATLiability Liable for VAT Show values
PaymentIsBlockedForSupplier Payment Block Show values
DeletionIndicator Central Deletion Flag for Master Record Show values
IN_GSTSupplierClassification Vendor Classification for GST Show values
SuplrIsDeltdCoCode Deletion Flag for Master Record (Company Code Level) Show values
IsToBeCheckedForDuplicates Check Flag for Double Invoices or Credit Memos Show values
SupplierIsBlockedForPosting Posting block for company code 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
FormOfAddress Title TEXT15
SortField Sort field CHAR10
PhoneNumber2 Second telephone number TEXT16
TaxInvoiceRepresentativeName Name of Representative REPRES
PaymentMethodsList List of Respected Payment Methods ZWELS
AccountingClerkFaxNumber Accounting clerk's fax number at the customer/vendor TEXT31
SupplierClerkURL Internet address of partner company clerk TXT130
AccountingClerkPhoneNumber Accounting clerk's telephone number at business partner CHAR30
SuplrCoCodePaymentTerms Terms of payment key ZTERM
CompanyCodeName Name of Company Code or Company TEXT25
PreviousAccountNumber Previous Master Record Number CHAR10
Master Data Relations | to Other Relations ↓ Join Conditions
Accounting Clerk Abbreviation
  • Company Code
  • Accounting Clerk Abbreviation
  • Client
  • P_SUPPLIERWITHCOMPANYCODE.COMPANYCODE == T001S.BUKRS
  • P_SUPPLIERWITHCOMPANYCODE.ACCOUNTINGCLERK == T001S.BUSAB
  • P_SUPPLIERWITHCOMPANYCODE.MANDT == T001S.MANDT
Account number of the alternative payee
  • Client
  • Account number of the alternative payee
  • P_SUPPLIERWITHCOMPANYCODE.MANDT == LFA1.MANDT
  • P_SUPPLIERWITHCOMPANYCODE.ALTERNATIVEPAYEE == LFA1.LIFNR
Account Number of the Alternative Payee
  • Account Number of the Alternative Payee
  • Client
  • P_SUPPLIERWITHCOMPANYCODE.ALTERNATIVEPAYEEACCOUNTNUMBER == LFA1.LIFNR
  • P_SUPPLIERWITHCOMPANYCODE.MANDT == LFA1.MANDT
Planning Group
  • Client
  • Planning Group
  • P_SUPPLIERWITHCOMPANYCODE.MANDT == T035.MANDT
  • P_SUPPLIERWITHCOMPANYCODE.CASHPLANNINGGROUP == T035.GRUPP
Company Code
  • Company Code
  • Client
  • P_SUPPLIERWITHCOMPANYCODE.COMPANYCODE == T001.BUKRS
  • P_SUPPLIERWITHCOMPANYCODE.MANDT == T001.MANDT
Country/Region Key
  • Client
  • Country/Region Key
  • P_SUPPLIERWITHCOMPANYCODE.MANDT == T005.MANDT
  • P_SUPPLIERWITHCOMPANYCODE.COUNTRY == T005.LAND1
Customer Number
  • Client
  • Customer Number
  • P_SUPPLIERWITHCOMPANYCODE.MANDT == KNA1.MANDT
  • P_SUPPLIERWITHCOMPANYCODE.CUSTOMER == KNA1.KUNNR
Account number of the master record with fiscal address
  • Client
  • Account number of the master record with fiscal address
  • P_SUPPLIERWITHCOMPANYCODE.MANDT == LFA1.MANDT
  • P_SUPPLIERWITHCOMPANYCODE.FISCALADDRESS == LFA1.LIFNR
Industry key
  • Industry key
  • Client
  • P_SUPPLIERWITHCOMPANYCODE.INDUSTRY == T016.BRSCH
  • P_SUPPLIERWITHCOMPANYCODE.MANDT == T016.MANDT
Key for sorting according to assignment numbers P_SUPPLIERWITHCOMPANYCODE.LAYOUTSORTINGRULE == TZUN.ZUAWA
Minority Indicator
  • Client
  • Minority Indicator
  • P_SUPPLIERWITHCOMPANYCODE.MANDT == T059M.MANDT
  • P_SUPPLIERWITHCOMPANYCODE.MINORITYGROUP == T059M.MINDK
Block Key for Payment
  • Client
  • Block Key for Payment
  • P_SUPPLIERWITHCOMPANYCODE.MANDT == T008.MANDT
  • P_SUPPLIERWITHCOMPANYCODE.PAYMENTBLOCKINGREASON == T008.ZAHLS
Reconciliation Account in General Ledger
  • Company Code
  • Reconciliation Account in General Ledger
  • Client
  • P_SUPPLIERWITHCOMPANYCODE.COMPANYCODE == SKB1.BUKRS
  • P_SUPPLIERWITHCOMPANYCODE.RECONCILIATIONACCOUNT == SKB1.SAKNR
  • P_SUPPLIERWITHCOMPANYCODE.MANDT == SKB1.MANDT
Reference Account Group for One-Time Account (Vendor)
  • Reference Account Group for One-Time Account (Vendor)
  • Client
  • P_SUPPLIERWITHCOMPANYCODE.REFERENCEACCOUNTGROUP == T077K.KTOKK
  • P_SUPPLIERWITHCOMPANYCODE.MANDT == T077K.MANDT
Region (State, Province, County)
  • Region (State, Province, County)
  • Client
  • Country/Region Key
  • P_SUPPLIERWITHCOMPANYCODE.REGION == T005S.BLAND
  • P_SUPPLIERWITHCOMPANYCODE.MANDT == T005S.MANDT
  • P_SUPPLIERWITHCOMPANYCODE.COUNTRY == T005S.LAND1
Tax Type
  • Tax type
  • Client
  • ?
  • P_SUPPLIERWITHCOMPANYCODE.RESPONSIBLETYPE == J_1AFITP.J_1AFITP
  • P_SUPPLIERWITHCOMPANYCODE.MANDT == J_1AFITP.MANDT
  • P_SUPPLIERWITHCOMPANYCODE.[column in domain "KOART"] == J_1AFITP.KOART
Supplier's QM System
  • Client
  • Supplier's QM System
  • P_SUPPLIERWITHCOMPANYCODE.MANDT == TQ02B.MANDT
  • P_SUPPLIERWITHCOMPANYCODE.SUPLRQUALITYMANAGEMENTSYSTEM == TQ02B.QSSYSFAM
Vendor account group
  • Vendor account group
  • Client
  • P_SUPPLIERWITHCOMPANYCODE.SUPPLIERACCOUNTGROUP == T077K.KTOKK
  • P_SUPPLIERWITHCOMPANYCODE.MANDT == T077K.MANDT
Language Key P_SUPPLIERWITHCOMPANYCODE.SUPPLIERLANGUAGE == T002.SPRAS
Function That Will Be Blocked
  • Client
  • Function That Will Be Blocked
  • P_SUPPLIERWITHCOMPANYCODE.MANDT == TQ04A.MANDT
  • P_SUPPLIERWITHCOMPANYCODE.SUPPLIERPROCUREMENTBLOCK == TQ04A.SPERRFKT
Release Approval Group
  • Client
  • Release Approval Group
  • P_SUPPLIERWITHCOMPANYCODE.MANDT == VBWF08.MANDT
  • P_SUPPLIERWITHCOMPANYCODE.SUPPLIERRELEASEGROUP == VBWF08.FRGRP
Tax Jurisdiction
  • ?
  • Client
  • Tax Jurisdiction
  • P_SUPPLIERWITHCOMPANYCODE.[column in domain "TAX_KALSM"] == TTXJ.KALSM
  • P_SUPPLIERWITHCOMPANYCODE.MANDT == TTXJ.MANDT
  • P_SUPPLIERWITHCOMPANYCODE.TAXJURISDICTION == TTXJ.TXJCD
Possible Checks for Tax Number 1
  • Client
  • Tax Number Type
  • P_SUPPLIERWITHCOMPANYCODE.MANDT == J_1ATODC.MANDT
  • P_SUPPLIERWITHCOMPANYCODE.TAXNUMBERTYPE == J_1ATODC.J_1ATODC
Company ID of Trading Partner
  • Company ID of Trading Partner
  • Client
  • P_SUPPLIERWITHCOMPANYCODE.TRADINGPARTNER == T880.RCOMP
  • P_SUPPLIERWITHCOMPANYCODE.MANDT == T880.MANDT
Withholding Tax Country/Region Key
  • Withholding Tax Country/Region Key
  • Client
  • Country/Region Key
  • P_SUPPLIERWITHCOMPANYCODE.WITHHOLDINGTAXCOUNTRY == T005Q.QLAND
  • P_SUPPLIERWITHCOMPANYCODE.MANDT == T005Q.MANDT
  • P_SUPPLIERWITHCOMPANYCODE.COUNTRY == T005Q.LAND1
Other Relations | to Master Data Relations ↑ Join Conditions
Type of Business
  • Client
  • Type of Business
  • P_SUPPLIERWITHCOMPANYCODE.MANDT == BUSTYPE.MANDT
  • P_SUPPLIERWITHCOMPANYCODE.BUSINESSTYPE == BUSTYPE.GESTYP
Type of Industry
  • Client
  • Type of Industry
  • P_SUPPLIERWITHCOMPANYCODE.MANDT == INDUSTYPE.MANDT
  • P_SUPPLIERWITHCOMPANYCODE.INDUSTRYTYPE == INDUSTYPE.INDTYPE