C_SupplierInvoiceDiscountDates

DDL: C_SUPPLIERINVOICEDISCOUNTDATES SQL: CSUPINVDISD Type: view CONSUMPTION
19 Fields 1 Data Sources 2 Associations

Supplier Invoice

C_SupplierInvoiceDiscountDates is a Consumption CDS View that provides data about "Supplier Invoice" in SAP S/4HANA. It reads from 1 data source (P_SuplrInvoiceDiscountDates1) and exposes 19 fields with key fields SupplierInvoice, FiscalYear. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
P_SuplrInvoiceDiscountDates1 P_SuplrInvoiceDiscountDates1 from

Associations (2)

CardinalityTargetAliasCondition
[0..*] C_SupplierInvoiceBlockedItem _SupplierInvoiceItem $projection.SupplierInvoice = _SupplierInvoiceItem.SupplierInvoice and $projection.FiscalYear = _SupplierInvoiceItem.FiscalYear
[0..1] I_SupplierContactCard _SupplierContactCard $projection.Supplier = _SupplierContactCard.ContactCardID

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CSUPINVDISD view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Supplier Invoice view

Fields (19)

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
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
NetPaymentDays NetPaymentDays Net Pmt Terms Period
IsEndOfPurposeBlocked IsEndOfPurposeBlocked Busin. Purp. Cmpltd.
PaymentStatusName
_SupplierInvoiceItem _SupplierInvoiceItem
_SupplierContactCard _SupplierContactCard

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_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: CSUPINVDISD

CREATE VIEW C_SupplierInvoiceDiscountDates AS
SELECT
  SupplierInvoice,
  FiscalYear,
  CompanyCode,
  SupplierInvoiceUUID,
  PostingDate,
  DocumentDate,
  Supplier,
  DueCalculationBaseDate,
  CashDiscount1Percent,
  CashDiscount1Days,
  CashDiscount1DueDate,
  CashDiscount2Percent,
  CashDiscount2Days,
  CashDiscount2DueDate,
  NetPaymentDays,
  IsEndOfPurposeBlocked,
  cast('' as abap.sstring( 100 )) AS PaymentStatusName
FROM P_SuplrInvoiceDiscountDates1
LEFT OUTER JOIN C_SupplierInvoiceBlockedItem AS _SupplierInvoiceItem ON SupplierInvoice = _SupplierInvoiceItem.SupplierInvoice AND FiscalYear = _SupplierInvoiceItem.FiscalYear  -- association [0..*]
LEFT OUTER JOIN I_SupplierContactCard AS _SupplierContactCard ON Supplier = _SupplierContactCard.ContactCardID  -- association [0..1]
;

Learn More