I_SupplierPaymentBlockTP

DDL: I_SUPPLIERPAYMENTBLOCKTP SQL: ISUPLRPAYTBLKTP Type: view TRANSACTIONAL

Supplier Payment Blocks - TP

I_SupplierPaymentBlockTP is a Transactional CDS View that provides data about "Supplier Payment Blocks - TP" in SAP S/4HANA. It reads from 1 data source (I_SupplierCompany) and exposes 7 fields with key fields Supplier, CompanyCode. It has 2 associations to related views.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
I_SupplierCompany I_SupplierCompany from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_SupplierPaymentBlockOpnItmTP _OpenItems $projection.Supplier = _OpenItems.Supplier and $projection.CompanyCode = _OpenItems.CompanyCode
[0..1] I_PaymentBlockingStatus _PaymentBlockingStatus $projection.Status = _PaymentBlockingStatus.Status

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName ISUPLRPAYTBLKTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Supplier Payment Blocks - TP view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.compositionRoot true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY Supplier Supplier
KEY CompanyCode CompanyCode
PaymentBlockingReason PaymentBlockingReason
_OpenItems _OpenItems
_Supplier _Supplier
_CompanyCode _CompanyCode
_PaymentBlockingStatus _PaymentBlockingStatus 
//Transactional View on Supplier-Level

@AbapCatalog.sqlViewName: 'ISUPLRPAYTBLKTP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@EndUserText.label: 'Supplier Payment Blocks - TP'
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.compositionRoot: true
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MIXED
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
define view I_SupplierPaymentBlockTP
  as select from I_SupplierCompany
  association [0..*] to I_SupplierPaymentBlockOpnItmTP  as _OpenItems                 on  $projection.Supplier    = _OpenItems.Supplier 
                                                                                      and $projection.CompanyCode = _OpenItems.CompanyCode
  association [0..1] to I_PaymentBlockingStatus         as _PaymentBlockingStatus     on  $projection.Status      = _PaymentBlockingStatus.Status  
{

  key Supplier,
  key CompanyCode,
      PaymentBlockingReason,

      cast ( 
        case PaymentBlockingReason
        when '' then 'U'
        else 'A'
        end  as  fap_payt_blkg_status ) as Status,

      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
      _OpenItems,
      _Supplier,
      _CompanyCode,
      _PaymentBlockingStatus
}
// exclude blocked/EoP business partners as they should never be displayed in MPB

// therefore @AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED is allowed

where I_SupplierCompany.IsBusinessPurposeCompleted = ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SUPPLIERCOMPANY"
],
"ASSOCIATED":
[
"I_COMPANYCODE",
"I_PAYMENTBLOCKINGSTATUS",
"I_SUPPLIER",
"I_SUPPLIERPAYMENTBLOCKOPNITMTP"
],
"BASE":
[
"I_SUPPLIERCOMPANY"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More