I_PrepaymentApprovalDocumentTP

DDL: I_PREPAYMENTAPPROVALDOCUMENTTP SQL: IPPMGAPPDTP Type: view TRANSACTIONAL
18 Fields 1 Data Sources 2 Associations

Prepayment Appr Doc Transactional view

I_PrepaymentApprovalDocumentTP is a Transactional CDS View that provides data about "Prepayment Appr Doc Transactional view" in SAP S/4HANA. It reads from 1 data source (I_PrepaymentApprovalDocument) and exposes 18 fields with key field PrepaymentAgrmtDocUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_PrepaymentApprovalDocument ApprovalDoc from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_PrepaymentApprovalTP _AgreementApproval $projection.PrepaymentApprovalUUID = _AgreementApproval.PrepaymentApprovalUUID -- Extension View for Approval Doc
[0..1] E_PrepaymentApprovalDocument _Extension $projection.PrepaymentAgrmtDocUUID = _Extension.PrepaymentAgrmtDocUUID

Annotations (18)

NameValueLevelField
AbapCatalog.sqlViewName IPPMGAPPDTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Prepayment Appr Doc Transactional view view
VDM.viewType #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.writeActivePersistence PPMGAG_T_APP_DOC view
ObjectModel.writeDraftPersistence PPMGAG_T_APD_D view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.lifecycle.enqueue.expiryBehavior #RELATIVE_TO_LAST_CHANGE view
ObjectModel.lifecycle.enqueue.expiryInterval PT60M view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.modelCategory #BUSINESS_OBJECT view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY PrepaymentAgrmtDocUUID I_PrepaymentApprovalDocument PrepaymentAgrmtDocUUID Key
PrepaymentApprovalUUID I_PrepaymentApprovalDocument PrepaymentApprovalUUID Key
PrepaymentAgrmtDistrUUID I_PrepaymentApprovalDocument PrepaymentAgrmtDistrUUID Key
SAPBusinessObjectTypeCode I_PrepaymentApprovalDocument SAPBusinessObjectTypeCode SAP Obj Rep
PrepaymentPostedDocument I_PrepaymentApprovalDocument PrepaymentPostedDocument Posted Document No.
PrepaymentReversedDocument I_PrepaymentApprovalDocument PrepaymentReversedDocument Reversed DocumentNo.
PrepaymentAgrmtRefDocument I_PrepaymentApprovalDocument PrepaymentAgrmtRefDocument Linking Document No.
CompanyCode I_PrepaymentApprovalDocument CompanyCode Receiver Company Code
FiscalYear I_PrepaymentApprovalDocument FiscalYear G/L Fiscal Year
PrepaymentAgreementAmount I_PrepaymentApprovalDocument PrepaymentAgreementAmount Pre Agrm Amount
PrepaymentAgreementCurrency I_PrepaymentApprovalDocument PrepaymentAgreementCurrency Currency
PrepaymentFeesDocument I_PrepaymentApprovalDocument PrepaymentFeesDocument Posted Document No.
PrepaymentFeesReversedDocument I_PrepaymentApprovalDocument PrepaymentFeesReversedDocument Reversed DocumentNo.
CreatedByUserasCreatedByUser
CreationDateTime I_PrepaymentApprovalDocument CreationDateTime Timestamp
LastChangedByUser I_PrepaymentApprovalDocument LastChangedByUser User Name
LastChangeDateTime I_PrepaymentApprovalDocument LastChangeDateTime Timestamp
Associations_AgreementApproval

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_PrepaymentApprovalDocumentTP.
-- 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: IPPMGAPPDTP

CREATE VIEW I_PrepaymentApprovalDocumentTP AS
SELECT
  ApprovalDoc.PrepaymentAgrmtDocUUID AS PrepaymentAgrmtDocUUID,
  ApprovalDoc.PrepaymentApprovalUUID AS PrepaymentApprovalUUID,
  ApprovalDoc.PrepaymentAgrmtDistrUUID AS PrepaymentAgrmtDistrUUID,
  ApprovalDoc.SAPBusinessObjectTypeCode AS SAPBusinessObjectTypeCode,
  ApprovalDoc.PrepaymentPostedDocument AS PrepaymentPostedDocument,
  ApprovalDoc.PrepaymentReversedDocument AS PrepaymentReversedDocument,
  ApprovalDoc.PrepaymentAgrmtRefDocument AS PrepaymentAgrmtRefDocument,
  ApprovalDoc.CompanyCode AS CompanyCode,
  ApprovalDoc.FiscalYear AS FiscalYear,
  ApprovalDoc.PrepaymentAgreementAmount AS PrepaymentAgreementAmount,
  ApprovalDoc.PrepaymentAgreementCurrency AS PrepaymentAgreementCurrency,
  ApprovalDoc.PrepaymentFeesDocument AS PrepaymentFeesDocument,
  ApprovalDoc.PrepaymentFeesReversedDocument AS PrepaymentFeesReversedDocument,
  ApprovalDoc.CreationDateTime AS CreationDateTime,
  ApprovalDoc.LastChangedByUser AS LastChangedByUser,
  ApprovalDoc.LastChangeDateTime AS LastChangeDateTime
FROM I_PrepaymentApprovalDocument AS ApprovalDoc
LEFT OUTER JOIN I_PrepaymentApprovalTP AS _AgreementApproval ON PrepaymentApprovalUUID = _AgreementApproval.PrepaymentApprovalUUID  -- association [1..1]
LEFT OUTER JOIN E_PrepaymentApprovalDocument AS _Extension ON PrepaymentAgrmtDocUUID = _Extension.PrepaymentAgrmtDocUUID  -- association [0..1]
;

Learn More