C_JP_SuplrInvcSmmryDocumentTP

DDL: C_JP_SUPLRINVCSMMRYDOCUMENTTP Type: view_entity CONSUMPTION Package: GLO_FIN_JP_SUPPLIER_INVCSUMMRY
16 Fields 1 Data Sources 1 Associations 1 OData Services

Japan Supplier Invoice Document

C_JP_SuplrInvcSmmryDocumentTP is a Consumption CDS View that provides data about "Japan Supplier Invoice Document" in SAP S/4HANA. It reads from 1 data source (R_JP_SuplrInvcSmmryDocumentTP) and exposes 16 fields with key field SuplrInvcSmmryDocumentUUID. It has 1 association to related views. It is exposed through 1 OData service (UI_JP_SUPLRINVCSUMMARY). Part of development package GLO_FIN_JP_SUPPLIER_INVCSUMMRY.

Data Sources (1)

SourceAliasJoin Type
R_JP_SuplrInvcSmmryDocumentTP R_JP_SuplrInvcSmmryDocumentTP projection

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_Supplier _Supplier $projection.Supplier = _Supplier.Supplier

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
VDM.viewType #CONSUMPTION view
ObjectModel.representativeKey SuplrInvcSmmryDocumentUUID view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
Metadata.allowExtensions true view
Search.searchable true view
EndUserText.label Japan Supplier Invoice Document view
Metadata.ignorePropagatedAnnotations true view

OData Services (1)

ServiceBindingVersionContractRelease
UI_JP_SUPLRINVCSUMMARY UI_JP_SUPLRINVCSUMMARY V4 C1 NOT_RELEASED

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY SuplrInvcSmmryDocumentUUID SuplrInvcSmmryDocumentUUID
CompanyCode CompanyCode Receiver Company Code
SupplierInvoiceSummaryNumber SupplierInvoiceSummaryNumber
TransactionCurrency TransactionCurrency Transaction Currency
Supplier Supplier Supplier
SuplrInvcSmmryGroupingUnit SuplrInvcSmmryGroupingUnit
SuplrInvoiceSummaryClosingDate SuplrInvoiceSummaryClosingDate
SuplrInvcSmmryDueDate SuplrInvcSmmryDueDate
SuplrInvcSmmryNetAmount SuplrInvcSmmryNetAmount
SuplrInvcSmmryTaxAmount SuplrInvcSmmryTaxAmount
SuplrInvoiceSummaryIsCancelled SuplrInvoiceSummaryIsCancelled
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
ChangedDateTime ChangedDateTime Time Stamp
_Supplier _Supplier

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_SuplrInvcSmmryDocumentTP.
-- 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_SuplrInvcSmmryDocumentTP AS
SELECT
  SuplrInvcSmmryDocumentUUID,
  CompanyCode,
  SupplierInvoiceSummaryNumber,
  TransactionCurrency,
  Supplier,
  SuplrInvcSmmryGroupingUnit,
  SuplrInvoiceSummaryClosingDate,
  SuplrInvcSmmryDueDate,
  SuplrInvcSmmryNetAmount,
  SuplrInvcSmmryTaxAmount,
  SuplrInvoiceSummaryIsCancelled,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  ChangedDateTime
FROM R_JP_SuplrInvcSmmryDocumentTP
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [1..1]
;

Learn More