C_SDDocumentCustomer

DDL: C_SDDOCUMENTCUSTOMER SQL: CSDDOCCUST Type: view CONSUMPTION Package: ODATA_SD_RETURN_V2

Business Partners

C_SDDocumentCustomer is a Consumption CDS View that provides data about "Business Partners" in SAP S/4HANA. It reads from 1 data source (I_SDDocumentCustomer) and exposes 16 fields with key fields SDDocument, PartnerFunction. It has 3 associations to related views. Part of development package ODATA_SD_RETURN_V2.

1 data source(s) 16 fields

Data Sources (1)

SourceAliasJoin Type
I_SDDocumentCustomer SDDocumentCustomer from

Associations (3)

CardinalityTargetAliasCondition
[0..*] I_PartnerFunctionText _PartnerFunctionText $projection.PartnerFunction = _PartnerFunctionText.PartnerFunction
[0..1] I_Customer _Customer $projection.Customer = _Customer.Customer
[0..1] I_SalesDocumentBasic _SalesDocument $projection.SDDocument = _SalesDocument.SalesDocument

Annotations (9)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName CSDDOCCUST view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #CONSUMPTION view
EndUserText.label Business Partners view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY SDDocument I_SDDocumentCustomer SDDocument
KEY PartnerFunction I_SDDocumentCustomer PartnerFunction
Customer I_SDDocumentCustomer Customer
CustomerName
HouseNumber
HouseNumberSupplementText
StreetName
PostalCode
CityName
Country
SalesDocumentType _SalesDocument SalesDocumentType
SalesOrganization _SalesDocument SalesOrganization
DistributionChannel _SalesDocument DistributionChannel
OrganizationDivision _SalesDocument OrganizationDivision
_PartnerFunctionText _PartnerFunctionText
_Customer _Customer 
@ClientHandling.algorithm:#SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'CSDDOCCUST'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #('TRANSACTIONAL_DATA')
@VDM.viewType: #CONSUMPTION
@EndUserText.label: 'Business Partners'
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL

define view C_SDDocumentCustomer
  as select from  I_SDDocumentCustomer as SDDocumentCustomer
  //as select from I_CustomerReturnPartner as SDDocumentCustomer

// Associations  

  association [0..*] to I_PartnerFunctionText as _PartnerFunctionText on $projection.PartnerFunction = _PartnerFunctionText.PartnerFunction
  association [0..1] to I_Customer            as _Customer            on $projection.Customer = _Customer.Customer
  association [0..1] to I_SalesDocumentBasic  as _SalesDocument       on $projection.SDDocument = _SalesDocument.SalesDocument
{
      @UI.hidden: true
  key SDDocumentCustomer.SDDocument,
      @ObjectModel.text.association: '_PartnerFunctionText'
  key SDDocumentCustomer.PartnerFunction,
      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_Customer_VH',
                     element: 'Customer' }
        }]
      @ObjectModel.text.element:  [ 'CustomerName' ]
      SDDocumentCustomer.Customer,
      SDDocumentCustomer._DfltAddrRprstn.AddresseeFullName as CustomerName,
      SDDocumentCustomer._DfltAddrRprstn.HouseNumber,
      SDDocumentCustomer._DfltAddrRprstn.HouseNumberSupplementText,
      SDDocumentCustomer._DfltAddrRprstn.StreetName,
      SDDocumentCustomer._DfltAddrRprstn.PostalCode,
      SDDocumentCustomer._DfltAddrRprstn.CityName,
      SDDocumentCustomer._DfltAddrRprstn.Country,

      //For access control

      @Consumption.hidden: true
      @UI.hidden: true
      _SalesDocument.SalesDocumentType,
      @Consumption.hidden: true
      @UI.hidden: true
      _SalesDocument.SalesOrganization,
      @Consumption.hidden: true
      @UI.hidden: true
      _SalesDocument.DistributionChannel,
      @Consumption.hidden: true
      @UI.hidden: true
      _SalesDocument.OrganizationDivision,


      _PartnerFunctionText,
      _Customer
}

Learn More