SDM_GLO_RO_ROFI_BPTY_BPNUM

DDL: SDM_GLO_RO_ROFI_BPTY_BPNUM Type: view_entity Package: GLO_FIN_IS_SAFT_RO

SDM View for ROFI_BPTY - Romania

SDM_GLO_RO_ROFI_BPTY_BPNUM is a CDS View that provides data about "SDM View for ROFI_BPTY - Romania" in SAP S/4HANA. It reads from 4 data sources (/ceecv/rofi_bpty, /ceecv/rofi_bpty, I_Customer, I_Supplier) and exposes 8 fields with key fields BusinessPartner, CustVendNum, BPType, BusinessPartner, CustVendNum. Part of development package GLO_FIN_IS_SAFT_RO.

4 data source(s) 8 fields

Data Sources (4)

SourceAliasJoin Type
/ceecv/rofi_bpty bpty from
/ceecv/rofi_bpty bpty union_all
I_Customer Customer inner
I_Supplier Supplier inner

Parameters (1)

NameTypeDefault
p_keydate syst_datum

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_ALLOWED view
Metadata.ignorePropagatedAnnotations true view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label SDM View for ROFI_BPTY - Romania view

Fields (8)

KeyFieldSource TableSource FieldDescription
mandt
KEY BusinessPartner
KEY CustVendNum /ceecv/rofi_bpty bpnum
KEY BPType /ceecv/rofi_bpty bptype
KEY BusinessPartner
KEY CustVendNum /ceecv/rofi_bpty bpnum
KEY BPType /ceecv/rofi_bpty bptype
taxnum /ceecv/rofi_bpty stceg 
@AccessControl.authorizationCheck: #NOT_ALLOWED
@Metadata.ignorePropagatedAnnotations: true
@AccessControl.personalData.blocking: #BLOCKED_DATA_INCLUDED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@EndUserText.label: 'SDM View for ROFI_BPTY - Romania'
define view entity SDM_GLO_RO_ROFI_BPTY_BPNUM
with parameters
    @Environment.systemField : #SYSTEM_DATE
    p_keydate : syst_datum

  as select from /ceecv/rofi_bpty as bpty
    inner join   I_Supplier as Supplier on Supplier.Supplier = bpty.bpnum

{
      --mandt as mandt,
  key Supplier._SupplierToBusinessPartner._BusinessPartner.BusinessPartner,
  key bpty.bpnum  as CustVendNum,
  key bpty.bptype as BPType,
      bpty.stceg  as taxnum

}
where
      bpty.valid_fr <= $parameters.p_keydate
  and bpty.valid_to >= $parameters.p_keydate
  and (bpty.taxtype  = '6' or bpty.taxtype  = '7')
  and bpty.bptype   = 'K'
union all select from /ceecv/rofi_bpty as bpty
  inner join          I_Customer as Customer on Customer.Customer = bpty.bpnum

{
      --mandt as mandt,
  key Customer._CustomerToBusinessPartner._BusinessPartner.BusinessPartner,
  key bpty.bpnum  as CustVendNum,
  key bpty.bptype as BPType,
      bpty.stceg  as taxnum

}
where
      bpty.valid_fr <= $parameters.p_keydate
  and bpty.valid_to >= $parameters.p_keydate
  and (bpty.taxtype  = '6' or bpty.taxtype  = '7')
  and bpty.bptype   = 'D'

Learn More