I_CN_TaxInvcBindgRecd

DDL: I_CN_TAXINVCBINDGRECD Type: view BASIC
23 Fields 3 Data Sources

China Tax Invoice Bind Record

I_CN_TaxInvcBindgRecd is a Basic CDS View that provides data about "China Tax Invoice Bind Record" in SAP S/4HANA. It reads from 3 data sources (I_CN_TaxInvcBindgRecdActv, I_CN_TaxInvcBindgRecdDrft, I_CN_TaxInvcBindgRecdDrft) and exposes 23 fields with key fields CN_TaxInvcBindgUUID, CN_TaxInvcBindgItmUUID, CN_TaxInvcBindgItmUUID.

Data Sources (3)

SourceAliasJoin Type
I_CN_TaxInvcBindgRecdActv Active from
I_CN_TaxInvcBindgRecdDrft Draft left_outer
I_CN_TaxInvcBindgRecdDrft Draft union_all

Annotations (11)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName ICNTXIBINDGRECD view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #BASIC view
VDM.private false view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label China Tax Invoice Bind Record view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY CN_TaxInvcBindgUUID I_CN_TaxInvcBindgRecdActv CN_TaxInvcBindgUUID Invoice Binding UUID
KEY CN_TaxInvcBindgItmUUID I_CN_TaxInvcBindgRecdActv CN_TaxInvcBindgItmUUID Binding Item UUID
CN_TaxInvcUUID I_CN_TaxInvcBindgRecdActv CN_TaxInvcUUID Invoice UUID
CN_TaxEntityID I_CN_TaxInvcBindgRecdActv CN_TaxEntityID Tax Entity
CN_TaxInvcBindgSrceBusObjType I_CN_TaxInvcBindgRecdActv CN_TaxInvcBindgSrceBusObjType Binding Src BO Type
CN_TaxInvcBindgSrceBusObjKey I_CN_TaxInvcBindgRecdActv CN_TaxInvcBindgSrceBusObjKey Binding Src BO Key
IsDeleted TRUE
CreatedByUser I_CN_TaxInvcBindgRecdActv CreatedByUser User Name
CreationUTCDateTime I_CN_TaxInvcBindgRecdActv CreationUTCDateTime Time Stamp
LastChangedByUser I_CN_TaxInvcBindgRecdActv LastChangedByUser User Name
LastChangeDateTime I_CN_TaxInvcBindgRecdActv LastChangeDateTime Timestamp
CN_TaxInvcBindgUUID Invoice Binding UUID
KEY CN_TaxInvcBindgItmUUID I_CN_TaxInvcBindgRecdDrft CN_TaxInvcBindgItmUUID Binding Item UUID
CN_TaxInvcUUID I_CN_TaxInvcBindgRecdDrft CN_TaxInvcUUID Invoice UUID
CN_TaxEntityID I_CN_TaxInvcBindgRecdDrft CN_TaxEntityID Tax Entity
CN_TaxInvcBindgSrceBusObjType I_CN_TaxInvcBindgRecdDrft CN_TaxInvcBindgSrceBusObjType Binding Src BO Type
CN_TaxInvcBindgSrceBusObjKey I_CN_TaxInvcBindgRecdDrft CN_TaxInvcBindgSrceBusObjKey Binding Src BO Key
IsDeleted I_CN_TaxInvcBindgRecdDrft IsDeleted TRUE
CreatedByUser I_CN_TaxInvcBindgRecdDrft CreatedByUser User Name
CreationUTCDateTime I_CN_TaxInvcBindgRecdDrft CreationUTCDateTime Time Stamp
LastChangedByUser I_CN_TaxInvcBindgRecdDrft LastChangedByUser User Name
LastChangeDateTime I_CN_TaxInvcBindgRecdDrft LastChangeDateTime Timestamp
IsActiveEntity

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_TaxInvcBindgRecd.
-- 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_TaxInvcBindgRecd AS
SELECT
  Active.CN_TaxInvcBindgUUID AS CN_TaxInvcBindgUUID,
  Active.CN_TaxInvcBindgItmUUID AS CN_TaxInvcBindgItmUUID,
  Active.CN_TaxInvcUUID AS CN_TaxInvcUUID,
  Active.CN_TaxEntityID AS CN_TaxEntityID,
  Active.CN_TaxInvcBindgSrceBusObjType AS CN_TaxInvcBindgSrceBusObjType,
  Active.CN_TaxInvcBindgSrceBusObjKey AS CN_TaxInvcBindgSrceBusObjKey,
  cast(' ' as boolean) AS IsDeleted,
  Active.CreatedByUser AS CreatedByUser,
  Active.CreationUTCDateTime AS CreationUTCDateTime,
  Active.LastChangedByUser AS LastChangedByUser,
  Active.LastChangeDateTime AS LastChangeDateTime,
  cast(' ' as boolean) AS IsActiveEntity
FROM I_CN_TaxInvcBindgRecdActv AS Active
LEFT OUTER JOIN I_CN_TaxInvcBindgRecdDrft AS Draft ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): I_CN_TaxInvcBindgRecdDrft
;

Learn More