I_SUPLRINVCITEMCONSIGNMENT

CDS View

Consignment Settlement Item

I_SUPLRINVCITEMCONSIGNMENT is a CDS View in S/4HANA. Consignment Settlement Item. It contains 22 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 22 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_SuplrInvcItemCsgnmtAPI01 view_entity from BASIC Consignment Settlement Item

Fields (22)

KeyField CDS FieldsUsed in Views
KEY FiscalYear FiscalYear 1
KEY SupplierInvoice SupplierInvoice 1
KEY SupplierInvoiceItem SupplierInvoiceItem 1
_Currency _Currency 1
_UnitOfMeasure _UnitOfMeasure 1
BusinessArea BusinessArea 1
CompanyCode CompanyCode 1
DebitCreditCode DebitCreditCode 1
DocumentCurrency DocumentCurrency 1
GLAccount GLAccount 1
Material Material 1
MaterialDocument MaterialDocument 1
MaterialDocumentItem MaterialDocumentItem 1
MaterialDocumentYear MaterialDocumentYear 1
Plant Plant 1
ProfitCenter ProfitCenter 1
Quantity Quantity 1
QuantityUnit QuantityUnit 1
SupplierInvoiceItemAmount SupplierInvoiceItemAmount 1
TaxCode TaxCode 1
TaxCountry TaxCountry 1
TaxJurisdiction TaxJurisdiction 1 
@EndUserText.label: 'Consignment Settlement Item'
@VDM.viewType : #BASIC
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@AbapCatalog.sqlViewName: 'ISINVCITMCONS'
@AccessControl.authorizationCheck: #MANDATORY
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@AccessControl.personalData.blocking:#REQUIRED
@AbapCatalog.preserveKey:true
@AbapCatalog.compiler.compareFilter:true

define view I_SuplrInvcItemConsignment
  as select from recon

  association [1..1] to I_SupplierInvoice as _SupplierInvoice on  $projection.SupplierInvoice = _SupplierInvoice.SupplierInvoice
                                                              and $projection.FiscalYear      = _SupplierInvoice.FiscalYear

  association [0..1] to I_Currency        as _Currency        on  $projection.documentcurrency = _Currency.Currency

  association [1..1] to I_UnitOfMeasure   as _UnitOfMeasure   on  $projection.QuantityUnit = _UnitOfMeasure.UnitOfMeasure

{
  key belnr                                as SupplierInvoice,
  key gjahr                                as FiscalYear,
  key buzei                                as SupplierInvoiceItem,
      mblnr                                as MaterialDocument,
      mjahr                                as MaterialDocumentYear,
      mblpo                                as MaterialDocumentItem,
      matnr                                as Material,
      bukrs                                as CompanyCode,
      werks                                as Plant,
      @Semantics.currencyCode: true
      _SupplierInvoice.DocumentCurrency,
      @Semantics.amount.currencyCode: 'DocumentCurrency'
      @DefaultAggregation:#NONE
      wrbtr                                as SupplierInvoiceItemAmount,
      shkzg                                as DebitCreditCode,
      mwskz                                as TaxCode,
      txjcd                                as TaxJurisdiction,
      @Semantics.unitOfMeasure: true
      meins                                as QuantityUnit,
      @Semantics.quantity.unitOfMeasure: 'QuantityUnit'
      @DefaultAggregation: #NONE
      menge                                as Quantity,
      gsber                                as BusinessArea,
      saknr                                as GLAccount,
      prctr                                as ProfitCenter,
      tax_country                          as TaxCountry,

      /* Associations */
      @ObjectModel.association.type: [#TO_COMPOSITION_ROOT,#TO_COMPOSITION_PARENT]
      _SupplierInvoice,
      _Currency,
      _UnitOfMeasure
}

Learn More