I_BhvrlInsgtsPromiseToPay

DDL: I_BHVRLINSGTSPROMISETOPAY SQL: IBIPTOP Type: view_entity BASIC
9 Fields 1 Data Sources

Promise to Pay Data

I_BhvrlInsgtsPromiseToPay is a Basic CDS View that provides data about "Promise to Pay Data" in SAP S/4HANA. It reads from 1 data source (dfkkpp) and exposes 9 fields with key field CustomerEventRecordID.

Data Sources (1)

SourceAliasJoin Type
dfkkpp dfkkpp from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Promise to Pay Data view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #XL view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY CustomerEventRecordID dfkkpp ppkey Promise to Pay
CompanyCode bukrs Value
BusinessPartner dfkkpp gpart Tech. BPartner
ContractAccount dfkkpp vkont Tech. CtrAcct
CustomerEventStartDate dfkkpp erdat Entered On
CustomerEventEndDate chdat Time Stamp
LocalCurrency prcur Currency
OpenAmountInLocalCurrency pramt Amount
CAPromiseToPayStatus dfkkpp ppsta Statuses

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 I_BhvrlInsgtsPromiseToPay.
-- 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: IBIPTOP

CREATE VIEW I_BhvrlInsgtsPromiseToPay AS
SELECT
  dfkkpp.ppkey AS CustomerEventRecordID,
  bukrs AS CompanyCode,
  dfkkpp.gpart AS BusinessPartner,
  dfkkpp.vkont AS ContractAccount,
  dfkkpp.erdat AS CustomerEventStartDate,
  chdat AS CustomerEventEndDate,
  prcur AS LocalCurrency,
  pramt AS OpenAmountInLocalCurrency,
  dfkkpp.ppsta AS CAPromiseToPayStatus
FROM dfkkpp
;

Learn More