C_PrepaymentHistoryProdTP

DDL: C_PREPAYMENTHISTORYPRODTP SQL: CPPMPRDHISTP Type: view CONSUMPTION
20 Fields 1 Data Sources 3 Associations

Prepayment Histroy consumtion view

C_PrepaymentHistoryProdTP is a Consumption CDS View that provides data about "Prepayment Histroy consumtion view" in SAP S/4HANA. It reads from 1 data source (I_PrepaymentHistoryProdTP) and exposes 20 fields with key field PrepaymentHistoryProdUUID. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_PrepaymentHistoryProdTP ProductionHistory from

Associations (3)

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

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName CPPMPRDHISTP 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 #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Prepayment Histroy consumtion view view
VDM.viewType #CONSUMPTION view
ObjectModel.transactionalProcessingDelegated 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 #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY PrepaymentHistoryProdUUID I_PrepaymentHistoryProdTP PrepaymentHistoryProdUUID Key
PrepaymentAgreementUUID I_PrepaymentHistoryProdTP PrepaymentAgreementUUID Key
PrepaymentAgrmtHarvestYear I_PrepaymentHistoryProdTP PrepaymentAgrmtHarvestYear Harvest Year
PrepaymentAgreementCrop I_PrepaymentHistoryProdTP PrepaymentAgreementCommodity Commodity
PrepaymentHistPlantedAreaQty I_PrepaymentHistoryProdTP PrepaymentHistPlantedAreaQty Quantity
PrepaymentHistPlantedAreaUoM I_PrepaymentHistoryProdTP PrepaymentHistPlantedAreaUoM Harvest Area UoM
PrepaymentHistAvgProdQty I_PrepaymentHistoryProdTP PrepaymentHistAvgProdQty Avg Prodn Quantity
PrepaymentHistAvgProdUoM I_PrepaymentHistoryProdTP PrepaymentHistAvgProdUoM Base Unit
PrepaymentHistTotProductionQty I_PrepaymentHistoryProdTP PrepaymentHistTotProductionQty Total Productn Qnty
PrepaymentHistTotProductionUoM I_PrepaymentHistoryProdTP PrepaymentHistTotProductionUoM Base Unit
PrepaymentHistoryCommentText I_PrepaymentHistoryProdTP PrepaymentHistoryCommentText History Comment Text
CompanyCode _PrepaymentAgreement CompanyCode Receiver Company Code
PrepaymentAgreementType _PrepaymentAgreement PrepaymentAgreementType Prepay Agreemnt Type
PrepaymentAgreementCategory _PrepaymentAgreement PrepaymentAgreementCategory Prepayment Category
CreatedByUserasCreatedByUser
CreationDateTime I_PrepaymentHistoryProdTP CreationDateTime Timestamp
LastChangedByUser I_PrepaymentHistoryProdTP LastChangedByUser User Name
LastChangeDateTime I_PrepaymentHistoryProdTP 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_PrepaymentHistoryProdTP.
-- 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: CPPMPRDHISTP

CREATE VIEW C_PrepaymentHistoryProdTP AS
SELECT
  ProductionHistory.PrepaymentHistoryProdUUID AS PrepaymentHistoryProdUUID,
  ProductionHistory.PrepaymentAgreementUUID AS PrepaymentAgreementUUID,
  ProductionHistory.PrepaymentAgrmtHarvestYear AS PrepaymentAgrmtHarvestYear,
  ProductionHistory.PrepaymentAgreementCommodity AS PrepaymentAgreementCrop,
  ProductionHistory.PrepaymentHistPlantedAreaQty AS PrepaymentHistPlantedAreaQty,
  ProductionHistory.PrepaymentHistPlantedAreaUoM AS PrepaymentHistPlantedAreaUoM,
  ProductionHistory.PrepaymentHistAvgProdQty AS PrepaymentHistAvgProdQty,
  ProductionHistory.PrepaymentHistAvgProdUoM AS PrepaymentHistAvgProdUoM,
  ProductionHistory.PrepaymentHistTotProductionQty AS PrepaymentHistTotProductionQty,
  ProductionHistory.PrepaymentHistTotProductionUoM AS PrepaymentHistTotProductionUoM,
  ProductionHistory.PrepaymentHistoryCommentText AS PrepaymentHistoryCommentText,
  _PrepaymentAgreement.CompanyCode AS CompanyCode,
  _PrepaymentAgreement.PrepaymentAgreementType AS PrepaymentAgreementType,
  _PrepaymentAgreement.PrepaymentAgreementCategory AS PrepaymentAgreementCategory,
  ProductionHistory.CreationDateTime AS CreationDateTime,
  ProductionHistory.LastChangedByUser AS LastChangedByUser,
  ProductionHistory.LastChangeDateTime AS LastChangeDateTime
FROM I_PrepaymentHistoryProdTP AS ProductionHistory
LEFT OUTER JOIN C_PrepaymentAgreementTP AS _PrepaymentAgreement ON PrepaymentAgreementUUID = _PrepaymentAgreement.PrepaymentAgreementUUID  -- association [1..1]
LEFT OUTER JOIN E_PrepaymentHistoryProd AS _Extension ON PrepaymentHistoryProdUUID = _Extension.PrepaymentHistoryProdUUID  -- association [0..1]
LEFT OUTER JOIN I_CmmdtyText AS _CmmdtyType ON PrepaymentAgreementCrop = _CmmdtyType.Commodity  -- association [0..*]
;

Learn More