C_PurOrdMaintainCoCodeValHelp

DDL: C_PURORDMAINTAINCOCODEVALHELP SQL: CPOMAINTVHCOCODE Type: view CONSUMPTION
17 Fields 2 Data Sources 2 Associations

PO Maintenance: Value Help for Company Code

C_PurOrdMaintainCoCodeValHelp is a Consumption CDS View that provides data about "PO Maintenance: Value Help for Company Code" in SAP S/4HANA. It reads from 2 data sources (I_CompanyCode, I_PurchasingOrganization) and exposes 17 fields with key fields CompanyCode, Supplier. It has 2 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_CompanyCode _CompanyCode from
I_PurchasingOrganization _PurchasingOrganization left_outer

Associations (2)

CardinalityTargetAliasCondition
[0..*] lfb1 _SupplierMaster $projection.CompanyCode = _SupplierMaster.bukrs
[0..*] I_SupplierCompany _SupplierCompany $projection.CompanyCode = _SupplierCompany.CompanyCode

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CPOMAINTVHCOCODE view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey CompanyCode view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
EndUserText.label PO Maintenance: Value Help for Company Code view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_CompanyCode CompanyCode Receiver Company Code
KEY Supplier _SupplierMaster lifnr Vendor no.
CompanyCodeName I_CompanyCode CompanyCodeName Company Name
PurchasingOrganization I_PurchasingOrganization PurchasingOrganization Purchasing Organization
AuthorizationGroup _SupplierMaster begru AuthorizGroup
DataController1
DataController2
DataController3
DataController4
DataController5
DataController6
DataController7
DataController8
DataController9
DataController10
DataControllerSet
_SupplierCompany _SupplierCompany

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 C_PurOrdMaintainCoCodeValHelp.
-- 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: CPOMAINTVHCOCODE

CREATE VIEW C_PurOrdMaintainCoCodeValHelp AS
SELECT
  _CompanyCode.CompanyCode AS CompanyCode,
  _SupplierMaster.lifnr AS Supplier,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  _PurchasingOrganization.PurchasingOrganization AS PurchasingOrganization,
  _SupplierMaster.begru AS AuthorizationGroup,
  _SupplierCompany._Supplier.DataController1 AS DataController1,
  _SupplierCompany._Supplier.DataController2 AS DataController2,
  _SupplierCompany._Supplier.DataController3 AS DataController3,
  _SupplierCompany._Supplier.DataController4 AS DataController4,
  _SupplierCompany._Supplier.DataController5 AS DataController5,
  _SupplierCompany._Supplier.DataController6 AS DataController6,
  _SupplierCompany._Supplier.DataController7 AS DataController7,
  _SupplierCompany._Supplier.DataController8 AS DataController8,
  _SupplierCompany._Supplier.DataController9 AS DataController9,
  _SupplierCompany._Supplier.DataController10 AS DataController10,
  _SupplierCompany._Supplier.DataControllerSet AS DataControllerSet
FROM I_CompanyCode AS _CompanyCode
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganization ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN lfb1 AS _SupplierMaster ON CompanyCode = _SupplierMaster.bukrs  -- association [0..*]
LEFT OUTER JOIN I_SupplierCompany AS _SupplierCompany ON CompanyCode = _SupplierCompany.CompanyCode  -- association [0..*]
;

Learn More