What is P_SuplrCoCodePurOrgAssgmt in SAP S/4HANA?

P_SuplrCoCodePurOrgAssgmt is a composite CDS view in SAP S/4HANA. Supplier assignment to CoCode and Purch Org It contains 70 fields.

Which tables does P_SuplrCoCodePurOrgAssgmt read from?

P_SuplrCoCodePurOrgAssgmt reads data from: P_SupplierWithCompanyCode.

What VDM layer is P_SuplrCoCodePurOrgAssgmt?

P_SuplrCoCodePurOrgAssgmt is classified as a Composite view that combines data from multiple basic views.

P_SuplrCoCodePurOrgAssgmt

DDL: P_SUPLRCOCODEPURORGASSGMT SQL: PSUCOCOPUORASGMT Type: view COMPOSITE Package: ODATA_SUPPLIER_LIST

70 Fields 1 Data Sources 1 Associations

Supplier assignment to CoCode and Purch Org

P_SuplrCoCodePurOrgAssgmt is a Composite CDS View that provides data about "Supplier assignment to CoCode and Purch Org" in SAP S/4HANA. It reads from 1 data source (P_SupplierWithCompanyCode) and exposes 70 fields with key fields Supplier, CompanyCode, PurchasingOrganization. It has 1 association to related views. Part of development package ODATA_SUPPLIER_LIST.

Data Sources (1)

Source	Alias	Join Type
P_SupplierWithCompanyCode	_SuppWithCoCode	from

Associations (1)

Cardinality	Target	Alias	Condition
[0..*]	P_SuplrCoCodePurgOrganization	_SuppCoCodePurOrg	`_SuppCoCodePurOrg.Supplier = _SuppWithCoCode.Supplier and _SuppCoCodePurOrg.CompanyCode = _SuppWithCoCode.CompanyCode`

Annotations (11)

Name	Value	Level
ClientHandling.algorithm	#SESSION_VARIABLE	view
AbapCatalog.sqlViewName	PSUCOCOPUORASGMT	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
AbapCatalog.preserveKey	true	view
AccessControl.personalData.blocking	#NOT_REQUIRED	view
VDM.private	true	view
VDM.viewType	#COMPOSITE	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#MIXED	view

Fields (70)

Key	Field	Source Table	Source Field	Description
KEY	Supplier	P_SupplierWithCompanyCode	Supplier	Supplier
KEY	CompanyCode	P_SupplierWithCompanyCode	CompanyCode	Receiver Company Code
KEY	PurchasingOrganization	_SuppCoCodePurOrg	PurchasingOrganization	Purchasing Organization
	AuthorizationGroup	P_SupplierWithCompanyCode	AuthorizationGroup	AuthorizGroup
	SupplierAccountGroup	P_SupplierWithCompanyCode	SupplierAccountGroup	Account group
	SupplierName	P_SupplierWithCompanyCode	BPSupplierName	Supplier Name
	SupplierFullName	P_SupplierWithCompanyCode	BPSupplierFullName
	CreatedByUser	P_SupplierWithCompanyCode	CreatedByUser	User Name
	CreationDate	P_SupplierWithCompanyCode	CreationDate	Time Stamp
	AccountIsBlockedForPosting	P_SupplierWithCompanyCode	AccountIsBlockedForPosting	Posting Block
	TaxNumber1	P_SupplierWithCompanyCode	TaxNumber1	VAT Reg. No.
	TaxNumber2	P_SupplierWithCompanyCode	TaxNumber2	Tax Number 2
	TaxNumber3	P_SupplierWithCompanyCode	TaxNumber3
	TaxNumber4	P_SupplierWithCompanyCode	TaxNumber4
	TaxNumber5	P_SupplierWithCompanyCode	TaxNumber5
	PurchasingIsBlocked	P_SupplierWithCompanyCode	PurchasingIsBlocked	Purch. block
	AddressID	P_SupplierWithCompanyCode	AddressID	Ship-to address
	OrganizationBPName1	P_SupplierWithCompanyCode	BusinessPartnerName1	Name
	OrganizationBPName2	P_SupplierWithCompanyCode	BusinessPartnerName2	Name 2
	CityName	P_SupplierWithCompanyCode	BPAddrCityName
	PostalCode	P_SupplierWithCompanyCode	PostalCode	Postal Code
	StreetName	P_SupplierWithCompanyCode	BPAddrStreetName
	Region	P_SupplierWithCompanyCode	Region	Venue Region
	Country	P_SupplierWithCompanyCode	Country	Venue: Ctry/Reg
	AlternativePayeeAccountNumber	P_SupplierWithCompanyCode	AlternativePayeeAccountNumber	Alternat. Payee
	AlternativePayee	P_SupplierWithCompanyCode	AlternativePayee	Alternat.payee
	PhoneNumber1	P_SupplierWithCompanyCode	PhoneNumber1	Telephone 1
	FaxNumber	P_SupplierWithCompanyCode	FaxNumber	Fax Number
	IsNaturalPerson	P_SupplierWithCompanyCode	IsNaturalPerson	Natural person
	TaxNumberResponsible	P_SupplierWithCompanyCode	TaxNumberResponsible
	VATLiability	P_SupplierWithCompanyCode	VATLiability	Liable for VAT
	ResponsibleType	P_SupplierWithCompanyCode	ResponsibleType	Tax Type
	TaxNumberType	P_SupplierWithCompanyCode	TaxNumberType	Tax number type
	PaymentIsBlockedForSupplier	P_SupplierWithCompanyCode	PaymentIsBlockedForSupplier	Payment block
	PhoneNumber2	P_SupplierWithCompanyCode	PhoneNumber2	Telephone 2
	TradingPartner	P_SupplierWithCompanyCode	TradingPartner	Trading Partner
	LayoutSortingRule	P_SupplierWithCompanyCode	LayoutSortingRule	Sort key
	ReconciliationAccount	P_SupplierWithCompanyCode	ReconciliationAccount	Recon. account
	PaymentMethodsList	P_SupplierWithCompanyCode	PaymentMethodsList	Payment Methods
	AccountingClerk	P_SupplierWithCompanyCode	AccountingClerk	Clerk Abbrev.
	AccountingClerkFaxNumber	P_SupplierWithCompanyCode	AccountingClerkFaxNumber	Clerk's fax
	SupplierClerkURL	P_SupplierWithCompanyCode	SupplierClerkURL
	AccountingClerkPhoneNumber	P_SupplierWithCompanyCode	AccountingClerkPhoneNumber	Act.clk tel.no.
	SuplrCoCodePaymentTerms	P_SupplierWithCompanyCode	SuplrCoCodePaymentTerms	Pyt Terms
	PaymentBlockingReason	P_SupplierWithCompanyCode	PaymentBlockingReason	Pmnt block
	DeletionIndicator	P_SupplierWithCompanyCode	DeletionIndicator	Deletion Ind.
	SuplrIsDeltdCoCode	P_SupplierWithCompanyCode	SuplrIsDeltdCoCode	Deletion Ind.
	CashPlanningGroup	P_SupplierWithCompanyCode	CashPlanningGroup	Planning Group
	IsToBeCheckedForDuplicates	P_SupplierWithCompanyCode	IsToBeCheckedForDuplicates
	CompanyCodeName	P_SupplierWithCompanyCode	CompanyCodeName	Company Name
	SupplierIsBlockedForPosting	P_SupplierWithCompanyCode	SupplierIsBlockedForPosting	Co.code post.block
	WithholdingTaxCountry	P_SupplierWithCompanyCode	WithholdingTaxCountry	WTax C/R Key
	PreviousAccountNumber	P_SupplierWithCompanyCode	PreviousAccountNumber	Prev.Acct No.
	MinorityGroup	P_SupplierWithCompanyCode	MinorityGroup	Minority Indic.
	DataControllerSet	P_SupplierWithCompanyCode	DataControllerSet	Data Ctrlr. Set
	PurOrdAutoGenerationIsAllowed	_SuppCoCodePurOrg	PurOrdAutoGenerationIsAllowed	Automatic PO
	PurchasingGroup	_SuppCoCodePurOrg	PurchasingGroup	Purchasing Group
	SupplierPurgOrgPaymentTerms	_SuppCoCodePurOrg	SupplierPurgOrgPaymentTerms
	PurchasingIsBlockedForSupplier	_SuppCoCodePurOrg	PurchasingIsBlockedForSupplier	Pur. block POrg
	SuplrIsDeltdPurgOrg	_SuppCoCodePurOrg	SuplrIsDeltdPurgOrg
	InvoiceIsGoodsReceiptBased	_SuppCoCodePurOrg	InvoiceIsGoodsReceiptBased	GR-Based IV
	PurchaseOrderCurrency	_SuppCoCodePurOrg	PurchaseOrderCurrency	Order currency
	IncotermsClassification	_SuppCoCodePurOrg	IncotermsClassification	Incoterms
	IncotermsTransferLocation	_SuppCoCodePurOrg	IncotermsTransferLocation	Incoterms 2
	_StandardAddress	P_SupplierWithCompanyCode	_StandardAddress
	_SupplierAccountGroup	P_SupplierWithCompanyCode	_SupplierAccountGroup
	_SupplierAccountGroupText	P_SupplierWithCompanyCode	_SupplierAccountGroupText
	SupplierReleaseGroup	P_SupplierWithCompanyCode	SupplierReleaseGroup	Release Group
	SupplierAccountNote	P_SupplierWithCompanyCode	SupplierAccountNote	Account Memo
	_IncotermsClassification	_SuppCoCodePurOrg	_IncotermsClassification

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_SuplrCoCodePurOrgAssgmt.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: PSUCOCOPUORASGMT

CREATE VIEW P_SuplrCoCodePurOrgAssgmt AS
SELECT
  _SuppWithCoCode.Supplier AS Supplier,
  _SuppWithCoCode.CompanyCode AS CompanyCode,
  _SuppCoCodePurOrg.PurchasingOrganization AS PurchasingOrganization,
  _SuppWithCoCode.AuthorizationGroup AS AuthorizationGroup,
  _SuppWithCoCode.SupplierAccountGroup AS SupplierAccountGroup,
  _SuppWithCoCode.BPSupplierName AS SupplierName,
  _SuppWithCoCode.BPSupplierFullName AS SupplierFullName,
  _SuppWithCoCode.CreatedByUser AS CreatedByUser,
  _SuppWithCoCode.CreationDate AS CreationDate,
  _SuppWithCoCode.AccountIsBlockedForPosting AS AccountIsBlockedForPosting,
  _SuppWithCoCode.TaxNumber1 AS TaxNumber1,
  _SuppWithCoCode.TaxNumber2 AS TaxNumber2,
  _SuppWithCoCode.TaxNumber3 AS TaxNumber3,
  _SuppWithCoCode.TaxNumber4 AS TaxNumber4,
  _SuppWithCoCode.TaxNumber5 AS TaxNumber5,
  _SuppWithCoCode.PurchasingIsBlocked AS PurchasingIsBlocked,
  _SuppWithCoCode.AddressID AS AddressID,
  _SuppWithCoCode.BusinessPartnerName1 AS OrganizationBPName1,
  _SuppWithCoCode.BusinessPartnerName2 AS OrganizationBPName2,
  _SuppWithCoCode.BPAddrCityName AS CityName,
  _SuppWithCoCode.PostalCode AS PostalCode,
  _SuppWithCoCode.BPAddrStreetName AS StreetName,
  _SuppWithCoCode.Region AS Region,
  _SuppWithCoCode.Country AS Country,
  _SuppWithCoCode.AlternativePayeeAccountNumber AS AlternativePayeeAccountNumber,
  _SuppWithCoCode.AlternativePayee AS AlternativePayee,
  _SuppWithCoCode.PhoneNumber1 AS PhoneNumber1,
  _SuppWithCoCode.FaxNumber AS FaxNumber,
  _SuppWithCoCode.IsNaturalPerson AS IsNaturalPerson,
  _SuppWithCoCode.TaxNumberResponsible AS TaxNumberResponsible,
  _SuppWithCoCode.VATLiability AS VATLiability,
  _SuppWithCoCode.ResponsibleType AS ResponsibleType,
  _SuppWithCoCode.TaxNumberType AS TaxNumberType,
  _SuppWithCoCode.PaymentIsBlockedForSupplier AS PaymentIsBlockedForSupplier,
  _SuppWithCoCode.PhoneNumber2 AS PhoneNumber2,
  _SuppWithCoCode.TradingPartner AS TradingPartner,
  _SuppWithCoCode.LayoutSortingRule AS LayoutSortingRule,
  _SuppWithCoCode.ReconciliationAccount AS ReconciliationAccount,
  _SuppWithCoCode.PaymentMethodsList AS PaymentMethodsList,
  _SuppWithCoCode.AccountingClerk AS AccountingClerk,
  _SuppWithCoCode.AccountingClerkFaxNumber AS AccountingClerkFaxNumber,
  _SuppWithCoCode.SupplierClerkURL AS SupplierClerkURL,
  _SuppWithCoCode.AccountingClerkPhoneNumber AS AccountingClerkPhoneNumber,
  _SuppWithCoCode.SuplrCoCodePaymentTerms AS SuplrCoCodePaymentTerms,
  _SuppWithCoCode.PaymentBlockingReason AS PaymentBlockingReason,
  _SuppWithCoCode.DeletionIndicator AS DeletionIndicator,
  _SuppWithCoCode.SuplrIsDeltdCoCode AS SuplrIsDeltdCoCode,
  _SuppWithCoCode.CashPlanningGroup AS CashPlanningGroup,
  _SuppWithCoCode.IsToBeCheckedForDuplicates AS IsToBeCheckedForDuplicates,
  _SuppWithCoCode.CompanyCodeName AS CompanyCodeName,
  _SuppWithCoCode.SupplierIsBlockedForPosting AS SupplierIsBlockedForPosting,
  _SuppWithCoCode.WithholdingTaxCountry AS WithholdingTaxCountry,
  _SuppWithCoCode.PreviousAccountNumber AS PreviousAccountNumber,
  _SuppWithCoCode.MinorityGroup AS MinorityGroup,
  _SuppWithCoCode.DataControllerSet AS DataControllerSet,
  _SuppCoCodePurOrg.PurOrdAutoGenerationIsAllowed AS PurOrdAutoGenerationIsAllowed,
  _SuppCoCodePurOrg.PurchasingGroup AS PurchasingGroup,
  _SuppCoCodePurOrg.SupplierPurgOrgPaymentTerms AS SupplierPurgOrgPaymentTerms,
  _SuppCoCodePurOrg.PurchasingIsBlockedForSupplier AS PurchasingIsBlockedForSupplier,
  _SuppCoCodePurOrg.SuplrIsDeltdPurgOrg AS SuplrIsDeltdPurgOrg,
  _SuppCoCodePurOrg.InvoiceIsGoodsReceiptBased AS InvoiceIsGoodsReceiptBased,
  _SuppCoCodePurOrg.PurchaseOrderCurrency AS PurchaseOrderCurrency,
  _SuppCoCodePurOrg.IncotermsClassification AS IncotermsClassification,
  _SuppCoCodePurOrg.IncotermsTransferLocation AS IncotermsTransferLocation,
  _SuppWithCoCode._StandardAddress AS _StandardAddress,
  _SuppWithCoCode._SupplierAccountGroup AS _SupplierAccountGroup,
  _SuppWithCoCode._SupplierAccountGroupText AS _SupplierAccountGroupText,
  _SuppWithCoCode.SupplierReleaseGroup AS SupplierReleaseGroup,
  _SuppWithCoCode.SupplierAccountNote AS SupplierAccountNote,
  _SuppCoCodePurOrg._IncotermsClassification AS _IncotermsClassification
FROM P_SupplierWithCompanyCode AS _SuppWithCoCode
LEFT OUTER JOIN P_SuplrCoCodePurgOrganization AS _SuppCoCodePurOrg ON _SuppCoCodePurOrg.Supplier = _SuppWithCoCode.Supplier AND _SuppCoCodePurOrg.CompanyCode = _SuppWithCoCode.CompanyCode  -- association [0..*]
;

Depth:

P_SuplrCoCodePurOrgAssgmt view

P_SupplierWithCompanyCode view

C_Supplier view