I_PrepaymentApproval

DDL: I_PREPAYMENTAPPROVAL SQL: IPPMGAPPROVAL Type: view BASIC
17 Fields 1 Data Sources 2 Associations

Prepayment Approval basic view

I_PrepaymentApproval is a Basic CDS View that provides data about "Prepayment Approval basic view" in SAP S/4HANA. It reads from 1 data source (ppmgag_t_appr) and exposes 17 fields with key field PrepaymentApprovalUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
ppmgag_t_appr AgreementApproval from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_BusinessPartnerSupplier _BusinessPartner $projection.Counterparty = _BusinessPartner.Supplier -- Extension View for Approval
[0..1] E_PrepaymentApproval _Extension $projection.PrepaymentApprovalUUID = _Extension.PrepaymentApprovalUUID

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IPPMGAPPROVAL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #BASIC view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MASTER view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Prepayment Approval basic view view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY PrepaymentApprovalUUID ppmgag_t_appr prepaymentapprovaluuid Key
PrepaymentAgreement ppmgag_t_appr prepaymentagreement Renegotiation PPA
PrepaymentAgreementType ppmgag_t_appr prepaymentagreementtype Prepay Agreemnt Type
PrepaymentAgreementCategory ppmgag_t_appr prepaymentagreementcategory Prepayment Category
PrepaymentAgrmtIsPosted ppmgag_t_appr prepaymentagrmtisposted Pre Agreement Posted
PrepaymentPostingIsBlocked ppmgag_t_appr prepaymentpostingisblocked PreAgr Postg Blocked
FinalSettlementIndicator ppmgag_t_appr finalsettlementindicator Final Settlement
IsIntercompanyPayment ppmgag_t_appr isintercompanypayment Intercompany Payment
ConditionApplication ppmgag_t_appr conditionapplication Application
CompanyCode ppmgag_t_appr companycode Receiver Company Code
Counterparty ppmgag_t_appr counterparty Supplier
IsBusinessPurposeCompleted _BusinessPartner IsBusinessPurposeCompleted Purpose Completed
AuthorizationGroup _BusinessPartner AuthorizationGroup AuthorizGroup
createdbyuserasCreatedByUser
CreationDateTime ppmgag_t_appr creationdatetime Timestamp
LastChangedByUser ppmgag_t_appr lastchangedbyuser User Name
LastChangeDateTime ppmgag_t_appr lastchangedatetime Timestamp

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_PrepaymentApproval.
-- 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: IPPMGAPPROVAL

CREATE VIEW I_PrepaymentApproval AS
SELECT
  AgreementApproval.prepaymentapprovaluuid AS PrepaymentApprovalUUID,
  AgreementApproval.prepaymentagreement AS PrepaymentAgreement,
  AgreementApproval.prepaymentagreementtype AS PrepaymentAgreementType,
  AgreementApproval.prepaymentagreementcategory AS PrepaymentAgreementCategory,
  AgreementApproval.prepaymentagrmtisposted AS PrepaymentAgrmtIsPosted,
  AgreementApproval.prepaymentpostingisblocked AS PrepaymentPostingIsBlocked,
  AgreementApproval.finalsettlementindicator AS FinalSettlementIndicator,
  AgreementApproval.isintercompanypayment AS IsIntercompanyPayment,
  AgreementApproval.conditionapplication AS ConditionApplication,
  AgreementApproval.companycode AS CompanyCode,
  AgreementApproval.counterparty AS Counterparty,
  _BusinessPartner.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  _BusinessPartner.AuthorizationGroup AS AuthorizationGroup,
  AgreementApproval.creationdatetime AS CreationDateTime,
  AgreementApproval.lastchangedbyuser AS LastChangedByUser,
  AgreementApproval.lastchangedatetime AS LastChangeDateTime
FROM ppmgag_t_appr AS AgreementApproval
LEFT OUTER JOIN I_BusinessPartnerSupplier AS _BusinessPartner ON Counterparty = _BusinessPartner.Supplier  -- association [0..1]
LEFT OUTER JOIN E_PrepaymentApproval AS _Extension ON PrepaymentApprovalUUID = _Extension.PrepaymentApprovalUUID  -- association [0..1]
;

Learn More