A_CntrlPurContrItemDistr_2

DDL: A_CNTRLPURCONTRITEMDISTR_2 Type: view_entity CONSUMPTION
54 Fields 1 Data Sources

CCTR Item Distribution

A_CntrlPurContrItemDistr_2 is a Consumption CDS View that provides data about "CCTR Item Distribution" in SAP S/4HANA. It reads from 1 data source (R_CntrlPurContrItemDistrTP) and exposes 54 fields with key fields CentralPurchaseContract, CentralPurchaseContractItem, DistributionKey.

Data Sources (1)

SourceAliasJoin Type
R_CntrlPurContrItemDistrTP R_CntrlPurContrItemDistrTP projection

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label CCTR Item 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 #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view
OData.entityType.name CentralPurchaseContractItemDistr_Type view

Fields (54)

KeyFieldSource TableSource FieldDescription
KEY CentralPurchaseContract CentralPurchaseContract Purchasing Doc.
KEY CentralPurchaseContractItem CentralPurchaseContractItem Item in Central Purchase Contract
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
TargetQuantity TargetQuantity Target Quantity
TargetAmount TargetAmount Target Value
IsDeleted IsDeleted TRUE
OrderQuantityUnit OrderQuantityUnit Sales Unit
OrderQuantityUnitISOCode OrderQuantityUnitISOCode
DistributionType DistributionType Distribution Type
ReferenceHeaderDistributionKey ReferenceHeaderDistributionKey
CntrlPurContrItmDistrIsBlocked CntrlPurContrItmDistrIsBlocked
ManualDeliveryAddressID ManualDeliveryAddressID Address Number
ProcmtHubDelivAddressTypeCode ProcmtHubDelivAddressTypeCode
ProcurementHubSourceSystem ProcurementHubSourceSystem Connected System ID
PurchasingInfoRecordUpdateCode PurchasingInfoRecordUpdateCode InfoUpdate
ProcmtHubPurchaseRequisition ProcmtHubPurchaseRequisition Purchase Req.
ProcmtHubPurRequisitionItem ProcmtHubPurRequisitionItem Requisn. item
SourceListIsUpdated SourceListIsUpdated Sourcelist Updated
SourceListRestriction SourceListRestriction SrcListRstrcn
ProcmtHubCompanyCodeGroupingID ProcmtHubCompanyCodeGroupingID Grouping ID
OutlineAgrmtItmIsBlocked OutlineAgrmtItmIsBlocked OA Blocked Ind
PurgDocItmBlkRsnCode PurgDocItmBlkRsnCode Block Reason 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_CntrlPurContrItemDistr_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_CntrlPurContrItemDistr_2 AS
SELECT
  CentralPurchaseContract,
  CentralPurchaseContractItem,
  DistributionKey,
  PurchasingDocumentCategory,
  PurchasingDocumentType,
  PurchasingOrganization,
  CompanyCode,
  Plant,
  DocumentCurrency,
  PurchasingGroup,
  StorageLocation,
  PaymentTerms,
  CashDiscount1Days,
  CashDiscount2Days,
  NetPaymentDays,
  CashDiscount1Percent,
  CashDiscount2Percent,
  CntrlPurContrDistributionPct,
  TargetQuantity,
  TargetAmount,
  IsDeleted,
  OrderQuantityUnit,
  OrderQuantityUnitISOCode,
  DistributionType,
  ReferenceHeaderDistributionKey,
  CntrlPurContrItmDistrIsBlocked,
  ManualDeliveryAddressID,
  ProcmtHubDelivAddressTypeCode,
  ProcurementHubSourceSystem,
  PurchasingInfoRecordUpdateCode,
  ProcmtHubPurchaseRequisition,
  ProcmtHubPurRequisitionItem,
  SourceListIsUpdated,
  SourceListRestriction,
  ProcmtHubCompanyCodeGroupingID,
  OutlineAgrmtItmIsBlocked,
  PurgDocItmBlkRsnCode,
  IncotermsClassification,
  IncotermsLocation1,
  ShippingInstruction,
  ProcmtHubSubcontractor,
  ProcmtHubSuplrIsSubcontractor,
  ReferenceDeliveryAddressID,
  FormOfAddress,
  ProcmtHubBusinessPartnerName1,
  ProcmtHubBusinessPartnerName2,
  ProcmtHubBusinessPartnerName3,
  ProcmtHubBusinessPartnerName4,
  ProcmtHubStreetName,
  ProcmtHubHouseNumber,
  ProcmtHubPostalCode,
  ProcmtHubCityName,
  ProcmtHubCountry,
  ProcmtHubRegion
FROM R_CntrlPurContrItemDistrTP
;

Learn More