R_JP_JrnlEntrItmSubstnTP

DDL: R_JP_JRNLENTRITMSUBSTNTP Type: view_entity TRANSACTIONAL Package: GLO_FIN_JP_SUPPLIER_INVCSUMMRY
37 Fields 1 Data Sources 1 Associations

Japan Supplier Invoice Summary Item - TP

R_JP_JrnlEntrItmSubstnTP is a Transactional CDS View that provides data about "Japan Supplier Invoice Summary Item - TP" in SAP S/4HANA. It reads from 1 data source (I_JP_JrnlEntrItmSubstitution) 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
I_JP_JrnlEntrItmSubstitution I_JP_JrnlEntrItmSubstitution from

Associations (1)

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

Annotations (12)

NameValueLevelField
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Search.searchable true view
ObjectModel.representativeKey JrnlEntryItemSubstitutionUUID view
EndUserText.label Japan Supplier Invoice Summary Item - TP view
Metadata.ignorePropagatedAnnotations true view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.sapObjectNodeType.name JP_JrnlEntryItemSubstitution 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 Group.Unit
SuplrInvoiceSummaryClosingDate SuplrInvoiceSummaryClosingDate Clos.Date
SuplrInvcSmmryDueDate SuplrInvcSmmryDueDate Due On
SuplrInvcSummaryClearingDate SuplrInvcSummaryClearingDate Paid Up To
SupplierInvoiceSummaryNumber SupplierInvoiceSummaryNumber
SuplrInvcSmmryIsExcluded SuplrInvcSmmryIsExcluded Not Incl. In MI
SuplrInvcSmmryIsBlocked SuplrInvcSmmryIsBlocked MI Block
SuplrInvcSmmryItemCategory SuplrInvcSmmryItemCategory WComp Item Cat.
SuplrInvcSmmryNetAmount SuplrInvcSmmryNetAmount Net Amount
SuplrInvcSmmryTaxAmount SuplrInvcSmmryTaxAmount Tax Amount
TaxCode TaxCode Tax Code
TaxCodeValidFrom TaxCodeValidFrom Tax Rate Valid-From
SuplrInvcSmmry1stAddlNetAmount SuplrInvcSmmry1stAddlNetAmount Net amount 1
SuplrInvcSmmry1stAddlTaxAmount SuplrInvcSmmry1stAddlTaxAmount Tax amount 1
SuplrInvcSmmryAddlTaxCode1 SuplrInvcSmmryAddlTaxCode1 Tax Code
SuplrInvcSmmry1stTaxFromDate SuplrInvcSmmry1stTaxFromDate Tax Rate Valid-From
SuplrInvcSmmry2ndAddlNetAmount SuplrInvcSmmry2ndAddlNetAmount Net amount 2
SuplrInvcSmmry2ndAddlTaxAmount SuplrInvcSmmry2ndAddlTaxAmount Tax amount 2
SuplrInvcSmmryAddlTaxCode2 SuplrInvcSmmryAddlTaxCode2 W/Tax Code
SuplrInvcSmmry2ndTaxFromDate SuplrInvcSmmry2ndTaxFromDate Tax Rate Valid-From
SuplrInvcSmmry3rdAddlNetAmount SuplrInvcSmmry3rdAddlNetAmount Net amount 3
SuplrInvcSmmry3rdAddlTaxAmount SuplrInvcSmmry3rdAddlTaxAmount Tax amount 3
SuplrInvcSmmryAddlTaxCode3 SuplrInvcSmmryAddlTaxCode3 Tax Code
SuplrInvcSmmry3rdTaxFromDate SuplrInvcSmmry3rdTaxFromDate Tax Rate Valid-From
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 R_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 R_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 I_JP_JrnlEntrItmSubstitution
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [1..1]
;

Learn More