I_CN_TaxInvcBindgItmTP

DDL: I_CN_TAXINVCBINDGITMTP Type: view TRANSACTIONAL Package: GLO_FIN_TAX_INVC_MGMT_REUSE_CN
11 Fields 1 Data Sources 2 Associations

China Tax Invoice Reuse Bind Item

I_CN_TaxInvcBindgItmTP is a Transactional CDS View that provides data about "China Tax Invoice Reuse Bind Item" in SAP S/4HANA. It reads from 1 data source (I_CN_TaxInvcBindgItm) and exposes 11 fields with key fields CN_TaxInvcBindgUUID, CN_TaxInvcBindgItmUUID. It has 2 associations to related views. Part of development package GLO_FIN_TAX_INVC_MGMT_REUSE_CN.

Data Sources (1)

SourceAliasJoin Type
I_CN_TaxInvcBindgItm _item from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_CN_TaxInvcBindgHdrTP _Header $projection.CN_TaxInvcBindgUUID = _Header.CN_TaxInvcBindgUUID
[1..1] I_CN_TaxInputInvcTP _Invoice $projection.CN_TaxInvcUUID = _Invoice.CN_TaxInvcUUID

Annotations (15)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName ICNTXIBNDGITMTP view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #TRANSACTIONAL view
VDM.private false view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.draftEnabled true view
ObjectModel.writeDraftPersistence TXI_BNDG_ITMTP view
ObjectModel.entityChangeStateId LastChangeDateTime view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label China Tax Invoice Reuse Bind Item view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY CN_TaxInvcBindgUUID I_CN_TaxInvcBindgItm CN_TaxInvcBindgUUID Invoice Binding UUID
KEY CN_TaxInvcBindgItmUUID I_CN_TaxInvcBindgItm CN_TaxInvcBindgItmUUID Binding Item UUID
CN_TaxInvcUUID
CreatedByUser I_CN_TaxInvcBindgItm CreatedByUser User Name
CreationUTCDateTime I_CN_TaxInvcBindgItm CreationUTCDateTime Time Stamp
LastChangedByUser I_CN_TaxInvcBindgItm LastChangedByUser User Name
LastChangeDateTime I_CN_TaxInvcBindgItm LastChangeDateTime Timestamp
_Header _Header
_Invoice _Invoice
CN_TaxInvcCode _Invoice CN_TaxInvcCode
CN_TaxInvcNmbr _Invoice CN_TaxInvcNmbr

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 I_CN_TaxInvcBindgItmTP.
-- 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 I_CN_TaxInvcBindgItmTP AS
SELECT
  _item.CN_TaxInvcBindgUUID AS CN_TaxInvcBindgUUID,
  _item.CN_TaxInvcBindgItmUUID AS CN_TaxInvcBindgItmUUID,
  _item.CreatedByUser AS CreatedByUser,
  _item.CreationUTCDateTime AS CreationUTCDateTime,
  _item.LastChangedByUser AS LastChangedByUser,
  _item.LastChangeDateTime AS LastChangeDateTime,
  _Invoice.CN_TaxInvcCode AS CN_TaxInvcCode,
  _Invoice.CN_TaxInvcNmbr AS CN_TaxInvcNmbr
FROM I_CN_TaxInvcBindgItm AS _item
LEFT OUTER JOIN I_CN_TaxInvcBindgHdrTP AS _Header ON CN_TaxInvcBindgUUID = _Header.CN_TaxInvcBindgUUID  -- association [1..1]
LEFT OUTER JOIN I_CN_TaxInputInvcTP AS _Invoice ON CN_TaxInvcUUID = _Invoice.CN_TaxInvcUUID  -- association [1..1]
;

Learn More