C_Purdoclistsuplrvalhelp

DDL: C_PURDOCLISTSUPLRVALHELP SQL: CDOCLVHSUPLR Type: view CONSUMPTION Package: ODATA_MM_PUR_DOCLIST
12 Fields 4 Associations

Monitor Puchasing Documents: Value Help for Supplier

C_Purdoclistsuplrvalhelp is a Consumption CDS View that provides data about "Monitor Puchasing Documents: Value Help for Supplier" in SAP S/4HANA. It has 4 associations to related views. Part of development package ODATA_MM_PUR_DOCLIST.

Associations (4)

CardinalityTargetAliasCondition
[1..1] C_PurDocListPODtl podtl podtl.supplier = lfa1.lifnr
[1..1] lfb1 _SupplierMaster lfa1.lifnr = _SupplierMaster.lifnr
[1..1] t005t _CountryNames lfa1.land1 = _CountryNames.land1
[1..1] t005u _RegionNames lfa1.land1 = _RegionNames.land1 and _RegionNames.bland = lfa1.regio

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName CDOCLVHSUPLR view
VDM.viewType #CONSUMPTION view
EndUserText.label Monitor Puchasing Documents: Value Help for Supplier view
AccessControl.authorizationCheck #CHECK view
VDM.private true view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY Supplier podtl supplier Supplier
KEY CompanyCode _SupplierMaster bukrs Value
SupplierName lfa1 name1 PA text
CountryKey lfa1 land1 Trip Ctry/Reg
City lfa1 ort01 Province
PostalCode lfa1 pstlz Postal Code
Region lfa1 regio Resident Region
AuthorizationGroup lfa1 begru AuthorizGroup
SupplierAccountGroup lfa1 ktokk Vendor Group
DataControllerSet lfa1 xdcset Data Ctrlr. Set
_CountryNames _CountryNames
_RegionNames _RegionNames

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_Purdoclistsuplrvalhelp.
-- 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: CDOCLVHSUPLR

CREATE VIEW C_Purdoclistsuplrvalhelp AS
SELECT
  podtl.supplier AS Supplier,
  _SupplierMaster.bukrs AS CompanyCode,
  lfa1.name1 AS SupplierName,
  lfa1.land1 AS CountryKey,
  lfa1.ort01 AS City,
  lfa1.pstlz AS PostalCode,
  lfa1.regio AS Region,
  lfa1.begru AS AuthorizationGroup,
  lfa1.ktokk AS SupplierAccountGroup,
  lfa1.xdcset AS DataControllerSet
LEFT OUTER JOIN C_PurDocListPODtl AS podtl ON podtl.supplier = lfa1.lifnr  -- association [1..1]
LEFT OUTER JOIN lfb1 AS _SupplierMaster ON lfa1.lifnr = _SupplierMaster.lifnr  -- association [1..1]
LEFT OUTER JOIN t005t AS _CountryNames ON lfa1.land1 = _CountryNames.land1  -- association [1..1]
LEFT OUTER JOIN t005u AS _RegionNames ON lfa1.land1 = _RegionNames.land1 AND _RegionNames.bland = lfa1.regio  -- association [1..1]
;

Learn More