What is I_ValnDocAcctgItem in SAP S/4HANA?

I_ValnDocAcctgItem is a basic CDS view in SAP S/4HANA. Valuation Document Accounting Item It contains 0 fields.

Which tables does I_ValnDocAcctgItem read from?

I_ValnDocAcctgItem reads data from: /pra/vl_acc_doc.

What VDM layer is I_ValnDocAcctgItem?

I_ValnDocAcctgItem is classified as a Basic (interface) view providing a 1:1 representation of a database table.

I_ValnDocAcctgItem

DDL: I_VALNDOCACCTGITEM SQL: IPVVLDOCACCTDOC Type: view BASIC

1 Data Sources 70 Associations

Valuation Document Accounting Item

I_ValnDocAcctgItem is a Basic CDS View (Cube) that provides data about "Valuation Document Accounting Item" in SAP S/4HANA. It reads from 1 data source (/pra/vl_acc_doc). It has 70 associations to related views.

Data Sources (1)

Source	Alias	Join Type
/pra/vl_acc_doc	/pra/vl_acc_doc	from

Associations (70)

Cardinality	Target	Alias	Condition
[0..1]	I_CalendarYear	_ValuationDocumentYear	`$projection.ValuationDocumentYear = _ValuationDocumentYear.CalendarYear`
[0..1]	I_ValuationDocumentHdr	_ValuationDocumentHdr	`$projection.ValuationDocumentYear = _ValuationDocumentHdr.ValuationDocumentYear and $projection.ValuationDocumentNumber = _ValuationDocumentHdr.ValuationDocumentNumber`
[0..1]	I_BookingReversalType	_BookingReversalType	`$projection.BookingReversalType = _BookingReversalType.BookingReversalType`
[0..1]	I_PRAOwner	_PRAOwner	`$projection.PRAOwner = _PRAOwner.PRAOwner`
[0..1]	I_PRAGLAccountType	_GLAccountType	`$projection.GLAccountType = _GLAccountType.GLAccountType`
[0..1]	I_OwnerInterestType	_OwnerInterestType	`$projection.OwnerInterestType = _OwnerInterestType.OwnerInterestType`
[0..1]	I_CompanyCode	_CompanyCode	`$projection.CompanyCode = _CompanyCode.CompanyCode`
[0..1]	I_CompanyCode	_ProcessingCompanyCode	`$projection.ProcessingCompanyCode = _ProcessingCompanyCode.CompanyCode`
[0..1]	I_CompanyCode	_AffiliatedCompanyCode	`$projection.AffiliatedCompanyCode = _AffiliatedCompanyCode.CompanyCode`
[0..1]	I_PRAAcctDetnCategory	_AcctDeterminationCategory	`$projection.AcctDeterminationCategory = _AcctDeterminationCategory.AcctDeterminationCategory`
[0..1]	I_Material	_Material	`$projection.Material = _Material.Material`
[0..1]	I_VolumeType	_VolumeType	`$projection.VolumeType = _VolumeType.VolumeType`
[0..1]	I_Partnercompany	_PartnerCompany	`$projection.PartnerCompany = _PartnerCompany.PartnerCompany`
[0..1]	I_PRAJointVenture	_PRAJointVenture	`$projection.CompanyCode = _PRAJointVenture.CompanyCode and $projection.JointVenture = _PRAJointVenture.PRAJointVenture`
[0..1]	I_PRAJointVenture	_UnitJointVenture	`$projection.CompanyCode = _UnitJointVenture.CompanyCode and $projection.UnitJointVenture = _UnitJointVenture.PRAJointVenture`
[0..1]	I_PRAJointVenture	_GasPlantJointVenture	`$projection.CompanyCode = _GasPlantJointVenture.CompanyCode and $projection.GasPlantJointVenture = _GasPlantJointVenture.PRAJointVenture`
[0..1]	I_PRAJointVenture	_ExpenseJointVenture	`$projection.CompanyCode = _ExpenseJointVenture.CompanyCode and $projection.ExpenseJointVenture = _ExpenseJointVenture.PRAJointVenture`
[0..1]	I_PRAJointVenture	_AccountsRblJointVenture	`$projection.CompanyCode = _AccountsRblJointVenture.CompanyCode and $projection.AccountsReceivableJointVenture = _AccountsRblJointVenture.PRAJointVenture`
[0..1]	I_DivisionOfInterest	_DivisionOfInterest	`$projection.CompanyCode = _DivisionOfInterest.CompanyCode and $projection.JointVenture = _DivisionOfInterest.JointVenture and $projection.DivisionOfInterest = _DivisionOfInterest.DivisionOfInterest`
[0..1]	I_DivisionOfInterest	_GasPlantDivisionOfInterest	`$projection.CompanyCode = _GasPlantDivisionOfInterest.CompanyCode and $projection.GasPlantJointVenture = _GasPlantDivisionOfInterest.JointVenture and $projection.GasPlantDivisionOfInterest = _GasPlantDivisionOfInterest.DivisionOfInterest`
[0..1]	I_DivisionOfInterest	_AcctsRblDivisionOfInterest	`$projection.CompanyCode = _AcctsRblDivisionOfInterest.CompanyCode and $projection.AccountsReceivableJointVenture = _AcctsRblDivisionOfInterest.JointVenture and $projection.AcctsRblDivisionOfInterest = _AcctsRblDivisionOfInterest.DivisionOfInterest`
[0..1]	I_DivisionOfInterest	_ExpenseDivisionOfInterest	`$projection.CompanyCode = _ExpenseDivisionOfInterest.CompanyCode and $projection.ExpenseJointVenture = _ExpenseDivisionOfInterest.JointVenture and $projection.ExpenseDivisionOfInterest = _ExpenseDivisionOfInterest.DivisionOfInterest`
[0..1]	I_PRAGLAccount	_PRAGLAccount	`$projection.CompanyCode = _PRAGLAccount.CompanyCode and $projection.GLAccount = _PRAGLAccount.GLAccount`
[0..1]	I_Currency	_CompanyCodeCurrency	`$projection.CompanyCodeCurrency = _CompanyCodeCurrency.Currency`
[0..1]	I_UnitOfMeasure	_VolumeUnit	`$projection.VolumeUnit = _VolumeUnit.UnitOfMeasure`
[0..1]	I_UnitOfMeasure	_EnergyUnit	`$projection.EnergyUnit = _EnergyUnit.UnitOfMeasure`
[0..1]	I_DeliveryNetwork	_DeliveryNetwork	`$projection.DeliveryNetwork = _DeliveryNetwork.DeliveryNetwork`
[0..1]	I_Well	_Well	`$projection.Well = _Well.Well`
[0..1]	I_WellCompletion	_WellCompletion	`$projection.Well = _WellCompletion.Well and $projection.WellCompletion = _WellCompletion.WellCompletion`
[0..1]	I_MeasurementPoint	_MeasurementPoint	`$projection.MeasurementPoint = _MeasurementPoint.MeasurementPoint`
[0..1]	I_MeasurementPoint	_OriginatingMeasurementPt	`$projection.OriginatingMeasurementPt = _OriginatingMeasurementPt.MeasurementPoint`
[0..1]	I_MeasurementPoint	_AcctsRblMeasurementPt	`$projection.AcctsRblMeasurementPt = _AcctsRblMeasurementPt.MeasurementPoint`
[0..1]	I_PRAContract	_PRAContract	`$projection.PRAContract = _PRAContract.PRAContract`
[0..1]	I_PRAContractType	_PRAContractType	`$projection.PRAContractType = _PRAContractType.PRAContractType`
[0..1]	I_PRAContract	_RelatedPRAContract	`$projection.RelatedPRAContract = _RelatedPRAContract.PRAContract`
[0..1]	I_PRAProduct	_Product	`$projection.Product = _Product.Product`
[0..*]	I_PRACostCenter	_CostCenter	`$projection.CompanyCode = _CostCenter.CompanyCode and $projection.CostCenter = _CostCenter.CostCenter`
[0..1]	I_Customer	_Purchaser	`$projection.Purchaser = _Purchaser.Customer`
[0..1]	I_Customer	_Remitter	`$projection.Remitter = _Remitter.Customer`
[0..1]	I_Customer	_Transporter	`$projection.Transporter = _Transporter.Customer`
[0..1]	I_Customer	_JntIntrstBilgPartner	`$projection.JntIntrstBilgPartner = _JntIntrstBilgPartner.Customer`
[0..1]	I_Country	_Country	`$projection.Country = _Country.Country`
[0..1]	I_Region	_Region	`$projection.Country = _Region.Country and $projection.Region = _Region.Region`
[0..1]	I_PRACounty	_County	`$projection.Country = _County.Country and $projection.Region = _County.Region and $projection.County = _County.County`
[0..1]	I_PrimaryGeogrlLocation	_PrimaryGeogrlLocation	`$projection.Country = _PrimaryGeogrlLocation.Country and $projection.PrimaryGeogrlLocation = _PrimaryGeogrlLocation.PrimaryGeogrlLocation`
[0..1]	I_ProductBalancingAgreement	_ProductBalancingAgreement	`$projection.ProductBalancingAgreement = _ProductBalancingAgreement.ProductBalancingAgreement`
[0..1]	I_Calculationbasis	_CalculationBasis	`$projection.CalculationBasis = _CalculationBasis.CalculationBasis`
[0..1]	I_OwnerPaymentStatus	_OwnerPaymentStatus	`$projection.OwnerPaymentStatus = _OwnerPaymentStatus.OwnerPaymentStatus`
[0..1]	I_SeveranceTaxType	_SeveranceTaxType	`$projection.Country = _SeveranceTaxType.Country and $projection.PrimaryGeogrlLocation = _SeveranceTaxType.PrimaryGeogrlLocation and $projection.SeveranceTaxType = _SeveranceTaxType.SeveranceTaxType`
[0..1]	I_MarketingType	_MarketingType	`$projection.MajorProduct = _MarketingType.MajorProduct and $projection.MarketingType = _MarketingType.MarketingType`
[0..1]	I_TaxClassification	_TaxClassification	`$projection.Country = _TaxClassification.Country and $projection.PrimaryGeogrlLocation = _TaxClassification.PrimaryGeogrlLocation and $projection.TaxClassification = _TaxClassification.TaxClassification`
[0..1]	I_TaxBasis	_TaxBasis	`$projection.TaxBasis = _TaxBasis.TaxBasis`
[0..1]	I_PRALegalForm	_PRALegalForm	`$projection.PRALegalForm = _PRALegalForm.PRALegalForm`
[0..1]	I_PriorPeriodAdjustmentReason	_PriorPeriodAdjustmentReason	`$projection.PriorPeriodAdjustmentReason = _PriorPeriodAdjustmentReason.PriorPeriodAdjustmentReason`
[0..1]	I_SuspenseReason	_SuspenseReason	`$projection.SuspenseReason = _SuspenseReason.SuspenseReason`
[0..1]	I_CalendarYear	_RefValnDocYear	`$projection.RefValnDocYear = _RefValnDocYear.CalendarYear`
[0..1]	I_ValuationDocumentHdr	_RefValnDocHdr	`$projection.RefValnDocYear = _RefValnDocHdr.ValuationDocumentYear and $projection.RefValnDoc = _RefValnDocHdr.ValuationDocumentNumber`
[0..*]	I_ValnDocAcctgItemDeduct	_ValnDocAcctgItemDeduct	`$projection.ValuationDocumentYear = _ValnDocAcctgItemDeduct.ValuationDocumentYear and $projection.ValuationDocumentNumber = _ValnDocAcctgItemDeduct.ValuationDocumentNumber and $projection.BookingReversalType = _ValnDocAcctgItemDeduct.BookingReversalType and $projection.ValnDocAcctgItem = _ValnDocAcctgItemDeduct.ValnDocAcctgItem`
[0..*]	I_ValnDocAcctgItemMktg	_ValnDocAcctgItemMktg	`$projection.ValuationDocumentYear = _ValnDocAcctgItemMktg.ValuationDocumentYear and $projection.ValuationDocumentNumber = _ValnDocAcctgItemMktg.ValuationDocumentNumber and $projection.BookingReversalType = _ValnDocAcctgItemMktg.BookingReversalType and $projection.ValnDocAcctgItem = _ValnDocAcctgItemMktg.ValnDocAcctgItem`
[0..*]	I_ValnDocAcctgItemTax	_ValnDocAcctgItemTax	`$projection.ValuationDocumentYear = _ValnDocAcctgItemTax.ValuationDocumentYear and $projection.ValuationDocumentNumber = _ValnDocAcctgItemTax.ValuationDocumentNumber and $projection.BookingReversalType = _ValnDocAcctgItemTax.BookingReversalType and $projection.ValnDocAcctgItem = _ValnDocAcctgItemTax.ValnDocAcctgItem`
[0..1]	I_MajorProduct	_MajorProduct	`$projection.MajorProduct = _MajorProduct.MajorProduct`
[0..1]	I_MinorProduct	_MinorProduct	`$projection.MajorProduct = _MinorProduct.MajorProduct and $projection.MinorProduct = _MinorProduct.MinorProduct`
[0..1]	I_Indicator	_ItemIsSummarizedByProduct	`$projection.ItemIsSummarizedByProduct = _ItemIsSummarizedByProduct.IndicatorValue`
[0..1]	I_Indicator	_ItemIsWriteOff	`$projection.ItemIsWriteOff = _ItemIsWriteOff.IndicatorValue`
[0..1]	I_Indicator	_ItemIsCleared	`$projection.ItemIsCleared = _ItemIsCleared.IndicatorValue`
[0..1]	I_Indicator	_OwnerIsJntIntrstBilgEnabled	`$projection.OwnerIsJntIntrstBilgEnabled = _OwnerIsJntIntrstBilgEnabled.IndicatorValue`
[0..1]	I_Indicator	_ItemIsReallocated	`$projection.ItemIsReallocated = _ItemIsReallocated.IndicatorValue`
[0..1]	I_Indicator	_ItemIsRejected	`$projection.ItemIsRejected = _ItemIsRejected.IndicatorValue`
[0..1]	I_Indicator	_ItemIsNetZero	`$projection.ItemIsNetZero = _ItemIsNetZero.IndicatorValue`
[0..1]	I_User	_CreatedByUser	`$projection.CreatedByUser = _CreatedByUser.UserID`

Annotations (11)

Name	Value	Level
EndUserText.label	Valuation Document Accounting Item	view
Analytics.dataCategory	#CUBE	view
Analytics.dataExtraction.enabled	true	view
Metadata.allowExtensions	true	view
VDM.viewType	#BASIC	view
AbapCatalog.sqlViewName	IPVVLDOCACCTDOC	view
AccessControl.authorizationCheck	#CHECK	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.dataClass	#MIXED	view

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_ValnDocAcctgItem.
-- 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: IPVVLDOCACCTDOC

CREATE VIEW I_ValnDocAcctgItem AS
SELECT *  -- field list not available in parsed metadata
FROM /pra/vl_acc_doc
LEFT OUTER JOIN I_CalendarYear AS _ValuationDocumentYear ON ValuationDocumentYear = _ValuationDocumentYear.CalendarYear  -- association [0..1]
LEFT OUTER JOIN I_ValuationDocumentHdr AS _ValuationDocumentHdr ON ValuationDocumentYear = _ValuationDocumentHdr.ValuationDocumentYear AND ValuationDocumentNumber = _ValuationDocumentHdr.ValuationDocumentNumber  -- association [0..1]
LEFT OUTER JOIN I_BookingReversalType AS _BookingReversalType ON BookingReversalType = _BookingReversalType.BookingReversalType  -- association [0..1]
LEFT OUTER JOIN I_PRAOwner AS _PRAOwner ON PRAOwner = _PRAOwner.PRAOwner  -- association [0..1]
LEFT OUTER JOIN I_PRAGLAccountType AS _GLAccountType ON GLAccountType = _GLAccountType.GLAccountType  -- association [0..1]
LEFT OUTER JOIN I_OwnerInterestType AS _OwnerInterestType ON OwnerInterestType = _OwnerInterestType.OwnerInterestType  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _ProcessingCompanyCode ON ProcessingCompanyCode = _ProcessingCompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _AffiliatedCompanyCode ON AffiliatedCompanyCode = _AffiliatedCompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_PRAAcctDetnCategory AS _AcctDeterminationCategory ON AcctDeterminationCategory = _AcctDeterminationCategory.AcctDeterminationCategory  -- association [0..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_VolumeType AS _VolumeType ON VolumeType = _VolumeType.VolumeType  -- association [0..1]
LEFT OUTER JOIN I_Partnercompany AS _PartnerCompany ON PartnerCompany = _PartnerCompany.PartnerCompany  -- association [0..1]
LEFT OUTER JOIN I_PRAJointVenture AS _PRAJointVenture ON CompanyCode = _PRAJointVenture.CompanyCode AND JointVenture = _PRAJointVenture.PRAJointVenture  -- association [0..1]
LEFT OUTER JOIN I_PRAJointVenture AS _UnitJointVenture ON CompanyCode = _UnitJointVenture.CompanyCode AND UnitJointVenture = _UnitJointVenture.PRAJointVenture  -- association [0..1]
LEFT OUTER JOIN I_PRAJointVenture AS _GasPlantJointVenture ON CompanyCode = _GasPlantJointVenture.CompanyCode AND GasPlantJointVenture = _GasPlantJointVenture.PRAJointVenture  -- association [0..1]
LEFT OUTER JOIN I_PRAJointVenture AS _ExpenseJointVenture ON CompanyCode = _ExpenseJointVenture.CompanyCode AND ExpenseJointVenture = _ExpenseJointVenture.PRAJointVenture  -- association [0..1]
LEFT OUTER JOIN I_PRAJointVenture AS _AccountsRblJointVenture ON CompanyCode = _AccountsRblJointVenture.CompanyCode AND AccountsReceivableJointVenture = _AccountsRblJointVenture.PRAJointVenture  -- association [0..1]
LEFT OUTER JOIN I_DivisionOfInterest AS _DivisionOfInterest ON CompanyCode = _DivisionOfInterest.CompanyCode AND JointVenture = _DivisionOfInterest.JointVenture AND DivisionOfInterest = _DivisionOfInterest.DivisionOfInterest  -- association [0..1]
LEFT OUTER JOIN I_DivisionOfInterest AS _GasPlantDivisionOfInterest ON CompanyCode = _GasPlantDivisionOfInterest.CompanyCode AND GasPlantJointVenture = _GasPlantDivisionOfInterest.JointVenture AND GasPlantDivisionOfInterest = _GasPlantDivisionOfInterest.DivisionOfInterest  -- association [0..1]
LEFT OUTER JOIN I_DivisionOfInterest AS _AcctsRblDivisionOfInterest ON CompanyCode = _AcctsRblDivisionOfInterest.CompanyCode AND AccountsReceivableJointVenture = _AcctsRblDivisionOfInterest.JointVenture AND AcctsRblDivisionOfInterest = _AcctsRblDivisionOfInterest.DivisionOfInterest  -- association [0..1]
LEFT OUTER JOIN I_DivisionOfInterest AS _ExpenseDivisionOfInterest ON CompanyCode = _ExpenseDivisionOfInterest.CompanyCode AND ExpenseJointVenture = _ExpenseDivisionOfInterest.JointVenture AND ExpenseDivisionOfInterest = _ExpenseDivisionOfInterest.DivisionOfInterest  -- association [0..1]
LEFT OUTER JOIN I_PRAGLAccount AS _PRAGLAccount ON CompanyCode = _PRAGLAccount.CompanyCode AND GLAccount = _PRAGLAccount.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON CompanyCodeCurrency = _CompanyCodeCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _VolumeUnit ON VolumeUnit = _VolumeUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _EnergyUnit ON EnergyUnit = _EnergyUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_DeliveryNetwork AS _DeliveryNetwork ON DeliveryNetwork = _DeliveryNetwork.DeliveryNetwork  -- association [0..1]
LEFT OUTER JOIN I_Well AS _Well ON Well = _Well.Well  -- association [0..1]
LEFT OUTER JOIN I_WellCompletion AS _WellCompletion ON Well = _WellCompletion.Well AND WellCompletion = _WellCompletion.WellCompletion  -- association [0..1]
LEFT OUTER JOIN I_MeasurementPoint AS _MeasurementPoint ON MeasurementPoint = _MeasurementPoint.MeasurementPoint  -- association [0..1]
LEFT OUTER JOIN I_MeasurementPoint AS _OriginatingMeasurementPt ON OriginatingMeasurementPt = _OriginatingMeasurementPt.MeasurementPoint  -- association [0..1]
LEFT OUTER JOIN I_MeasurementPoint AS _AcctsRblMeasurementPt ON AcctsRblMeasurementPt = _AcctsRblMeasurementPt.MeasurementPoint  -- association [0..1]
LEFT OUTER JOIN I_PRAContract AS _PRAContract ON PRAContract = _PRAContract.PRAContract  -- association [0..1]
LEFT OUTER JOIN I_PRAContractType AS _PRAContractType ON PRAContractType = _PRAContractType.PRAContractType  -- association [0..1]
LEFT OUTER JOIN I_PRAContract AS _RelatedPRAContract ON RelatedPRAContract = _RelatedPRAContract.PRAContract  -- association [0..1]
LEFT OUTER JOIN I_PRAProduct AS _Product ON Product = _Product.Product  -- association [0..1]
LEFT OUTER JOIN I_PRACostCenter AS _CostCenter ON CompanyCode = _CostCenter.CompanyCode AND CostCenter = _CostCenter.CostCenter  -- association [0..*]
LEFT OUTER JOIN I_Customer AS _Purchaser ON Purchaser = _Purchaser.Customer  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Remitter ON Remitter = _Remitter.Customer  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Transporter ON Transporter = _Transporter.Customer  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _JntIntrstBilgPartner ON JntIntrstBilgPartner = _JntIntrstBilgPartner.Customer  -- association [0..1]
LEFT OUTER JOIN I_Country AS _Country ON Country = _Country.Country  -- association [0..1]
LEFT OUTER JOIN I_Region AS _Region ON Country = _Region.Country AND Region = _Region.Region  -- association [0..1]
LEFT OUTER JOIN I_PRACounty AS _County ON Country = _County.Country AND Region = _County.Region AND County = _County.County  -- association [0..1]
LEFT OUTER JOIN I_PrimaryGeogrlLocation AS _PrimaryGeogrlLocation ON Country = _PrimaryGeogrlLocation.Country AND PrimaryGeogrlLocation = _PrimaryGeogrlLocation.PrimaryGeogrlLocation  -- association [0..1]
LEFT OUTER JOIN I_ProductBalancingAgreement AS _ProductBalancingAgreement ON ProductBalancingAgreement = _ProductBalancingAgreement.ProductBalancingAgreement  -- association [0..1]
LEFT OUTER JOIN I_Calculationbasis AS _CalculationBasis ON CalculationBasis = _CalculationBasis.CalculationBasis  -- association [0..1]
LEFT OUTER JOIN I_OwnerPaymentStatus AS _OwnerPaymentStatus ON OwnerPaymentStatus = _OwnerPaymentStatus.OwnerPaymentStatus  -- association [0..1]
LEFT OUTER JOIN I_SeveranceTaxType AS _SeveranceTaxType ON Country = _SeveranceTaxType.Country AND PrimaryGeogrlLocation = _SeveranceTaxType.PrimaryGeogrlLocation AND SeveranceTaxType = _SeveranceTaxType.SeveranceTaxType  -- association [0..1]
LEFT OUTER JOIN I_MarketingType AS _MarketingType ON MajorProduct = _MarketingType.MajorProduct AND MarketingType = _MarketingType.MarketingType  -- association [0..1]
LEFT OUTER JOIN I_TaxClassification AS _TaxClassification ON Country = _TaxClassification.Country AND PrimaryGeogrlLocation = _TaxClassification.PrimaryGeogrlLocation AND TaxClassification = _TaxClassification.TaxClassification  -- association [0..1]
LEFT OUTER JOIN I_TaxBasis AS _TaxBasis ON TaxBasis = _TaxBasis.TaxBasis  -- association [0..1]
LEFT OUTER JOIN I_PRALegalForm AS _PRALegalForm ON PRALegalForm = _PRALegalForm.PRALegalForm  -- association [0..1]
LEFT OUTER JOIN I_PriorPeriodAdjustmentReason AS _PriorPeriodAdjustmentReason ON PriorPeriodAdjustmentReason = _PriorPeriodAdjustmentReason.PriorPeriodAdjustmentReason  -- association [0..1]
LEFT OUTER JOIN I_SuspenseReason AS _SuspenseReason ON SuspenseReason = _SuspenseReason.SuspenseReason  -- association [0..1]
LEFT OUTER JOIN I_CalendarYear AS _RefValnDocYear ON RefValnDocYear = _RefValnDocYear.CalendarYear  -- association [0..1]
LEFT OUTER JOIN I_ValuationDocumentHdr AS _RefValnDocHdr ON RefValnDocYear = _RefValnDocHdr.ValuationDocumentYear AND RefValnDoc = _RefValnDocHdr.ValuationDocumentNumber  -- association [0..1]
LEFT OUTER JOIN I_ValnDocAcctgItemDeduct AS _ValnDocAcctgItemDeduct ON ValuationDocumentYear = _ValnDocAcctgItemDeduct.ValuationDocumentYear AND ValuationDocumentNumber = _ValnDocAcctgItemDeduct.ValuationDocumentNumber AND BookingReversalType = _ValnDocAcctgItemDeduct.BookingReversalType AND ValnDocAcctgItem = _ValnDocAcctgItemDeduct.ValnDocAcctgItem  -- association [0..*]
LEFT OUTER JOIN I_ValnDocAcctgItemMktg AS _ValnDocAcctgItemMktg ON ValuationDocumentYear = _ValnDocAcctgItemMktg.ValuationDocumentYear AND ValuationDocumentNumber = _ValnDocAcctgItemMktg.ValuationDocumentNumber AND BookingReversalType = _ValnDocAcctgItemMktg.BookingReversalType AND ValnDocAcctgItem = _ValnDocAcctgItemMktg.ValnDocAcctgItem  -- association [0..*]
LEFT OUTER JOIN I_ValnDocAcctgItemTax AS _ValnDocAcctgItemTax ON ValuationDocumentYear = _ValnDocAcctgItemTax.ValuationDocumentYear AND ValuationDocumentNumber = _ValnDocAcctgItemTax.ValuationDocumentNumber AND BookingReversalType = _ValnDocAcctgItemTax.BookingReversalType AND ValnDocAcctgItem = _ValnDocAcctgItemTax.ValnDocAcctgItem  -- association [0..*]
LEFT OUTER JOIN I_MajorProduct AS _MajorProduct ON MajorProduct = _MajorProduct.MajorProduct  -- association [0..1]
LEFT OUTER JOIN I_MinorProduct AS _MinorProduct ON MajorProduct = _MinorProduct.MajorProduct AND MinorProduct = _MinorProduct.MinorProduct  -- association [0..1]
LEFT OUTER JOIN I_Indicator AS _ItemIsSummarizedByProduct ON ItemIsSummarizedByProduct = _ItemIsSummarizedByProduct.IndicatorValue  -- association [0..1]
LEFT OUTER JOIN I_Indicator AS _ItemIsWriteOff ON ItemIsWriteOff = _ItemIsWriteOff.IndicatorValue  -- association [0..1]
LEFT OUTER JOIN I_Indicator AS _ItemIsCleared ON ItemIsCleared = _ItemIsCleared.IndicatorValue  -- association [0..1]
LEFT OUTER JOIN I_Indicator AS _OwnerIsJntIntrstBilgEnabled ON OwnerIsJntIntrstBilgEnabled = _OwnerIsJntIntrstBilgEnabled.IndicatorValue  -- association [0..1]
LEFT OUTER JOIN I_Indicator AS _ItemIsReallocated ON ItemIsReallocated = _ItemIsReallocated.IndicatorValue  -- association [0..1]
LEFT OUTER JOIN I_Indicator AS _ItemIsRejected ON ItemIsRejected = _ItemIsRejected.IndicatorValue  -- association [0..1]
LEFT OUTER JOIN I_Indicator AS _ItemIsNetZero ON ItemIsNetZero = _ItemIsNetZero.IndicatorValue  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
;

Depth:

I_ValnDocAcctgItem view

/pra/vl_acc_doc

I_ValnDocAcctgItemAll view