P_SupplierWithCompanyCode

DDL: P_SUPPLIERWITHCOMPANYCODE SQL: PSUPPLIERCOCODE Type: view COMPOSITE Package: ODATA_SUPPLIER_LIST
103 Fields 1 Data Sources

Supplier extended by Company Code

P_SupplierWithCompanyCode is a Composite CDS View that provides data about "Supplier extended by Company Code" in SAP S/4HANA. It reads from 1 data source (I_Supplier) and exposes 103 fields with key fields Supplier, CompanyCode. Part of development package ODATA_SUPPLIER_LIST.

Data Sources (1)

SourceAliasJoin Type
I_Supplier I_Supplier from

Annotations (12)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName PSUPPLIERCOCODE view
Metadata.ignorePropagatedAnnotations true 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 #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (103)

KeyFieldSource TableSource FieldDescription
KEY Supplier Supplier Supplier
KEY CompanyCode _SupplierCompany CompanyCode Receiver Company Code
SupplierAccountGroup I_Supplier SupplierAccountGroup Account group
SupplierName I_Supplier SupplierName Supplier Name
BPSupplierName I_Supplier BPSupplierName Supplier Name
SupplierFullName I_Supplier SupplierFullName
BPSupplierFullName I_Supplier BPSupplierFullName
IsBusinessPurposeCompleted I_Supplier IsBusinessPurposeCompleted Purpose Completed
CreatedByUser I_Supplier CreatedByUser User Name
CreationDate I_Supplier CreationDate Time Stamp
IsOneTimeAccount I_Supplier IsOneTimeAccount One-time acct
AuthorizationGroup I_Supplier AuthorizationGroup AuthorizGroup
VATRegistration I_Supplier VATRegistration VAT Registration No.
AccountIsBlockedForPosting I_Supplier AccountIsBlockedForPosting Posting Block
TaxJurisdiction I_Supplier TaxJurisdiction Tax Jurisdiction
SupplierCorporateGroup I_Supplier SupplierCorporateGroup Group
Customer I_Supplier Customer Sold-to Party
Industry I_Supplier Industry Industry Sector
TaxNumber1 I_Supplier TaxNumber1 VAT Reg. No.
TaxNumber2 I_Supplier TaxNumber2 Tax Number 2
TaxNumber3 I_Supplier TaxNumber3 Tax Number 3
TaxNumber4 I_Supplier TaxNumber4 Tax Number 4
TaxNumber5 I_Supplier TaxNumber5 Tax Number 5
PostingIsBlocked I_Supplier PostingIsBlocked Posting Block
PurchasingIsBlocked I_Supplier PurchasingIsBlocked Purch. block
InternationalLocationNumber1 I_Supplier InternationalLocationNumber1 Location no. 1
InternationalLocationNumber2 I_Supplier InternationalLocationNumber2 Location no. 2
InternationalLocationNumber3 I_Supplier InternationalLocationNumber3 Check digit
AddressID I_Supplier AddressID Ship-to address
Region I_Supplier Region Venue Region
OrganizationBPName1 I_Supplier OrganizationBPName1 Name 1
BusinessPartnerName1 I_Supplier BusinessPartnerName1 Name
OrganizationBPName2 I_Supplier OrganizationBPName2 Name 2
BusinessPartnerName2 I_Supplier BusinessPartnerName2 Name 2
CityName I_Supplier CityName Name
BPAddrCityName I_Supplier BPAddrCityName Name
PostalCode I_Supplier PostalCode Postal Code
StreetName I_Supplier StreetName Text
BPAddrStreetName I_Supplier BPAddrStreetName Text
Country I_Supplier Country Venue: Ctry/Reg
SupplierProcurementBlock I_Supplier SupplierProcurementBlock Block Function
SuplrQualityManagementSystem I_Supplier SuplrQualityManagementSystem Target QM Sys.
SuplrQltyInProcmtCertfnValidTo I_Supplier SuplrQltyInProcmtCertfnValidTo QM System To
SupplierLanguage I_Supplier SupplierLanguage Off. Language
AlternativePayeeAccountNumber I_Supplier AlternativePayeeAccountNumber Alternat. Payee
PhoneNumber1 I_Supplier PhoneNumber1 Telephone 1
FaxNumber I_Supplier FaxNumber Fax Number
IsNaturalPerson I_Supplier IsNaturalPerson Natural person
TaxNumberResponsible I_Supplier TaxNumberResponsible Tax Number
UK_ContractorBusinessType I_Supplier UK_ContractorBusinessType Category
UK_PartnerTradingName I_Supplier UK_PartnerTradingName Prtnr Trad Name
UK_PartnerTaxReference I_Supplier UK_PartnerTaxReference Partner's UTR
UK_VerificationStatus I_Supplier UK_VerificationStatus Workflow Status
UK_VerificationNumber I_Supplier UK_VerificationNumber Verification N.
UK_CompanyRegistrationNumber I_Supplier UK_CompanyRegistrationNumber Comp. House Reg. No.
UK_VerifiedTaxStatus I_Supplier UK_VerifiedTaxStatus Tax Status
FormOfAddress I_Supplier FormOfAddress Title Key
ReferenceAccountGroup I_Supplier ReferenceAccountGroup Ref.Acct Group
VATLiability I_Supplier VATLiability Liable for VAT
ResponsibleType I_Supplier ResponsibleType Tax Type
TaxNumberType I_Supplier TaxNumberType Tax number type
FiscalAddress I_Supplier FiscalAddress Fiscal address
BusinessType I_Supplier BusinessType Type of Business
BirthDate I_Supplier BirthDate Date of Birth
PaymentIsBlockedForSupplier I_Supplier PaymentIsBlockedForSupplier Payment block
SortField I_Supplier SortField Sort Field
PhoneNumber2 I_Supplier PhoneNumber2 Telephone 2
DeletionIndicator I_Supplier DeletionIndicator Deletion Ind.
TradingPartner I_Supplier TradingPartner Trading Partner
TaxInvoiceRepresentativeName I_Supplier TaxInvoiceRepresentativeName Rep's Name
IndustryType I_Supplier IndustryType Type of Industry
IN_GSTSupplierClassification I_Supplier IN_GSTSupplierClassification GST Ven Class.
DataControllerSet I_Supplier DataControllerSet Data Ctrlr. Set
LayoutSortingRule _SupplierCompany LayoutSortingRule Sort key
ReconciliationAccount _SupplierCompany ReconciliationAccount Recon. account
PaymentMethodsList _SupplierCompany PaymentMethodsList Payment Methods
AccountingClerk _SupplierCompany AccountingClerk Clerk Abbrev.
AccountingClerkFaxNumber _SupplierCompany AccountingClerkFaxNumber Clerk's fax
SupplierClerkURL _SupplierCompany SupplierClerkURL
AccountingClerkPhoneNumber _SupplierCompany AccountingClerkPhoneNumber Act.clk tel.no.
SuplrCoCodePaymentTerms _SupplierCompany PaymentTerms Pyt Terms
PaymentBlockingReason _SupplierCompany PaymentBlockingReason Pmnt block
SuplrIsDeltdCoCode _SupplierCompany DeletionIndicator Deletion Ind.
CashPlanningGroup _SupplierCompany CashPlanningGroup Planning Group
IsToBeCheckedForDuplicates _SupplierCompany IsToBeCheckedForDuplicates
CompanyCodeName _SupplierCompany CompanyCodeName Company Name
SupplierIsBlockedForPosting _SupplierCompany SupplierIsBlockedForPosting Co.code post.block
WithholdingTaxCountry _SupplierCompany WithholdingTaxCountry WTax C/R Key
PreviousAccountNumber _SupplierCompany PreviousAccountNumber Prev.Acct No.
SupplierReleaseGroup _SupplierCompany SupplierReleaseGroup Release Group
MinorityGroup _SupplierCompany MinorityGroup Minority Indic.
AlternativePayee _SupplierCompany AlternativePayee Alternat.payee
SupplierAccountNote _SupplierCompany SupplierAccountNote Account Memo
_CorrespondingCustomer I_Supplier _CorrespondingCustomer
_Industry I_Supplier _Industry
_ProcurementBlock I_Supplier _ProcurementBlock
_QualityManagementSystem I_Supplier _QualityManagementSystem
_StandardAddress I_Supplier _StandardAddress
_SupplierAccountGroup I_Supplier _SupplierAccountGroup
_SupplierAccountGroupText I_Supplier _SupplierAccountGroupText
_SupplierBankDetails I_Supplier _SupplierBankDetails
_SupplierIndustryText I_Supplier _SupplierIndustryText
_SupplierToBusinessPartner I_Supplier _SupplierToBusinessPartner

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_SupplierWithCompanyCode.
-- 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: PSUPPLIERCOCODE

CREATE VIEW P_SupplierWithCompanyCode AS
SELECT
  Supplier,
  _SupplierCompany.CompanyCode AS CompanyCode,
  I_Supplier.SupplierAccountGroup AS SupplierAccountGroup,
  I_Supplier.SupplierName AS SupplierName,
  I_Supplier.BPSupplierName AS BPSupplierName,
  I_Supplier.SupplierFullName AS SupplierFullName,
  I_Supplier.BPSupplierFullName AS BPSupplierFullName,
  I_Supplier.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  I_Supplier.CreatedByUser AS CreatedByUser,
  I_Supplier.CreationDate AS CreationDate,
  I_Supplier.IsOneTimeAccount AS IsOneTimeAccount,
  I_Supplier.AuthorizationGroup AS AuthorizationGroup,
  I_Supplier.VATRegistration AS VATRegistration,
  I_Supplier.AccountIsBlockedForPosting AS AccountIsBlockedForPosting,
  I_Supplier.TaxJurisdiction AS TaxJurisdiction,
  I_Supplier.SupplierCorporateGroup AS SupplierCorporateGroup,
  I_Supplier.Customer AS Customer,
  I_Supplier.Industry AS Industry,
  I_Supplier.TaxNumber1 AS TaxNumber1,
  I_Supplier.TaxNumber2 AS TaxNumber2,
  I_Supplier.TaxNumber3 AS TaxNumber3,
  I_Supplier.TaxNumber4 AS TaxNumber4,
  I_Supplier.TaxNumber5 AS TaxNumber5,
  I_Supplier.PostingIsBlocked AS PostingIsBlocked,
  I_Supplier.PurchasingIsBlocked AS PurchasingIsBlocked,
  I_Supplier.InternationalLocationNumber1 AS InternationalLocationNumber1,
  I_Supplier.InternationalLocationNumber2 AS InternationalLocationNumber2,
  I_Supplier.InternationalLocationNumber3 AS InternationalLocationNumber3,
  I_Supplier.AddressID AS AddressID,
  I_Supplier.Region AS Region,
  I_Supplier.OrganizationBPName1 AS OrganizationBPName1,
  I_Supplier.BusinessPartnerName1 AS BusinessPartnerName1,
  I_Supplier.OrganizationBPName2 AS OrganizationBPName2,
  I_Supplier.BusinessPartnerName2 AS BusinessPartnerName2,
  I_Supplier.CityName AS CityName,
  I_Supplier.BPAddrCityName AS BPAddrCityName,
  I_Supplier.PostalCode AS PostalCode,
  I_Supplier.StreetName AS StreetName,
  I_Supplier.BPAddrStreetName AS BPAddrStreetName,
  I_Supplier.Country AS Country,
  I_Supplier.SupplierProcurementBlock AS SupplierProcurementBlock,
  I_Supplier.SuplrQualityManagementSystem AS SuplrQualityManagementSystem,
  I_Supplier.SuplrQltyInProcmtCertfnValidTo AS SuplrQltyInProcmtCertfnValidTo,
  I_Supplier.SupplierLanguage AS SupplierLanguage,
  I_Supplier.AlternativePayeeAccountNumber AS AlternativePayeeAccountNumber,
  I_Supplier.PhoneNumber1 AS PhoneNumber1,
  I_Supplier.FaxNumber AS FaxNumber,
  I_Supplier.IsNaturalPerson AS IsNaturalPerson,
  I_Supplier.TaxNumberResponsible AS TaxNumberResponsible,
  I_Supplier.UK_ContractorBusinessType AS UK_ContractorBusinessType,
  I_Supplier.UK_PartnerTradingName AS UK_PartnerTradingName,
  I_Supplier.UK_PartnerTaxReference AS UK_PartnerTaxReference,
  I_Supplier.UK_VerificationStatus AS UK_VerificationStatus,
  I_Supplier.UK_VerificationNumber AS UK_VerificationNumber,
  I_Supplier.UK_CompanyRegistrationNumber AS UK_CompanyRegistrationNumber,
  I_Supplier.UK_VerifiedTaxStatus AS UK_VerifiedTaxStatus,
  I_Supplier.FormOfAddress AS FormOfAddress,
  I_Supplier.ReferenceAccountGroup AS ReferenceAccountGroup,
  I_Supplier.VATLiability AS VATLiability,
  I_Supplier.ResponsibleType AS ResponsibleType,
  I_Supplier.TaxNumberType AS TaxNumberType,
  I_Supplier.FiscalAddress AS FiscalAddress,
  I_Supplier.BusinessType AS BusinessType,
  I_Supplier.BirthDate AS BirthDate,
  I_Supplier.PaymentIsBlockedForSupplier AS PaymentIsBlockedForSupplier,
  I_Supplier.SortField AS SortField,
  I_Supplier.PhoneNumber2 AS PhoneNumber2,
  I_Supplier.DeletionIndicator AS DeletionIndicator,
  I_Supplier.TradingPartner AS TradingPartner,
  I_Supplier.TaxInvoiceRepresentativeName AS TaxInvoiceRepresentativeName,
  I_Supplier.IndustryType AS IndustryType,
  I_Supplier.IN_GSTSupplierClassification AS IN_GSTSupplierClassification,
  I_Supplier.DataControllerSet AS DataControllerSet,
  _SupplierCompany.LayoutSortingRule AS LayoutSortingRule,
  _SupplierCompany.ReconciliationAccount AS ReconciliationAccount,
  _SupplierCompany.PaymentMethodsList AS PaymentMethodsList,
  _SupplierCompany.AccountingClerk AS AccountingClerk,
  _SupplierCompany.AccountingClerkFaxNumber AS AccountingClerkFaxNumber,
  _SupplierCompany.SupplierClerkURL AS SupplierClerkURL,
  _SupplierCompany.AccountingClerkPhoneNumber AS AccountingClerkPhoneNumber,
  _SupplierCompany.PaymentTerms AS SuplrCoCodePaymentTerms,
  _SupplierCompany.PaymentBlockingReason AS PaymentBlockingReason,
  _SupplierCompany.DeletionIndicator AS SuplrIsDeltdCoCode,
  _SupplierCompany.CashPlanningGroup AS CashPlanningGroup,
  _SupplierCompany.IsToBeCheckedForDuplicates AS IsToBeCheckedForDuplicates,
  _SupplierCompany.CompanyCodeName AS CompanyCodeName,
  _SupplierCompany.SupplierIsBlockedForPosting AS SupplierIsBlockedForPosting,
  _SupplierCompany.WithholdingTaxCountry AS WithholdingTaxCountry,
  _SupplierCompany.PreviousAccountNumber AS PreviousAccountNumber,
  _SupplierCompany.SupplierReleaseGroup AS SupplierReleaseGroup,
  _SupplierCompany.MinorityGroup AS MinorityGroup,
  _SupplierCompany.AlternativePayee AS AlternativePayee,
  _SupplierCompany.SupplierAccountNote AS SupplierAccountNote,
  I_Supplier._CorrespondingCustomer AS _CorrespondingCustomer,
  I_Supplier._Industry AS _Industry,
  I_Supplier._ProcurementBlock AS _ProcurementBlock,
  I_Supplier._QualityManagementSystem AS _QualityManagementSystem,
  I_Supplier._StandardAddress AS _StandardAddress,
  I_Supplier._SupplierAccountGroup AS _SupplierAccountGroup,
  I_Supplier._SupplierAccountGroupText AS _SupplierAccountGroupText,
  I_Supplier._SupplierBankDetails AS _SupplierBankDetails,
  I_Supplier._SupplierIndustryText AS _SupplierIndustryText,
  I_Supplier._SupplierToBusinessPartner AS _SupplierToBusinessPartner
FROM I_Supplier
;

Learn More