C_JP_JrnlEntrItmSubstnTP

DDL: C_JP_JRNLENTRITMSUBSTNTP Type: view_entity CONSUMPTION Package: GLO_FIN_JP_SUPPLIER_INVCSUMMRY
37 Fields 1 Data Sources 1 Associations

Japan Supplier Invoice Summary Item

C_JP_JrnlEntrItmSubstnTP is a Consumption CDS View that provides data about "Japan Supplier Invoice Summary Item" in SAP S/4HANA. It reads from 1 data source (R_JP_JrnlEntrItmSubstnTP) and exposes 37 fields with key field JrnlEntryItemSubstitutionUUID. It has 1 association to related views. Part of development package GLO_FIN_JP_SUPPLIER_INVCSUMMRY.

Data Sources (1)

SourceAliasJoin Type
R_JP_JrnlEntrItmSubstnTP R_JP_JrnlEntrItmSubstnTP projection

Associations (1)

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

Annotations (11)

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

Fields (37)

KeyFieldSource TableSource FieldDescription
KEY JrnlEntryItemSubstitutionUUID JrnlEntryItemSubstitutionUUID
CompanyCode CompanyCode Receiver Company Code
AccountingDocument AccountingDocument Journal Entry
FiscalYear FiscalYear G/L Fiscal Year
AccountingDocumentItem AccountingDocumentItem Posting View Item
AccountingDocumentCategory AccountingDocumentCategory Journal Entry Category
TransactionCurrency TransactionCurrency Transaction Currency
Supplier Supplier Supplier
SuplrInvcSmmryGroupingUnit SuplrInvcSmmryGroupingUnit
SuplrInvoiceSummaryClosingDate SuplrInvoiceSummaryClosingDate
SuplrInvcSmmryDueDate SuplrInvcSmmryDueDate
SuplrInvcSummaryClearingDate SuplrInvcSummaryClearingDate
SupplierInvoiceSummaryNumber SupplierInvoiceSummaryNumber
SuplrInvcSmmryIsExcluded SuplrInvcSmmryIsExcluded
SuplrInvcSmmryIsBlocked SuplrInvcSmmryIsBlocked
SuplrInvcSmmryItemCategory SuplrInvcSmmryItemCategory
SuplrInvcSmmryNetAmount SuplrInvcSmmryNetAmount
SuplrInvcSmmryTaxAmount SuplrInvcSmmryTaxAmount
TaxCode TaxCode Tax Code
TaxCodeValidFrom TaxCodeValidFrom Tax Rate Valid-From
SuplrInvcSmmry1stAddlNetAmount SuplrInvcSmmry1stAddlNetAmount
SuplrInvcSmmry1stAddlTaxAmount SuplrInvcSmmry1stAddlTaxAmount
SuplrInvcSmmryAddlTaxCode1 SuplrInvcSmmryAddlTaxCode1
SuplrInvcSmmry1stTaxFromDate SuplrInvcSmmry1stTaxFromDate
SuplrInvcSmmry2ndAddlNetAmount SuplrInvcSmmry2ndAddlNetAmount
SuplrInvcSmmry2ndAddlTaxAmount SuplrInvcSmmry2ndAddlTaxAmount
SuplrInvcSmmryAddlTaxCode2 SuplrInvcSmmryAddlTaxCode2
SuplrInvcSmmry2ndTaxFromDate SuplrInvcSmmry2ndTaxFromDate
SuplrInvcSmmry3rdAddlNetAmount SuplrInvcSmmry3rdAddlNetAmount
SuplrInvcSmmry3rdAddlTaxAmount SuplrInvcSmmry3rdAddlTaxAmount
SuplrInvcSmmryAddlTaxCode3 SuplrInvcSmmryAddlTaxCode3
SuplrInvcSmmry3rdTaxFromDate SuplrInvcSmmry3rdTaxFromDate
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_JrnlEntrItmSubstnTP.
-- 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_JrnlEntrItmSubstnTP AS
SELECT
  JrnlEntryItemSubstitutionUUID,
  CompanyCode,
  AccountingDocument,
  FiscalYear,
  AccountingDocumentItem,
  AccountingDocumentCategory,
  TransactionCurrency,
  Supplier,
  SuplrInvcSmmryGroupingUnit,
  SuplrInvoiceSummaryClosingDate,
  SuplrInvcSmmryDueDate,
  SuplrInvcSummaryClearingDate,
  SupplierInvoiceSummaryNumber,
  SuplrInvcSmmryIsExcluded,
  SuplrInvcSmmryIsBlocked,
  SuplrInvcSmmryItemCategory,
  SuplrInvcSmmryNetAmount,
  SuplrInvcSmmryTaxAmount,
  TaxCode,
  TaxCodeValidFrom,
  SuplrInvcSmmry1stAddlNetAmount,
  SuplrInvcSmmry1stAddlTaxAmount,
  SuplrInvcSmmryAddlTaxCode1,
  SuplrInvcSmmry1stTaxFromDate,
  SuplrInvcSmmry2ndAddlNetAmount,
  SuplrInvcSmmry2ndAddlTaxAmount,
  SuplrInvcSmmryAddlTaxCode2,
  SuplrInvcSmmry2ndTaxFromDate,
  SuplrInvcSmmry3rdAddlNetAmount,
  SuplrInvcSmmry3rdAddlTaxAmount,
  SuplrInvcSmmryAddlTaxCode3,
  SuplrInvcSmmry3rdTaxFromDate,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  ChangedDateTime
FROM R_JP_JrnlEntrItmSubstnTP
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [1..1]
;

Learn More