I_CePuCoDistrdContrPaytTrmsTP

DDL: I_CEPUCODISTRDCONTRPAYTTRMSTP SQL: ICNTRLPCDISPTP Type: view TRANSACTIONAL

CCTR Distributed PayTerms in OA - TP

I_CePuCoDistrdContrPaytTrmsTP is a Transactional CDS View that provides data about "CCTR Distributed PayTerms in OA - TP" in SAP S/4HANA. It has 2 associations to related views.

18 fields

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_CentralPurchaseContractTP _CentralPurchaseContractTP _CentralPurchaseContractTP.CentralPurchaseContract = $projection.CentralPurchaseContract
[1..1] I_CePuCoDistributedContrTP _DistrdContrForCntrlPurContrTP _DistrdContrForCntrlPurContrTP.CentralPurchaseContract = $projection.CentralPurchaseContract and _DistrdContrForCntrlPurContrTP.ExtContractForPurg = $projection.ExtContractForPurg and _DistrdContrForCntrlPurContrTP.ProcurementHubSourceSystem = $projection.ProcurementHubSourceSystem and _DistrdContrForCntrlPurContrTP.CompanyCode = $projection.CompanyCode and _DistrdContrForCntrlPurContrTP.PurchasingOrganization = $projection.PurchasingOrganization and _DistrdContrForCntrlPurContrTP.PurchasingGroup = $projection.PurchasingGroup and _DistrdContrForCntrlPurContrTP.DistrResponseMessageUUID = $projection.DistrResponseMessageUUID and _DistrdContrForCntrlPurContrTP.PurchasingDocumentCategory = $projection.PurchasingDocumentCategory and _DistrdContrForCntrlPurContrTP.DistributionKey = $projection.DistributionKey and _DistrdContrForCntrlPurContrTP.CentralPurchaseContractItem = $projection.CentralPurchaseContractItem

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName ICNTRLPCDISPTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label CCTR Distributed PayTerms in OA - TP view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.createEnabled false view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled false view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #TRANSACTIONAL view
ObjectModel.writeDraftPersistence CNTRLPCOAPT_D view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY CentralPurchaseContract CentralPurchaseContract
KEY ExtContractForPurg ExtContractForPurg
KEY ProcurementHubSourceSystem ProcurementHubSourceSystem
KEY CompanyCode CompanyCode
KEY PurchasingOrganization PurchasingOrganization
KEY PurchasingGroup PurchasingGroup
KEY DistrResponseMessageUUID DistrResponseMessageUUID
KEY PurchasingDocumentCategory PurchasingDocumentCategory
KEY DistributionKey DistributionKey
KEY CentralPurchaseContractItem CentralPurchaseContractItem
PaymentTerms PaymentTerms
NetPaymentDays NetPaymentDays
CashDiscount1Days CashDiscount1Days
CashDiscount1Percent CashDiscount1Percent
CashDiscount2Days CashDiscount2Days
CashDiscount2Percent CashDiscount2Percent
_CentralPurchaseContractTP _CentralPurchaseContractTP
_DistrdContrForCntrlPurContrTP _DistrdContrForCntrlPurContrTP 
@AbapCatalog.sqlViewName: 'ICNTRLPCDISPTP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'CCTR Distributed PayTerms in OA - TP'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #REQUIRED
//@ObjectModel.draftEnabled: true

@ObjectModel.createEnabled: false
@ObjectModel.updateEnabled: true
@ObjectModel.deleteEnabled: false
//@ObjectModel.semanticKey: ['ExtContractForPurg']

@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MIXED
@VDM.viewType:#TRANSACTIONAL
@ObjectModel.writeDraftPersistence: 'CNTRLPCOAPT_D'
define view I_CePuCoDistrdContrPaytTrmsTP as select distinct from I_CntrlPurContrDistribution 
association [1..1] to I_CentralPurchaseContractTP   as _CentralPurchaseContractTP   on  _CentralPurchaseContractTP.CentralPurchaseContract = $projection.CentralPurchaseContract
association [1..1] to I_CePuCoDistributedContrTP    as _DistrdContrForCntrlPurContrTP   on  _DistrdContrForCntrlPurContrTP.CentralPurchaseContract = $projection.CentralPurchaseContract
                                                                                        and _DistrdContrForCntrlPurContrTP.ExtContractForPurg = $projection.ExtContractForPurg
                                                                                        and _DistrdContrForCntrlPurContrTP.ProcurementHubSourceSystem = $projection.ProcurementHubSourceSystem
                                                                                        and _DistrdContrForCntrlPurContrTP.CompanyCode = $projection.CompanyCode
                                                                                        and _DistrdContrForCntrlPurContrTP.PurchasingOrganization = $projection.PurchasingOrganization
                                                                                        and _DistrdContrForCntrlPurContrTP.PurchasingGroup = $projection.PurchasingGroup
                                                                                        and _DistrdContrForCntrlPurContrTP.DistrResponseMessageUUID = $projection.DistrResponseMessageUUID
                                                                                        and _DistrdContrForCntrlPurContrTP.PurchasingDocumentCategory = $projection.PurchasingDocumentCategory
                                                                                        and _DistrdContrForCntrlPurContrTP.DistributionKey = $projection.DistributionKey
                                                                                        and _DistrdContrForCntrlPurContrTP.CentralPurchaseContractItem = $projection.CentralPurchaseContractItem                                                                                        
                                                                             
 {
  key CentralPurchaseContract,
  key ExtContractForPurg,
  key ProcurementHubSourceSystem,
  key    CompanyCode,       
        
  key    PurchasingOrganization,
  key    PurchasingGroup,
  key    DistrResponseMessageUUID,  
  key    PurchasingDocumentCategory,
  key    DistributionKey ,
  key    CentralPurchaseContractItem,
  PaymentTerms,
  NetPaymentDays,
  CashDiscount1Days,
  CashDiscount1Percent,
  CashDiscount2Days,
  CashDiscount2Percent,
  
  @ObjectModel.association.type: [ #TO_COMPOSITION_ROOT ]
   _CentralPurchaseContractTP,
   @ObjectModel.association.type: [ #TO_COMPOSITION_PARENT ]
  _DistrdContrForCntrlPurContrTP
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CNTRLPURCONTRDISTRIBUTION"
],
"ASSOCIATED":
[
"I_CENTRALPURCHASECONTRACTTP",
"I_CEPUCODISTRIBUTEDCONTRTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More