P_SuplrCoCodePurOrgAssgmt

Supplier assignment to CoCode and Purch Org | view: PSUCOCOPUORASGMT | Extraction: Not supported | Component: Fiori FXU Accounts Payable FI-FIO-AP
Tables used: T001TKA02T024WT024ET001KLFA1LFB1LFM1
Column Name Description
Supplier Account Number of Supplier
CompanyCode FK Company Code
PurchasingOrganization FK Purchasing organization
Column Name Description
Column Name Description
Column Name Description
CreationDate Date on which the Record Was Created
Column Name Description
AccountIsBlockedForPosting Central posting block Show values
PurchasingIsBlocked Centrally imposed purchasing block Show values
IsNaturalPerson Natural Person Show values
VATLiability Liable for VAT Show values
PaymentIsBlockedForSupplier Payment Block Show values
DeletionIndicator Central Deletion Flag for Master Record 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
PurOrdAutoGenerationIsAllowed Automatic Generation of Purchase Order Allowed Show values
PurchasingIsBlockedForSupplier Purchasing block at purchasing organization level Show values
SuplrIsDeltdPurgOrg Deletion Flag for Master Record on Purchasing Org. Level Show values
InvoiceIsGoodsReceiptBased Indicator: GR-Based Invoice Verification Show values
Column Name Description Domain name
AuthorizationGroup Authorization Group BRGRU
SupplierName Name of Supplier TEXT80
SupplierFullName Supplier Full Name TEXT220
CreatedByUser Name of Person who Created the Object USNAM
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
AddressID Address ADRNR
OrganizationBPName1 Name 1 NAME
OrganizationBPName2 Name 2 NAME
CityName City TEXT35
PostalCode Postal Code PSTLZ
StreetName Street and House Number TEXT35
PhoneNumber1 First telephone number TEXT16
FaxNumber Fax Number TEXT31
TaxNumberResponsible Tax Number at Responsible Tax Authority CHAR18
PhoneNumber2 Second telephone number TEXT16
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
SupplierPurgOrgPaymentTerms Terms of Payment Key (Purchasing Org) ZTERM
Master Data Relations Join Conditions
Accounting Clerk Abbreviation
  • Company Code
  • Client
  • Accounting Clerk Abbreviation
  • P_SUPLRCOCODEPURORGASSGMT.COMPANYCODE == T001S.BUKRS
  • P_SUPLRCOCODEPURORGASSGMT.MANDT == T001S.MANDT
  • P_SUPLRCOCODEPURORGASSGMT.ACCOUNTINGCLERK == T001S.BUSAB
Account number of the alternative payee
  • Account number of the alternative payee
  • Client
  • P_SUPLRCOCODEPURORGASSGMT.ALTERNATIVEPAYEE == LFA1.LIFNR
  • P_SUPLRCOCODEPURORGASSGMT.MANDT == LFA1.MANDT
Account Number of the Alternative Payee
  • Client
  • Account Number of the Alternative Payee
  • P_SUPLRCOCODEPURORGASSGMT.MANDT == LFA1.MANDT
  • P_SUPLRCOCODEPURORGASSGMT.ALTERNATIVEPAYEEACCOUNTNUMBER == LFA1.LIFNR
Planning Group
  • Client
  • Planning Group
  • P_SUPLRCOCODEPURORGASSGMT.MANDT == T035.MANDT
  • P_SUPLRCOCODEPURORGASSGMT.CASHPLANNINGGROUP == T035.GRUPP
Company Code
  • Company Code
  • Client
  • P_SUPLRCOCODEPURORGASSGMT.COMPANYCODE == T001.BUKRS
  • P_SUPLRCOCODEPURORGASSGMT.MANDT == T001.MANDT
Country/Region Key
  • Country/Region Key
  • Client
  • P_SUPLRCOCODEPURORGASSGMT.COUNTRY == T005.LAND1
  • P_SUPLRCOCODEPURORGASSGMT.MANDT == T005.MANDT
Key for sorting according to assignment numbers P_SUPLRCOCODEPURORGASSGMT.LAYOUTSORTINGRULE == TZUN.ZUAWA
Minority Indicator
  • Client
  • Minority Indicator
  • P_SUPLRCOCODEPURORGASSGMT.MANDT == T059M.MANDT
  • P_SUPLRCOCODEPURORGASSGMT.MINORITYGROUP == T059M.MINDK
Block Key for Payment
  • Client
  • Block Key for Payment
  • P_SUPLRCOCODEPURORGASSGMT.MANDT == T008.MANDT
  • P_SUPLRCOCODEPURORGASSGMT.PAYMENTBLOCKINGREASON == T008.ZAHLS
Purchase order currency
  • Client
  • Purchase order currency
  • P_SUPLRCOCODEPURORGASSGMT.MANDT == TCURC.MANDT
  • P_SUPLRCOCODEPURORGASSGMT.PURCHASEORDERCURRENCY == TCURC.WAERS
Purchasing Group
  • Client
  • Purchasing Group
  • P_SUPLRCOCODEPURORGASSGMT.MANDT == T024.MANDT
  • P_SUPLRCOCODEPURORGASSGMT.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Purchasing organization
  • Client
  • P_SUPLRCOCODEPURORGASSGMT.PURCHASINGORGANIZATION == T024E.EKORG
  • P_SUPLRCOCODEPURORGASSGMT.MANDT == T024E.MANDT
Reconciliation Account in General Ledger
  • Company Code
  • Client
  • Reconciliation Account in General Ledger
  • P_SUPLRCOCODEPURORGASSGMT.COMPANYCODE == SKB1.BUKRS
  • P_SUPLRCOCODEPURORGASSGMT.MANDT == SKB1.MANDT
  • P_SUPLRCOCODEPURORGASSGMT.RECONCILIATIONACCOUNT == SKB1.SAKNR
Region (State, Province, County)
  • Country/Region Key
  • Client
  • Region (State, Province, County)
  • P_SUPLRCOCODEPURORGASSGMT.COUNTRY == T005S.LAND1
  • P_SUPLRCOCODEPURORGASSGMT.MANDT == T005S.MANDT
  • P_SUPLRCOCODEPURORGASSGMT.REGION == T005S.BLAND
Tax Type
  • ?
  • Client
  • Tax type
  • P_SUPLRCOCODEPURORGASSGMT.[column in domain "KOART"] == J_1AFITP.KOART
  • P_SUPLRCOCODEPURORGASSGMT.MANDT == J_1AFITP.MANDT
  • P_SUPLRCOCODEPURORGASSGMT.RESPONSIBLETYPE == J_1AFITP.J_1AFITP
Vendor account group
  • Client
  • Vendor account group
  • P_SUPLRCOCODEPURORGASSGMT.MANDT == T077K.MANDT
  • P_SUPLRCOCODEPURORGASSGMT.SUPPLIERACCOUNTGROUP == T077K.KTOKK
Release Approval Group
  • Client
  • Release Approval Group
  • P_SUPLRCOCODEPURORGASSGMT.MANDT == VBWF08.MANDT
  • P_SUPLRCOCODEPURORGASSGMT.SUPPLIERRELEASEGROUP == VBWF08.FRGRP
Possible Checks for Tax Number 1
  • Client
  • Tax Number Type
  • P_SUPLRCOCODEPURORGASSGMT.MANDT == J_1ATODC.MANDT
  • P_SUPLRCOCODEPURORGASSGMT.TAXNUMBERTYPE == J_1ATODC.J_1ATODC
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • P_SUPLRCOCODEPURORGASSGMT.MANDT == T880.MANDT
  • P_SUPLRCOCODEPURORGASSGMT.TRADINGPARTNER == T880.RCOMP
Withholding Tax Country/Region Key
  • Country/Region Key
  • Client
  • Withholding Tax Country/Region Key
  • P_SUPLRCOCODEPURORGASSGMT.COUNTRY == T005Q.LAND1
  • P_SUPLRCOCODEPURORGASSGMT.MANDT == T005Q.MANDT
  • P_SUPLRCOCODEPURORGASSGMT.WITHHOLDINGTAXCOUNTRY == T005Q.QLAND