P_LU_SAFTContractAccBPItem1

DDL: P_LU_SAFTCONTRACTACCBPITEM1 Type: view_entity COMPOSITE Package: FKK_ID_LU
76 Fields 3 Data Sources

LU SAFT Contract Account Business Partner Item 1

P_LU_SAFTContractAccBPItem1 is a Composite CDS View that provides data about "LU SAFT Contract Account Business Partner Item 1" in SAP S/4HANA. It reads from 3 data sources (I_CADocument, I_CADocument, I_CADocument) and exposes 76 fields with key fields CADocumentNumber, CABPItemNumber, CASubItemNumber, CARepetitionItemNumber, CABPItemNumber. Part of development package FKK_ID_LU.

Data Sources (3)

SourceAliasJoin Type
I_CADocument ficadoc from
I_CADocument ficadoc union_all
I_CADocument ficadoc union_all

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 #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (76)

KeyFieldSource TableSource FieldDescription
KEY CADocumentNumber fica_itm_bp CADocumentNumber Document Number
KEY CABPItemNumber fica_itm_bp CABPItemNumber Item
KEY CASubItemNumber fica_itm_bp CASubItemNumber Subitem
KEY CARepetitionItemNumber fica_itm_bp CARepetitionItemNumber Repetition Item
CompanyCode fica_itm_bp CompanyCode Receiver Company Code
FiscalYearVariant
CreatedByUser I_CADocument CreatedByUser User Name
CreationDate I_CADocument CreationDate Time Stamp
CAApplicationArea I_CADocument CAApplicationArea ApplicationArea
DocumentDate I_CADocument DocumentDate Journal Entry Date
CAGLItemNumber
CAPostingDate fica_itm_bp CAPostingDate Posting Date
ChartOfAccounts fica_itm_bp ChartOfAccounts Node Class
GLAccount fica_itm_bp CAReconciliationAccount G/L Account
TaxCode fica_itm_bp TaxCode Tax Code
CADocumentType fica_itm_bp CADocumentType Document Type
CAAmountInTransactionCurrency fica_itm_bp CAAmountInTransactionCurrency Amount
TransactionCurrency fica_itm_bp TransactionCurrency Transaction Currency
CompanyCodeCurrency fica_itm_bp CompanyCodeCurrency Local Currency
CAAmountInLocalCurrency fica_itm_bp CAAmountInLocalCurrency Local Crcy Amt
CAExchangeRate fica_itm_bp CAExchangeRate Absolute Exchange Rate
CAClearingDate fica_itm_bp CAClearingDate Clearing
CAClearingDocumentNumber fica_itm_bp CAClearingDocumentNumber Clearing Doc.
CAClearedDocument Document Number
CAReversedDocumentNumber
CADocumentNumber Document Number
KEY CABPItemNumber fica_itm_bp_rev CABPItemNumber Item
KEY CASubItemNumber fica_itm_bp_rev CASubItemNumber Subitem
KEY CARepetitionItemNumber fica_itm_bp_rev CARepetitionItemNumber Repetition Item
CompanyCode fica_itm_bp_rev CompanyCode Receiver Company Code
FiscalYearVariant
CreatedByUser I_CADocument CreatedByUser User Name
CreationDate I_CADocument CreationDate Time Stamp
CAApplicationArea I_CADocument CAApplicationArea ApplicationArea
DocumentDate I_CADocument DocumentDate Journal Entry Date
CAGLItemNumber
CAPostingDate I_CADocument CAPostingDate Posting Date
ChartOfAccounts fica_itm_bp_rev ChartOfAccounts Node Class
GLAccount fica_itm_bp_rev CAReconciliationAccount G/L Account
TaxCode fica_itm_bp_rev TaxCode Tax Code
CADocumentType I_CADocument CADocumentType Document Type
CAAmountInTransactionCurrency Amount
TransactionCurrency fica_itm_bp_rev TransactionCurrency Transaction Currency
CompanyCodeCurrency fica_itm_bp_rev CompanyCodeCurrency Local Currency
CAAmountInLocalCurrency Local Crcy Amt
CAExchangeRate fica_itm_bp_rev CAExchangeRate Absolute Exchange Rate
CAClearingDate fica_itm_bp_rev CAClearingDate Clearing
CAClearingDocumentNumber fica_itm_bp_rev CAClearingDocumentNumber Clearing Doc.
CAClearedDocument Document Number
CAReversedDocumentNumber
CADocumentNumber Document Number
KEY CABPItemNumber fica_itm_bp_clear CABPItemNumber Item
KEY CASubItemNumber fica_itm_bp_clear CASubItemNumber Subitem
KEY CARepetitionItemNumber fica_itm_bp_clear CARepetitionItemNumber Repetition Item
CompanyCode fica_itm_bp_clear CompanyCode Receiver Company Code
FiscalYearVariant
CreatedByUser I_CADocument CreatedByUser User Name
CreationDate I_CADocument CreationDate Time Stamp
CAApplicationArea I_CADocument CAApplicationArea ApplicationArea
DocumentDate I_CADocument DocumentDate Journal Entry Date
CAGLItemNumber
CAPostingDate I_CADocument CAPostingDate Posting Date
ChartOfAccounts fica_itm_bp_clear ChartOfAccounts Node Class
GLAccount fica_itm_bp_clear CAReconciliationAccount G/L Account
TaxCode fica_itm_bp_clear TaxCode Tax Code
CADocumentType I_CADocument CADocumentType Document Type
CAAmountInTransactionCurrency Amount
TransactionCurrency fica_itm_bp_clear TransactionCurrency Transaction Currency
CompanyCodeCurrency fica_itm_bp_clear CompanyCodeCurrency Local Currency
CAAmountInLocalCurrency Local Crcy Amt
CAExchangeRate fica_itm_bp_clear CAExchangeRate Absolute Exchange Rate
CAClearingDate fica_itm_bp_clear CAClearingDate Clearing
CAClearingDocumentNumber fica_itm_bp_clear CAClearingDocumentNumber Clearing Doc.
CAClearedDocument fica_itm_bp_clear CADocumentNumber Document Number
CAReversedDocumentNumber
BusinessPartner fica_itm_bp_clear BusinessPartner Issuing Authority

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_SAFTContractAccBPItem1.
-- 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_SAFTContractAccBPItem1 AS
SELECT
  fica_itm_bp.CADocumentNumber AS CADocumentNumber,
  fica_itm_bp.CABPItemNumber AS CABPItemNumber,
  fica_itm_bp.CASubItemNumber AS CASubItemNumber,
  fica_itm_bp.CARepetitionItemNumber AS CARepetitionItemNumber,
  fica_itm_bp.CompanyCode AS CompanyCode,
  fica_itm_bp._CompanyCode.FiscalYearVariant AS FiscalYearVariant,
  ficadoc.CreatedByUser AS CreatedByUser,
  ficadoc.CreationDate AS CreationDate,
  ficadoc.CAApplicationArea AS CAApplicationArea,
  ficadoc.DocumentDate AS DocumentDate,
  cast( '' as opupk_kk) AS CAGLItemNumber,
  fica_itm_bp.CAPostingDate AS CAPostingDate,
  fica_itm_bp.ChartOfAccounts AS ChartOfAccounts,
  fica_itm_bp.CAReconciliationAccount AS GLAccount,
  fica_itm_bp.TaxCode AS TaxCode,
  fica_itm_bp.CADocumentType AS CADocumentType,
  fica_itm_bp.CAAmountInTransactionCurrency AS CAAmountInTransactionCurrency,
  fica_itm_bp.TransactionCurrency AS TransactionCurrency,
  fica_itm_bp.CompanyCodeCurrency AS CompanyCodeCurrency,
  fica_itm_bp.CAAmountInLocalCurrency AS CAAmountInLocalCurrency,
  fica_itm_bp.CAExchangeRate AS CAExchangeRate,
  fica_itm_bp.CAClearingDate AS CAClearingDate,
  fica_itm_bp.CAClearingDocumentNumber AS CAClearingDocumentNumber,
  cast( '' as fica_opbel ) AS CAClearedDocument,
  fica_itm_bp._CADocument.CAReversedDocumentNumber AS CAReversedDocumentNumber,
  fica_itm_bp_clear.BusinessPartner AS BusinessPartner
FROM I_CADocument AS ficadoc
-- UNION ALL with additional select branch(es): I_CADocument
;

Learn More