C_OutgInvoiceItemTP

DDL: C_OUTGINVOICEITEMTP Type: view_entity CONSUMPTION
83 Fields 1 Data Sources 1 Associations 1 OData Services

C_OutgInvoiceItemTP is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (R_IncgOutgInvoiceItemTP) and exposes 83 fields with key field OutgoingInvoiceItemUUID. It has 1 association to related views. It is exposed through 1 OData service (UI_UPLOADOPENARITEMS).

Data Sources (1)

SourceAliasJoin Type
R_IncgOutgInvoiceItemTP R_IncgOutgInvoiceItemTP projection

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_TaxCodeText _TaxCodeText $projection.TaxCode = _TaxCodeText.TaxCode and _TaxCodeText.TaxCalculationProcedure = 'TAXD' and _TaxCodeText.Language = $session.system_language

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
Metadata.allowExtensions true view

OData Services (1)

ServiceBindingVersionContractRelease
UI_UPLOADOPENARITEMS UI_UPLOADOPENARITEMS V4 C1 NOT_TO_BE_RELEASED_STABLE

Fields (83)

KeyFieldSource TableSource FieldDescription
KEY OutgoingInvoiceItemUUID OutgoingInvoiceItemUUID UCOI G/L Items UUID
OutgoingInvoiceUUID OutgoingInvoiceUUID Upload Invoice UUID
OutgoingInvoiceItem OutgoingInvoiceItem Number
CompanyCode CompanyCode Receiver Company Code
CompanyCodeName _CompanyCode CompanyCodeName Company Name
GLAccount GLAccount General Ledger
GLAccountLongName _GLAccountText GLAccountLongName Long Text
DocumentItemText DocumentItemText Text
DebitCreditCode DebitCreditCode Single-Character Flag
AmountInTransactionCurrency AmountInTransactionCurrency Pt Crcy Amt
IsNegativePosting IsNegativePosting Negative Posting
TaxCode TaxCode Tax Code
TaxJurisdiction TaxJurisdiction Tax Jurisdiction
AssignmentReference AssignmentReference Assignment Reference
CostCenter CostCenter Cost Center
CostCenterName
ProfitCenter ProfitCenter Profit Center
InternalOrder InternalOrder Order
InternalOrderDescription _InternalOrder InternalOrderDescription Description
WBSElement WBSElement WBS Internal ID
WBSDescription _WBSElementData WBSDescription WBS Element Name
BusinessArea BusinessArea Business Area
BusinessAreaText
BusinessProcess BusinessProcess Business Process
BusinessProcessName _BusinessProcessText BusinessProcessName Long Text
ControllingArea ControllingArea Controlling Area
ControllingAreaName _ControllingArea ControllingAreaName Long Text
ReceiverActivityType ReceiverActivityType Activity Type
CostObject CostObject Cost Object
FunctionalArea FunctionalArea Sendr Fctl Area
FunctionalAreaName _FndsMgmtFuncnlAreaStdVH FunctionalAreaName Long Text
IsNotCashDiscountLiable IsNotCashDiscountLiable W/o CashDsc.
PersonnelNumber PersonnelNumber Personnel No.
SalesOrder SalesOrder SD Document
SalesOrderItem SalesOrderItem Sales Order Item
SalesOrderItemText _SalesOrderItemStdVH SalesOrderItemText
SalesOrderScheduleLine SalesOrderScheduleLine SOrder schedule
Plant Plant Valuation Area
PlantName _PlantVH PlantName Plant Name
Material Material Vehicle Model
MaterialName _MaterialText MaterialName Material Description
ProjectNetwork ProjectNetwork Order
ProjectNetworkDescription _ProjectNetworkBasicData InternalOrderDescription Description
NetworkActivity NetworkActivity Operation/Activity
WorkItem WorkItem Work Item ID
WorkItemName _WorkItemText WorkItemName
CommitmentItem CommitmentItem Commitment item
FundsCenter FundsCenter Funds Center
TaxBaseAmountInTransCrcy TaxBaseAmountInTransCrcy Value-Added Tax
Fund Fund Sender Fund
AssetGrant AssetGrant Grant
BaseUnit BaseUnit Unit of Measure
QuantityInBaseUnit QuantityInBaseUnit Quantity
PartnerBusinessArea PartnerBusinessArea Trdg Part.BA
PartnerBusinessAreaName _PartnerBusinessAreaText BusinessAreaName Business Area Name
PartnerProfitCenter PartnerProfitCenter Profit Center
ReportingSegment ReportingSegment Reporting Segment
ServiceDocumentType ServiceDocumentType Transaction Type
ServiceDocID ServiceDocID Service Document
ServiceDocItemID ServiceDocItemID Service Doc. Item
FinancialTransactionType FinancialTransactionType Transact. Type
JointVentureCostRecoveryCode JointVentureCostRecoveryCode Recovery Ind.
JointVentureRecoveryCodeName _JointVentureRecoveryText JointVentureRecoveryCodeName
TaxCountry _SupplierInvoice TaxCountry Tax Ctry/Reg.
TransactionCurrency TransactionCurrency Transaction Currency
_CompanyCode _CompanyCode
_TaxCodeText _TaxCodeText
_BusinessAreaText _BusinessAreaText
_PartnerBusinessAreaText _PartnerBusinessAreaText
_BusinessProcessText _BusinessProcessText
_ControllingArea _ControllingArea
_CostCenterText _CostCenterText
_FndsMgmtFuncnlAreaStdVH _FndsMgmtFuncnlAreaStdVH
_GLAccountText _GLAccountText
_InternalOrder _InternalOrder
_WBSElementData _WBSElementData
_WorkItemText _WorkItemText
_ProjectNetworkBasicData _ProjectNetworkBasicData
_SalesOrderItemStdVH _SalesOrderItemStdVH
_DebitCreditCodeText _GlLine _DebitCreditCodeText
_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 C_OutgInvoiceItemTP.
-- 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_OutgInvoiceItemTP AS
SELECT
  OutgoingInvoiceItemUUID,
  OutgoingInvoiceUUID,
  OutgoingInvoiceItem,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  GLAccount,
  _GLAccountText.GLAccountLongName AS GLAccountLongName,
  DocumentItemText,
  DebitCreditCode,
  AmountInTransactionCurrency,
  IsNegativePosting,
  TaxCode,
  TaxJurisdiction,
  AssignmentReference,
  CostCenter,
  _CostCenterText._Text[1:Language=$session.system_language].CostCenterName AS CostCenterName,
  ProfitCenter,
  InternalOrder,
  _InternalOrder.InternalOrderDescription AS InternalOrderDescription,
  WBSElement,
  _WBSElementData.WBSDescription AS WBSDescription,
  BusinessArea,
  _BusinessAreaText[1:Language=$session.system_language].BusinessAreaName AS BusinessAreaText,
  BusinessProcess,
  _BusinessProcessText.BusinessProcessName AS BusinessProcessName,
  ControllingArea,
  _ControllingArea.ControllingAreaName AS ControllingAreaName,
  ReceiverActivityType,
  CostObject,
  FunctionalArea,
  _FndsMgmtFuncnlAreaStdVH.FunctionalAreaName AS FunctionalAreaName,
  IsNotCashDiscountLiable,
  PersonnelNumber,
  SalesOrder,
  SalesOrderItem,
  _SalesOrderItemStdVH.SalesOrderItemText AS SalesOrderItemText,
  SalesOrderScheduleLine,
  Plant,
  _PlantVH.PlantName AS PlantName,
  Material,
  _MaterialText.MaterialName AS MaterialName,
  ProjectNetwork,
  _ProjectNetworkBasicData.InternalOrderDescription AS ProjectNetworkDescription,
  NetworkActivity,
  WorkItem,
  _WorkItemText.WorkItemName AS WorkItemName,
  CommitmentItem,
  FundsCenter,
  TaxBaseAmountInTransCrcy,
  Fund,
  AssetGrant,
  BaseUnit,
  QuantityInBaseUnit,
  PartnerBusinessArea,
  _PartnerBusinessAreaText.BusinessAreaName AS PartnerBusinessAreaName,
  PartnerProfitCenter,
  ReportingSegment,
  ServiceDocumentType,
  ServiceDocID,
  ServiceDocItemID,
  FinancialTransactionType,
  JointVentureCostRecoveryCode,
  _JointVentureRecoveryText.JointVentureRecoveryCodeName AS JointVentureRecoveryCodeName,
  _SupplierInvoice.TaxCountry AS TaxCountry,
  TransactionCurrency,
  _GlLine._DebitCreditCodeText AS _DebitCreditCodeText
FROM R_IncgOutgInvoiceItemTP
LEFT OUTER JOIN I_TaxCodeText AS _TaxCodeText ON TaxCode = _TaxCodeText.TaxCode AND _TaxCodeText.TaxCalculationProcedure = 'TAXD' AND _TaxCodeText.Language = $session.system_language  -- association [0..1]
;

Learn More