What is R_IncgOutgInvoiceItemTP in SAP S/4HANA?

R_IncgOutgInvoiceItemTP is a transactional CDS view in SAP S/4HANA. Manage G/L Item Info of AP/AR Invoices It contains 73 fields.

Which tables does R_IncgOutgInvoiceItemTP read from?

R_IncgOutgInvoiceItemTP reads data from: farp_miv_glitm.

What VDM layer is R_IncgOutgInvoiceItemTP?

R_IncgOutgInvoiceItemTP is classified as a Transactional view that supports create, update, and delete operations.

R_IncgOutgInvoiceItemTP

DDL: R_INCGOUTGINVOICEITEMTP Type: view_entity TRANSACTIONAL

73 Fields 1 Data Sources 17 Associations

Manage G/L Item Info of AP/AR Invoices

R_IncgOutgInvoiceItemTP is a Transactional CDS View that provides data about "Manage G/L Item Info of AP/AR Invoices" in SAP S/4HANA. It reads from 1 data source (farp_miv_glitm) and exposes 73 fields with key field OutgoingInvoiceItemUUID. It has 17 associations to related views.

Data Sources (1)

Source	Alias	Join Type
farp_miv_glitm	farp_miv_glitm	from

Associations (17)

Cardinality	Target	Alias	Condition
[0..1]	I_DebitCreditCode	_DebitCreditCodeText	`$projection.DebitCreditCode = _DebitCreditCodeText.DebitCreditCode`
[0..1]	I_CompanyCode	_CompanyCode	`$projection.CompanyCode = _CompanyCode.CompanyCode`
[0..1]	I_BusinessAreaText	_BusinessAreaText	`$projection.BusinessArea = _BusinessAreaText.BusinessArea and _BusinessAreaText.Language = $session.system_language`
[0..1]	I_BusinessAreaText	_PartnerBusinessAreaText	`$projection.PartnerBusinessArea = _PartnerBusinessAreaText.BusinessArea and _PartnerBusinessAreaText.Language = $session.system_language`
[0..1]	I_BusinessProcessText	_BusinessProcessText	`$projection.BusinessProcess = _BusinessProcessText.BusinessProcess and $projection.ControllingArea = _BusinessProcessText.ControllingArea and _BusinessProcessText.Language = $session.system_language and _BusinessProcessText.ValidityEndDate >= $session.system_date`
[0..1]	I_ControllingArea	_ControllingArea	`$projection.ControllingArea = _ControllingArea.ControllingArea`
[0..1]	I_CostCenter	_CostCenterText	`$projection.ControllingArea = _CostCenterText.ControllingArea and $projection.CostCenter = _CostCenterText.CostCenter and _CostCenterText.ValidityEndDate >= $session.system_date`
[0..1]	I_FunctionalAreaText	_FndsMgmtFuncnlAreaStdVH	`$projection.FunctionalArea = _FndsMgmtFuncnlAreaStdVH.FunctionalArea and _FndsMgmtFuncnlAreaStdVH.Language = $session.system_language`
[0..1]	I_GlAccountTextInCompanycode	_GLAccountText	`$projection.CompanyCode = _GLAccountText.CompanyCode and $projection.GLAccount = _GLAccountText.GLAccount and _GLAccountText.Language = $session.system_language`
[0..1]	I_InternalOrder	_InternalOrder	`$projection.InternalOrder = _InternalOrder.InternalOrder`
[0..1]	I_WBSElementData_2	_WBSElementData	`$projection.WBSElement = _WBSElementData.WBSElement`
[0..1]	I_WorkItemText	_WorkItemText	`$projection.WorkItem = _WorkItemText.WorkItem and _WorkItemText.Language = $session.system_language`
[0..1]	I_BR_OrderText	_ProjectNetworkBasicData	`$projection.ProjectNetwork = _ProjectNetworkBasicData.InternalOrder`
[0..1]	I_SalesOrderItem	_SalesOrderItemStdVH	`$projection.SalesOrder = _SalesOrderItemStdVH.SalesOrder and $projection.SalesOrderItem = _SalesOrderItemStdVH.SalesOrderItem`
[0..1]	I_PlantVH	_PlantVH	`$projection.Plant = _PlantVH.Plant`
[0..1]	I_MaterialText	_MaterialText	`$projection.Material = _MaterialText.Material and _MaterialText.Language = $session.system_language`
[0..1]	I_JointVentureRecoveryText	_JointVentureRecoveryText	`$projection.JointVentureCostRecoveryCode = _JointVentureRecoveryText.JointVentureRecoveryCode and $projection.CompanyCode = _JointVentureRecoveryText.CompanyCode and _JointVentureRecoveryText.Language = $session.system_language`

Annotations (8)

Name	Value	Level
AbapCatalog.dataMaintenance	#RESTRICTED	view
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	Manage G/L Item Info of AP/AR Invoices	view
VDM.viewType	#TRANSACTIONAL	view
VDM.lifecycle.contract.type	#SAP_INTERNAL_API	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.dataClass	#MIXED	view

Fields (73)

Key	Field	Source Table	Source Field	Description
KEY	OutgoingInvoiceItemUUID		outgoinginvoiceitemuuid	UCOI G/L Items UUID
	OutgoingInvoiceUUID		outgoinginvoiceuuid	Upload Invoice UUID
	OutgoingInvoiceItem		outgoinginvoiceitem	Number
	GLAccount		glaccount	General Ledger
	AmountInTransactionCurrency		amountintransactioncurrency	Pt Crcy Amt
	ActualAmountInTransactionCrcy		actualamountintransactioncrcy	Dummy Field of Amt
	DebitCreditCode		debitcreditcode	Single-Character Flag
	IsNegativePosting		isnegativeposting	Negative Posting
	CompanyCode		companycode	Receiver Company Code
	TaxCode		taxcode	Tax Code
	TaxCountry		taxcountry	Tax Ctry/Reg.
	TaxJurisdiction		taxjurisdiction	Tax Jurisdiction
	DocumentItemText		documentitemtext	Text
	CostCenter		costcenter	Cost Center
	SalesOrder		salesorder	SD Document
	SalesOrderItem		salesorderitem	Sales Order Item
	InternalOrder		internalorder	Order
	SettlementReferenceDate		settlementreferencedate	Reference date
	FundsCenter		fundscenter	Funds Center
	FunctionalArea		functionalarea	Sendr Fctl Area
	ProfitCenter		profitcenter	Profit Center
	Fund		fund	Sender Fund
	BusinessArea		businessarea	Business Area
	PartnerBusinessArea		partnerbusinessarea	Trdg Part.BA
	CostObject		costobject	Cost Object
	ProjectNetwork		projectnetwork	Order
	NetworkActivity		networkactivity	Operation/Activity
	WBSElement		wbselement	WBS Internal ID
	ReceiverActivityType		receiveractivitytype	Activity Type
	RealEstateObject		realestateobject	Real Estate Key
	PersonnelNumber		personnelnumber	Personnel No.
	BusinessProcess		businessprocess	Business Process
	AssetGrant		assetgrant	Grant
	CommitmentItem		commitmentitem	Commitment item
	QuantityInBaseUnit		quantityinbaseunit	Quantity
	BaseUnit		baseunit	Unit of Measure
	AssignmentReference		assignmentreference	Assignment Reference
	IsNotCashDiscountLiable		isnotcashdiscountliable	W/o CashDsc.
	TaxBaseAmountInTransCrcy		taxbaseamountintranscrcy	Value-Added Tax
	TaxAmountInTransCrcy		taxamountintranscrcy	TaxAmt in Tran. Crcy
	ProfitabilitySegment		profitabilitysegment	Profitability Segment
	Plant		plant	Valuation Area
	BudgetPeriod		budgetperiod	Budget Period
	ControllingArea		controllingarea	Controlling Area
	JointVentureCostRecoveryCode		jointventurecostrecoverycode	Recovery Ind.
	WorkItem		workitem	Work Item ID
	PartnerProfitCenter		partnerprofitcenter	Profit Center
	ReportingSegment		reportingsegment	Reporting Segment
	SalesOrderScheduleLine		salesorderscheduleline	SOrder schedule
	Material		material	Vehicle Model
	ServiceDocumentType		servicedocumenttype	Transaction Type
	ServiceDocID		servicedocid	Service Document
	ServiceDocItemID		servicedocitemid	Service Doc. Item
	FinancialTransactionType		financialtransactiontype	Transact. Type
	_DebitCreditCodeText		_DebitCreditCodeText
	TransactionCurrency	_SupplierInvoice	TransactionCurrency	Transaction Currency
	_SupplierInvoice		_SupplierInvoice
	_CompanyCode		_CompanyCode
	_BusinessAreaText		_BusinessAreaText
	_PartnerBusinessAreaText		_PartnerBusinessAreaText
	_BusinessProcessText		_BusinessProcessText
	_ControllingArea		_ControllingArea
	_CostCenterText		_CostCenterText
	_FndsMgmtFuncnlAreaStdVH		_FndsMgmtFuncnlAreaStdVH
	_GLAccountText		_GLAccountText
	_InternalOrder		_InternalOrder
	_WBSElementData		_WBSElementData
	_WorkItemText		_WorkItemText
	_ProjectNetworkBasicData		_ProjectNetworkBasicData
	_SalesOrderItemStdVH		_SalesOrderItemStdVH
	_PlantVH		_PlantVH
	_MaterialText		_MaterialText
	_JointVentureRecoveryText		_JointVentureRecoveryText

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_IncgOutgInvoiceItemTP.
-- 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_IncgOutgInvoiceItemTP AS
SELECT
  OutgoingInvoiceItemUUID,
  OutgoingInvoiceUUID,
  OutgoingInvoiceItem,
  GLAccount,
  AmountInTransactionCurrency,
  ActualAmountInTransactionCrcy,
  DebitCreditCode,
  IsNegativePosting,
  CompanyCode,
  TaxCode,
  TaxCountry,
  TaxJurisdiction,
  DocumentItemText,
  CostCenter,
  SalesOrder,
  SalesOrderItem,
  InternalOrder,
  SettlementReferenceDate,
  FundsCenter,
  FunctionalArea,
  ProfitCenter,
  Fund,
  BusinessArea,
  PartnerBusinessArea,
  CostObject,
  ProjectNetwork,
  NetworkActivity,
  WBSElement,
  ReceiverActivityType,
  RealEstateObject,
  PersonnelNumber,
  BusinessProcess,
  AssetGrant,
  CommitmentItem,
  QuantityInBaseUnit,
  BaseUnit,
  AssignmentReference,
  IsNotCashDiscountLiable,
  TaxBaseAmountInTransCrcy,
  TaxAmountInTransCrcy,
  ProfitabilitySegment,
  Plant,
  BudgetPeriod,
  ControllingArea,
  JointVentureCostRecoveryCode,
  WorkItem,
  PartnerProfitCenter,
  ReportingSegment,
  SalesOrderScheduleLine,
  Material,
  ServiceDocumentType,
  ServiceDocID,
  ServiceDocItemID,
  FinancialTransactionType,
  _SupplierInvoice.TransactionCurrency AS TransactionCurrency
FROM farp_miv_glitm
LEFT OUTER JOIN I_DebitCreditCode AS _DebitCreditCodeText ON DebitCreditCode = _DebitCreditCodeText.DebitCreditCode  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_BusinessAreaText AS _BusinessAreaText ON BusinessArea = _BusinessAreaText.BusinessArea AND _BusinessAreaText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BusinessAreaText AS _PartnerBusinessAreaText ON PartnerBusinessArea = _PartnerBusinessAreaText.BusinessArea AND _PartnerBusinessAreaText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BusinessProcessText AS _BusinessProcessText ON BusinessProcess = _BusinessProcessText.BusinessProcess AND ControllingArea = _BusinessProcessText.ControllingArea AND _BusinessProcessText.Language = $session.system_language AND _BusinessProcessText.ValidityEndDate >= $session.system_date  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _CostCenterText ON ControllingArea = _CostCenterText.ControllingArea AND CostCenter = _CostCenterText.CostCenter AND _CostCenterText.ValidityEndDate >= $session.system_date  -- association [0..1]
LEFT OUTER JOIN I_FunctionalAreaText AS _FndsMgmtFuncnlAreaStdVH ON FunctionalArea = _FndsMgmtFuncnlAreaStdVH.FunctionalArea AND _FndsMgmtFuncnlAreaStdVH.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_GlAccountTextInCompanycode AS _GLAccountText ON CompanyCode = _GLAccountText.CompanyCode AND GLAccount = _GLAccountText.GLAccount AND _GLAccountText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_InternalOrder AS _InternalOrder ON InternalOrder = _InternalOrder.InternalOrder  -- association [0..1]
LEFT OUTER JOIN I_WBSElementData_2 AS _WBSElementData ON WBSElement = _WBSElementData.WBSElement  -- association [0..1]
LEFT OUTER JOIN I_WorkItemText AS _WorkItemText ON WorkItem = _WorkItemText.WorkItem AND _WorkItemText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BR_OrderText AS _ProjectNetworkBasicData ON ProjectNetwork = _ProjectNetworkBasicData.InternalOrder  -- association [0..1]
LEFT OUTER JOIN I_SalesOrderItem AS _SalesOrderItemStdVH ON SalesOrder = _SalesOrderItemStdVH.SalesOrder AND SalesOrderItem = _SalesOrderItemStdVH.SalesOrderItem  -- association [0..1]
LEFT OUTER JOIN I_PlantVH AS _PlantVH ON Plant = _PlantVH.Plant  -- association [0..1]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON Material = _MaterialText.Material AND _MaterialText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_JointVentureRecoveryText AS _JointVentureRecoveryText ON JointVentureCostRecoveryCode = _JointVentureRecoveryText.JointVentureRecoveryCode AND CompanyCode = _JointVentureRecoveryText.CompanyCode AND _JointVentureRecoveryText.Language = $session.system_language  -- association [0..1]
;

Depth:

R_IncgOutgInvoiceItemTP view_entity

farp_miv_glitm

C_OutgInvoiceItemTP view_entity