I_ContractTransientField

DDL: I_CONTRACTTRANSIENTFIELD SQL: IPURCTRTRANS Type: view COMPOSITE
30 Fields 1 Data Sources

I View For Transient Fields in Contracts

I_ContractTransientField is a Composite CDS View that provides data about "I View For Transient Fields in Contracts" in SAP S/4HANA. It reads from 1 data source (P_Contractmaintain_Trans) and exposes 30 fields with key field PurchaseContract.

Data Sources (1)

SourceAliasJoin Type
P_Contractmaintain_Trans P_Contractmaintain_Trans from

Annotations (9)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName IPURCTRTRANS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #COMPOSITE view
EndUserText.label I View For Transient Fields in Contracts view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY PurchaseContract PurchaseContract Purchasing Doc.
PurchaseContractType PurchaseContractType Order Type
PurchaseContractClassification PurchaseContractClassification
PurchaseContractConsumedAmount PurchaseContractConsumedAmount
SupplierOperationalScore SupplierOperationalScore Operational Score
SuplrEvalOplScrInDcmlVal SuplrEvalOplScrInDcmlVal
ContractExpiryPredictedDate ContractExpiryPredictedDate Predicted Expry Date
NumberOfDays NumberOfDays Number of Days
IsExpired IsExpired Indicator
PurContrOutputCtrlType PurContrOutputCtrlType Output Control Type
PurContrOutputCtrlStatus PurContrOutputCtrlStatus Output Control Statu
PurContrOutputCtrlStatusTxt PurContrOutputCtrlStatusTxt OC Status Text
PurContrOutputCtrlDateTime PurContrOutputCtrlDateTime Output Control Time
WeightedRelevance WeightedRelevance Weighted Relevance
ContractConsumptionInPct ContractConsumptionInPct Consumption Pct
PurContractCnsmpnInPctValue ContractConsumptionInPct Consumption Pct
PurContrCnsmpnCriticality PurContrCnsmpnCriticality Val. Status Critic.
AccWorkflowApprover AccWorkflowApprover User
AccWorkflowApproverFirstName AccWorkflowApproverFirstName Full Name
ApprovalStatusName ApprovalStatusName Short Description
ApproverUser ApproverUser Approver
WorkflowApproverNote WorkflowApproverNote
IsContrRefOfPurReqn IsContrRefOfPurReqn TRUE
IsPurContrTemplate IsPurContrTemplate Is Contract Template
ChangeRecordReferenceUUID ChangeRecordReferenceUUID UUID
PurgContractIsInPreparation PurgContractIsInPreparation Boolean Variable (X = True, - = False, Space = Unknown)
PurchasingDocumentStatus PurchasingDocumentStatus Short Description
PurContrHasAdvncdUsrInterface PurContrHasAdvncdUsrInterface Boolean Variable (X = True, - = False, Space = Unknown)
PurchasingIsBlocked PurchasingIsBlocked Purch. block
ActivePurchasingDocument ActivePurchasingDocument Active Purchase Doc

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_ContractTransientField.
-- 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: IPURCTRTRANS

CREATE VIEW I_ContractTransientField AS
SELECT
  PurchaseContract,
  PurchaseContractType,
  PurchaseContractClassification,
  PurchaseContractConsumedAmount,
  SupplierOperationalScore,
  SuplrEvalOplScrInDcmlVal,
  ContractExpiryPredictedDate,
  NumberOfDays,
  IsExpired,
  PurContrOutputCtrlType,
  PurContrOutputCtrlStatus,
  PurContrOutputCtrlStatusTxt,
  PurContrOutputCtrlDateTime,
  WeightedRelevance,
  ContractConsumptionInPct,
  ContractConsumptionInPct AS PurContractCnsmpnInPctValue,
  PurContrCnsmpnCriticality,
  AccWorkflowApprover,
  AccWorkflowApproverFirstName,
  ApprovalStatusName,
  ApproverUser,
  WorkflowApproverNote,
  IsContrRefOfPurReqn,
  IsPurContrTemplate,
  ChangeRecordReferenceUUID,
  PurgContractIsInPreparation,
  PurchasingDocumentStatus,
  PurContrHasAdvncdUsrInterface,
  PurchasingIsBlocked,
  ActivePurchasingDocument
FROM P_Contractmaintain_Trans
;

Learn More