P_LU_SAFTContractAccEntityItm

DDL: P_LU_SAFTCONTRACTACCENTITYITM Type: view_entity COMPOSITE
10 Fields 1 Data Sources

P_LU_SAFTContractAccEntityItm is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (R_LU_SAFTContractAcctItem2) and exposes 10 fields with key field CADocumentNumber.

Data Sources (1)

SourceAliasJoin Type
R_LU_SAFTContractAcctItem2 itm from

Annotations (8)

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

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY CADocumentNumber R_LU_SAFTContractAcctItem2 CADocumentNumber Document Number
CompanyCode R_LU_SAFTContractAcctItem2 CompanyCode Receiver Company Code
FiscalYearVariant R_LU_SAFTContractAcctItem2 FiscalYearVariant FY Variant
CreatedByUser R_LU_SAFTContractAcctItem2 CreatedByUser User Name
CreationDate R_LU_SAFTContractAcctItem2 CreationDate Time Stamp
CADocumentType R_LU_SAFTContractAcctItem2 CADocumentType Document Type
CAApplicationArea R_LU_SAFTContractAcctItem2 CAApplicationArea ApplicationArea
TaxCode R_LU_SAFTContractAcctItem2 TaxCode Tax Code
CAPostingDate R_LU_SAFTContractAcctItem2 CAPostingDate Posting Date
DocumentDate R_LU_SAFTContractAcctItem2 DocumentDate Journal Entry Date

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_LU_SAFTContractAccEntityItm.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW P_LU_SAFTContractAccEntityItm AS
SELECT
  itm.CADocumentNumber AS CADocumentNumber,
  itm.CompanyCode AS CompanyCode,
  itm.FiscalYearVariant AS FiscalYearVariant,
  itm.CreatedByUser AS CreatedByUser,
  itm.CreationDate AS CreationDate,
  itm.CADocumentType AS CADocumentType,
  itm.CAApplicationArea AS CAApplicationArea,
  itm.TaxCode AS TaxCode,
  itm.CAPostingDate AS CAPostingDate,
  itm.DocumentDate AS DocumentDate
FROM R_LU_SAFTContractAcctItem2 AS itm
;

Learn More