C_CustomerCompanyCodeOP

DDL: C_CUSTOMERCOMPANYCODEOP SQL: CCUSTCCODEOP Type: view CONSUMPTION

Customer Company Code Fact Sheet

C_CustomerCompanyCodeOP is a Consumption CDS View that provides data about "Customer Company Code Fact Sheet" in SAP S/4HANA. It reads from 1 data source (I_CustomerCompany) and exposes 21 fields with key fields Customer, CompanyCode. It has 5 associations to related views.

1 data source(s) 21 fields

Data Sources (1)

SourceAliasJoin Type
I_CustomerCompany CustomerCompany from

Associations (5)

CardinalityTargetAliasCondition
[0..1] I_CompanyCode _CompanyCodeValueHelp $projection.CompanyCode = _CompanyCodeValueHelp.CompanyCode
[0..1] I_AccountingClerk _AccountingClerkValueHelp $projection.AccountingClerk = _AccountingClerkValueHelp.AccountingClerk and $projection.CompanyCode = _AccountingClerkValueHelp.CompanyCode
[0..1] C_Custrecnclnacctvhtemp _RecnclnAcctValueHelp $projection.ReconciliationAccount = _RecnclnAcctValueHelp.ReconciliationAccount and $projection.CompanyCode = _RecnclnAcctValueHelp.CompanyCode
[0..1] I_PaymentBlockingReason _PaymentBlockValueHelp $projection.PaymentBlockingReason = _PaymentBlockValueHelp.PaymentBlockingReason
[0..1] I_CustomerDunning _CustomerDunning $projection.Customer = _CustomerDunning.Customer and $projection.CompanyCode = _CustomerDunning.CompanyCode and _CustomerDunning.DunningArea = ''

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CCUSTCCODEOP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Customer Company Code Fact Sheet view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #CONSUMPTION view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY Customer I_CustomerCompany Customer
KEY CompanyCode I_CustomerCompany CompanyCode
AuthorizationGroup I_CustomerCompany AuthorizationGroup
AccountingClerk I_CustomerCompany AccountingClerk
ReconciliationAccount I_CustomerCompany ReconciliationAccount
PaymentBlockingReason I_CustomerCompany PaymentBlockingReason
LastDunnedOn _CustomerDunning LastDunnedOn
DunningProcedure _CustomerDunning DunningProcedure
DunningLevel _CustomerDunning DunningLevel
DunningBlock _CustomerDunning DunningBlock
DunningRecipient _CustomerDunning DunningRecipient
LegDunningProcedureOn _CustomerDunning LegDunningProcedureOn
IsBusinessPurposeCompleted IsBusinessPurposeCompleted
CustomerName _Customer CustomerName
BPCustomerName _Customer BPCustomerName
_CustomerDunning _CustomerDunning
_Customer _Customer
_CompanyCodeValueHelp _CompanyCodeValueHelp
_AccountingClerkValueHelp _AccountingClerkValueHelp
_RecnclnAcctValueHelp _RecnclnAcctValueHelp
_PaymentBlockValueHelp _PaymentBlockValueHelp 
@AbapCatalog.sqlViewName: 'CCUSTCCODEOP'
@AbapCatalog.compiler.compareFilter: true

@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED

@EndUserText.label: 'Customer Company Code Fact Sheet'

@Metadata.allowExtensions: true

@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MASTER

@VDM.viewType: #CONSUMPTION

define view C_CustomerCompanyCodeOP
  as select from I_CustomerCompany as CustomerCompany

  association [0..1] to I_CompanyCode           as _CompanyCodeValueHelp     on  $projection.CompanyCode = _CompanyCodeValueHelp.CompanyCode
  association [0..1] to I_AccountingClerk       as _AccountingClerkValueHelp on  $projection.AccountingClerk = _AccountingClerkValueHelp.AccountingClerk
                                                                             and $projection.CompanyCode     = _AccountingClerkValueHelp.CompanyCode
  association [0..1] to C_Custrecnclnacctvhtemp as _RecnclnAcctValueHelp     on  $projection.ReconciliationAccount = _RecnclnAcctValueHelp.ReconciliationAccount
                                                                             and $projection.CompanyCode           = _RecnclnAcctValueHelp.CompanyCode
  association [0..1] to I_PaymentBlockingReason as _PaymentBlockValueHelp    on  $projection.PaymentBlockingReason = _PaymentBlockValueHelp.PaymentBlockingReason
  association [0..1] to I_CustomerDunning       as _CustomerDunning          on  $projection.Customer         = _CustomerDunning.Customer
                                                                             and $projection.CompanyCode      = _CustomerDunning.CompanyCode
                                                                             and _CustomerDunning.DunningArea = ''

{
  key CustomerCompany.Customer,      
      @ObjectModel.foreignKey.association: '_CompanyCodeValueHelp'
  key CustomerCompany.CompanyCode,      
      CustomerCompany.AuthorizationGroup,
      @ObjectModel.foreignKey.association: '_AccountingClerkValueHelp'
      CustomerCompany.AccountingClerk,
      @ObjectModel.foreignKey.association: '_RecnclnAcctValueHelp'
      CustomerCompany.ReconciliationAccount,      
      @ObjectModel.foreignKey.association: '_PaymentBlockValueHelp'      
      CustomerCompany.PaymentBlockingReason,
      _CustomerDunning.LastDunnedOn,
      _CustomerDunning.DunningProcedure,
      _CustomerDunning.DunningLevel,      
      _CustomerDunning.DunningBlock,
      _CustomerDunning.DunningRecipient,
      _CustomerDunning.LegDunningProcedureOn,  
      IsBusinessPurposeCompleted, 
      _Customer.CustomerName,
      @UI.hidden: true  
      _Customer.BPCustomerName,
           
      _CustomerDunning,
      _Customer,
      _CompanyCodeValueHelp,
      _AccountingClerkValueHelp,
      _RecnclnAcctValueHelp,
      _PaymentBlockValueHelp

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CUSTOMER",
"I_CUSTOMERCOMPANY",
"I_CUSTOMERDUNNING"
],
"ASSOCIATED":
[
"C_CUSTRECNCLNACCTVHTEMP",
"I_ACCOUNTINGCLERK",
"I_COMPANYCODE",
"I_CUSTOMER",
"I_CUSTOMERDUNNING",
"I_PAYMENTBLOCKINGREASON"
],
"BASE":
[
"I_CUSTOMERCOMPANY"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More