C_PurCntrlContrMassUpdt

DDL: C_PURCNTRLCONTRMASSUPDT SQL: CCNTRLCTRMASS Type: view CONSUMPTION
60 Fields 1 Data Sources 5 Associations

Mass Changes to Central Contracts

C_PurCntrlContrMassUpdt is a Consumption CDS View that provides data about "Mass Changes to Central Contracts" in SAP S/4HANA. It reads from 1 data source (I_CentralPurchaseContract) and exposes 60 fields with key field CentralPurchaseContract. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_CentralPurchaseContract I_CentralPurchaseContract from

Associations (5)

CardinalityTargetAliasCondition
[0..1] C_CntrlPurContrTypeValueHelp _CntrlPurContrTypeValueHelp $projection.PurchaseContractType = _CntrlPurContrTypeValueHelp.PurchasingDocumentType
[0..1] I_IncotermsVersionText _IncotermVersionText $projection.IncotermsVersion = _IncotermVersionText.IncotermsVersion and _IncotermVersionText.Language = $session.system_language
[1..1] C_CentralPurchaseContractTP _CentralPurchaseContractTP $projection.CentralPurchaseContract = _CentralPurchaseContractTP.CentralPurchaseContract
[0..1] C_PurgDocVersionReasonValHelp _VersionReasonVH $projection.PurchasingDocVersionReasonCode = _VersionReasonVH.PurchasingDocVersionReasonCode
[0..1] P_SGBT_NTE_CDS_APITP _PurchaseNote $projection.CentralPurchaseContract = _PurchaseNote.ObjectID and _PurchaseNote.ObjectNodeType = 'CentralPurchaseContract' and _PurchaseNote.NoteType = 'CH16' and _PurchaseNote.LanguageCode = $session.system_language --Extension

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName CCNTRLCTRMASS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Mass Changes to Central Contracts view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #NONE view
UI.headerInfo.typeName Central Purchase Contract header view
UI.headerInfo.typeNamePlural Central Purchase Contract headers view

Fields (60)

KeyFieldSource TableSource FieldDescription
KEY CentralPurchaseContract CentralPurchaseContract Central Contract
ActivePurchasingDocument ActivePurchasingDocument Central Contract
PurchaseContractType PurchaseContractType Contract Type
PurchasingDocumentTypeName _CntrlPurContrTypeValueHelp PurchasingDocumentTypeName Description
PurchasingOrganization PurchasingOrganization Central Purchasing Organization
PurchasingOrganizationName _PurchasingOrganization PurchasingOrganizationName Purch. Org. Name
PurchasingGroup PurchasingGroup Central Purchasing Group
PurchasingGroupName _PurchasingGroup PurchasingGroupName Purchasing Grp. Name
CompanyCode CompanyCode Central Company Code
CompanyCodeName _CompanyCode CompanyCodeName Company Name
Supplier Supplier Supplier
SupplierName _Supplier SupplierName Supplier Name
ValidityStartDate ValidityStartDate Valid From
ValidityEndDate ValidityEndDate Valid To
PurchaseContractTargetAmount PurchaseContractTargetAmount Target Value
Currency Currency Currency
CurrencyName
CntrlPurContrOvrlDistrStsTxt _CentralPurchaseContractTP PurchasingProcessingStatus Proc. State
PurchasingProcessingStatus _CentralPurchaseContractTP CntrlPurContrOvrlDistrStsTxt Distribution Status
ItemDistributionStatusName _CentralPurchaseContractTP ItemDistributionStatusName Distribution Status
DocumentStatusName
PurchasingDocumentStatus _CentralPurchaseContractTP PurchasingProcessingStatus Status
CreatedByUser CreatedByUser Created By
UserDescription _CreatedByUser UserDescription Created By
CreationDate CreationDate Created On
IsEndOfPurposeBlocked IsEndOfPurposeBlocked Business Purpose Completed
PaymentTerms PaymentTerms Payment Terms
PaymentTermsName
CashDiscount1Days CashDiscount1Days First Payment in Days
CashDiscount1Percent CashDiscount1Percent Discount for First Payment in %
CashDiscount2Days CashDiscount2Days Second Payment in Days
CashDiscount2Percent CashDiscount2Percent Discount for Second Payment in %
NetPaymentDays NetPaymentDays Cash Discount Days
IncotermsClassification IncotermsClassification Incoterm
IncotermsClassificationName
IncotermsLocation1 IncotermsLocation1 Incoterm Location 1
IncotermsLocation2 IncotermsLocation2 Incoterm Location 2
IncotermsVersion IncotermsVersion Incoterms Version
IncotermsVersionName _IncotermVersionText IncotermsVersionName
QuotationSubmissionDate QuotationSubmissionDate Quotation Date
SupplierQuotation SupplierQuotation Quotation
CorrespncExternalReference CorrespncExternalReference Your Reference
CorrespncInternalReference CorrespncInternalReference Our Reference
SupplierRespSalesPersonName SupplierRespSalesPersonName Salesperson
SupplierPhoneNumber SupplierPhoneNumber Telephone
ProductType
ProductTypeCode
MaterialGroup
Material
CntrlPurContrItmDistrPct
CntrlPurContrDistributionPct
ProcmtHubPurchasingOrg
ProcmtHubPurchasingGroup
ProcmtHubCompanyCode
Plant
ContrHdrIsCreated Is New
PurchasingDocumentDeletionCode PurchasingDocumentDeletionCode Del. Indicator
PurchasingDocVersionReasonCode PurchasingDocVersionReasonCode Reason for Change
PurchasingDocVersionReasonText _VersionReasonVH PurchasingDocVersionReasonText Reason Description
PurgDocNoteText _PurchaseNote Content Purchaser Note

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_PurCntrlContrMassUpdt.
-- 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: CCNTRLCTRMASS

CREATE VIEW C_PurCntrlContrMassUpdt AS
SELECT
  CentralPurchaseContract,
  ActivePurchasingDocument,
  PurchaseContractType,
  _CntrlPurContrTypeValueHelp.PurchasingDocumentTypeName AS PurchasingDocumentTypeName,
  PurchasingOrganization,
  _PurchasingOrganization.PurchasingOrganizationName AS PurchasingOrganizationName,
  PurchasingGroup,
  _PurchasingGroup.PurchasingGroupName AS PurchasingGroupName,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  Supplier,
  _Supplier.SupplierName AS SupplierName,
  ValidityStartDate,
  ValidityEndDate,
  PurchaseContractTargetAmount,
  Currency,
  _DocumentCurrency._Text[1: Language = $session.system_language ].CurrencyName AS CurrencyName,
  _CentralPurchaseContractTP.PurchasingProcessingStatus AS CntrlPurContrOvrlDistrStsTxt,
  _CentralPurchaseContractTP.CntrlPurContrOvrlDistrStsTxt AS PurchasingProcessingStatus,
  _CentralPurchaseContractTP.ItemDistributionStatusName AS ItemDistributionStatusName,
  _CentralPurchaseContractTP._CntrlPurContrStatusText.DocumentStatusName AS DocumentStatusName,
  _CentralPurchaseContractTP.PurchasingProcessingStatus AS PurchasingDocumentStatus,
  CreatedByUser,
  _CreatedByUser.UserDescription AS UserDescription,
  CreationDate,
  IsEndOfPurposeBlocked,
  PaymentTerms,
  _PaymentTerms._Text[1: Language = $session.system_language ].PaymentTermsName AS PaymentTermsName,
  CashDiscount1Days,
  CashDiscount1Percent,
  CashDiscount2Days,
  CashDiscount2Percent,
  NetPaymentDays,
  IncotermsClassification,
  _IncotermsClassification._Text[1: Language = $session.system_language ].IncotermsClassificationName AS IncotermsClassificationName,
  IncotermsLocation1,
  IncotermsLocation2,
  IncotermsVersion,
  _IncotermVersionText.IncotermsVersionName AS IncotermsVersionName,
  QuotationSubmissionDate,
  SupplierQuotation,
  CorrespncExternalReference,
  CorrespncInternalReference,
  SupplierRespSalesPersonName,
  SupplierPhoneNumber,
  cast ('' as producttype) AS ProductType,
  cast ('' as product_type) AS ProductTypeCode,
  cast ('' as matkl) AS MaterialGroup,
  cast ('' as matnr) AS Material,
  cast (0 as mm_purgdoc_distr_pct) AS CntrlPurContrItmDistrPct,
  cast (0 as mm_purgdoc_distr_pct ) AS CntrlPurContrDistributionPct,
  cast ('' as ekorg ) AS ProcmtHubPurchasingOrg,
  cast ('' as bkgrp ) AS ProcmtHubPurchasingGroup,
  cast ('' as bukrs) AS ProcmtHubCompanyCode,
  cast ('' as ewerk ) AS Plant,
  cast ('' as xfeld) AS ContrHdrIsCreated,
  PurchasingDocumentDeletionCode,
  PurchasingDocVersionReasonCode,
  _VersionReasonVH.PurchasingDocVersionReasonText AS PurchasingDocVersionReasonText,
  _PurchaseNote.Content AS PurgDocNoteText
FROM I_CentralPurchaseContract
LEFT OUTER JOIN C_CntrlPurContrTypeValueHelp AS _CntrlPurContrTypeValueHelp ON PurchaseContractType = _CntrlPurContrTypeValueHelp.PurchasingDocumentType  -- association [0..1]
LEFT OUTER JOIN I_IncotermsVersionText AS _IncotermVersionText ON IncotermsVersion = _IncotermVersionText.IncotermsVersion AND _IncotermVersionText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN C_CentralPurchaseContractTP AS _CentralPurchaseContractTP ON CentralPurchaseContract = _CentralPurchaseContractTP.CentralPurchaseContract  -- association [1..1]
LEFT OUTER JOIN C_PurgDocVersionReasonValHelp AS _VersionReasonVH ON PurchasingDocVersionReasonCode = _VersionReasonVH.PurchasingDocVersionReasonCode  -- association [0..1]
LEFT OUTER JOIN P_SGBT_NTE_CDS_APITP AS _PurchaseNote ON CentralPurchaseContract = _PurchaseNote.ObjectID AND _PurchaseNote.ObjectNodeType = 'CentralPurchaseContract' AND _PurchaseNote.NoteType = 'CH16' AND _PurchaseNote.LanguageCode = $session.system_language  -- association [0..1]
;

Learn More