I_CACORRESPONDENCEHEADER
Korrespondenzkopf
I_CACORRESPONDENCEHEADER is a CDS View in S/4HANA. Korrespondenzkopf. It contains 7 fields. 6 CDS views read from this table.
CDS Views using this table (6)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_CABillPrntInvcgHdrCorrespnc | view | from | CONSUMPTION | Fakt.beleg mit Korrespondenzauftrag |
| C_CACorrespondenceHdrEmail | view | from | CONSUMPTION | Kopfdaten Korrespondenz für Email |
| C_CAInvcgDocPrintReceiver | view_entity | from | CONSUMPTION | Rechnungsempfänger |
| I_CAReturnNoticeHeader | view | inner | COMPOSITE | Output Management - Return Notice Header |
| P_CAInterestNoticeDupHeader | view | from | COMPOSITE | |
| P_CASecDepCorrDupHeader | view | from | COMPOSITE |
Fields (7)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | BusinessPartner | BusinessPartner | 1 |
| KEY | CACorrespondence | CACorrespondence | 1 |
| KEY | ContractAccount | ContractAccount | 1 |
| CAContract | CAContract | 1 | |
| CACorrespondenceType | CACorrespondenceType | 1 | |
| CompanyCode | CompanyCode | 1 | |
| CorrespondenceIssueDate | CorrespondenceIssueDate | 1 |
@EndUserText.label: 'Korrespondenzkopf'
@VDM.viewType: #BASIC
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@AbapCatalog.sqlViewName: 'ICACORRESPNCHEAD'
define view I_CACorrespondenceHeader as select from dfkkcoh
association [1..1] to I_CACorrespondenceType as _CorrespncType on $projection.CACorrespondenceType = _CorrespncType.CACorrespondenceType
association [1..1] to I_CACorrespondenceTypeText as _CorrespncTypeT on $projection.CACorrespondenceType = _CorrespncTypeT.CACorrespondenceType
and $projection.Language = _CorrespncTypeT.Language
association [1..1] to I_ContractAccountHeader as _ContrAcc on $projection.ContractAccount = _ContrAcc.ContractAccount
association [1..1] to I_ContractAccountPartner as _CAPartner on $projection.BusinessPartner = _CAPartner.BusinessPartner
and $projection.ContractAccount = _CAPartner.ContractAccount
association [0..1] to I_CAProviderContractHeader as _ProviderContract on $projection.CASubApplication = 'P'
and $projection.CAContract = _ProviderContract.CAProviderContract
association [1..1] to I_BusinessPartner as _BusinessPartner on $projection.BusinessPartner = _BusinessPartner.BusinessPartner
// association [1..1] to I_CAContractPartner as _BusinessPartner on $projection.BusinessPartner = _BusinessPartner.BusinessPartner
association [1..1] to I_CAContractPartner as _OriglCorrespncRcpnt on $projection.OriglCorrespondenceRecipient = _OriglCorrespncRcpnt.BusinessPartner
association [1..1] to I_CompanyCode as _CompCode on $projection.CompanyCode = _CompCode.CompanyCode
{
@ObjectModel.foreignKey.association: '_CorrespncType'
key cotyp as CACorrespondenceType,
key cokey as CACorrespondence,
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_ContractAccountHeaderStdVH',
element: 'ContractAccount' }
}]
@ObjectModel.foreignKey.association: '_ContrAcc'
cast(cast(vkont as abap.char(12)) as corr_vkont_kk) as ContractAccount,
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_BusinessPartnerVH',
element: 'BusinessPartner' }
}]
@ObjectModel.foreignKey.association: '_BusinessPartner'
// cast(cast(gpart as abap.char(10)) as /scdl/dl_partyno) as BusinessPartner,
cast(gpart as bu_partner) as BusinessPartner,
@ObjectModel.foreignKey.association: '_OriglCorrespncRcpnt'
org_gpart as OriglCorrespondenceRecipient,
cast(cast(vtref as abap.char(20)) as vtref_kk) as CAContract,
subap as CASubApplication,
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_CompanyCodeStdVH',
element: 'CompanyCode' }
}]
@ObjectModel.foreignKey.association: '_CompCode'
bukrs as CompanyCode,
aadrnr as CACorrespncSenderAddressID,
cast(cast(uname as abap.char(12)) as fclm_bam_created_by) as CreatedByUser,
cast(cast(cdate as abap.dats) as fis_cpdat) as CreationDate,
cast(cast(ctime as abap.tims) as ttet_dt_cr_time) as CreationTime,
copri as CorrespondencePrintDate,
coidt as CorrespondenceIssueDate,
coitm as CorrespondenceIssueTime,
cast(salwa as waers) as Currency,
@Semantics.amount.currencyCode: 'Currency'
cast(salbe as betrh_kk) as CAAmountInLocalCurrency,
cast(laufd as laufd_kk) as CAMassRunDate,
cast(laufi as laufi_kk) as CAMassRunID,
spras as Language,
adrnr as BusinessPartnerAddressID,
persnumber as PersonNumber,
entid1 as Correspondence1stEntityIdn,
data1 as Correspondence1stEntityData,
entid2 as Correspondence2ndEntityIdn,
data2 as Correspondence2ndEntityData,
entid3 as Correspondence3rdEntityIdn,
data3 as Correspondence3rdEntityData,
entid4 as Correspondence4thEntityIdn,
data4 as Correspondence4thEntityData,
_CorrespncType,
_CorrespncTypeT,
_ContrAcc,
_CAPartner,
_ProviderContract,
_BusinessPartner,
_OriglCorrespncRcpnt,
_CompCode
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DFKKCOH"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNER",
"I_CACONTRACTPARTNER",
"I_CACORRESPONDENCETYPE",
"I_CACORRESPONDENCETYPETEXT",
"I_CAPROVIDERCONTRACTHEADER",
"I_COMPANYCODE",
"I_CONTRACTACCOUNTHEADER",
"I_CONTRACTACCOUNTPARTNER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/