A_CntrlPurContrHeaderDistr_2

DDL: A_CNTRLPURCONTRHEADERDISTR_2 Type: view_entity CONSUMPTION Package: ODATA_MM_PUR_CCTR_API
43 Fields 1 Data Sources 1 OData Services

CCTR Header Distribution

A_CntrlPurContrHeaderDistr_2 is a Consumption CDS View that provides data about "CCTR Header Distribution" in SAP S/4HANA. It reads from 1 data source (R_CntrlPurContrHdrDistrTP) and exposes 43 fields with key fields CentralPurchaseContract, DistributionKey. It is exposed through 1 OData service (API_CNTRLPURCONTRACT_2). Part of development package ODATA_MM_PUR_CCTR_API.

Data Sources (1)

SourceAliasJoin Type
R_CntrlPurContrHdrDistrTP R_CntrlPurContrHdrDistrTP projection

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label CCTR Header Distribution view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
VDM.viewType #CONSUMPTION view
ObjectModel.modelingPattern #TRANSACTIONAL_INTERFACE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
Metadata.ignorePropagatedAnnotations true view
OData.entityType.name CentralPurchaseContractHdrDistr_Type view

OData Services (1)

ServiceBindingVersionContractRelease
API_CNTRLPURCONTRACT_2 API_CNTRLPURCONTRACT_2 V4 C2 NOT_RELEASED

Fields (43)

KeyFieldSource TableSource FieldDescription
KEY CentralPurchaseContract CentralPurchaseContract Purchasing Doc.
KEY DistributionKey DistributionKey Distr. Number
PurchasingDocumentCategory PurchasingDocumentCategory Doc. Category
PurchasingDocumentType PurchasingDocumentType RFQ Type
PurchasingOrganization PurchasingOrganization Purchasing Organization
CompanyCode CompanyCode Receiver Company Code
Plant Plant Valuation Area
DocumentCurrency DocumentCurrency Document Currency
PurchasingGroup PurchasingGroup Purchasing Group
StorageLocation StorageLocation StorageLocation
PaymentTerms PaymentTerms Pyt Terms
CashDiscount1Days CashDiscount1Days Days from Baseline Date for Payment
CashDiscount2Days CashDiscount2Days Days from Baseline Date for Payment
NetPaymentDays NetPaymentDays Net Pmt Terms Period
CashDiscount1Percent CashDiscount1Percent Disc. Percent 1
CashDiscount2Percent CashDiscount2Percent Disc. Percent 2
CntrlPurContrDistributionPct CntrlPurContrDistributionPct
IsDeleted IsDeleted TRUE
OrderQuantityUnit OrderQuantityUnit Sales Unit
OrderQuantityUnitISOCode OrderQuantityUnitISOCode
ManualDeliveryAddressID ManualDeliveryAddressID Address Number
ProcmtHubDelivAddressTypeCode ProcmtHubDelivAddressTypeCode
ProcurementHubSourceSystem ProcurementHubSourceSystem Connected System ID
SourceListIsUpdated SourceListIsUpdated Sourcelist Updated
SourceListRestriction SourceListRestriction SrcListRstrcn
ProcmtHubCompanyCodeGroupingID ProcmtHubCompanyCodeGroupingID Grouping ID
IncotermsClassification IncotermsClassification Incoterms
IncotermsLocation1 IncotermsLocation1 Inco. Location1
ShippingInstruction ShippingInstruction Shipping Instr.
ProcmtHubSubcontractor ProcmtHubSubcontractor Supplier
ProcmtHubSuplrIsSubcontractor ProcmtHubSuplrIsSubcontractor SC Supplier
ReferenceDeliveryAddressID ReferenceDeliveryAddressID Reference Address
FormOfAddress FormOfAddress Title Key
ProcmtHubBusinessPartnerName1 ProcmtHubBusinessPartnerName1 Name
ProcmtHubBusinessPartnerName2 ProcmtHubBusinessPartnerName2 Name 2
ProcmtHubBusinessPartnerName3 ProcmtHubBusinessPartnerName3 Name 3
ProcmtHubBusinessPartnerName4 ProcmtHubBusinessPartnerName4 Name 4
ProcmtHubStreetName ProcmtHubStreetName Street
ProcmtHubHouseNumber ProcmtHubHouseNumber House Number
ProcmtHubPostalCode ProcmtHubPostalCode Postal Code
ProcmtHubCityName ProcmtHubCityName City
ProcmtHubCountry ProcmtHubCountry Country/Reg.
ProcmtHubRegion ProcmtHubRegion Region

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 A_CntrlPurContrHeaderDistr_2.
-- 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 A_CntrlPurContrHeaderDistr_2 AS
SELECT
  CentralPurchaseContract,
  DistributionKey,
  PurchasingDocumentCategory,
  PurchasingDocumentType,
  PurchasingOrganization,
  CompanyCode,
  Plant,
  DocumentCurrency,
  PurchasingGroup,
  StorageLocation,
  PaymentTerms,
  CashDiscount1Days,
  CashDiscount2Days,
  NetPaymentDays,
  CashDiscount1Percent,
  CashDiscount2Percent,
  CntrlPurContrDistributionPct,
  IsDeleted,
  OrderQuantityUnit,
  OrderQuantityUnitISOCode,
  ManualDeliveryAddressID,
  ProcmtHubDelivAddressTypeCode,
  ProcurementHubSourceSystem,
  SourceListIsUpdated,
  SourceListRestriction,
  ProcmtHubCompanyCodeGroupingID,
  IncotermsClassification,
  IncotermsLocation1,
  ShippingInstruction,
  ProcmtHubSubcontractor,
  ProcmtHubSuplrIsSubcontractor,
  ReferenceDeliveryAddressID,
  FormOfAddress,
  ProcmtHubBusinessPartnerName1,
  ProcmtHubBusinessPartnerName2,
  ProcmtHubBusinessPartnerName3,
  ProcmtHubBusinessPartnerName4,
  ProcmtHubStreetName,
  ProcmtHubHouseNumber,
  ProcmtHubPostalCode,
  ProcmtHubCityName,
  ProcmtHubCountry,
  ProcmtHubRegion
FROM R_CntrlPurContrHdrDistrTP
;

Learn More