I_SALESQUOTATIONPARTNER

CDS View

Sales Quotation Partner

I_SALESQUOTATIONPARTNER is a CDS View in S/4HANA. Sales Quotation Partner. It contains 24 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 24 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
C_SalesQuotationWrkflwInbox view left_outer CONSUMPTION Sales Quotation Workflow Inbox
R_SalesQuotationPartnerTP view_entity from TRANSACTIONAL Sales Quotation Partner - TP
R_SalesQuotationShipToPartyTP view_entity from TRANSACTIONAL Ship-to Party for Sales Quotation - TP

Fields (24)

KeyField CDS FieldsUsed in Views
_BusinessPartnerAddress _BusinessPartnerAddress 1
_DfltAddrRprstn _DfltAddrRprstn 1
AddressID AddressID 2
AddressObjectType AddressObjectType 2
AddressPersonID AddressPersonID 2
BPAddrDeterminationTransaction BPAddrDeterminationTransaction 1
BPRefAddressIDForDocSpcfcAddr BPRefAddressIDForDocSpcfcAddr 1
ContactPerson ContactPerson 1
CorrespondenceLanguage CorrespondenceLanguage 2
Customer Customer,Partner,ShipToParty 3
EmailAddress EmailAddress 2
FormOfAddress FormOfAddress 2
FullName FullName 2
InternationalFaxNumber InternationalFaxNumber 2
InternationalMobilePhoneNumber InternationalMobilePhoneNumber 2
InternationalPhoneNumber InternationalPhoneNumber 2
Partner Partner 1
Personnel Personnel 1
ReferenceBusinessPartner ReferenceBusinessPartner 2
SDDocPartnerAddressRefType SDDocPartnerAddressRefType 1
SDDocPartnerAddrIsDocSpecific SDDocPartnerAddrIsDocSpecific 2
Supplier Supplier 1
UnloadingPointName UnloadingPointName 2
VATRegistration VATRegistration 2 
@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