I_SuplrInvcItmAcctAssgmtAPI01

DDL: I_SUPLRINVCITMACCTASSGMTAPI01 SQL: ISUINITACASAPI01 Type: view COMPOSITE Package: VDM_MM_IV_SI_API

Account Assignment for Supplier Invoice

I_SuplrInvcItmAcctAssgmtAPI01 is a Composite CDS View that provides data about "Account Assignment for Supplier Invoice" in SAP S/4HANA. It reads from 2 data sources (I_SupplierInvoiceAPI01, I_SupplierInvoiceItmAcctAssgmt) and exposes 49 fields with key fields SupplierInvoice, FiscalYear, SupplierInvoiceItem, OrdinalNumber. It has 2 associations to related views. Part of development package VDM_MM_IV_SI_API.

Data Sources (2)

SourceAliasJoin Type
I_SupplierInvoiceAPI01 I_SupplierInvoiceAPI01 inner
I_SupplierInvoiceItmAcctAssgmt I_SupplierInvoiceItmAcctAssgmt from

Associations (2)

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

Annotations (13)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName ISUINITACASAPI01 view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
EndUserText.label Account Assignment for Supplier Invoice view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.modelingPattern #NONE view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
Metadata.ignorePropagatedAnnotations true view

Fields (49)

KeyFieldSource TableSource FieldDescription
KEY SupplierInvoice I_SupplierInvoiceItmAcctAssgmt SupplierInvoice
KEY FiscalYear I_SupplierInvoiceItmAcctAssgmt FiscalYear
KEY SupplierInvoiceItem SupplierInvoiceItem
KEY OrdinalNumber OrdinalNumber
CostCenter CostCenter
ControllingArea ControllingArea
BusinessArea BusinessArea
ProfitCenter ProfitCenter
FunctionalArea FunctionalArea
GLAccount GLAccount
SalesOrder SalesOrder
SalesOrderItem SalesOrderItem
CostObject CostObject
CostCtrActivityType CostCtrActivityType
BusinessProcess BusinessProcess
WBSElementInternalID WBSElementInternalID
WBSElementInternalID_2 WBSElementInternalID_2
DocumentCurrency I_SupplierInvoiceItmAcctAssgmt DocumentCurrency
SupplierInvoiceItemAmount SupplierInvoiceItemAmount
PurchaseOrderQuantityUnit PurchaseOrderQuantityUnit
Quantity Quantity
TaxCode TaxCode
AccountAssignmentNumber AccountAssignmentNumber
AccountAssignmentIsUnplanned AccountAssignmentIsUnplanned
PersonnelNumber PersonnelNumber
WorkItem WorkItem
MasterFixedAsset MasterFixedAsset
FixedAsset FixedAsset
DebitCreditCode DebitCreditCode
TaxJurisdiction TaxJurisdiction
InternalOrder InternalOrder
ProjectNetworkInternalID ProjectNetworkInternalID
NetworkActivityInternalID NetworkActivityInternalID
ProjectNetwork ProjectNetwork
NetworkActivity NetworkActivity
CommitmentItem CommitmentItem
FundsCenter FundsCenter
Fund Fund
GrantID GrantID
PartnerBusinessArea PartnerBusinessArea
TaxCountry I_SupplierInvoiceItmAcctAssgmt TaxCountry
ServiceDocument ServiceDocument
ServiceDocumentItem ServiceDocumentItem
ServiceDocumentType ServiceDocumentType
_SupplierInvoiceAPI01 _SupplierInvoiceAPI01
_SuplrInvcItemPurOrdRefAPI01 _SuplrInvcItemPurOrdRefAPI01
_Currency I_SupplierInvoiceItmAcctAssgmt _Currency
_UnitOfMeasure _UnitOfMeasure
_WBSElementBasicData _WBSElementBasicData
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'ISUINITACASAPI01'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #MANDATORY
@VDM.viewType: #COMPOSITE
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@EndUserText.label: 'Account Assignment for Supplier Invoice'
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #XL
@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

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

      /* Associations */
      _SupplierInvoiceAPI01,
      _SuplrInvcItemPurOrdRefAPI01,
      I_SupplierInvoiceItmAcctAssgmt._Currency,
      _UnitOfMeasure,
      _WBSElementBasicData
}