P_SupplierInvoiceDiscountDates

DDL: P_SUPPLIERINVOICEDISCOUNTDATES SQL: PSUPINVDISD Type: view CONSUMPTION
23 Fields 1 Data Sources 1 Associations

P_SupplierInvoiceDiscountDates is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (P_SuplrInvoiceDiscountDates1) and exposes 23 fields with key fields SupplierInvoice, FiscalYear. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
P_SuplrInvoiceDiscountDates1 P_SuplrInvoiceDiscountDates1 from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_SuplrInvcBlkdItemReasonText _BlockingReasonText $projection.SuplrInvcItmBlockingReason = _BlockingReasonText.SuplrInvcItmBlockingReason and _BlockingReasonText.Language = $session.system_language

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PSUPINVDISD view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
VDM.private true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY SupplierInvoice SupplierInvoice
KEY FiscalYear FiscalYear G/L Fiscal Year
CompanyCode CompanyCode Receiver Company Code
SupplierInvoiceUUID SupplierInvoiceUUID
PostingDate PostingDate Posting Date for GR
DocumentDate DocumentDate Journal Entry Date
Supplier Supplier Supplier
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency Local Crcy Amt
CompanyCodeCurrency CompanyCodeCurrency Local Currency
DueCalculationBaseDate DueCalculationBaseDate Due Calculation Base Date
CashDiscount1Percent CashDiscount1Percent Disc. Percent 1
CashDiscount1Days CashDiscount1Days Days from Baseline Date for Payment
CashDiscount1DueDate CashDiscount1DueDate Cash Discount 1
CashDiscount2Percent CashDiscount2Percent Disc. Percent 2
CashDiscount2Days CashDiscount2Days Days from Baseline Date for Payment
CashDiscount2DueDate CashDiscount2DueDate Cash Discount 2
NetDueDate NetDueDate Net Due Date
ClearingDate _AccountingItem ClearingDate Clearing Date
PaymentBlockingReason _AccountingItem PaymentBlockingReason Pmnt block
SuplrInvcItmBlockingReason SuplrInvcItmBlockingReason
SuplrInvcItmBlockingReasonDesc _BlockingReasonText SuplrInvcItmBlockingReasonDesc
IsEndOfPurposeBlocked IsEndOfPurposeBlocked Busin. Purp. Cmpltd.
_CompanyCode _CompanyCode

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 P_SupplierInvoiceDiscountDates.
-- 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: PSUPINVDISD

CREATE VIEW P_SupplierInvoiceDiscountDates AS
SELECT
  SupplierInvoice,
  FiscalYear,
  CompanyCode,
  SupplierInvoiceUUID,
  PostingDate,
  DocumentDate,
  Supplier,
  AmountInCompanyCodeCurrency,
  CompanyCodeCurrency,
  DueCalculationBaseDate,
  CashDiscount1Percent,
  CashDiscount1Days,
  CashDiscount1DueDate,
  CashDiscount2Percent,
  CashDiscount2Days,
  CashDiscount2DueDate,
  NetDueDate,
  _AccountingItem.ClearingDate AS ClearingDate,
  _AccountingItem.PaymentBlockingReason AS PaymentBlockingReason,
  SuplrInvcItmBlockingReason,
  _BlockingReasonText.SuplrInvcItmBlockingReasonDesc AS SuplrInvcItmBlockingReasonDesc,
  IsEndOfPurposeBlocked
FROM P_SuplrInvoiceDiscountDates1
LEFT OUTER JOIN I_SuplrInvcBlkdItemReasonText AS _BlockingReasonText ON SuplrInvcItmBlockingReason = _BlockingReasonText.SuplrInvcItmBlockingReason AND _BlockingReasonText.Language = $session.system_language  -- association [0..1]
;

Learn More