I_SalesQuotationPartner

DDL: I_SALESQUOTATIONPARTNER Type: view COMPOSITE

Sales Quotation Partner

I_SalesQuotationPartner is a Composite CDS View that provides data about "Sales Quotation Partner" in SAP S/4HANA. It reads from 1 data source (I_SalesDocumentPartner) and exposes 34 fields with key fields SalesQuotation, PartnerFunction.

1 data source(s) 34 fields

Data Sources (1)

SourceAliasJoin Type
I_SalesDocumentPartner Partner from

Annotations (12)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Sales Quotation Partner view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.sqlViewName ISDSLSQTANPT view
AbapCatalog.compiler.compareFilter true view
ObjectModel.representativeKey PartnerFunction view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
Metadata.ignorePropagatedAnnotations true view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY SalesQuotation
KEY PartnerFunction PartnerFunction
Customer Customer
Supplier Supplier
Personnel Personnel
AddressID AddressID
ContactPerson ContactPerson
Partner Partner
FullName FullName
AddressPersonID AddressPersonID
AddressObjectType AddressObjectType
SDDocPartnerAddressRefType SDDocPartnerAddressRefType
ReferenceBusinessPartner ReferenceBusinessPartner
BPRefAddressIDForDocSpcfcAddr BPRefAddressIDForDocSpcfcAddr
SDDocPartnerAddrIsDocSpecific SDDocPartnerAddrIsDocSpecific
BPAddrDeterminationTransaction BPAddrDeterminationTransaction
VATRegistration VATRegistration
UnloadingPointName UnloadingPointName
CorrespondenceLanguage CorrespondenceLanguage
FormOfAddress FormOfAddress
InternationalPhoneNumber InternationalPhoneNumber
InternationalMobilePhoneNumber InternationalMobilePhoneNumber
InternationalFaxNumber InternationalFaxNumber
EmailAddress EmailAddress
_SalesQuotation _SalesQuotation
_PartnerFunction _PartnerFunction
_ContactPerson _ContactPerson
_Address _Address
_DfltAddrRprstn _DfltAddrRprstn
_BusinessPartnerAddress _BusinessPartnerAddress
_PersonAddress _PersonAddress
_PersonName _PersonName
_OrganizationAddress _OrganizationAddress
_OrgNamePostalAddress _OrgNamePostalAddress 
@ClientHandling.algorithm: #SESSION_VARIABLE 
@EndUserText.label: 'Sales Quotation Partner'
@VDM: {
  viewType: #COMPOSITE,
  lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@AccessControl: { 
  authorizationCheck: #CHECK,
  personalData.blocking: #('TRANSACTIONAL_DATA'),
  privilegedAssociations: [ '_Address', '_DfltAddrRprstn' ]
}
@AbapCatalog: {
  sqlViewName: 'ISDSLSQTANPT',
  compiler.compareFilter: true
}
@ObjectModel: {
  representativeKey: 'PartnerFunction',
  usageType: {
    dataClass:      #TRANSACTIONAL,
    serviceQuality: #C,
    sizeCategory:   #XL
  },
  supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET ]
}
@Metadata.ignorePropagatedAnnotations: true

define view I_SalesQuotationPartner as select from I_SalesDocumentPartner  as Partner
      
    association[1..1] to I_SalesQuotation       as _SalesQuotation      on $projection.SalesQuotation   = _SalesQuotation.SalesQuotation     
    
{
        @ObjectModel.foreignKey.association: '_SalesQuotation'                                                                                                   
    key cast(SalesDocument as sales_quotation preserving type) as SalesQuotation,         
        @ObjectModel.foreignKey.association: '_PartnerFunction'
    key PartnerFunction,       
        Customer,          
        Supplier,           
        Personnel,  
        @ObjectModel.foreignKey.association: '_Address'  
        AddressID,        
        ContactPerson,
        @ObjectModel.text.element: ['FullName']
        Partner,
        @Semantics: {
          text: true,
          name.fullName: true
        }
        FullName,
        AddressPersonID,
        AddressObjectType,
        SDDocPartnerAddressRefType,  
        ReferenceBusinessPartner,
        BPRefAddressIDForDocSpcfcAddr,
        SDDocPartnerAddrIsDocSpecific,
        BPAddrDeterminationTransaction,
        
        VATRegistration,  
        @Semantics.text: true
        UnloadingPointName,
        
        CorrespondenceLanguage,
        FormOfAddress,
        InternationalPhoneNumber,
        InternationalMobilePhoneNumber,
        InternationalFaxNumber,
        EmailAddress,
        
        //Association

        @ObjectModel.association.type: [#TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT]    
        _SalesQuotation,
        _PartnerFunction,
        _ContactPerson,
        _Address,
        _DfltAddrRprstn,
        _BusinessPartnerAddress,
        _PersonAddress,
        _PersonName,
        _OrganizationAddress,
        _OrgNamePostalAddress
}
where SDDocumentCategory = 'B';         
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SALESDOCUMENTPARTNER"
],
"ASSOCIATED":
[
"I_ADDRESS",
"I_ADDRESSPERSONNAME",
"I_ADDRESS_2",
"I_ADDRORGNAMEPOSTALADDRESS",
"I_BUSPARTADDRESS",
"I_CONTACTPERSON",
"I_ORGANIZATIONADDRESS",
"I_PARTNERFUNCTION",
"I_PERSONADDRESS",
"I_SALESQUOTATION"
],
"BASE":
[
"I_SALESDOCUMENTPARTNER"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More