C_JP_SubcontrgSubcontractor2DP

DDL: C_JP_SUBCONTRGSUBCONTRACTOR2DP Type: view_entity CONSUMPTION Package: GLO_LOG_JP_SC_PS
14 Fields 1 Data Sources

Item for JP Subcontractor List Form

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

Data Sources (1)

SourceAliasJoin Type
R_JP_SubcontrgSubcontractor R_JP_SubcontrgSubcontractor from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Item 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 (14)

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
JP_CapitalAmount JP_CapitalAmount
JP_SupplierCapitalAmountCrcy JP_SupplierCapitalAmountCrcy
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
JP_EmployeeNumber JP_EmployeeNumber

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_SubcontrgSubcontractor2DP.
-- 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_SubcontrgSubcontractor2DP AS
SELECT
  Supplier,
  CompanyCode,
  PurchasingOrganization,
  CompanyCodeName,
  BPSupplierName,
  JP_CapitalAmount,
  JP_SupplierCapitalAmountCrcy,
  PaymentTerms,
  Country,
  JP_SubcontractorType,
  JP_CompletionDateOfInspValue,
  PurchasingOrganizationName,
  JP_SubcontractorTypeDomainText,
  JP_EmployeeNumber
FROM R_JP_SubcontrgSubcontractor
;

Learn More