P_ContrAccountEnterpriseSearch

DDL: P_CONTRACCOUNTENTERPRISESEARCH SQL: PCONTRACCES Type: view COMPOSITE

P_ContrAccountEnterpriseSearch is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_ContractAccountPartner) and exposes 18 fields with key fields ContractAccount, BusinessPartner. It has 6 associations to related views.

1 data source(s) 18 fields

Data Sources (1)

SourceAliasJoin Type
I_ContractAccountPartner CAPartner from

Associations (6)

CardinalityTargetAliasCondition
[1..1] I_CACorrespondenceVariant _CorrVariant $projection.CACorrespondenceVariant = _CorrVariant.CACorrespondenceVariant
[0..1] I_CADunningProcedure _DunningProcedure $projection.CADunningProcedure = _DunningProcedure.CADunningProcedure
[0..1] I_CAInvcgCategory _InvcgCategory $projection.CAInvcgCategory = _InvcgCategory.CAInvcgCategory
[1..1] I_ContractAccountHeader _ContrAcc $projection.ContractAccount = _ContrAcc.ContractAccount
[0..1] I_PaymentCondition _PaymentCondition $projection.PaymentCondition = _PaymentCondition.PaymentCondition
[0..1] I_ContrAcctPrtnRelshpType _RelshpOfBP $projection.CARelationshipOfBPToContrAcct = _RelshpOfBP.CARelationshipOfBPToContrAcct

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PCONTRACCES view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY ContractAccount I_ContractAccountPartner ContractAccount
KEY BusinessPartner I_ContractAccountPartner BusinessPartner
CARelationshipOfBPToContrAcct I_ContractAccountPartner CARelationshipOfBPToContrAcct
PaymentCondition I_ContractAccountPartner PaymentCondition
CACompanyCodeGroup I_ContractAccountPartner CACompanyCodeGroup
CABusinessPartnerForPayment I_ContractAccountPartner CABusinessPartnerForPayment
CAPaymentMethodForIncgPayment I_ContractAccountPartner CAPaymentMethodForIncgPayment
CAPaymentMethodForOutgPayment I_ContractAccountPartner CAPaymentMethodForOutgPayment
CACorrespondenceVariant I_ContractAccountPartner CACorrespondenceVariant
CADunningProcedure I_ContractAccountPartner CADunningProcedure
CAInvcgCategory I_ContractAccountPartner CAInvcgCategory
CAPaymentMethodName
_CorrVariant _CorrVariant
_DunningProcedure _DunningProcedure
_InvcgCategory _InvcgCategory
_ContrAcc _ContrAcc
_PaymentCondition _PaymentCondition
_RelshpOfBP _RelshpOfBP 
@AbapCatalog.sqlViewName: 'PCONTRACCES'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private:true
@VDM.viewType:#COMPOSITE 
define view P_ContrAccountEnterpriseSearch
  as select from    I_ContractAccountPartner as CAPartner
    left outer to one join I_CACompanyCodeGroup     as CompanyCodeGroup on  CAPartner.CACompanyCodeGroup = CompanyCodeGroup.CACompanyCodeGroup
    left outer to one join I_CompanyCode            as CompanyCode      on  CompanyCodeGroup.CAPaymentCompanyCode = CompanyCode.CompanyCode
    left outer to one join I_CAPaymentMethod        as PaytMethodIncg   on  CompanyCode.Country = PaytMethodIncg.Country
                                                                        and CAPartner.CAPaymentMethodForIncgPayment = PaytMethodIncg.CAPaymentMethod

  association [1..1] to I_CACorrespondenceVariant as _CorrVariant      on $projection.CACorrespondenceVariant = _CorrVariant.CACorrespondenceVariant
  association [0..1] to I_CADunningProcedure      as _DunningProcedure on $projection.CADunningProcedure = _DunningProcedure.CADunningProcedure
  association [0..1] to I_CAInvcgCategory         as _InvcgCategory    on $projection.CAInvcgCategory = _InvcgCategory.CAInvcgCategory
  association [1..1] to I_ContractAccountHeader   as _ContrAcc         on $projection.ContractAccount = _ContrAcc.ContractAccount
  association [0..1] to I_PaymentCondition        as _PaymentCondition on $projection.PaymentCondition = _PaymentCondition.PaymentCondition
  association [0..1] to I_ContrAcctPrtnRelshpType as _RelshpOfBP       on $projection.CARelationshipOfBPToContrAcct = _RelshpOfBP.CARelationshipOfBPToContrAcct
{
  key CAPartner.ContractAccount,
  key CAPartner.BusinessPartner,
      CAPartner.CARelationshipOfBPToContrAcct,
      CAPartner.PaymentCondition,
      CAPartner.CACompanyCodeGroup,
      CAPartner.CABusinessPartnerForPayment,
      CAPartner.CAPaymentMethodForIncgPayment,
      CAPartner.CAPaymentMethodForOutgPayment,
      CAPartner.CACorrespondenceVariant,
      CAPartner.CADunningProcedure,
      CAPartner.CAInvcgCategory,
      PaytMethodIncg._Text[1:Language = $session.system_language].CAPaymentMethodName,

      _CorrVariant,
      _DunningProcedure,
      _InvcgCategory,
      _ContrAcc,
      _PaymentCondition,
      _RelshpOfBP

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CACOMPANYCODEGROUP",
"I_CAPAYMENTMETHOD",
"I_CAPAYMENTMETHODTEXT",
"I_COMPANYCODE",
"I_CONTRACTACCOUNTPARTNER"
],
"ASSOCIATED":
[
"I_CACORRESPONDENCEVARIANT",
"I_CADUNNINGPROCEDURE",
"I_CAINVCGCATEGORY",
"I_CONTRACCTPRTNRELSHPTYPE",
"I_CONTRACTACCOUNTHEADER",
"I_PAYMENTCONDITION"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More