A_Customer

DDL: A_CUSTOMER SQL: ACUSTOMER Type: view BASIC Package: ODATA_MASTER_DATA_BP

Customer

A_Customer is a Basic CDS View that provides data about "Customer" in SAP S/4HANA. It reads from 1 data source (I_Customer) and exposes 73 fields with key field Customer. It has 9 associations to related views. Part of development package ODATA_MASTER_DATA_BP.

1 data source(s) 73 fields

Data Sources (1)

SourceAliasJoin Type
I_Customer I_Customer from

Associations (9)

CardinalityTargetAliasCondition
[0..1] E_Customer _CustomerExtension $projection.Customer = _CustomerExtension.Customer
[0..*] A_CustomerSalesArea _CustomerSalesArea $projection.Customer = _CustomerSalesArea.Customer
[0..*] A_CustomerCompany _CustomerCompany $projection.Customer = _CustomerCompany.Customer
[0..*] A_CustomerText _CustomerText $projection.Customer = _CustomerText.Customer
[0..*] A_CustomerTaxGrouping _CustomerTaxGrouping $projection.Customer = _CustomerTaxGrouping.Customer
[0..*] A_CustAddrDepdntInformation _CustAddrDepdntInformation $projection.Customer = _CustAddrDepdntInformation.Customer
[0..*] A_CustomerUnloadingPoint _CustomerUnloadingPoint $projection.Customer = _CustomerUnloadingPoint.Customer
[0..*] A_CustUnldgPtAddrDepdntInfo _CustUnldgPtAddrDepdntInfo $projection.Customer = _CustUnldgPtAddrDepdntInfo.Customer
[0..*] A_CustAddrDepdntExtIdentifier _CustAddrDepdntExtIdentifier $projection.Customer = _CustAddrDepdntExtIdentifier.Customer

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName ACUSTOMER view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Customer view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.updateEnabled true view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view

Fields (73)

KeyFieldSource TableSource FieldDescription
KEY Customer Customer
AuthorizationGroup AuthorizationGroup
BillingIsBlockedForCustomer BillingIsBlockedForCustomer
CreatedByUser CreatedByUser
CreationDate CreationDate
CustomerAccountGroup CustomerAccountGroup
CustomerClassification CustomerClassification
CustomerFullName CustomerFullName
BPCustomerFullName BPCustomerFullName
CustomerName CustomerName
BPCustomerName BPCustomerName
DeliveryIsBlocked DeliveryIsBlocked
FreeDefinedAttribute01 FreeDefinedAttribute01
FreeDefinedAttribute02 FreeDefinedAttribute02
FreeDefinedAttribute03 FreeDefinedAttribute03
FreeDefinedAttribute04 FreeDefinedAttribute04
FreeDefinedAttribute05 FreeDefinedAttribute05
FreeDefinedAttribute06 FreeDefinedAttribute06
FreeDefinedAttribute07 FreeDefinedAttribute07
FreeDefinedAttribute08 FreeDefinedAttribute08
FreeDefinedAttribute09 FreeDefinedAttribute09
FreeDefinedAttribute10 FreeDefinedAttribute10
NFPartnerIsNaturalPerson NFPartnerIsNaturalPerson
OrderIsBlockedForCustomer OrderIsBlockedForCustomer
PostingIsBlocked PostingIsBlocked
Supplier Supplier
CustomerCorporateGroup CustomerCorporateGroup
FiscalAddress FiscalAddress
Industry Industry
IndustryCode1 IndustryCode1
IndustryCode2 IndustryCode2
IndustryCode3 IndustryCode3
IndustryCode4 IndustryCode4
IndustryCode5 IndustryCode5
InternationalLocationNumber1 InternationalLocationNumber1
InternationalLocationNumber2 InternationalLocationNumber2
InternationalLocationNumber3 InternationalLocationNumber3
NielsenRegion NielsenRegion
PaymentReason PaymentReason
ResponsibleType ResponsibleType
TaxNumber1 TaxNumber1
TaxNumber2 TaxNumber2
TaxNumber3 TaxNumber3
TaxNumber4 TaxNumber4
TaxNumber5 TaxNumber5
TaxNumberType TaxNumberType
VATRegistration VATRegistration
DeletionIndicator DeletionIndicator
ExpressTrainStationName ExpressTrainStationName
TrainStationName TrainStationName
CityCode CityCode
County County
IsBusinessPurposeCompleted IsBusinessPurposeCompleted
DataControllerSet DataControllerSet
DataController1 DataController1
DataController2 DataController2
DataController3 DataController3
DataController4 DataController4
DataController5 DataController5
DataController6 DataController6
DataController7 DataController7
DataController8 DataController8
DataController9 DataController9
DataController10 DataController10
BR_ICMSTaxPayerType BR_ICMSTaxPayerType
_CustomerSalesArea _CustomerSalesArea
_CustomerCompany _CustomerCompany
_CustomerText _CustomerText
_CustomerTaxGrouping _CustomerTaxGrouping
_CustAddrDepdntInformation _CustAddrDepdntInformation
_CustomerUnloadingPoint _CustomerUnloadingPoint
_CustUnldgPtAddrDepdntInfo _CustUnldgPtAddrDepdntInfo
_CustAddrDepdntExtIdentifier _CustAddrDepdntExtIdentifier 
@AbapCatalog.sqlViewName: 'ACUSTOMER'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck:#MANDATORY
@AccessControl.personalData.blocking: #REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations:true
@EndUserText.label: 'Customer'
@VDM.viewType: #BASIC
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MASTER
//@ObjectModel.createEnabled:true

@ObjectModel.updateEnabled:true
//@ObjectModel.deleteEnabled:true 

@VDM.lifecycle.contract.type:#PUBLIC_REMOTE_API
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]

define view A_Customer as select from I_Customer

  association [0..1] to E_Customer as _CustomerExtension on $projection.Customer = _CustomerExtension.Customer

  association [0..*] to A_CustomerSalesArea as _CustomerSalesArea on $projection.Customer = _CustomerSalesArea.Customer

  association [0..*] to A_CustomerCompany as _CustomerCompany on $projection.Customer = _CustomerCompany.Customer

  association [0..*] to A_CustomerText as _CustomerText on $projection.Customer = _CustomerText.Customer

  association [0..*] to A_CustomerTaxGrouping as _CustomerTaxGrouping on $projection.Customer = _CustomerTaxGrouping.Customer

  association [0..*] to A_CustAddrDepdntInformation as _CustAddrDepdntInformation on $projection.Customer = _CustAddrDepdntInformation.Customer
  
  association [0..*] to A_CustomerUnloadingPoint as _CustomerUnloadingPoint on $projection.Customer = _CustomerUnloadingPoint.Customer

  association [0..*] to A_CustUnldgPtAddrDepdntInfo as _CustUnldgPtAddrDepdntInfo on $projection.Customer = _CustUnldgPtAddrDepdntInfo.Customer

  association [0..*] to A_CustAddrDepdntExtIdentifier as _CustAddrDepdntExtIdentifier on $projection.Customer = _CustAddrDepdntExtIdentifier.Customer

{
  key Customer,
      AuthorizationGroup, 
      BillingIsBlockedForCustomer, 
      @ObjectModel.readOnly: true
      CreatedByUser, 
      @ObjectModel.readOnly: true
      CreationDate,  
      CustomerAccountGroup, 
      CustomerClassification, 
      @ObjectModel.readOnly: true
      CustomerFullName, 
      @ObjectModel.readOnly: true
      BPCustomerFullName,
      @ObjectModel.readOnly: true
      CustomerName,
      @ObjectModel.readOnly: true
      BPCustomerName, 
      DeliveryIsBlocked,  
      FreeDefinedAttribute01,
      FreeDefinedAttribute02,
      FreeDefinedAttribute03,
      FreeDefinedAttribute04,
      FreeDefinedAttribute05,
      FreeDefinedAttribute06,
      FreeDefinedAttribute07,
      FreeDefinedAttribute08,
      FreeDefinedAttribute09,
      FreeDefinedAttribute10,
      @ObjectModel.readOnly: true
      NFPartnerIsNaturalPerson, 
      OrderIsBlockedForCustomer, 
      PostingIsBlocked,
      Supplier, 
      CustomerCorporateGroup, 
      FiscalAddress, 
      @ObjectModel.readOnly: true
      Industry,   
      IndustryCode1, 
      IndustryCode2, 
      IndustryCode3, 
      IndustryCode4, 
      IndustryCode5, 
      @ObjectModel.readOnly: true
      InternationalLocationNumber1, 
      @ObjectModel.readOnly: true
      InternationalLocationNumber2,
      @ObjectModel.readOnly: true
      InternationalLocationNumber3,
      NielsenRegion,  
      PaymentReason,
      ResponsibleType, 
      @ObjectModel.readOnly: true
      TaxNumber1, 
      @ObjectModel.readOnly: true
      TaxNumber2, 
      @ObjectModel.readOnly: true
      TaxNumber3, 
      @ObjectModel.readOnly: true
      TaxNumber4, 
      @ObjectModel.readOnly: true
      TaxNumber5, 
      TaxNumberType, 
      @ObjectModel.readOnly: true
      VATRegistration,
      DeletionIndicator,
      ExpressTrainStationName,
      TrainStationName,
      CityCode,
      County,
      @Consumption.hidden: true
      IsBusinessPurposeCompleted,
      @Consumption.hidden:true
      DataControllerSet,
      @Consumption.hidden:true
      DataController1,
      @Consumption.hidden:true
      DataController2,
      @Consumption.hidden:true
      DataController3,
      @Consumption.hidden:true
      DataController4,
      @Consumption.hidden:true
      DataController5,
      @Consumption.hidden:true
      DataController6,
      @Consumption.hidden:true
      DataController7,
      @Consumption.hidden:true
      DataController8,
      @Consumption.hidden:true
      DataController9,
      @Consumption.hidden:true
      DataController10,  
      @Feature: 'FI_LO_BR_ICMSTYPE_BP'
      BR_ICMSTaxPayerType,
      _CustomerSalesArea,
      _CustomerCompany,
      _CustomerText,
      _CustomerTaxGrouping,
      _CustAddrDepdntInformation,
      _CustomerUnloadingPoint,
      _CustUnldgPtAddrDepdntInfo,
      _CustAddrDepdntExtIdentifier
}

Learn More