I_PrepaymentAgrmtHarvest

DDL: I_PREPAYMENTAGRMTHARVEST SQL: IPPMGHARV Type: view BASIC
16 Fields 1 Data Sources 1 Associations

Prepayment Agreement Harvest View

I_PrepaymentAgrmtHarvest is a Basic CDS View that provides data about "Prepayment Agreement Harvest View" in SAP S/4HANA. It reads from 1 data source (ppmgag_t_harv) and exposes 16 fields with key field PrepaymentAgrmtHarvestUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
ppmgag_t_harv PrepaymentHarvest from

Associations (1)

CardinalityTargetAliasCondition
[0..1] E_PrepaymentAgrmtHarvest _Extension $projection.PrepaymentAgreementUUID = _Extension.PrepaymentAgrmtHarvestUUID

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IPPMGHARV view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #BASIC view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Prepayment Agreement Harvest View view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY PrepaymentAgrmtHarvestUUID ppmgag_t_harv prepaymentagrmtharvestuuid Key
PrepaymentAgreementUUID ppmgag_t_harv prepaymentagreementuuid Key
PrepaymentAgrmtHarvestYear ppmgag_t_harv prepaymentagrmtharvestyear Harvest Year
PrepaymentAgreementCommodity ppmgag_t_harv prepaymentagreementcommodity Commodity
PrepaymentHarvestTotalAreaQty ppmgag_t_harv prepaymentharvesttotalareaqty Prepmt Harv Area
PrepaymentHistPlantedAreaUoM ppmgag_t_harv prepaymenthistplantedareauom Harvest Area UoM
PrepaymentHarvestProductivity ppmgag_t_harv prepaymentharvestproductivity Prepmt Harv Prdctvty
PrepaymentHarvestLastProduct ppmgag_t_harv prepaymentharvestlastproduct Prepmt Harv Last Prd
PrepaymentHarvestSalesQty ppmgag_t_harv prepaymentharvestsalesqty Prepmt Harv Sale Qty
PrepaymentHarvestSalesUoM ppmgag_t_harv prepaymentharvestsalesuom Total Sales Area UoM
PrepaymentHarvestObservations ppmgag_t_harv prepaymentharvestobservations Prepmt Harvest Obsvn
PrepaymentAgreement _PrepayAgreement PrepaymentAgreement Renegotiation PPA
createdbyuserasCreatedByUser
CreationDateTime ppmgag_t_harv creationdatetime Timestamp
LastChangedByUser ppmgag_t_harv lastchangedbyuser User Name
LastChangeDateTime ppmgag_t_harv 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_PrepaymentAgrmtHarvest.
-- 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: IPPMGHARV

CREATE VIEW I_PrepaymentAgrmtHarvest AS
SELECT
  PrepaymentHarvest.prepaymentagrmtharvestuuid AS PrepaymentAgrmtHarvestUUID,
  PrepaymentHarvest.prepaymentagreementuuid AS PrepaymentAgreementUUID,
  PrepaymentHarvest.prepaymentagrmtharvestyear AS PrepaymentAgrmtHarvestYear,
  PrepaymentHarvest.prepaymentagreementcommodity AS PrepaymentAgreementCommodity,
  PrepaymentHarvest.prepaymentharvesttotalareaqty AS PrepaymentHarvestTotalAreaQty,
  PrepaymentHarvest.prepaymenthistplantedareauom AS PrepaymentHistPlantedAreaUoM,
  PrepaymentHarvest.prepaymentharvestproductivity AS PrepaymentHarvestProductivity,
  PrepaymentHarvest.prepaymentharvestlastproduct AS PrepaymentHarvestLastProduct,
  PrepaymentHarvest.prepaymentharvestsalesqty AS PrepaymentHarvestSalesQty,
  PrepaymentHarvest.prepaymentharvestsalesuom AS PrepaymentHarvestSalesUoM,
  PrepaymentHarvest.prepaymentharvestobservations AS PrepaymentHarvestObservations,
  _PrepayAgreement.PrepaymentAgreement AS PrepaymentAgreement,
  PrepaymentHarvest.creationdatetime AS CreationDateTime,
  PrepaymentHarvest.lastchangedbyuser AS LastChangedByUser,
  PrepaymentHarvest.lastchangedatetime AS LastChangeDateTime
FROM ppmgag_t_harv AS PrepaymentHarvest
LEFT OUTER JOIN E_PrepaymentAgrmtHarvest AS _Extension ON PrepaymentAgreementUUID = _Extension.PrepaymentAgrmtHarvestUUID  -- association [0..1]
;

Learn More