I_CFinSalesDocumentPartner

DDL: I_CFINSALESDOCUMENTPARTNER SQL: ICFINSOBP Type: view COMPOSITE
22 Fields 2 Data Sources 1 Associations

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.

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 Sender Logical System
KEY CentralFinanceSalesDocument Central Finance Repl. Sales Document
KEY CFinSalesDocumentItem Central Finance Repl. Sales Doc. Item
KEY PartnerFunction PartnerFunction Partner Functn
Customer Customer Sold-to Party
AddressID AddressID Ship-to address
PartnerIsOneTimeAccount PartnerIsOneTimeAccount One-time acct
TaxNumber1 TaxNumber1 VAT Reg. No.
TaxNumber3 TaxNumber3 Tax Number 3
AddressPersonID AddressPersonID Person Number
_LogicalSystem _LogicalSystem
KEY CentralFinanceSalesDocument Central Finance Repl. Sales Document
KEY CFinSalesDocumentItem Central Finance Repl. Sales Doc. Item
KEY PartnerFunction I_SDDocumentCompletePartners PartnerFunction Partner Functn
Customer I_SDDocumentCompletePartners Customer Sold-to Party
AddressID I_SDDocumentCompletePartners AddressID Ship-to address
PartnerIsOneTimeAccount I_SDDocumentCompletePartners PartnerIsOneTimeAccount One-time acct
TaxNumber1 OneTimeCustomerTaxNumber TaxNumber1 VAT Reg. No.
TaxNumber3 OneTimeCustomerTaxNumber TaxNumber3 Tax Number 3
AddressPersonID I_SDDocumentCompletePartners AddressPersonID Person Number
_LogicalSystem _LogicalSystem
_DfltAddrRprstn I_SDDocumentCompletePartners _DfltAddrRprstn

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_CFinSalesDocumentPartner.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: ICFINSOBP

CREATE VIEW I_CFinSalesDocumentPartner AS
SELECT
  SenderLogicalSystem,
  cast( CFinReplicatedSalesDocument as fins_cfin_av_sales_document preserving type ) AS CentralFinanceSalesDocument,
  cast( CFinRpldSalesDocumentItem as fins_cfin_av_sales_doc_item preserving type ) AS CFinSalesDocumentItem,
  PartnerFunction,
  Customer,
  AddressID,
  PartnerIsOneTimeAccount,
  TaxNumber1,
  TaxNumber3,
  AddressPersonID,
  SDDocumentCompletePartners._DfltAddrRprstn AS _DfltAddrRprstn
FROM I_CFinRpldSalesDocumentPartner
LEFT OUTER JOIN I_LogicalSystem AS _LogicalSystem ON SenderLogicalSystem = _LogicalSystem.LogicalSystem  -- association [0..1]
-- UNION ALL with additional select branch(es): I_SDDocumentCompletePartners
;

Learn More