I_CFinSalesDocumentPartner

DDL: I_CFINSALESDOCUMENTPARTNER SQL: ICFINSOBP Type: view COMPOSITE

Central Finance Sales Document: Partner

I_CFinSalesDocumentPartner is a Composite CDS View that provides data about "Central Finance Sales Document: Partner" in SAP S/4HANA. It reads from 2 data sources (I_CFinRpldSalesDocumentPartner, I_SDDocumentCompletePartners) and exposes 22 fields with key fields SenderLogicalSystem, CentralFinanceSalesDocument, CFinSalesDocumentItem, PartnerFunction, CentralFinanceSalesDocument. It has 1 association to related views.

2 data source(s) 22 fields

Data Sources (2)

SourceAliasJoin Type
I_CFinRpldSalesDocumentPartner I_CFinRpldSalesDocumentPartner from
I_SDDocumentCompletePartners SDDocumentCompletePartners union_all

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_LogicalSystem _LogicalSystem $projection.SenderLogicalSystem = _LogicalSystem.LogicalSystem

Annotations (12)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName ICFINSOBP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.representativeKey PartnerFunction view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
EndUserText.label Central Finance Sales Document: Partner view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY SenderLogicalSystem SenderLogicalSystem
KEY CentralFinanceSalesDocument
KEY CFinSalesDocumentItem
KEY PartnerFunction PartnerFunction
Customer Customer
AddressID AddressID
PartnerIsOneTimeAccount PartnerIsOneTimeAccount
TaxNumber1 TaxNumber1
TaxNumber3 TaxNumber3
AddressPersonID AddressPersonID
_LogicalSystem _LogicalSystem
KEY CentralFinanceSalesDocument
KEY CFinSalesDocumentItem
KEY PartnerFunction I_SDDocumentCompletePartners PartnerFunction
Customer I_SDDocumentCompletePartners Customer
AddressID I_SDDocumentCompletePartners AddressID
PartnerIsOneTimeAccount I_SDDocumentCompletePartners PartnerIsOneTimeAccount
TaxNumber1 OneTimeCustomerTaxNumber TaxNumber1
TaxNumber3 OneTimeCustomerTaxNumber TaxNumber3
AddressPersonID I_SDDocumentCompletePartners AddressPersonID
_LogicalSystem _LogicalSystem
_DfltAddrRprstn I_SDDocumentCompletePartners _DfltAddrRprstn 
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'ICFINSOBP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking: #('TRANSACTIONAL_DATA')
@VDM: {
  viewType: #COMPOSITE,
  lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@ObjectModel: {
   representativeKey: 'PartnerFunction',
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #C,
     sizeCategory:   #XL
   }
}
@EndUserText.label: 'Central Finance Sales Document: Partner'
define view I_CFinSalesDocumentPartner
  as select from I_CFinRpldSalesDocumentPartner


{
      @ObjectModel.foreignKey.association: '_LogicalSystem'
  key SenderLogicalSystem,
  key cast( CFinReplicatedSalesDocument as fins_cfin_av_sales_document preserving type ) as CentralFinanceSalesDocument,
  key cast( CFinRpldSalesDocumentItem as fins_cfin_av_sales_doc_item  preserving type )  as CFinSalesDocumentItem,
  key PartnerFunction,
      Customer,
      AddressID,
      PartnerIsOneTimeAccount,
      TaxNumber1,
      TaxNumber3,
      AddressPersonID,

      //Associations

      _LogicalSystem,
      _DfltAddrRprstn
}

union all select from    I_SDDocumentCompletePartners as SDDocumentCompletePartners
  left outer to one join I_OneTimeCustomerTaxNumber   as OneTimeCustomerTaxNumber on  SDDocumentCompletePartners.SDDocument      = OneTimeCustomerTaxNumber.SDDocument
                                                                                  and SDDocumentCompletePartners.SDDocumentItem  = OneTimeCustomerTaxNumber.SDDocumentItem
                                                                                  and SDDocumentCompletePartners.PartnerFunction = OneTimeCustomerTaxNumber.PartnerFunction
association [0..1] to I_LogicalSystem as _LogicalSystem on $projection.SenderLogicalSystem = _LogicalSystem.LogicalSystem
{

      @ObjectModel.foreignKey.association: '_LogicalSystem'
  key cast( '          ' as logsys preserving type  )                                                   as SenderLogicalSystem,
  key cast( SDDocumentCompletePartners.SDDocument as fins_cfin_av_sales_document preserving type  )     as CentralFinanceSalesDocument,
  key cast( SDDocumentCompletePartners.SDDocumentItem as fins_cfin_av_sales_doc_item  preserving type ) as CFinSalesDocumentItem,
  key SDDocumentCompletePartners.PartnerFunction,
      SDDocumentCompletePartners.Customer,
      SDDocumentCompletePartners.AddressID,
      SDDocumentCompletePartners.PartnerIsOneTimeAccount,
      OneTimeCustomerTaxNumber.TaxNumber1,
      OneTimeCustomerTaxNumber.TaxNumber3,
      SDDocumentCompletePartners.AddressPersonID,

      //Associations

      _LogicalSystem,
      SDDocumentCompletePartners._DfltAddrRprstn
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CFINRPLDSALESDOCUMENTPARTNER",
"I_ONETIMECUSTOMERTAXNUMBER",
"I_SDDOCUMENTCOMPLETEPARTNERS"
],
"ASSOCIATED":
[
"I_ADDRESS_2",
"I_LOGICALSYSTEM"
],
"BASE":
[
"I_CFINRPLDSALESDOCUMENTPARTNER"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More