C_Activepurchasecontract

DDL: C_ACTIVEPURCHASECONTRACT SQL: CACTPURCTR Type: view CONSUMPTION
15 Fields 1 Data Sources 1 Associations

Consumption view for active purchase contract

C_Activepurchasecontract is a Consumption CDS View that provides data about "Consumption view for active purchase contract" in SAP S/4HANA. It reads from 1 data source (I_Activepurchasecontract) and exposes 15 fields with key field PurchaseContract. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_Activepurchasecontract I_Activepurchasecontract from

Associations (1)

CardinalityTargetAliasCondition
[0..*] C_Activepurchasecontractitem _Activepurchasecontractitem $projection.PurchaseContract = _Activepurchasecontractitem.PurchaseContract

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CACTPURCTR view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Consumption view for active purchase contract view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY PurchaseContract I_Activepurchasecontract PurchaseContract Purchasing Doc.
PurchasingDocumentTypeName I_Activepurchasecontract PurchasingDocumentTypeName Description
ValidityStartDateendasValidityStartDate
ValidityEndDateendasValidityEndDate
IsEndOfPurposeBlocked IsEndOfPurposeBlocked Busin. Purp. Cmpltd.
PurContrConsumedVal I_Activepurchasecontract PurchaseContractConsumedAmount
DocumentCurrency I_Activepurchasecontract DocumentCurrency Document Currency
PurchaseContractTargetAmount I_Activepurchasecontract PurchaseContractTargetAmount Target Value
PurchaseContractClassification I_Activepurchasecontract PurchaseContractClassification
PurchaseContractType I_Activepurchasecontract PurchaseContractType Order Type
PurchasingGroup I_Activepurchasecontract PurchasingGroup Purchasing Group
PurchasingOrganization I_Activepurchasecontract PurchasingOrganization Purchasing Organization
ReleaseIsNotCompleted I_Activepurchasecontract ReleaseIsNotCompleted Subj.to Release
PurchasingProcessingStatus I_Activepurchasecontract PurchasingProcessingStatus Proc. State
_Activepurchasecontractitem _Activepurchasecontractitem

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_Activepurchasecontract.
-- 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: CACTPURCTR

CREATE VIEW C_Activepurchasecontract AS
SELECT
  I_Activepurchasecontract.PurchaseContract AS PurchaseContract,
  I_Activepurchasecontract.PurchasingDocumentTypeName AS PurchasingDocumentTypeName,
  case when I_Activepurchasecontract.ValidityStartDate = '' then '19700101' when I_Activepurchasecontract.ValidityStartDate = '00000000' then '19700101' else I_Activepurchasecontract.ValidityStartDate end as ValidityStartDate AS ValidityStartDateendasValidityStartDate,
  case when I_Activepurchasecontract.ValidityEndDate = '' then '99991231' when I_Activepurchasecontract.ValidityEndDate = '00000000' then '99991231' else I_Activepurchasecontract.ValidityEndDate end as ValidityEndDate AS ValidityEndDateendasValidityEndDate,
  IsEndOfPurposeBlocked,
  I_Activepurchasecontract.PurchaseContractConsumedAmount AS PurContrConsumedVal,
  I_Activepurchasecontract.DocumentCurrency AS DocumentCurrency,
  I_Activepurchasecontract.PurchaseContractTargetAmount AS PurchaseContractTargetAmount,
  I_Activepurchasecontract.PurchaseContractClassification AS PurchaseContractClassification,
  I_Activepurchasecontract.PurchaseContractType AS PurchaseContractType,
  I_Activepurchasecontract.PurchasingGroup AS PurchasingGroup,
  I_Activepurchasecontract.PurchasingOrganization AS PurchasingOrganization,
  I_Activepurchasecontract.ReleaseIsNotCompleted AS ReleaseIsNotCompleted,
  I_Activepurchasecontract.PurchasingProcessingStatus AS PurchasingProcessingStatus
FROM I_Activepurchasecontract
LEFT OUTER JOIN C_Activepurchasecontractitem AS _Activepurchasecontractitem ON PurchaseContract = _Activepurchasecontractitem.PurchaseContract  -- association [0..*]
;

Learn More