C_JP_SubcontrgChrgblCompPr1DP

DDL: C_JP_SUBCONTRGCHRGBLCOMPPR1DP Type: view_entity CONSUMPTION Package: GLO_LOG_JP_SC_PCP
14 Fields 1 Data Sources 1 Associations

JP Subcontrg Header for Price List Form

C_JP_SubcontrgChrgblCompPr1DP is a Consumption CDS View that provides data about "JP Subcontrg Header for Price List Form" in SAP S/4HANA. It reads from 1 data source (R_JP_SubcontrgChrgblCompPr) and exposes 14 fields with key fields Supplier, Material, PurchasingInfoRecord, Plant. It has 1 association to related views. Part of development package GLO_LOG_JP_SC_PCP.

Data Sources (1)

SourceAliasJoin Type
R_JP_SubcontrgChrgblCompPr R_JP_SubcontrgChrgblCompPr from

Associations (1)

CardinalityTargetAliasCondition
[0..*] C_JP_SubcontrgChrgblCompPr2DP _Item $projection.Material = _Item.Material and $projection.Supplier = _Item.Supplier

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label JP Subcontrg Header for Price List Form view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY Supplier Supplier Supplier
KEY Material Material Vehicle Model
KEY PurchasingInfoRecord PurchasingInfoRecord Info Record
KEY Plant Plant Valuation Area
BPSupplierName BPSupplierName Supplier Name
AddressID AddressID Ship-to address
CityName CityName Name
StreetName StreetName Text
PostalCode PostalCode Postal Code
DistrictName DistrictName District
Country Country Venue: Ctry/Reg
CurrentDate CurrentDate
PurchasingOrganization PurchasingOrganization Purchasing Organization
_Item _Item

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_JP_SubcontrgChrgblCompPr1DP.
-- 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.

CREATE VIEW C_JP_SubcontrgChrgblCompPr1DP AS
SELECT
  Supplier,
  Material,
  PurchasingInfoRecord,
  Plant,
  BPSupplierName,
  AddressID,
  CityName,
  StreetName,
  PostalCode,
  DistrictName,
  Country,
  CurrentDate,
  PurchasingOrganization
FROM R_JP_SubcontrgChrgblCompPr
LEFT OUTER JOIN C_JP_SubcontrgChrgblCompPr2DP AS _Item ON Material = _Item.Material AND Supplier = _Item.Supplier  -- association [0..*]
;

Learn More