I_CFINRPLDSALESDOCUMENTPARTNER

CDS View

CFin Replicated Sales Document: Partner

I_CFINRPLDSALESDOCUMENTPARTNER is a CDS View in S/4HANA. CFin Replicated Sales Document: Partner. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CFinSalesDocumentPartner view from COMPOSITE Central Finance Sales Document: Partner 
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'ICFINRSOBP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking: #('TRANSACTIONAL_DATA')
@EndUserText.label: 'CFin Replicated Sales Document: Partner'
@VDM: {
  viewType: #BASIC,
  lifecycle.contract.type: #PUBLIC_LOCAL_API,
  private: false
}
@ObjectModel: {
   representativeKey: 'PartnerFunction',
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #C,
     sizeCategory:   #XL
   }
}
/*+[hideWarning] { "IDS" :
[ "KEY_CHECK" ] } */
define view I_CFinRpldSalesDocumentPartner
  as select from cfin_av_so_part
  association [0..1] to I_LogicalSystem as _LogicalSystem  on  $projection.SenderLogicalSystem = _LogicalSystem.LogicalSystem
  association [0..1] to I_Address_2     as _DfltAddrRprstn on  $projection.AddressID                     = _DfltAddrRprstn.AddressID
                                                           and $projection.AddressPersonID               = _DfltAddrRprstn.AddressPersonID
                                                           and _DfltAddrRprstn.AddressRepresentationCode is initial
{
  key    fins_logsys                                                     as SenderLogicalSystem,
  key    cast( vbeln as fins_cfin_av_rpld_sls_doc preserving type )      as CFinReplicatedSalesDocument,
  key    cast( posnr as fins_cfin_av_rpld_sls_doc_item preserving type ) as CFinRpldSalesDocumentItem,
  key    cast(parvw as parvw_unv preserving type )                       as PartnerFunction,
         kunnr                                                           as Customer,
         adrnr                                                           as AddressID,
         xcpdk                                                           as PartnerIsOneTimeAccount,
         stcd1                                                           as TaxNumber1,
         stcd3                                                           as TaxNumber3,
         cast( '          ' as ad_persnum preserving type )              as AddressPersonID,

         //Association

         _LogicalSystem,
         _DfltAddrRprstn
}
union all select from cfin_av_ci_part
association [0..1] to I_LogicalSystem as _LogicalSystem  on  $projection.SenderLogicalSystem = _LogicalSystem.LogicalSystem
association [0..1] to I_Address       as _Address        on  $projection.AddressID = _Address.AddressID
association [0..1] to I_Address_2     as _DfltAddrRprstn on  $projection.AddressID                     = _DfltAddrRprstn.AddressID
                                                         and $projection.AddressPersonID               = _DfltAddrRprstn.AddressPersonID
                                                         and _DfltAddrRprstn.AddressRepresentationCode is initial
{
  key    fins_logsys                                                     as SenderLogicalSystem,
  key    cast( vbeln as fins_cfin_av_rpld_sls_doc preserving type )      as CFinReplicatedSalesDocument,
  key    cast( posnr as fins_cfin_av_rpld_sls_doc_item preserving type ) as CFinRpldSalesDocumentItem,
  key    cast(parvw as parvw_unv preserving type )                       as PartnerFunction,
         kunnr                                                           as Customer,
         adrnr                                                           as AddressID,
         xcpdk                                                           as PartnerIsOneTimeAccount,
         stcd1                                                           as TaxNumber1,
         stcd3                                                           as TaxNumber3,
         cast( '          ' as ad_persnum preserving type )              as AddressPersonID,

         //Association

         _LogicalSystem,
         _DfltAddrRprstn
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"CFIN_AV_CI_PART",
"CFIN_AV_SO_PART"
],
"ASSOCIATED":
[
"I_ADDRESS_2",
"I_LOGICALSYSTEM"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More