What is I_JVAInfoRecordAttachLink in SAP S/4HANA?

I_JVAInfoRecordAttachLink is a composite CDS view in SAP S/4HANA. JVABILLING Attachment Service It contains 15 fields.

Which tables does I_JVAInfoRecordAttachLink read from?

I_JVAInfoRecordAttachLink reads data from: I_JVABillingFileLink.

What VDM layer is I_JVAInfoRecordAttachLink?

I_JVAInfoRecordAttachLink is classified as a Composite view that combines data from multiple basic views.

I_JVAInfoRecordAttachLink

DDL: I_JVAINFORECORDATTACHLINK SQL: IRECFILELNK Type: view COMPOSITE

15 Fields 1 Data Sources

JVABILLING Attachment Service

I_JVAInfoRecordAttachLink (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Joint Venture Billing - Read · Cross Applications

I_JVAInfoRecordAttachLink is a Composite CDS View that provides data about "JVABILLING Attachment Service" in SAP S/4HANA. It reads from 1 data source (I_JVABillingFileLink) and exposes 15 fields with key fields CompanyCode, FiscalYear, FiscalPeriod, JointVenturePartner, CreationDate.

SAP API Hub

State	C1
Line of Business	Cross Applications
Application Component	CA-JVA-JVA
Capabilities	Association Target for Defining CDS Entities, Data Source in SQL Select, Data Source for Defining CDS Entities
Package	Cross Applications for SAP S/4HANA Cloud Private Edition

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Private Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Private Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Private Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP Extensibility Explorer for SAP S/4HANA Cloud Private Edition — Explore SAP S/4HANA Cloud Private Edition Extensibility options by leveraging the sample scenarios from SAP
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Private Edition
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
I_JVABillingFileLink	JVFile	from

Parameters (3)

Name	Type	Default
P_CompanyCode	bukrs
P_FiscalYear	gjahr
P_FiscalPeriod	poper

Annotations (12)

Name	Value	Level
AbapCatalog.sqlViewName	IRECFILELNK	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#MANDATORY	view
VDM.viewType	#COMPOSITE	view
VDM.lifecycle.contract.type	#PUBLIC_LOCAL_API	view
EndUserText.label	JVABILLING Attachment Service	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.sapObjectNodeType.name	JVABillingDocument	view
ObjectModel.usageType.sizeCategory	#M	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.serviceQuality	#C	view

Fields (15)

Key	Field	Source Table	Source Field	Description
KEY	CompanyCode	I_JVABillingFileLink	CompanyCode	Receiver Company Code
KEY	FiscalYear	I_JVABillingFileLink	FiscalYear	G/L Fiscal Year
KEY	FiscalPeriod	I_JVABillingFileLink	FiscalPeriod	Posting Period
KEY	JointVenturePartner	I_JVABillingFileLink	JointVenturePartner	Joint Venture Partner
KEY	CreationDate	I_JVABillingFileLink	CreationDate	Time Stamp
KEY	LinkedSAPObjectKey	I_JVABillingFileLink	ObjectKey	Document Management Object Key
KEY	JVABillingFileType	I_JVABillingFileLink	JVABillingFileType	Billing File Type
	DocumentInfoRecordDocType	_DirObjectLinks	DocumentInfoRecordDocType	Document Type
	DocumentInfoRecordDocNumber	_DirObjectLinks	DocumentInfoRecordDocNumber	Document number
	DocumentInfoRecordDocPart	_DirObjectLinks	DocumentInfoRecordDocPart	Document Part
	DocumentInfoRecordDocVersion	_DirObjectLinks	DocumentInfoRecordDocVersion	Document Version
	LinkedSAPObject	_DirObjectLinks	LinkedSAPObject	Linked SAP Object
	LogicalDocument	_DirOriginals	LogicalDocument	Logical document
	PhysicalDocument	_DirOriginals	PhysicalDocument	Physical document
	WorkstationApplication	_DirOriginals	WorkstationApplication	Application

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 I_JVAInfoRecordAttachLink.
-- 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.
-- SQL view name: IRECFILELNK
-- Parameters: P_CompanyCode : bukrs, P_FiscalYear : gjahr, P_FiscalPeriod : poper

CREATE VIEW I_JVAInfoRecordAttachLink AS
SELECT
  JVFile.CompanyCode AS CompanyCode,
  JVFile.FiscalYear AS FiscalYear,
  JVFile.FiscalPeriod AS FiscalPeriod,
  JVFile.JointVenturePartner AS JointVenturePartner,
  JVFile.CreationDate AS CreationDate,
  JVFile.ObjectKey AS LinkedSAPObjectKey,
  JVFile.JVABillingFileType AS JVABillingFileType,
  _DirObjectLinks.DocumentInfoRecordDocType AS DocumentInfoRecordDocType,
  _DirObjectLinks.DocumentInfoRecordDocNumber AS DocumentInfoRecordDocNumber,
  _DirObjectLinks.DocumentInfoRecordDocPart AS DocumentInfoRecordDocPart,
  _DirObjectLinks.DocumentInfoRecordDocVersion AS DocumentInfoRecordDocVersion,
  _DirObjectLinks.LinkedSAPObject AS LinkedSAPObject,
  _DirOriginals.LogicalDocument AS LogicalDocument,
  _DirOriginals.PhysicalDocument AS PhysicalDocument,
  _DirOriginals.WorkstationApplication AS WorkstationApplication
FROM I_JVABillingFileLink AS JVFile
;

Depth:

I_JVAInfoRecordAttachLink view

I_JVABillingFileLink view