C_SupplierPaymentBlock

DDL: C_SUPPLIERPAYMENTBLOCK SQL: CSUPLRPAYTBLK Type: view_entity CONSUMPTION
19 Fields 1 Data Sources 7 Associations

Supplier Payment Blocks

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

Data Sources (1)

SourceAliasJoin Type
I_SupplierPaymentBlockTP I_SupplierPaymentBlockTP from

Associations (7)

CardinalityTargetAliasCondition
[1] I_SupplierCompany _SupplierCompany $projection.Supplier = _SupplierCompany.Supplier and $projection.CompanyCode = _SupplierCompany.CompanyCode
[1..1] I_Supplier _Supplier $projection.Supplier = _Supplier.Supplier
[1..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[0..*] C_SupplierPaymentBlockOpnItm _OpenItems $projection.Supplier = _OpenItems.Supplier and $projection.CompanyCode = _OpenItems.CompanyCode
[1..1] C_SuplrPaytBlkOpnItmsAggrgn _OpenItemsAggregation $projection.Supplier = _OpenItemsAggregation.Supplier and $projection.CompanyCode = _OpenItemsAggregation.CompanyCode
[1..1] C_SuplrPaytBlkBlkdItmsAggrgn _BlockedItemsAggregation $projection.Supplier = _BlockedItemsAggregation.Supplier and $projection.CompanyCode = _BlockedItemsAggregation.CompanyCode
[0..1] C_SuplrPaytBlockingReasonVH _PaymentBlockingReasonText $projection.PaymentBlockingReason = _PaymentBlockingReasonText.PaymentBlockingReason and $projection.PaymentBlockingReason != ''

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Supplier Payment Blocks view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
Search.searchable true view
VDM.viewType #CONSUMPTION view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY Supplier Supplier Supplier
KEY CompanyCode CompanyCode Receiver Company Code
PaymentBlockingReason PaymentBlockingReason Pmnt block
Status Status Workflow Status
CompanyCodeName _CompanyCode CompanyCodeName Company Name
SupplierName _Supplier OrganizationBPName1 Name 1
OrganizationBPName2 _Supplier OrganizationBPName2 Name 2
PaymentBlockingReasonName
StatusDescription
NumberOfItems _OpenItemsAggregation NumberOfOpenItems
NumberOfBlockedItems _BlockedItemsAggregation NumberOfBlockedItems
Currency _SupplierCompany Currency Company Code Currency
PostalCode _Supplier PostalCode Postal Code
CityName _Supplier CityName Name
StreetName _Supplier StreetName Text
_Supplier _Supplier
_SupplierCompany _SupplierCompany
_CompanyCode _CompanyCode
_OpenItems _OpenItems

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_SupplierPaymentBlock.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CSUPLRPAYTBLK

CREATE VIEW C_SupplierPaymentBlock AS
SELECT
  Supplier,
  CompanyCode,
  PaymentBlockingReason,
  Status,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  _Supplier.OrganizationBPName1 AS SupplierName,
  _Supplier.OrganizationBPName2 AS OrganizationBPName2,
  _PaymentBlockingReasonText._Text[1:Language=$session.system_language].PaymentBlockingReasonName AS PaymentBlockingReasonName,
  _PaymentBlockingStatus._Text[1:Language=$session.system_language].StatusDescription AS StatusDescription,
  _OpenItemsAggregation.NumberOfOpenItems AS NumberOfItems,
  _BlockedItemsAggregation.NumberOfBlockedItems AS NumberOfBlockedItems,
  _SupplierCompany.Currency AS Currency,
  _Supplier.PostalCode AS PostalCode,
  _Supplier.CityName AS CityName,
  _Supplier.StreetName AS StreetName
FROM I_SupplierPaymentBlockTP
LEFT OUTER JOIN I_SupplierCompany AS _SupplierCompany ON Supplier = _SupplierCompany.Supplier AND CompanyCode = _SupplierCompany.CompanyCode  -- association [1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN C_SupplierPaymentBlockOpnItm AS _OpenItems ON Supplier = _OpenItems.Supplier AND CompanyCode = _OpenItems.CompanyCode  -- association [0..*]
LEFT OUTER JOIN C_SuplrPaytBlkOpnItmsAggrgn AS _OpenItemsAggregation ON Supplier = _OpenItemsAggregation.Supplier AND CompanyCode = _OpenItemsAggregation.CompanyCode  -- association [1..1]
LEFT OUTER JOIN C_SuplrPaytBlkBlkdItmsAggrgn AS _BlockedItemsAggregation ON Supplier = _BlockedItemsAggregation.Supplier AND CompanyCode = _BlockedItemsAggregation.CompanyCode  -- association [1..1]
LEFT OUTER JOIN C_SuplrPaytBlockingReasonVH AS _PaymentBlockingReasonText ON PaymentBlockingReason = _PaymentBlockingReasonText.PaymentBlockingReason AND PaymentBlockingReason != ''  -- association [0..1]
;

Learn More