C_SDDocumentCustomer

DDL: C_SDDOCUMENTCUSTOMER SQL: CSDDOCCUST Type: view CONSUMPTION

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_CustomerReturnPartner) and exposes 16 fields with key fields SDDocument, PartnerFunction. It has 2 associations to related views.

1 data source(s) 16 fields

Data Sources (1)

SourceAliasJoin Type
I_CustomerReturnPartner SDDocumentCustomer from

Associations (2)

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

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_CustomerReturnPartner CustomerReturn
KEY PartnerFunction I_CustomerReturnPartner PartnerFunction
Customer I_CustomerReturnPartner Customer
CustomerName
HouseNumber
HouseNumberSupplementText
StreetName
PostalCode
CityName
Country
CustomerReturnType _CustomerReturn CustomerReturnType
SalesOrganization _CustomerReturn SalesOrganization
DistributionChannel _CustomerReturn DistributionChannel
OrganizationDivision _CustomerReturn 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
{
      @UI.hidden: true
  key SDDocumentCustomer.CustomerReturn                    as SDDocument,
      @ObjectModel.text.association: '_PartnerFunctionText'
  key SDDocumentCustomer.PartnerFunction,
      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_Customer_VH',
                     element: 'Customer' }
        }]
      @ObjectModel.text.element:  [ 'CustomerName' ]
      SDDocumentCustomer.Customer,
      //      SDDocumentCustomer._Customer.CustomerName,

      //      SDDocumentCustomer._Address.HouseNumber,

      //      SDDocumentCustomer._Address.HouseNumberSupplementText,

      //      SDDocumentCustomer._Address.StreetName,

      //      SDDocumentCustomer._Address.PostalCode,

      //      SDDocumentCustomer._Address.CityName,

      //      SDDocumentCustomer._Address.Country,

      
      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
      _CustomerReturn.CustomerReturnType,
      @Consumption.hidden: true
      @UI.hidden: true
      _CustomerReturn.SalesOrganization,
      @Consumption.hidden: true
      @UI.hidden: true
      _CustomerReturn.DistributionChannel,
      @Consumption.hidden: true
      @UI.hidden: true
      _CustomerReturn.OrganizationDivision,

      _PartnerFunctionText,
      _Customer
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ADDRESS_2",
"I_CUSTOMERRETURN",
"I_CUSTOMERRETURNPARTNER"
],
"ASSOCIATED":
[
"I_CUSTOMER",
"I_PARTNERFUNCTIONTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More