C_PrepaymentRenegttnHarvestTP

DDL: C_PREPAYMENTRENEGTTNHARVESTTP SQL: CPPMGREGHRVST Type: view CONSUMPTION
19 Fields 1 Data Sources 3 Associations

Prepayment Agreement Harvest

C_PrepaymentRenegttnHarvestTP is a Consumption CDS View that provides data about "Prepayment Agreement Harvest" in SAP S/4HANA. It reads from 1 data source (I_PrepaymentAgrmtHarvestTP) and exposes 19 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_PreRenegotiationTP _PrepaymentRenegotiation $projection.PrepaymentAgreementUUID = _PrepaymentRenegotiation.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.PrepaymentAgreementCommodity = _CmmdtyType.Commodity

Annotations (18)

NameValueLevelField
AbapCatalog.sqlViewName CPPMGREGHRVST 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 Agreement Harvest 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 (19)

KeyFieldSource TableSource FieldDescription
KEY PrepaymentAgrmtHarvestUUID I_PrepaymentAgrmtHarvestTP PrepaymentAgrmtHarvestUUID Key
PrepaymentAgreementUUID I_PrepaymentAgrmtHarvestTP PrepaymentAgreementUUID Key
PrepaymentAgrmtHarvestYear I_PrepaymentAgrmtHarvestTP PrepaymentAgrmtHarvestYear Harvest Year
PrepaymentAgreementCommodity 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 _PrepaymentRenegotiation CompanyCode Receiver Company Code
PrepaymentAgreementType _PrepaymentRenegotiation PrepaymentAgreementType Prepay Agreemnt Type
CreatedByUser
CreationDateTime I_PrepaymentAgrmtHarvestTP CreationDateTime Timestamp
LastChangedByUser I_PrepaymentAgrmtHarvestTP LastChangedByUser User Name
LastChangeDateTime I_PrepaymentAgrmtHarvestTP LastChangeDateTime Timestamp
Associations_PrepaymentRenegotiation
_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_PrepaymentRenegttnHarvestTP.
-- 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: CPPMGREGHRVST

CREATE VIEW C_PrepaymentRenegttnHarvestTP 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,
  _PrepaymentRenegotiation.CompanyCode AS CompanyCode,
  _PrepaymentRenegotiation.PrepaymentAgreementType AS PrepaymentAgreementType,
  PrepaymentHarvest.CreationDateTime AS CreationDateTime,
  PrepaymentHarvest.LastChangedByUser AS LastChangedByUser,
  PrepaymentHarvest.LastChangeDateTime AS LastChangeDateTime
FROM I_PrepaymentAgrmtHarvestTP AS PrepaymentHarvest
LEFT OUTER JOIN C_PreRenegotiationTP AS _PrepaymentRenegotiation ON PrepaymentAgreementUUID = _PrepaymentRenegotiation.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 PrepaymentAgreementCommodity = _CmmdtyType.Commodity  -- association [0..*]
;

Learn More