R_CNTRLPURCONTRDISTRIBUTION
Central Purchase Contract Distriution
R_CNTRLPURCONTRDISTRIBUTION is a CDS View in S/4HANA. Central Purchase Contract Distriution. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_SrcgProjectItemProcessFlow | view_entity | inner | CONSUMPTION | Sourcing Project Item Process Flow |
| I_CntrlPurContrDistribution | view | from | BASIC | Central PC Distribution Basic View |
@AbapCatalog.sqlViewName: 'RCNTRLPCONDSTR'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@EndUserText.label: 'Central Purchase Contract Distriution'
@AccessControl.personalData.blocking:#REQUIRED
@VDM.viewType : #BASIC
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@Metadata.ignorePropagatedAnnotations: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.representativeKey: 'DistributionKey'
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
define view R_CntrlPurContrDistribution
as select from ekpo_distr
association [1..1] to R_CentralPurchaseContract as _CentralPurchaseContract on _CentralPurchaseContract.CentralPurchaseContract = $projection.CentralPurchaseContract
association [1..1] to R_CntrlPurchaseContractItem as _CntrlPurchaseContractItem on $projection.CentralPurchaseContract = _CntrlPurchaseContractItem.CentralPurchaseContract
and $projection.CentralPurchaseContractItem = _CntrlPurchaseContractItem.CentralPurchaseContractItem
{
@ObjectModel.foreignKey.association: '_CentralPurchaseContract'
key purchasingdocument as CentralPurchaseContract,
@ObjectModel.foreignKey.association: '_CntrlPurchaseContractItem'
key purchasingdocumentitem as CentralPurchaseContractItem,
key ekpo_distr.distributionnumber as DistributionKey,
ekpo_distr.purchasingdocumentcategory as PurchasingDocumentCategory,
ekpo_distr.purchasingdocumenttype as PurchasingDocumentType,
ekpo_distr.purchasingorganization as PurchasingOrganization,
ekpo_distr.companycode as CompanyCode,
ekpo_distr.plant as Plant,
ekpo_distr.logicalsystem as LogicalSystem,
ekpo_distr.documentcurrency as DocumentCurrency,
ekpo_distr.documentcurrency as Currency,
ekpo_distr.purchasinggroup as PurchasingGroup,
ekpo_distr.storagelocation as StorageLocation,
ekpo_distr.paymentterms as PaymentTerms,
ekpo_distr.cashdiscount1days as CashDiscount1Days,
ekpo_distr.cashdiscount2days as CashDiscount2Days,
ekpo_distr.netpaymentdays as NetPaymentDays,
ekpo_distr.cashdiscount1percent as CashDiscount1Percent,
ekpo_distr.cashdiscount2percent as CashDiscount2Percent,
ekpo_distr.material as Material,
ekpo_distr.materialgroup as MaterialGroup,
ekpo_distr.purchasingdocumentdistrpct as CntrlPurContrDistributionPct,
@Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
ekpo_distr.targetquantity as TargetQuantity,
@Semantics.amount.currencyCode: 'DocumentCurrency'
ekpo_distr.targetvalue as TargetAmount,
ekpo_distr.extcontractforpurg as ExtContractForPurg,
ekpo_distr.extcontractitemforpurg as ExtContractItemForPurg,
ekpo_distr.extcontractitemdistrforpurg as ExtContractItemDistrForPurg,
ekpo_distr.extcontractitemdistrstatus as PurgDocItemDistributionStatus,
@Semantics.booleanIndicator:true
cast( ekpo_distr.isdeleted as xfeld ) as IsDeleted ,
ekpo_distr.orderquantityunit as OrderQuantityUnit,
ekpo_distr.distributiontype as DistributionType,
ekpo_distr.responsemessageguid as DistrResponseMessageUUID,
@Semantics.booleanIndicator:true
cast( ekpo_distr.itemdistributionisrelevant as xfeld ) as ItemDistributionIsRelevant,
ekpo_distr.referencedhdrdistrnumber as ReferenceHeaderDistributionKey,
@Semantics.booleanIndicator:true
cast( ekpo_distr.isitemdistributionblocked as xfeld ) as CntrlPurContrItmDistrIsBlocked,
ekpo_distr.distributionlevel as CntrlPurContrDistributionLevel,
ekpo_distr.manualdeliveryaddressid as ManualDeliveryAddressID,
ekpo_distr.deliveryaddresstype as ProcmtHubDelivAddressTypeCode,
case
when ekpo_distr.procurementhubsourcesystem is not initial
then ekpo_distr.procurementhubsourcesystem
else
ekpo_distr.logicalsystem end as ProcurementHubSourceSystem,
ekpo_distr.externalreferencedocument as ExternalReferenceDocument,
ekpo_distr.externalreferencedocumentitem as ExternalReferenceDocumentItem,
ekpo_distr.externalrefdoccategory as ExternalRefDocCategory,
ekpo_distr.purchasinginforecordupdatecode as PurchasingInfoRecordUpdateCode,
ekpo_distr.procmthubpredecessordocument as ProcmtHubPredecessorDocument,
ekpo_distr.procmthubpredecessordocitem as ProcmtHubPredecessorDocItem,
ekpo_distr.procmthubpredecessordoccat as ProcmtHubPredecessorDocCat,
ekpo_distr.procmthubpurchaserequisition as ProcmtHubPurchaseRequisition,
ekpo_distr.procmthubpurrequisitionitem as ProcmtHubPurRequisitionItem,
@Semantics.booleanIndicator:true
ekpo_distr.sourcelistisupdated as SourceListIsUpdated,
ekpo_distr.sourcelistrestriction as SourceListRestriction,
ekpo_distr.mrpsourcingcontrol as MRPSourcingControl,
ekpo_distr.srcelistresponsemsguuid as SrceListResponseMsgUUID,
ekpo_distr.sourcelistchangeconfstatus as SourceListChangeConfStatus,
ekpo_distr.procmthubcompanycodegroupingid as ProcmtHubCompanyCodeGroupingID,
ekpo_distr.outlineagrmtitmisblocked as OutlineAgrmtItmIsBlocked,
ekpo_distr.purgdocitmblkrsncode as PurgDocItmBlkRsnCode,
ekpo_distr.incotermsclassification as IncotermsClassification,
ekpo_distr.incotermslocation1 as IncotermsLocation1,
ekpo_distr.shippinginstruction as ShippingInstruction,
ekpo_distr.cntrlpurcontrdistrtrggrdtetime as CntrlPurContrDistrTrggrDteTime,
ekpo_distr.procmthubsubcontractor as ProcmtHubSubcontractor,
ekpo_distr.procmthubsuplrissubcontractor as ProcmtHubSuplrIsSubcontractor,
ekpo_distr.referencedeliveryaddressid as ReferenceDeliveryAddressID,
ekpo_distr.formofaddress as FormOfAddress,
ekpo_distr.procmthubbusinesspartnername1 as ProcmtHubBusinessPartnerName1,
ekpo_distr.procmthubbusinesspartnername2 as ProcmtHubBusinessPartnerName2,
ekpo_distr.procmthubbusinesspartnername3 as ProcmtHubBusinessPartnerName3,
ekpo_distr.procmthubbusinesspartnername4 as ProcmtHubBusinessPartnerName4,
ekpo_distr.procmthubstreetname as ProcmtHubStreetName,
ekpo_distr.procmthubhousenumber as ProcmtHubHouseNumber,
ekpo_distr.procmthubpostalcode as ProcmtHubPostalCode,
ekpo_distr.procmthubcityname as ProcmtHubCityName,
ekpo_distr.procmthubcountry as ProcmtHubCountry,
ekpo_distr.procmthubregion as ProcmtHubRegion,
ekpo_distr.procmthubprdcssrdocuuid as ProcmtHubPrdcssrDocUUID,
ekpo_distr.procmthubprdcssrdocitemuuid as ProcmtHubPrdcssrDocItemUUID,
ekpo_distr.procmthubprdcssrdocobjtype as ProcmtHubPrdcssrDocObjType,
ekpo_distr.procmthubprdcssrdocobjnodetype as ProcmtHubPrdcssrDocObjNodeType,
_CentralPurchaseContract,
_CntrlPurchaseContractItem
}