I_PrelimBillingDocPartner

DDL: I_PRELIMBILLINGDOCPARTNER Type: view COMPOSITE

Preliminary Billing Document Partner

I_PrelimBillingDocPartner is a Composite CDS View that provides data about "Preliminary Billing Document Partner" in SAP S/4HANA. It reads from 1 data source (I_BillingDocumentPartnerBasic) and exposes 17 fields with key fields PrelimBillingDocument, PartnerFunction. It has 1 association to related views.

1 data source(s) 17 fields

Data Sources (1)

SourceAliasJoin Type
I_BillingDocumentPartnerBasic Partner from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_PrelimBillingDocument _PrelimBillingDocument $projection.PrelimBillingDocument = _PrelimBillingDocument.PrelimBillingDocument

Annotations (12)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Preliminary Billing Document Partner view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.sqlViewName ISDPREBILDOCPT 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 #COMPOSITE view
Metadata.ignorePropagatedAnnotations true view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY PrelimBillingDocument
KEY PartnerFunction
Customer I_BillingDocumentPartnerBasic Customer
Supplier I_BillingDocumentPartnerBasic Supplier
Personnel I_BillingDocumentPartnerBasic Personnel
ContactPerson I_BillingDocumentPartnerBasic ContactPerson
ReferenceBusinessPartner I_BillingDocumentPartnerBasic ReferenceBusinessPartner
AddressID I_BillingDocumentPartnerBasic AddressID
AddressPersonID I_BillingDocumentPartnerBasic AddressPersonID
AddressObjectType I_BillingDocumentPartnerBasic AddressObjectType
SDDocPartnerAddressRefType I_BillingDocumentPartnerBasic SDDocPartnerAddressRefType
VATRegistration I_BillingDocumentPartnerBasic VATRegistration
UnloadingPointName I_BillingDocumentPartnerBasic UnloadingPointName
_PrelimBillingDocument _PrelimBillingDocument
_PartnerFunction I_BillingDocumentPartnerBasic _PartnerFunction
_Address I_BillingDocumentPartnerBasic _Address
_DfltAddrRprstn I_BillingDocumentPartnerBasic _DfltAddrRprstn 
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Preliminary Billing Document Partner'
@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #('TRANSACTIONAL_DATA'),
  privilegedAssociations: [ '_Address', '_DfltAddrRprstn' ]
}
@AbapCatalog: {
  sqlViewName: 'ISDPREBILDOCPT',
  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: #COMPOSITE
@Metadata.ignorePropagatedAnnotations: true

define view I_PrelimBillingDocPartner
  as select from I_BillingDocumentPartnerBasic as Partner

  association [1..1] to I_PrelimBillingDocument as _PrelimBillingDocument on $projection.PrelimBillingDocument = _PrelimBillingDocument.PrelimBillingDocument

{
      @Consumption.valueHelpDefinition: [
          { entity:  { name:    'I_PrelimBillingDocumentStdVH',
                       element: 'PrelimBillingDocument' }
          }]
      @ObjectModel.foreignKey.association: '_PrelimBillingDocument'
  key cast( Partner.BillingDocument as prelim_billing_document preserving type ) as PrelimBillingDocument,

      @ObjectModel.foreignKey.association: '_PartnerFunction'
  key cast(Partner.PartnerFunction as parvw_unv preserving type )                as PartnerFunction,

      Partner.Customer,
      Partner.Supplier,
      Partner.Personnel,
      Partner.ContactPerson,
      Partner.ReferenceBusinessPartner,

      @ObjectModel.foreignKey.association: '_Address'
      Partner.AddressID,
      Partner.AddressPersonID,
      Partner.AddressObjectType,
      Partner.SDDocPartnerAddressRefType,

      Partner.VATRegistration,
      Partner.UnloadingPointName,

      //Association

      @ObjectModel.association.type: [#TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT]
      _PrelimBillingDocument,
      Partner._PartnerFunction,
      Partner._Address,
      Partner._DfltAddrRprstn
}
where
  _PrelimBillingDocument.SDDocumentCategory = 'PBD'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BILLINGDOCUMENTPARTNERBASIC",
"I_PRELIMBILLINGDOCUMENT"
],
"ASSOCIATED":
[
"I_ADDRESS",
"I_ADDRESS_2",
"I_PARTNERFUNCTION",
"I_PRELIMBILLINGDOCUMENT"
],
"BASE":
[
"I_BILLINGDOCUMENTPARTNERBASIC"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More