I_CFinSalesDocumentPartner

DDL: I_CFINSALESDOCUMENTPARTNER SQL: ICFINSOBP Type: view COMPOSITE Package: FINS_CFIN_ACC_VIEW_API

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 1 data source (I_SDDocumentCompletePartners) and exposes 13 fields with key fields SenderLogicalSystem, CentralFinanceSalesDocument, CFinSalesDocumentItem, PartnerFunction. It has 1 association to related views. Part of development package FINS_CFIN_ACC_VIEW_API.

1 data source(s) 13 fields

Data Sources (1)

SourceAliasJoin Type
I_SDDocumentCompletePartners SDDocumentCompletePartners from

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 (13)

KeyFieldSource TableSource FieldDescription
KEY SenderLogicalSystem
KEY CentralFinanceSalesDocument
KEY CFinSalesDocumentItem
KEY 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
_PartnerFunction I_SDDocumentCompletePartners _PartnerFunction 
@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_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 cast( SDDocumentCompletePartners.PartnerFunction as parvw_unv preserving type )                   as PartnerFunction,
      SDDocumentCompletePartners.Customer,
      SDDocumentCompletePartners.AddressID,
      SDDocumentCompletePartners.PartnerIsOneTimeAccount,
      OneTimeCustomerTaxNumber.TaxNumber1,
      OneTimeCustomerTaxNumber.TaxNumber3,
      SDDocumentCompletePartners.AddressPersonID,

      //Associations

      _LogicalSystem,
      SDDocumentCompletePartners._DfltAddrRprstn,
      SDDocumentCompletePartners._PartnerFunction
}

Learn More