C_PrepaymentAgrmtCommlRefTP

DDL: C_PREPAYMENTAGRMTCOMMLREFTP SQL: CPPMGCOMMLREFTP Type: view CONSUMPTION
20 Fields 1 Data Sources 5 Associations

Prepayment Agrmt Comml Ref Details

C_PrepaymentAgrmtCommlRefTP is a Consumption CDS View that provides data about "Prepayment Agrmt Comml Ref Details" in SAP S/4HANA. It reads from 1 data source (I_PrepaymentAgrmtCommlRefTP) and exposes 20 fields with key field PrepaymentCommlRefUUID. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_PrepaymentAgrmtCommlRefTP PrepaymentAgrmntCommercialRef from

Associations (5)

CardinalityTargetAliasCondition
[1..1] C_PrepaymentAgreementTP _PrepaymentAgreement $projection.PrepaymentAgreementUUID = _PrepaymentAgreement.PrepaymentAgreementUUID -- Extension View for Reference in Prepayment
[0..1] E_PrepaymentAgrmtReference _Extension $projection.PrepaymentCommlRefUUID = _Extension.PrepaymentCommlRefUUID ---
[0..1] I_PrepaymentRefDivisionVH _DivisionText $projection.PrepaymentCommlRefDivision = _DivisionText.PrepaymentAgrmtDomainCode and _DivisionText.Language = $session.system_language ---
[0..1] I_PrepaymentRefJobTitleVH _JobTitle $projection.PrepaymentCommlRefCurJobTitle = _JobTitle.PrepaymentAgrmtDomainCode ---
[0..*] I_CityCode _CityText $projection.PrepaymentCommlRefCity = _CityText.CityCode

Annotations (19)

NameValueLevelField
AbapCatalog.sqlViewName CPPMGCOMMLREFTP 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 Agrmt Comml Ref Details view
VDM.viewType #CONSUMPTION view
Search.searchable true 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 PrepaymentCommlRefUUID I_PrepaymentAgrmtCommlRefTP PrepaymentCommlRefUUID Key
PrepaymentAgreementUUID I_PrepaymentAgrmtCommlRefTP PrepaymentAgreementUUID Key
PrepaymentCommercialReference I_PrepaymentAgrmtCommlRefTP PrepaymentCommercialReference Commercial Ref Type
PrepaymentCommlRefName I_PrepaymentAgrmtCommlRefTP PrepaymentCommlRefName Commercial Ref Name
PrepaymentRefContactPersonName I_PrepaymentAgrmtCommlRefTP PrepaymentRefContactPersonName Commercial Ref Name
PrepaymentCommlRefCurJobTitle I_PrepaymentAgrmtCommlRefTP PrepaymentCommlRefCurJobTitle Current Job Title
PrepaymentCommlRefSegment I_PrepaymentAgrmtCommlRefTP PrepaymentCommlRefSegment Comml Ref Segment
PrepaymentCommlRefIndstryFunc I_PrepaymentAgrmtCommlRefTP PrepaymentCommlRefIndstryFunc Industry Function
PrepaymentCommlRefCity I_PrepaymentAgrmtCommlRefTP PrepaymentCommlRefCity Reference City
PrepaymentCommlRefContNumber I_PrepaymentAgrmtCommlRefTP PrepaymentCommlRefContNumber Commercial Ref No.
PrepaymentCommlRefContEmail I_PrepaymentAgrmtCommlRefTP PrepaymentCommlRefContEmail CommRef Email
PrepaymentCommlRefDivision I_PrepaymentAgrmtCommlRefTP PrepaymentCommlRefDivision Division
CountryCode _PrepaymentAgreement CountryCode Country/Reg.
CompanyCode _PrepaymentAgreement CompanyCode Receiver Company Code
PrepaymentAgreementType _PrepaymentAgreement PrepaymentAgreementType Prepay Agreemnt Type
PrepaymentAgreementCategory _PrepaymentAgreement PrepaymentAgreementCategory Prepayment Category
Associations_PrepaymentAgreement
_JobTitle _JobTitle
_CityText _CityText
_DivisionText _DivisionText

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_PrepaymentAgrmtCommlRefTP.
-- 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: CPPMGCOMMLREFTP

CREATE VIEW C_PrepaymentAgrmtCommlRefTP AS
SELECT
  PrepaymentAgrmntCommercialRef.PrepaymentCommlRefUUID AS PrepaymentCommlRefUUID,
  PrepaymentAgrmntCommercialRef.PrepaymentAgreementUUID AS PrepaymentAgreementUUID,
  PrepaymentAgrmntCommercialRef.PrepaymentCommercialReference AS PrepaymentCommercialReference,
  PrepaymentAgrmntCommercialRef.PrepaymentCommlRefName AS PrepaymentCommlRefName,
  PrepaymentAgrmntCommercialRef.PrepaymentRefContactPersonName AS PrepaymentRefContactPersonName,
  PrepaymentAgrmntCommercialRef.PrepaymentCommlRefCurJobTitle AS PrepaymentCommlRefCurJobTitle,
  PrepaymentAgrmntCommercialRef.PrepaymentCommlRefSegment AS PrepaymentCommlRefSegment,
  PrepaymentAgrmntCommercialRef.PrepaymentCommlRefIndstryFunc AS PrepaymentCommlRefIndstryFunc,
  PrepaymentAgrmntCommercialRef.PrepaymentCommlRefCity AS PrepaymentCommlRefCity,
  PrepaymentAgrmntCommercialRef.PrepaymentCommlRefContNumber AS PrepaymentCommlRefContNumber,
  PrepaymentAgrmntCommercialRef.PrepaymentCommlRefContEmail AS PrepaymentCommlRefContEmail,
  PrepaymentAgrmntCommercialRef.PrepaymentCommlRefDivision AS PrepaymentCommlRefDivision,
  _PrepaymentAgreement.CountryCode AS CountryCode,
  _PrepaymentAgreement.CompanyCode AS CompanyCode,
  _PrepaymentAgreement.PrepaymentAgreementType AS PrepaymentAgreementType,
  _PrepaymentAgreement.PrepaymentAgreementCategory AS PrepaymentAgreementCategory
FROM I_PrepaymentAgrmtCommlRefTP AS PrepaymentAgrmntCommercialRef
LEFT OUTER JOIN C_PrepaymentAgreementTP AS _PrepaymentAgreement ON PrepaymentAgreementUUID = _PrepaymentAgreement.PrepaymentAgreementUUID  -- association [1..1]
LEFT OUTER JOIN E_PrepaymentAgrmtReference AS _Extension ON PrepaymentCommlRefUUID = _Extension.PrepaymentCommlRefUUID  -- association [0..1]
LEFT OUTER JOIN I_PrepaymentRefDivisionVH AS _DivisionText ON PrepaymentCommlRefDivision = _DivisionText.PrepaymentAgrmtDomainCode AND _DivisionText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_PrepaymentRefJobTitleVH AS _JobTitle ON PrepaymentCommlRefCurJobTitle = _JobTitle.PrepaymentAgrmtDomainCode  -- association [0..1]
LEFT OUTER JOIN I_CityCode AS _CityText ON PrepaymentCommlRefCity = _CityText.CityCode  -- association [0..*]
;

Learn More