I_LCMDOCUMENT
Document
I_LCMDOCUMENT is a CDS View in S/4HANA. Document. It contains 65 fields. 14 CDS views read from this table.
CDS Views using this table (14)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_LCMLegalTrDocument | view | from | CONSUMPTION | C view for Document in Lgl Transaction |
| C_LegalDocumentIntegFacet | view | left_outer | CONSUMPTION | Legal Document Integration Facet |
| C_LglCntntMDocLowTouchProcg | view | from | CONSUMPTION | Consumption View for Low Touch Document Processing |
| C_LglCntntMDocumentVersion | view | from | CONSUMPTION | C view for LCM Document Version |
| C_LglTransReqLglCntntDoc | view | from | CONSUMPTION | Document for Request Legal Content |
| ESH_N_LEGAL_DOCUMENT | view | from | Anchor view -LEGAL_DOCUMENT | |
| I_LcmDocumentTP | view | from | TRANSACTIONAL | TP View for Legal Document |
| I_LglCntntMCollabnDocFilter | view | right_outer | COMPOSITE | LCM of Doc Collab filter |
| I_LglCntntMDocAgeAnalysis | view | from | COMPOSITE | LCM Document Aging Analysis |
| I_LglCntntMDocContextInfo | view | from | COMPOSITE | Legal Document - Context Information |
| I_LglCntntMDocToBeAged | view | from | COMPOSITE | Document Aging Date |
| I_LglCntntMRefreshDocAgreement | view_entity | inner | COMPOSITE | Legal document Agreement refresh detail |
| I_LglDocCntntCopyFailedSitn | view | from | COMPOSITE | Document Content Copy Failure in Legal Document |
| R_LegalDocumentTP | view_entity | from | TRANSACTIONAL | Legal Document |
Fields (65)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | LegalTransaction | LegalTransaction | 5 |
| KEY | LegalTransactionUUID | LegalTransactionUUID | 6 |
| KEY | LglCntntMDocumentUUID | LglCntntMDocumentUUID | 8 |
| _AccessLvlText | _AccessLvlText | 1 | |
| _ContentTypeText | _ContentTypeText | 2 | |
| _DocAttach | _DocAttach | 1 | |
| _DocStatusText | _DocStatusText | 2 | |
| _DocSyncStatusText | _DocSyncStatusText | 1 | |
| _DocumentKindText | _DocumentKindText | 1 | |
| _LegalTransaction | _LegalTransaction | 3 | |
| _LglCntntMDocAmendmentTypeTxt | _LglCntntMDocAmendmentTypeTxt | 1 | |
| _LglCntntMDocAssemblyInfo | _LglCntntMDocAssemblyInfo | 1 | |
| _LglCntntMDocLowTouchLvlTxt | _LglCntntMDocLowTouchLvlTxt | 1 | |
| _LglCntntMDocPaperTypeTxt | _LglCntntMDocPaperTypeTxt | 1 | |
| _LglCntntMSgntrPreferenceText | _LglCntntMSgntrPreferenceText | 1 | |
| _SgntrDocStatusText | _SgntrDocStatusText | 1 | |
| DocumentDescription | DocumentDescription | 6 | |
| DocumentVersion | DocumentVersion | 1 | |
| InternalDocumentStatus | InternalDocumentStatus | 6 | |
| IsEndOfPurposeBlocked | IsEndOfPurposeBlocked | 4 | |
| LegalDocumentSource | LegalDocumentSource | 1 | |
| LegalDocumentVersion | LegalDocumentVersion | 2 | |
| LegalTransactionTitle | LegalTransactionTitle | 1 | |
| LglCntntMAgingTemperature | LglCntntMAgingTemperature | 2 | |
| LglCntntMChangedByUser | LglCntntMChangedByUser | 3 | |
| LglCntntMChangedUTCDateTime | LglCntntMChangedUTCDateTime | 6 | |
| LglCntntMCntxtDocUUID | LglCntntMCntxtDocUUID | 1 | |
| LglCntntMContextUUID | LglCntntMContextUUID | 1 | |
| LglCntntMCreatedByUser | LglCntntMCreatedByUser | 2 | |
| LglCntntMCreatedFromDocUUID | LglCntntMCreatedFromDocUUID | 2 | |
| LglCntntMCreatedUTCDateTime | LglCntntMCreatedUTCDateTime | 2 | |
| LglCntntMDocAccessLvl | LglCntntMDocAccessLvl | 3 | |
| LglCntntMDocAmendmentType | LglCntntMDocAmendmentType | 2 | |
| LglCntntMDocAssemblyStatus | LglCntntMDocAssemblyStatus | 2 | |
| LglCntntMDocContentType | LglCntntMDocCntntTypeFilter,LglCntntMDocContentType | 5 | |
| LglCntntMDocEffectiveFromDate | LglCntntMDocEffectiveFromDate | 2 | |
| LglCntntMDocIsToBeDeleted | LglCntntMDocIsToBeDeleted | 1 | |
| LglCntntMDocLockedReasonCode | LglCntntMDocLockedReasonCode | 1 | |
| LglCntntMDocLowTouchLevel | LglCntntMDocLowTouchLevel | 2 | |
| LglCntntMDocPaperType | LglCntntMDocPaperType | 2 | |
| LglCntntMDocReferenceNumber | LglCntntMDocReferenceNumber | 1 | |
| LglCntntMDocRefreshStatus | LglCntntMDocRefreshStatus | 3 | |
| LglCntntMDocStatusName | LglCntntMDocStatusName | 1 | |
| LglCntntMDocType | LglCntntMDocType | 5 | |
| LglCntntMDocument | LegalDocument,LegalDocumentMyInboxDisplay,LglCntntMDocument | 7 | |
| LglCntntMDocumentIsTopVersion | LglCntntMDocumentIsTopVersion | 3 | |
| LglCntntMDocumentKind | LglCntntMDocumentKind | 2 | |
| LglCntntMDocumentLinkedObject | LglCntntMDocumentLinkedObject | 5 | |
| LglCntntMDocumentLinkedObjKey | LglCntntMDocumentLinkedObjKey | 7 | |
| LglCntntMGovLaw | LglCntntMGovLaw | 2 | |
| LglCntntMIsMandatory | LglCntntMIsMandatory | 2 | |
| LglCntntMLanguage | LglCntntMLanguage | 4 | |
| LglCntntMLongText | LglCntntMLongText | 1 | |
| LglCntntMLongTextMimeType | LglCntntMLongTextMimeType | 1 | |
| LglCntntMLongTextUUID | LglCntntMLongTextUUID | 1 | |
| LglCntntMMainLinkdObjType | LglCntntMMainLinkdObjType | 1 | |
| LglCntntMMainLinkedObject | LglCntntMMainLinkedObject | 1 | |
| LglCntntMParentDocument | LglCntntMParentDocument | 2 | |
| LglCntntMProfile | LglCntntMProfile | 2 | |
| LglCntntMSgntrPreference | LglCntntMSgntrPreference | 3 | |
| LglCntntMSignatureDocStatus | LglCntntMSignatureDocStatus | 2 | |
| LglCntntMTmplUUID | LglCntntMTmplUUID | 4 | |
| LglCntntMVirtualDocSyncSts | LglCntntMVirtualDocSyncSts | 2 | |
| LglCntntMVirtualDocVersKey | LglCntntMVirtualDocVersKey | 4 | |
| mandt | mandt | 1 |
@AbapCatalog.sqlViewName: 'ILCMDOCUMENT'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck:#CHECK
@VDM.viewType : #COMPOSITE
@Metadata.ignorePropagatedAnnotations: true
@AccessControl.personalData.blocking: #REQUIRED
@AccessControl.privilegedAssociations: [ '_DocLock', '_CreatedBy', '_ChangedBy' ]
@ObjectModel: {
representativeKey: 'LglCntntMDocumentUUID',
usageType.serviceQuality: #C,
usageType.sizeCategory: #L,
usageType.dataClass: #TRANSACTIONAL
}
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@EndUserText.label: 'Document'
define view I_LcmDocument
as select from I_LegalDocument as Document
association [1..1] to I_LglCntntMDocStatus as _DocStatus on $projection.InternalDocumentStatus = _DocStatus.InternalDocumentStatus
// Doc Attachment
association [1..1] to I_LglCntntMDocInfoAttachment as _DocAttach on $projection.LglCntntMDocumentLinkedObjKey = _DocAttach.LinkedSAPObjectKey
association [1..1] to I_LcmContext as _Context on $projection.LglCntntMContextUUID = _Context.LglCntntMContextUUID
association [0..1] to Sgbt_Nte_Cds_Cont as _Note on _Note.noteid = $projection.LglCntntMLongTextUUID
and _Note.objectnodetype = 'LegalDocument'
and _Note.notetype = 'LCM_LONGTEXT'
association [0..1] to I_LglCntntMDocLock as _DocLock on $projection.LglCntntMDocumentUUID = _DocLock.LglCntntMDocumentUUID
and $projection.LglCntntMDocumentLinkedObjKey = _DocLock.LglCntntMDocumentLinkedObjKey
association [0..1] to I_LglCntntMAccessLvlText as _AccessLvlText on $projection.LglCntntMDocAccessLvl = _AccessLvlText.LglCntntMAccessLvl
and Language = $session.system_language
association [0..1] to I_LanguageText as _LanguageText on $projection.LglCntntMLanguage = _LanguageText.LanguageCode
and Language = $session.system_language
association [0..1] to I_LglCntntMDocContentTypeText as _ContentTypeText on $projection.LglCntntMDocContentType = _ContentTypeText.LglCntntMDocContentType
and Language = $session.system_language
association [0..1] to I_LglCntntMDocCntntTypeSrchTxt as _LglCntntMDocCntntTypeSrchTxt on $projection.LglCntntMDocContentType = _LglCntntMDocCntntTypeSrchTxt.LglCntntMDocContentType
and Language = $session.system_language
association [0..1] to I_LglCntntMDocStatusText as _DocStatusText on $projection.InternalDocumentStatus = _DocStatusText.InternalDocumentStatus
and Language = $session.system_language
association [0..1] to I_LglCntntMSgntrDocStatusText as _SgntrDocStatusText on $projection.LglCntntMSignatureDocStatus = _SgntrDocStatusText.LglCntntMSignatureDocStatus
and Language = $session.system_language
//association [0..1] to I_LglCntntMDocAssemblyStsText as _AssemblyStatusText on $projection.LglCntntMDocAssemblyStatus = _AssemblyStatusText.LglCntntMDocAssemblyStatus
// and Language = $session.system_language
association [0..1] to I_LglCntntMDocSyncStatusText as _DocSyncStatusText on $projection.LglCntntMVirtualDocSyncSts = _DocSyncStatusText.LglCntntMVirtualDocSyncSts
and Language = $session.system_language
association [0..1] to I_LglCntntMDocLowTouchLvlTxt as _LglCntntMDocLowTouchLvlTxt on $projection.LglCntntMDocLowTouchLevel = _LglCntntMDocLowTouchLvlTxt.LglCntntMDocLowTouchLevel
and Language = $session.system_language
association [0..1] to I_LglCntntMDocumentKindText as _DocumentKindText on $projection.LglCntntMDocumentKind = _DocumentKindText.LglCntntMDocumentKind
and _DocumentKindText.Language = $session.system_language
association [0..1] to R_LglCntntMDocAmendmentTypeTxt as _LglCntntMDocAmendmentTypeTxt on $projection.LglCntntMDocAmendmentType = _LglCntntMDocAmendmentTypeTxt.LglCntntMDocAmendmentType
and _LglCntntMDocAmendmentTypeTxt.Language = $session.system_language
association [0..1] to R_LglCntntMSgntrPreferenceText as _LglCntntMSgntrPreferenceText on $projection.LglCntntMSgntrPreference = _LglCntntMSgntrPreferenceText.LglCntntMSgntrPreference
and _LglCntntMSgntrPreferenceText.Language = $session.system_language
association [1..1] to I_LglCntntMDocLockedReasonText as _LglCntntMDocLockedReasonText on $projection.LglCntntMDocLockedReasonCode = _LglCntntMDocLockedReasonText.LglCntntMDocLockedReasonCode
// association [0..1] to I_LglCntntMDocAutoRefreshTxt as _LglCntntMDocAutoRefreshTxt on $projection.LglCntntMDocAutoRefresh = _LglCntntMDocAutoRefreshTxt.LglCntntMDocAutoRefresh
// and Language = $session.system_language
association [0..1] to I_LglCntntMDocRefreshStatus as _LglCntntMDocRefreshStatus on $projection.LglCntntMDocument = _LglCntntMDocRefreshStatus.LglCntntMDocument
// association [0..1] to I_LglCntntMDocRefreshStsTxt as _LglCntntMDocRefreshStsTxt on $projection.LglCntntMDocRefreshStatus = _LglCntntMDocRefreshStsTxt.LglCntntMDocRefreshStatus
// and Language = $session.system_language
// Additional associations for ESH
association [1..1] to I_LglCntntMDocTemplateInfo as _LglCntntMDocTemplateInfo on $projection.LglCntntMDocumentUUID = _LglCntntMDocTemplateInfo.LglCntntMDocumentUUID
association [0..1] to I_LglCntntMDocInfoAttchAll as _DocAttachAll on $projection.LglCntntMDocumentLinkedObjKey = _DocAttachAll.LinkedSAPObjectKey
association [0..*] to I_LglCntntMDocumentStamp as _LglCntntMDocumentStamp on $projection.LglCntntMDocumentUUID = _LglCntntMDocumentStamp.LglCntntMDocumentUUID
association [0..*] to I_LegalTransactionDocLink as _LegalTransactionDocLink on $projection.LglCntntMDocument = _LegalTransactionDocLink.LglCntntMDocument
association [0..1] to I_LCMUserAddressAssignment as _CreatedBy on $projection.LglCntntMCreatedByUser = _CreatedBy.ContactCardID
association [0..1] to I_LCMUserAddressAssignment as _ChangedBy on $projection.LglCntntMChangedByUser = _ChangedBy.ContactCardID
association [1..1] to I_LglCntntMDocAssemblyInfo as _LglCntntMDocAssemblyInfo on $projection.LglCntntMDocumentUUID = _LglCntntMDocAssemblyInfo.LglCntntMDocumentUUID
and Document.LglCntntMVirtualDocVersKey = _LglCntntMDocAssemblyInfo.LglCntntMVirtualDocVersKey
association [0..1] to I_LglCntntMDocPaperTypeTxt as _LglCntntMDocPaperTypeTxt on $projection.LglCntntMDocPaperType = _LglCntntMDocPaperTypeTxt.LglCntntMDocPaperType
and _LglCntntMDocPaperTypeTxt.Language = $session.system_language
association [0..1] to I_LegalTransactionDate as _LglCntntMDocEffectiveDate on $projection.LegalTransactionUUID = _LglCntntMDocEffectiveDate.LegalTransactionUUID
and _LglCntntMDocEffectiveDate.LglCntntMDateType = 'SAP2'
//Document Agreement
association [0..1] to I_LglCntntMDocAgreement as _LglCntntMDocAgreement on $projection.LglCntntMDocumentUUID = _LglCntntMDocAgreement.LglCntntMDocumentUUID
//Extension
association [1..1] to E_LegalDocument as _Extenstion on $projection.LglCntntMDocumentUUID = _Extenstion.LglCntntMDocumentUUID
{
// LCM Document properties
key Document.LglCntntMDocumentUUID as LglCntntMDocumentUUID,
Document.LglCntntMDocument as LglCntntMDocument,
Document.LglCntntMDocumentLinkedObject as LglCntntMDocumentLinkedObject,
Document.LglCntntMDocumentLinkedObjKey as LglCntntMDocumentLinkedObjKey,
Document.LglCntntMDocumentIsTopVersion as LglCntntMDocumentIsTopVersion,
Document.LegalTransaction as LegalTransaction,
Document.LegalTransactionUUID as LegalTransactionUUID,
Document.LglCntntMDocContentType as LglCntntMDocContentType,
Document.LglCntntMLanguage as LglCntntMLanguage,
Document.LglCntntMParentDocument as LglCntntMParentDocument,
Document.LglCntntMChangedByUser as LglCntntMChangedByUser,
Document.LglCntntMChangedUTCDateTime as LglCntntMChangedUTCDateTime,
Document.LglCntntMCreatedByUser as LglCntntMCreatedByUser,
Document.LglCntntMCreatedUTCDateTime as LglCntntMCreatedUTCDateTime,
Document.DocumentDescription as DocumentDescription,
Document.LglCntntMLongTextUUID as LglCntntMLongTextUUID,
Document.LglCntntMIsMandatory as LglCntntMIsMandatory,
Document.LegalDocumentSource as LegalDocumentSource,
Document.LglCntntMDocAccessLvl as LglCntntMDocAccessLvl,
Document.LglCntntMAgingTemperature as LglCntntMAgingTemperature,
InternalDocumentStatus as InternalDocumentStatus,
Document.LglCntntMSignatureDocStatus as LglCntntMSignatureDocStatus,
@VDM.lifecycle.status:#DEPRECATED
@VDM.lifecycle.successor: 'LegalDocumentVersion'
DocumentVersion as DocumentVersion,
LegalDocumentVersion as LegalDocumentVersion, //new field for document version number(NUMC4)
@Semantics.booleanIndicator: true
Document.IsEndOfPurposeBlocked as IsEndOfPurposeBlocked,
Document.LglCntntMDocType as LglCntntMDocType,
//Document.LglCntntMDocAssemblyStatus as LglCntntMDocAssemblyStatus,
_LglCntntMDocAssemblyInfo.LglCntntMDocAssemblyStatus as LglCntntMDocAssemblyStatus,
Document.LglCntntMTmplUUID as LglCntntMTmplUUID,
// Document.LglCntntMVirtualDocRefKey as LglCntntMVirtualDocRefKey,
Document.LglCntntMVirtualDocVersKey as LglCntntMVirtualDocVersKey,
Document.LglCntntMVirtualDocSyncSts as LglCntntMVirtualDocSyncSts,
Document.LglCntntMCntxtDocUUID as LglCntntMCntxtDocUUID,
Document.LglCntntMDocIsToBeDeleted as LglCntntMDocIsToBeDeleted,
Document.LglCntntMDocReferenceNumber as LglCntntMDocReferenceNumber,
Document.LglCntntMDocLowTouchLevel as LglCntntMDocLowTouchLevel,
Document.LglCntntMCreatedFromDocUUID as LglCntntMCreatedFromDocUUID,
Document.LglCntntMDocPaperType as LglCntntMDocPaperType,
Document.LglCntntMMainLinkdObjType as LglCntntMMainLinkdObjType,
Document.LglCntntMMainLinkedObject as LglCntntMMainLinkedObject,
Document.LglCntntMDocEffectiveFromDate as LglCntntMDocEffectiveFromDate,
_LglCntntMDocEffectiveDate.LglCntntMFromDate as LglCntntMDocEffectiveToDate,
Document.LglCntntMDocAmendmentType as LglCntntMDocAmendmentType,
Document.LglCntntMSgntrPreference as LglCntntMSgntrPreference,
// LCM Legal Transaction
_LegalTransaction.LglCntntMProfile as LglCntntMProfile,
_LegalTransaction.LglCntntMGovLaw as LglCntntMGovLaw,
_LegalTransaction.LglCntntMContextUUID as LglCntntMContextUUID,
_LegalTransaction.LegalTransactionTitle as LegalTransactionTitle,
// LCM Notes
_Note.content as LglCntntMLongText,
_Note.mimetype as LglCntntMLongTextMimeType,
_DocStatusText.LglCntntMDocStatusName as LglCntntMDocStatusName,
_DocLock.LglCntntMDocLockedReasonCode as LglCntntMDocLockedReasonCode,
LglCntntMCntxtDocumentID,
LglCntntMIsIntegRelevant,
_LglCntntMDocRefreshStatus.LglCntntMDocRefreshStatus as LglCntntMDocRefreshStatus,
LglCntntMNmbrOfAdminvDocUpdt,
LglCntntMDocumentKind,
// Authorization
_LegalTransaction,
_Note,
_Context,
_DocLock,
_DocAttach,
_AccessLvlText,
_ContentTypeText,
_DocumentKindText,
_LanguageText,
_DocStatusText,
_SgntrDocStatusText,
_DocSyncStatusText,
_LglCntntMDocLowTouchLvlTxt,
_LglCntntMDocAmendmentTypeTxt,
_LglCntntMSgntrPreferenceText,
_LglCntntMDocLockedReasonText,
// _LglCntntMDocAutoRefreshTxt,
//_AssemblyStatusText,
_LglCntntMDocAssemblyInfo,
_LglCntntMDocTemplateInfo,
_DocAttachAll,
_LglCntntMDocumentStamp,
_LegalTransactionDocLink,
_CreatedBy,
_ChangedBy,
_LglCntntMDocRefreshStatus,
// _LglCntntMDocRefreshStsTxt,
//ESH
_LglCntntMDocCntntTypeSrchTxt,
_LglCntntMDocPaperTypeTxt,
_LglCntntMDocAgreement
}