I_SUPPLIERINVOICEBLOCK

CDS View

Supplier Invoice Block

I_SUPPLIERINVOICEBLOCK is a CDS View in S/4HANA. Supplier Invoice Block. It contains 9 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 9 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_SupplierInvoiceBlockAPI01 view from BASIC Supplier Invoice Block Logistics

Fields (9)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 1
KEY CreatedByUser CreatedByUser 1
KEY FiscalYear FiscalYear 1
KEY InvoicingParty InvoicingParty 1
KEY NetDueDate NetDueDate 1
KEY PaymentBlockingReason PaymentBlockingReason 1
KEY PostingDate PostingDate 1
KEY PurchasingGroup PurchasingGroup 1
KEY SupplierInvoice SupplierInvoice 1 
@EndUserText.label: 'Supplier Invoice Block'
@AbapCatalog.sqlViewName: 'ISUPINVBLOCK'
@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API 
@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_SupplierInvoiceBlock
  as select from rbkp_blocked

  association [1..1] to I_SupplierInvoice as _SupplierInvoice on  $projection.SupplierInvoice = _SupplierInvoice.SupplierInvoice
                                                              and $projection.FiscalYear      = _SupplierInvoice.FiscalYear
{
  key mrm_zlspr as PaymentBlockingReason,
  key bukrs     as CompanyCode,
  key gjahr     as FiscalYear,
  key lifnr     as InvoicingParty,
  key belnr     as SupplierInvoice,
  key usnam     as CreatedByUser,
  key budat     as PostingDate,
  key ekgrp     as PurchasingGroup,
  key faell     as NetDueDate,

      /* Associations */
      _SupplierInvoice

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"RBKP_BLOCKED"
],
"ASSOCIATED":
[
"I_SUPPLIERINVOICE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More