I_SrcgProjItmCndnAmountTP

DDL: I_SRCGPROJITMCNDNAMOUNTTP Type: view_entity TRANSACTIONAL
16 Fields 1 Data Sources

Payment Terms for Srcg Proj Item - TP

I_SrcgProjItmCndnAmountTP is a Transactional CDS View that provides data about "Payment Terms for Srcg Proj Item - TP" in SAP S/4HANA. It reads from 1 data source (R_SrcgProjItmCndnAmountTP) and exposes 16 fields with key field SrcgProjItemCndnAmountUUID.

Data Sources (1)

SourceAliasJoin Type
R_SrcgProjItmCndnAmountTP R_SrcgProjItmCndnAmountTP projection

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.representativeKey SrcgProjItemCndnAmountUUID view
ObjectModel.modelingPattern #TRANSACTIONAL_INTERFACE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
EndUserText.label Payment Terms for Srcg Proj Item - TP view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY SrcgProjItemCndnAmountUUID SrcgProjItemCndnAmountUUID Srcg Proj Item Condition Amount UUID
SourcingProjectUUID SourcingProjectUUID Sourcing Project UUID
SrcgProjItemCndnValdtyUUID SrcgProjItemCndnValdtyUUID Srcg Proj Item Condition Validity UUID
ConditionType ConditionType Condition type
SrcgProjItemCndnIsMand SrcgProjItemCndnIsMand Condition is Mandatory
SrcgProjItemCndnIsExcld SrcgProjItemCndnIsExcld Condition is Excluded
SrcgProjPricingScaleBasis SrcgProjPricingScaleBasis Scale Base Type
ConditionRecord ConditionRecord Cond.Record No.
ConditionQuantity ConditionQuantity Pricing Unit
ConditionQuantityUnit ConditionQuantityUnit Unit of Measure
ConditionSequentialNumberShort ConditionSequentialNumberShort Sequent. No. of Cond
ConditionValidityStartDate ConditionValidityStartDate Valid From
ConditionValidityEndDate ConditionValidityEndDate Valid To
CmmdtyPricingEngineIsEnabled CmmdtyPricingEngineIsEnabled Enabled for CPE
SourcingOrigin SourcingOrigin Sourcing Origin
SourcingScenario SourcingScenario Integration Scenario

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_SrcgProjItmCndnAmountTP.
-- 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.

CREATE VIEW I_SrcgProjItmCndnAmountTP AS
SELECT
  SrcgProjItemCndnAmountUUID,
  SourcingProjectUUID,
  SrcgProjItemCndnValdtyUUID,
  ConditionType,
  SrcgProjItemCndnIsMand,
  SrcgProjItemCndnIsExcld,
  SrcgProjPricingScaleBasis,
  ConditionRecord,
  ConditionQuantity,
  ConditionQuantityUnit,
  ConditionSequentialNumberShort,
  ConditionValidityStartDate,
  ConditionValidityEndDate,
  CmmdtyPricingEngineIsEnabled,
  SourcingOrigin,
  SourcingScenario
FROM R_SrcgProjItmCndnAmountTP
;

Learn More