APS_BP_DDL

DDL: APS_BP_DDL SQL: APS_BP Type: view Package: SR_APS_IAM_COMMON

Business Partner

APS_BP_DDL is a CDS View that provides data about "Business Partner" in SAP S/4HANA. It reads from 1 data source (but000) and exposes 6 fields with key field BusinessPartner. Part of development package SR_APS_IAM_COMMON.

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
but000 but000 from

Annotations (3)

NameValueLevelField
ClientDependent true view
AbapCatalog.sqlViewName APS_BP view
EndUserText.label Business Partner view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner but000 partner
BusinessPartnerCategory but000 type
BusinessPartnerUUID but000 partner_guid
BusinessPartnerName but000 name1_text
FirstName but000 name_first
LastName but000 name_last 
@ClientDependent: true
@AbapCatalog.sqlViewName: 'APS_BP'
@EndUserText.label: 'Business Partner'

// SAP_BASIS representation of the VDM CDS view "I_BusinessPartner".

define view APS_BP_DDL as select from but000
    { 
      // Fields valid for all types of business partner

      key   but000.partner                        as BusinessPartner
        ,   but000.type                           as BusinessPartnerCategory
        ,   but000.partner_guid                   as BusinessPartnerUUID
        ,   but000.name1_text                     as BusinessPartnerName
        
      // Fields valid only for but000.type = '1' -- Person

        ,  but000.name_first as FirstName
        ,  but000.name_last  as LastName
}

Learn More