I_SuplrInvoiceItemGLAcctAPI01

DDL: I_SUPLRINVOICEITEMGLACCTAPI01 SQL: ISINITGLACCAPI01 Type: view BASIC

G/L Account Item of Supplier Invoice

I_SuplrInvoiceItemGLAcctAPI01 is a Basic CDS View that provides data about "G/L Account Item of Supplier Invoice" in SAP S/4HANA. It reads from 2 data sources (I_SupplierInvoiceAPI01, I_SupplierInvoiceItemGLAcct) and exposes 48 fields with key fields SupplierInvoice, FiscalYear, SupplierInvoiceItem. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
I_SupplierInvoiceAPI01 I_SupplierInvoiceAPI01 inner
I_SupplierInvoiceItemGLAcct I_SupplierInvoiceItemGLAcct from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_SupplierInvoiceAPI01 _SupplierInvoiceAPI01 $projection.SupplierInvoice = _SupplierInvoiceAPI01.SupplierInvoice and $projection.FiscalYear = _SupplierInvoiceAPI01.FiscalYear

Annotations (14)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName ISINITGLACCAPI01 view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
EndUserText.label G/L Account Item of Supplier Invoice view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.modelingPattern #NONE view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
Metadata.ignorePropagatedAnnotations true view
AbapCatalog.preserveKey true view

Fields (48)

KeyFieldSource TableSource FieldDescription
KEY SupplierInvoice I_SupplierInvoiceItemGLAcct SupplierInvoice
KEY FiscalYear I_SupplierInvoiceItemGLAcct FiscalYear
KEY SupplierInvoiceItem OrdinalNumber
CostCenter CostCenter
ControllingArea ControllingArea
BusinessArea BusinessArea
ProfitCenter ProfitCenter
FunctionalArea FunctionalArea
GLAccount GLAccount
SalesOrder SalesOrder
SalesOrderItem SalesOrderItem
ProjectNetworkInternalID ProjectNetworkInternalID
NetworkActivityInternalID NetworkActivityInternalID
ProjectNetwork ProjectNetwork
NetworkActivity NetworkActivity
CostObject CostObject
CostCtrActivityType CostCtrActivityType
BusinessProcess BusinessProcess
WBSElementInternalID WBSElementInternalID
WBSElementInternalID_2 WBSElementInternalID_2
DocumentCurrency I_SupplierInvoiceItemGLAcct DocumentCurrency
SupplierInvoiceItemAmount SupplierInvoiceItemAmount
TaxCode TaxCode
PersonnelNumber PersonnelNumber
WorkItem WorkItem
DebitCreditCode DebitCreditCode
TaxJurisdiction TaxJurisdiction
SupplierInvoiceItemText SupplierInvoiceItemText
AssignmentReference I_SupplierInvoiceItemGLAcct AssignmentReference
IsNotCashDiscountLiable IsNotCashDiscountLiable
InternalOrder InternalOrder
CommitmentItem CommitmentItem
FundsCenter FundsCenter
Fund Fund
GrantID GrantID
QuantityUnit QuantityUnit
Quantity Quantity
PartnerBusinessArea PartnerBusinessArea
FinancialTransactionType FinancialTransactionType
ServiceDocument ServiceDocument
ServiceDocumentItem ServiceDocumentItem
ServiceDocumentType ServiceDocumentType
CompanyCode I_SupplierInvoiceItemGLAcct CompanyCode
TaxCountry I_SupplierInvoiceItemGLAcct TaxCountry
_SupplierInvoiceAPI01 _SupplierInvoiceAPI01
_Currency I_SupplierInvoiceItemGLAcct _Currency
_UnitOfMeasure _UnitOfMeasure
_WBSElementBasicData _WBSElementBasicData
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'ISINITGLACCAPI01'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #MANDATORY
@VDM.viewType : #BASIC
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@EndUserText.label: 'G/L Account Item of Supplier Invoice'
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.supportedCapabilities: [ #CDS_MODELING_DATA_SOURCE, #SQL_DATA_SOURCE ]
@ObjectModel.modelingPattern: #NONE
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@Metadata.ignorePropagatedAnnotations:true
@AbapCatalog.preserveKey:true

define view I_SuplrInvoiceItemGLAcctAPI01
  as select from I_SupplierInvoiceItemGLAcct
    inner join   I_SupplierInvoiceAPI01 on  I_SupplierInvoiceItemGLAcct.SupplierInvoice = I_SupplierInvoiceAPI01.SupplierInvoice
                                        and I_SupplierInvoiceItemGLAcct.FiscalYear      = I_SupplierInvoiceAPI01.FiscalYear
  association [1..1] to I_SupplierInvoiceAPI01 as _SupplierInvoiceAPI01 on  $projection.SupplierInvoice = _SupplierInvoiceAPI01.SupplierInvoice
                                                                        and $projection.FiscalYear      = _SupplierInvoiceAPI01.FiscalYear
{
  key I_SupplierInvoiceItemGLAcct.SupplierInvoice,
  key I_SupplierInvoiceItemGLAcct.FiscalYear,
  key OrdinalNumber as SupplierInvoiceItem,
      CostCenter,
      ControllingArea,
      BusinessArea,
      ProfitCenter,
      FunctionalArea,
      GLAccount,
      SalesOrder,
      SalesOrderItem,
      ProjectNetworkInternalID,
      NetworkActivityInternalID,
      ProjectNetwork,
      NetworkActivity,
      CostObject,
      CostCtrActivityType,
      BusinessProcess,
      @VDM.lifecycle.status: #DEPRECATED
      @VDM.lifecycle.successor: 'WBSElementInternalID_2'
      WBSElementInternalID,
      WBSElementInternalID_2,
      @ObjectModel.foreignKey.association: '_Currency'
      @Semantics.currencyCode: true
      I_SupplierInvoiceItemGLAcct.DocumentCurrency,
      @Semantics.amount.currencyCode: 'DocumentCurrency'
      SupplierInvoiceItemAmount,
      TaxCode,
      PersonnelNumber,
      WorkItem,
      DebitCreditCode,
      TaxJurisdiction,
      SupplierInvoiceItemText,
      I_SupplierInvoiceItemGLAcct.AssignmentReference,
      IsNotCashDiscountLiable,
      InternalOrder,
      CommitmentItem,
      FundsCenter,
      Fund,
      GrantID,
      @ObjectModel.foreignKey.association: '_UnitOfMeasure'
      @Semantics.unitOfMeasure: true
      QuantityUnit,
      @Semantics.quantity.unitOfMeasure: 'QuantityUnit'
      Quantity,
      PartnerBusinessArea,
      FinancialTransactionType,
      ServiceDocument,
      ServiceDocumentItem,
      ServiceDocumentType,

      I_SupplierInvoiceItemGLAcct.CompanyCode,
      I_SupplierInvoiceItemGLAcct.TaxCountry,

      /* Associations */
      _SupplierInvoiceAPI01,
      I_SupplierInvoiceItemGLAcct._Currency,
      _UnitOfMeasure,
      _WBSElementBasicData

}