C_BPCustDepartmentAddrDepdnt

DDL: C_BPCUSTDEPARTMENTADDRDEPDNT SQL: CCUSDEPADRDDEP Type: view CONSUMPTION

Cview for addrdep custdep

C_BPCustDepartmentAddrDepdnt is a Consumption CDS View that provides data about "Cview for addrdep custdep" in SAP S/4HANA. It reads from 1 data source (I_BPCustDeptAddrDepdntInfoTP) and exposes 21 fields with key fields Customer, AddressID, BusinessPartner, CustomerDepartment. It has 6 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_BPCustDeptAddrDepdntInfoTP BPCustDeptAddrDepdntInfoTP from

Associations (6)

CardinalityTargetAliasCondition
[1..1] C_BusinessPartnerCustomer _BusinessPartnerCustomer $projection.BusinessPartner = _BusinessPartnerCustomer.BusinessPartner
[1..1] C_BusinessPartner _BusinessPartner $projection.BusinessPartner = _BusinessPartner.BusinessPartner
[0..*] I_ContactPersonStdDepartmentT _ContactPersonStdDepartmentT $projection.CustomerDepartmentForEdit = _ContactPersonStdDepartmentT.ContactPersonStdDepartment
[0..*] I_UnitOfMeasureText _UnitOfMeasureText $projection.RetailLocationSellingAreaUnit = _UnitOfMeasureText.UnitOfMeasure
[0..*] I_RetailLayoutText _RetailLayoutText $projection.DepartmentLayout = _RetailLayoutText.RetailLayout
[0..*] I_RetailAreaSchemaText _RetailAreaSchemaText $projection.DepartmentLayoutAreaSchema = _RetailAreaSchemaText.RetailLayoutAreaSchema

Annotations (20)

NameValueLevelField
AbapCatalog.sqlViewName CCUSDEPADRDDEP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Cview for addrdep custdep view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #NOT_REQUIRED view
Metadata.allowExtensions true view
ObjectModel.type #CONSUMPTION view
ObjectModel.writeEnabled true view
ObjectModel.text.control #ASSOCIATED_TEXT_UI_HIDDEN view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
Search.searchable true view
VDM.viewType #CONSUMPTION view
UI.headerInfo.typeName Address-Dependent Department view
UI.headerInfo.typeNamePlural Address-Dependent Departments view
UI.headerInfo.title.label Address-Dependent Department view
UI.headerInfo.title.value Address-Dependent Department view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY Customer Customer
KEY AddressID AddressID
KEY BusinessPartner BusinessPartner
KEY CustomerDepartment CustomerDepartment
AddressIDForEdit AddressIDForEdit
CustomerForEdit CustomerForEdit
CustomerDepartmentForEdit CustomerDepartmentForEdit
ReceivingPoint ReceivingPoint
RetailLocationSellingAreaSize RetailLocationSellingAreaSize
RetailLocationSellingAreaUnit RetailLocationSellingAreaUnit
DepartmentLayout DepartmentLayout
DepartmentLayoutAreaSchema DepartmentLayoutAreaSchema
BusinessPartnerForEdit BusinessPartnerForEdit
FormattedAddress FormattedAddress
_Customer _Customer
_BusinessPartnerCustomer _BusinessPartnerCustomer
_BusinessPartner _BusinessPartner
_ContactPersonStdDepartmentT _ContactPersonStdDepartmentT
_UnitOfMeasureText _UnitOfMeasureText
_RetailLayoutText _RetailLayoutText
_RetailAreaSchemaText _RetailAreaSchemaText
@AbapCatalog.sqlViewName: 'CCUSDEPADRDDEP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Cview for addrdep custdep'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #NOT_REQUIRED
@Metadata.allowExtensions: true
@ObjectModel.type: #CONSUMPTION
@ObjectModel.writeEnabled: true
@ObjectModel: {
    semanticKey: ['Customer', 'AddressIDForEdit', 'BusinessPartner', 'CustomerDepartmentForEdit'],
    createEnabled,
    updateEnabled,
    deleteEnabled,
    text.control: #ASSOCIATED_TEXT_UI_HIDDEN //texts will be shown together with the Code values. if the Code values are hidden, then texts wont be visible in UI.  no independent visibility for text fields

}
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MASTER

@Search.searchable: true


@VDM.viewType: #CONSUMPTION
@UI.headerInfo:{
 typeName: 'Address-Dependent  Department',
 typeNamePlural: 'Address-Dependent Departments',
 title:  { label: 'Address-Dependent Department', value: 'Address-Dependent Department'}
}


define view C_BPCustDepartmentAddrDepdnt
  as select from I_BPCustDeptAddrDepdntInfoTP as BPCustDeptAddrDepdntInfoTP

  association [1..1] to C_BusinessPartnerCustomer     as _BusinessPartnerCustomer     on $projection.BusinessPartner = _BusinessPartnerCustomer.BusinessPartner

  association [1..1] to C_BusinessPartner             as _BusinessPartner             on $projection.BusinessPartner = _BusinessPartner.BusinessPartner

  association [0..*] to I_ContactPersonStdDepartmentT as _ContactPersonStdDepartmentT on $projection.CustomerDepartmentForEdit = _ContactPersonStdDepartmentT.ContactPersonStdDepartment

  association [0..*] to I_UnitOfMeasureText           as _UnitOfMeasureText           on $projection.RetailLocationSellingAreaUnit = _UnitOfMeasureText.UnitOfMeasure

  association [0..*] to I_RetailLayoutText            as _RetailLayoutText            on $projection.DepartmentLayout = _RetailLayoutText.RetailLayout

  association [0..*] to I_RetailAreaSchemaText        as _RetailAreaSchemaText        on $projection.DepartmentLayoutAreaSchema = _RetailAreaSchemaText.RetailLayoutAreaSchema

{

  key Customer,
  key AddressID,
  key BusinessPartner,
  key CustomerDepartment,
      AddressIDForEdit,
      CustomerForEdit,
      @ObjectModel.text.association: '_ContactPersonStdDepartmentT'
      CustomerDepartmentForEdit,
      ReceivingPoint,
      RetailLocationSellingAreaSize,
      @ObjectModel.text.association: '_UnitOfMeasureText'
      RetailLocationSellingAreaUnit,
      @ObjectModel.text.association: '_RetailLayoutText'
      DepartmentLayout,
      @ObjectModel.text.association: '_RetailAreaSchemaText'
      DepartmentLayoutAreaSchema,
      BusinessPartnerForEdit,
      FormattedAddress,
      /* Associations */

      _Customer,
      @ObjectModel.association.type:  [ #TO_COMPOSITION_ROOT , #TO_COMPOSITION_PARENT ]
      _BusinessPartnerCustomer,
      @ObjectModel.association.type:  [ #TO_COMPOSITION_ROOT , #TO_COMPOSITION_PARENT ]
      _BusinessPartner,

      _ContactPersonStdDepartmentT,
      _UnitOfMeasureText,
      _RetailLayoutText,
      _RetailAreaSchemaText
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BPCUSTDEPTADDRDEPDNTINFOTP"
],
"ASSOCIATED":
[
"C_BUSINESSPARTNER",
"C_BUSINESSPARTNERCUSTOMER",
"I_CONTACTPERSONSTDDEPARTMENTT",
"I_CUSTOMER",
"I_RETAILAREASCHEMATEXT",
"I_RETAILLAYOUTTEXT",
"I_UNITOFMEASURETEXT"
],
"BASE":
[
"I_BPCUSTDEPTADDRDEPDNTINFOTP"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/