C_PrepaymentAgrmtHarvestTP

DDL: C_PREPAYMENTAGRMTHARVESTTP SQL: CPPAGMTPSTHRVST Type: view CONSUMPTION
20 Fields 1 Data Sources 3 Associations

Prepayment Harvest Consumtion View

C_PrepaymentAgrmtHarvestTP is a Consumption CDS View that provides data about "Prepayment Harvest Consumtion View" in SAP S/4HANA. It reads from 1 data source (I_PrepaymentAgrmtHarvestTP) and exposes 20 fields with key field PrepaymentAgrmtHarvestUUID. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_PrepaymentAgrmtHarvestTP PrepaymentHarvest from

Associations (3)

CardinalityTargetAliasCondition
[1..1] C_PrepaymentAgreementTP _PrepaymentAgreement $projection.PrepaymentAgreementUUID = _PrepaymentAgreement.PrepaymentAgreementUUID -- Extension View for Prepayment Agreement Sales History in Prepayment
[0..1] E_PrepaymentAgrmtHarvest _Extension $projection.PrepaymentAgrmtHarvestUUID = _Extension.PrepaymentAgrmtHarvestUUID --Commodity Type
[0..*] I_CmmdtyText _CmmdtyType $projection.PrepaymentAgreementCrop = _CmmdtyType.Commodity

Annotations (18)

NameValueLevelField
AbapCatalog.sqlViewName CPPAGMTPSTHRVST view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
Metadata.allowExtensions true view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Prepayment Harvest Consumtion View view
VDM.viewType #CONSUMPTION view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.draftEnabled true view
ObjectModel.createEnabled EXTERNAL_CALCULATION view
ObjectModel.updateEnabled EXTERNAL_CALCULATION view
ObjectModel.deleteEnabled EXTERNAL_CALCULATION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY PrepaymentAgrmtHarvestUUID I_PrepaymentAgrmtHarvestTP PrepaymentAgrmtHarvestUUID Key
PrepaymentAgreementUUID I_PrepaymentAgrmtHarvestTP PrepaymentAgreementUUID Key
PrepaymentAgrmtHarvestYear I_PrepaymentAgrmtHarvestTP PrepaymentAgrmtHarvestYear Harvest Year
PrepaymentAgreementCrop I_PrepaymentAgrmtHarvestTP PrepaymentAgreementCommodity Commodity
PrepaymentHarvestTotalAreaQty I_PrepaymentAgrmtHarvestTP PrepaymentHarvestTotalAreaQty Prepmt Harv Area
PrepaymentHistPlantedAreaUoM I_PrepaymentAgrmtHarvestTP PrepaymentHistPlantedAreaUoM Harvest Area UoM
PrepaymentHarvestProductivity I_PrepaymentAgrmtHarvestTP PrepaymentHarvestProductivity Prepmt Harv Prdctvty
PrepaymentHarvestLastProduct I_PrepaymentAgrmtHarvestTP PrepaymentHarvestLastProduct Prepmt Harv Last Prd
PrepaymentHarvestSalesQty I_PrepaymentAgrmtHarvestTP PrepaymentHarvestSalesQty Prepmt Harv Sale Qty
PrepaymentHarvestSalesUoM I_PrepaymentAgrmtHarvestTP PrepaymentHarvestSalesUoM Total Sales Area UoM
PrepaymentHarvestObservations I_PrepaymentAgrmtHarvestTP PrepaymentHarvestObservations Prepmt Harvest Obsvn
CompanyCode _PrepaymentAgreement CompanyCode Receiver Company Code
PrepaymentAgreementType _PrepaymentAgreement PrepaymentAgreementType Prepay Agreemnt Type
PrepaymentAgreementCategory _PrepaymentAgreement PrepaymentAgreementCategory Prepayment Category
CreatedByUser
CreationDateTime I_PrepaymentAgrmtHarvestTP CreationDateTime Timestamp
LastChangedByUser I_PrepaymentAgrmtHarvestTP LastChangedByUser User Name
LastChangeDateTime I_PrepaymentAgrmtHarvestTP LastChangeDateTime Timestamp
Associations_PrepaymentAgreement
_CmmdtyType _CmmdtyType

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_PrepaymentAgrmtHarvestTP.
-- 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: CPPAGMTPSTHRVST

CREATE VIEW C_PrepaymentAgrmtHarvestTP AS
SELECT
  PrepaymentHarvest.PrepaymentAgrmtHarvestUUID AS PrepaymentAgrmtHarvestUUID,
  PrepaymentHarvest.PrepaymentAgreementUUID AS PrepaymentAgreementUUID,
  PrepaymentHarvest.PrepaymentAgrmtHarvestYear AS PrepaymentAgrmtHarvestYear,
  PrepaymentHarvest.PrepaymentAgreementCommodity AS PrepaymentAgreementCrop,
  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,
  _PrepaymentAgreement.CompanyCode AS CompanyCode,
  _PrepaymentAgreement.PrepaymentAgreementType AS PrepaymentAgreementType,
  _PrepaymentAgreement.PrepaymentAgreementCategory AS PrepaymentAgreementCategory,
  PrepaymentHarvest.CreationDateTime AS CreationDateTime,
  PrepaymentHarvest.LastChangedByUser AS LastChangedByUser,
  PrepaymentHarvest.LastChangeDateTime AS LastChangeDateTime
FROM I_PrepaymentAgrmtHarvestTP AS PrepaymentHarvest
LEFT OUTER JOIN C_PrepaymentAgreementTP AS _PrepaymentAgreement ON PrepaymentAgreementUUID = _PrepaymentAgreement.PrepaymentAgreementUUID  -- association [1..1]
LEFT OUTER JOIN E_PrepaymentAgrmtHarvest AS _Extension ON PrepaymentAgrmtHarvestUUID = _Extension.PrepaymentAgrmtHarvestUUID  -- association [0..1]
LEFT OUTER JOIN I_CmmdtyText AS _CmmdtyType ON PrepaymentAgreementCrop = _CmmdtyType.Commodity  -- association [0..*]
;

Learn More