P_CATransferredDocumentHeader

DDL: P_CATRANSFERREDDOCUMENTHEADER Type: view_entity COMPOSITE Package: FKK_ID_IL_REP

Trasferred document header

P_CATransferredDocumentHeader is a Composite CDS View that provides data about "Trasferred document header" in SAP S/4HANA. It reads from 1 data source (I_CADocument) and exposes 7 fields with key field CADocumentNumber. Part of development package FKK_ID_IL_REP.

Data Sources (1)

SourceAliasJoin Type
I_CADocument Header from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY CADocumentNumber I_CADocument CADocumentNumber
CADocumentType I_CADocument CADocumentType
DocumentDate I_CADocument DocumentDate
PostingDate I_CADocument CAPostingDate
TaxReportingDate I_CADocument TaxReportingDate
CAReferenceDocument I_CADocument CAReferenceDocument
IL_ElectronicDocOutgDocUnqID I_CADocument CA1stCountrySpecificReference
@AccessControl.authorizationCheck: #NOT_REQUIRED

@Metadata.ignorePropagatedAnnotations: true

@ObjectModel.usageType: { serviceQuality: #A, sizeCategory: #XL, dataClass: #TRANSACTIONAL }

@VDM.private: true
@VDM.viewType: #COMPOSITE

//this cds is called from DRC tool (IL_VAT_DCL) with 

//condition DocumentDate between (expected 1 month)

define view entity P_CATransferredDocumentHeader
  as select from           I_CADocument          as Header

    inner many to one join I_CAReconciliationKey as ReconKeyStatus on Header.CAReconciliationKey = ReconKeyStatus.CAReconciliationKey

{
  key Header.CADocumentNumber,

      Header.CADocumentType,

      Header.DocumentDate,
      Header.CAPostingDate                 as PostingDate,
      Header.TaxReportingDate,
      Header.CAReferenceDocument,
      Header.CA1stCountrySpecificReference as IL_ElectronicDocOutgDocUnqID
}

where ReconKeyStatus.CARecnclnKeyIsTransferredToGL = 'X'