C_JP_SubcontrgChrgblCompPr2DP

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

JP Subcontrg Item for Price List Form

C_JP_SubcontrgChrgblCompPr2DP is a Consumption CDS View that provides data about "JP Subcontrg Item 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. Part of development package GLO_LOG_JP_SC_PCP.

Data Sources (1)

SourceAliasJoin Type
R_JP_SubcontrgChrgblCompPr R_JP_SubcontrgChrgblCompPr from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label JP Subcontrg Item 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
MaterialName MaterialName Material Description
ValidityEndDate ValidityEndDate ValidTo
NetPriceAmount NetPriceAmount Net Price
Currency Currency Valuation Crcy
StandardPurchaseOrderQuantity StandardPurchaseOrderQuantity Standard Qty
PurchaseOrderPriceUnit PurchaseOrderPriceUnit Order Price Un.
PurchasingInfoRecordCategory PurchasingInfoRecordCategory Infotype
PurchasingOrganization PurchasingOrganization Purchasing Organization
MaterialGroup MaterialGroup Product Group
ValidityStartDate

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_SubcontrgChrgblCompPr2DP.
-- 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_SubcontrgChrgblCompPr2DP AS
SELECT
  Supplier,
  Material,
  PurchasingInfoRecord,
  Plant,
  MaterialName,
  ValidityEndDate,
  NetPriceAmount,
  Currency,
  StandardPurchaseOrderQuantity,
  PurchaseOrderPriceUnit,
  PurchasingInfoRecordCategory,
  PurchasingOrganization,
  MaterialGroup,
  $session.system_date AS ValidityStartDate
FROM R_JP_SubcontrgChrgblCompPr
;

Learn More