I_BillingDocItemPartnerBasic

DDL: I_BILLINGDOCITEMPARTNERBASIC Type: view BASIC

Billing Document Item Partner Basic

I_BillingDocItemPartnerBasic is a Basic CDS View that provides data about "Billing Document Item Partner Basic" in SAP S/4HANA. It reads from 2 data sources (I_BillingDocumentItemBasic, I_SDDocumentItemPartner) and exposes 22 fields with key fields BillingDocument, BillingDocumentItem, PartnerFunction. It has 2 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_BillingDocumentItemBasic BillingDocumentItem inner
I_SDDocumentItemPartner Partner from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_BillingDocumentBasic _BillingDocumentBasic $projection.BillingDocument = _BillingDocumentBasic.BillingDocument
[1..1] I_BillingDocumentItemBasic _ItemBasic $projection.BillingDocument = _ItemBasic.BillingDocument and $projection.BillingDocumentItem = _ItemBasic.BillingDocumentItem

Annotations (13)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Billing Document Item Partner Basic view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
AbapCatalog.sqlViewName ISDBILDOCITPTBC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.representativeKey PartnerFunction view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #BASIC view
Metadata.ignorePropagatedAnnotations true view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY BillingDocument
KEY BillingDocumentItem I_BillingDocumentItemBasic BillingDocumentItem
KEY PartnerFunction I_SDDocumentItemPartner PartnerFunction
Customer I_SDDocumentItemPartner Customer
Supplier I_SDDocumentItemPartner Supplier
Personnel I_SDDocumentItemPartner Personnel
AddressID I_SDDocumentItemPartner AddressID
ContactPerson I_SDDocumentItemPartner ContactPerson
AddressPersonID I_SDDocumentItemPartner AddressPersonID
ReferenceBusinessPartner I_SDDocumentItemPartner ReferenceBusinessPartner
BPRefAddressIDForDocSpcfcAddr I_SDDocumentItemPartner BPRefAddressIDForDocSpcfcAddr
SDDocPartnerAddressRefType I_SDDocumentItemPartner SDDocPartnerAddressRefType
AddressObjectType I_SDDocumentItemPartner AddressObjectType
VATRegistration I_SDDocumentItemPartner VATRegistration
UnloadingPointName I_SDDocumentItemPartner UnloadingPointName
_BillingDocumentBasic _BillingDocumentBasic
_ItemBasic _ItemBasic
_PartnerFunction I_SDDocumentItemPartner _PartnerFunction
_Address I_SDDocumentItemPartner _Address
_BusinessPartnerAddress I_SDDocumentItemPartner _BusinessPartnerAddress
_BPRefAddressForDocSpcfcAddr I_SDDocumentItemPartner _BPRefAddressForDocSpcfcAddr
_DfltAddrRprstn I_SDDocumentItemPartner _DfltAddrRprstn
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Billing Document Item Partner Basic'
@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #REQUIRED,
  privilegedAssociations: [ '_Address', '_DfltAddrRprstn' ]
}
@AbapCatalog: {
  sqlViewName: 'ISDBILDOCITPTBC',
  compiler.compareFilter: true,
  preserveKey: true
}
@ObjectModel: {
   representativeKey: 'PartnerFunction',
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #B,
     sizeCategory:   #XL
   },
   supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET ]
}
@VDM.viewType: #BASIC
@Metadata.ignorePropagatedAnnotations: true

define view I_BillingDocItemPartnerBasic
  as select from I_SDDocumentItemPartner    as Partner
    inner join   I_BillingDocumentItemBasic as BillingDocumentItem on  BillingDocumentItem.BillingDocument               = Partner.SDDocument
                                                                   and BillingDocumentItem.BillingDocumentItemInPartSgmt = Partner.SDDocumentItem

  association [1..1] to I_BillingDocumentBasic     as _BillingDocumentBasic on  $projection.BillingDocument = _BillingDocumentBasic.BillingDocument
  association [1..1] to I_BillingDocumentItemBasic as _ItemBasic            on  $projection.BillingDocument     = _ItemBasic.BillingDocument
                                                                            and $projection.BillingDocumentItem = _ItemBasic.BillingDocumentItem

{

      //--[ GENERATED:012:GlBfhyJl7kY4v5RWfCiSf0

      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_BillingDocumentBasicStdVH',
                     element: 'BillingDocument' }
        }]
      // ]--GENERATED

      @ObjectModel.foreignKey.association: '_BillingDocumentBasic'
  key cast(Partner.SDDocument as vbeln_vf preserving type ) as BillingDocument,

      //--[ GENERATED:012:GlBfhyJl7kY4v5RWfCiSf0

      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_BillgDocItmBscStdVH',
                     element: 'BillingDocumentItem' },
          additionalBinding: [{ localElement: 'BillingDocument',
                                element: 'BillingDocument' }]
        }]
      // ]--GENERATED

      @ObjectModel.foreignKey.association: '_ItemBasic'
  key BillingDocumentItem.BillingDocumentItem,
      @ObjectModel.foreignKey.association: '_PartnerFunction'
  key Partner.PartnerFunction,

      Partner.Customer,

      Partner.Supplier,

      Partner.Personnel,
      @ObjectModel.foreignKey.association: '_Address'
      Partner.AddressID,
      Partner.ContactPerson,

      Partner.AddressPersonID,
      Partner.ReferenceBusinessPartner,
      Partner.BPRefAddressIDForDocSpcfcAddr,
      Partner.SDDocPartnerAddressRefType,

      Partner.AddressObjectType,
      Partner.VATRegistration,
      Partner.UnloadingPointName,

      //Association

      @ObjectModel.association.type: [#TO_COMPOSITION_ROOT]
      _BillingDocumentBasic,
      @ObjectModel.association.type: [#TO_COMPOSITION_PARENT]
      _ItemBasic,
      Partner._PartnerFunction,
      Partner._Address,
      Partner._BusinessPartnerAddress,
      Partner._BPRefAddressForDocSpcfcAddr,
      Partner._DfltAddrRprstn
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BILLINGDOCUMENTITEMBASIC",
"I_SDDOCUMENTITEMPARTNER"
],
"ASSOCIATED":
[
"I_ADDRESS",
"I_ADDRESS_2",
"I_BILLINGDOCUMENTBASIC",
"I_BILLINGDOCUMENTITEMBASIC",
"I_BUSPARTADDRESS",
"I_PARTNERFUNCTION"
],
"BASE":
[
"I_SDDOCUMENTITEMPARTNER"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/