C_JP_SubcontrgSubcontractor1DP

DDL: C_JP_SUBCONTRGSUBCONTRACTOR1DP Type: view_entity CONSUMPTION Package: GLO_LOG_JP_SC_PS
12 Fields 1 Data Sources 1 Associations

Header for JP Subcontractor List Form

C_JP_SubcontrgSubcontractor1DP is a Consumption CDS View that provides data about "Header for JP Subcontractor List Form" in SAP S/4HANA. It reads from 1 data source (R_JP_SubcontrgSubcontractor) and exposes 12 fields with key fields Supplier, CompanyCode, PurchasingOrganization. It has 1 association to related views. Part of development package GLO_LOG_JP_SC_PS.

Data Sources (1)

SourceAliasJoin Type
R_JP_SubcontrgSubcontractor R_JP_SubcontrgSubcontractor from

Associations (1)

CardinalityTargetAliasCondition
[0..*] C_JP_SubcontrgSubcontractor2DP _Item $projection.Supplier = _Item.Supplier and $projection.CompanyCode = _Item.CompanyCode or $projection.PurchasingOrganization = _Item.PurchasingOrganization

Annotations (8)

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

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY Supplier Supplier Supplier
KEY CompanyCode CompanyCode Receiver Company Code
KEY PurchasingOrganization PurchasingOrganization Purchasing Organization
CompanyCodeName CompanyCodeName Company Name
BPSupplierName BPSupplierName Supplier Name
PaymentTerms PaymentTerms Pyt Terms
Country Country Venue: Ctry/Reg
JP_SubcontractorType JP_SubcontractorType
JP_CompletionDateOfInspValue JP_CompletionDateOfInspValue
PurchasingOrganizationName PurchasingOrganizationName Purch. Org. Name
JP_SubcontractorTypeDomainText JP_SubcontractorTypeDomainText
_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_SubcontrgSubcontractor1DP.
-- 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_SubcontrgSubcontractor1DP AS
SELECT
  Supplier,
  CompanyCode,
  PurchasingOrganization,
  CompanyCodeName,
  BPSupplierName,
  PaymentTerms,
  Country,
  JP_SubcontractorType,
  JP_CompletionDateOfInspValue,
  PurchasingOrganizationName,
  JP_SubcontractorTypeDomainText
FROM R_JP_SubcontrgSubcontractor
LEFT OUTER JOIN C_JP_SubcontrgSubcontractor2DP AS _Item ON Supplier = _Item.Supplier AND CompanyCode = _Item.CompanyCode OR PurchasingOrganization = _Item.PurchasingOrganization  -- association [0..*]
;

Learn More