FAA_COMPDRVDAREADOCIT01
Compare Derived Area DOC_IT 01
FAA_COMPDRVDAREADOCIT01 is a CDS View in S/4HANA. Compare Derived Area DOC_IT 01. It contains 140 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| FAA_CompDrvdAreaDocit02 | view | from | Compare Derived Area DOC_IT 02 |
Fields (140)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | afabe | afabe | 1 |
| KEY | anln1 | anln1 | 1 |
| KEY | anln2 | anln2 | 1 |
| KEY | aworg | aworg | 1 |
| KEY | awref | awref | 1 |
| KEY | awsys | awsys | 1 |
| KEY | awtyp | awtyp | 1 |
| KEY | belnr | belnr | 1 |
| KEY | bukrs | bukrs | 1 |
| KEY | docln | docln | 1 |
| KEY | drcrk | drcrk | 1 |
| KEY | gjahr | gjahr | 1 |
| KEY | rldnr | rldnr | 1 |
| KEY | slalittype | slalittype | 1 |
| KEY | subta | subta | 1 |
| anlkl_d | anlkl_d | 1 | |
| awitem_d | awitem_d | 1 | |
| aworg_rev_d | aworg_rev_d | 1 | |
| awref_rev_d | awref_rev_d | 1 | |
| awtyp_rev_d | awtyp_rev_d | 1 | |
| bldat_d | bldat_d | 1 | |
| budat_d | budat_d | 1 | |
| bwasl_d | bwasl_d | 1 | |
| bzdat_d | bzdat_d | 1 | |
| hsl_d | hsl_d | 1 | |
| ksl_d | ksl_d | 1 | |
| ktogr_d | ktogr_d | 1 | |
| mig_source_d | mig_source_d | 1 | |
| movcat_d | movcat_d | 1 | |
| obart_d | obart_d | 1 | |
| objid_d | objid_d | 1 | |
| osl_d | osl_d | 1 | |
| panl1_d | panl1_d | 1 | |
| panl2_d | panl2_d | 1 | |
| poper_d | poper_d | 1 | |
| prec_aworg_d | prec_aworg_d | 1 | |
| prec_awref_d | prec_awref_d | 1 | |
| prec_awtyp_d | prec_awtyp_d | 1 | |
| prec_subta_d | prec_subta_d | 1 | |
| prozs_pn_d | prozs_pn_d | 1 | |
| recid_d | recid_d | 1 | |
| rfccur_d | rfccur_d | 1 | |
| rhcur_d | rhcur_d | 1 | |
| rkcur_d | rkcur_d | 1 | |
| rocur_d | rocur_d | 1 | |
| s_anlkl | s_anlkl | 1 | |
| s_awitem | s_awitem | 1 | |
| s_aworg_rev | s_aworg_rev | 1 | |
| s_awref_rev | s_awref_rev | 1 | |
| s_awtyp_rev | s_awtyp_rev | 1 | |
| s_bldat | s_bldat | 1 | |
| s_budat | s_budat | 1 | |
| s_bwasl | s_bwasl | 1 | |
| s_bzdat | s_bzdat | 1 | |
| s_hsl | s_hsl | 1 | |
| s_ksl | s_ksl | 1 | |
| s_ktogr | s_ktogr | 1 | |
| s_mig_source | s_mig_source | 1 | |
| s_movcat | s_movcat | 1 | |
| s_obart | s_obart | 1 | |
| s_objid | s_objid | 1 | |
| s_osl | s_osl | 1 | |
| s_panl1 | s_panl1 | 1 | |
| s_panl2 | s_panl2 | 1 | |
| s_poper | s_poper | 1 | |
| s_prec_aworg | s_prec_aworg | 1 | |
| s_prec_awref | s_prec_awref | 1 | |
| s_prec_awtyp | s_prec_awtyp | 1 | |
| s_prec_subta | s_prec_subta | 1 | |
| s_prozs_pn | s_prozs_pn | 1 | |
| s_recid | s_recid | 1 | |
| s_rfccur | s_rfccur | 1 | |
| s_rhcur | s_rhcur | 1 | |
| s_rkcur | s_rkcur | 1 | |
| s_rocur | s_rocur | 1 | |
| s_sgtxt | s_sgtxt | 1 | |
| s_subta_rev | s_subta_rev | 1 | |
| s_ubzdt_pn | s_ubzdt_pn | 1 | |
| s_vorgn | s_vorgn | 1 | |
| s_xmanpropval_pn | s_xmanpropval_pn | 1 | |
| s_xreversed | s_xreversed | 1 | |
| s_xreversing | s_xreversing | 1 | |
| s_xsettled | s_xsettled | 1 | |
| s_xsettling | s_xsettling | 1 | |
| s_xvabg_pn | s_xvabg_pn | 1 | |
| s_zuonr | s_zuonr | 1 | |
| sdm_status | sdm_status | 1 | |
| sgtxt_d | sgtxt_d | 1 | |
| split_number | split_number | 1 | |
| subta_rev_d | subta_rev_d | 1 | |
| t_anlkl | t_anlkl | 1 | |
| t_awitem | t_awitem | 1 | |
| t_aworg_rev | t_aworg_rev | 1 | |
| t_awref_rev | t_awref_rev | 1 | |
| t_awtyp_rev | t_awtyp_rev | 1 | |
| t_bldat | t_bldat | 1 | |
| t_budat | t_budat | 1 | |
| t_bwasl | t_bwasl | 1 | |
| t_bzdat | t_bzdat | 1 | |
| t_hsl | t_hsl | 1 | |
| t_ksl | t_ksl | 1 | |
| t_ktogr | t_ktogr | 1 | |
| t_mig_source | t_mig_source | 1 | |
| t_movcat | t_movcat | 1 | |
| t_obart | t_obart | 1 | |
| t_objid | t_objid | 1 | |
| t_osl | t_osl | 1 | |
| t_panl1 | t_panl1 | 1 | |
| t_panl2 | t_panl2 | 1 | |
| t_poper | t_poper | 1 | |
| t_prec_aworg | t_prec_aworg | 1 | |
| t_prec_awref | t_prec_awref | 1 | |
| t_prec_awtyp | t_prec_awtyp | 1 | |
| t_prec_subta | t_prec_subta | 1 | |
| t_prozs_pn | t_prozs_pn | 1 | |
| t_recid | t_recid | 1 | |
| t_rfccur | t_rfccur | 1 | |
| t_rhcur | t_rhcur | 1 | |
| t_rkcur | t_rkcur | 1 | |
| t_rocur | t_rocur | 1 | |
| t_sgtxt | t_sgtxt | 1 | |
| t_subta_rev | t_subta_rev | 1 | |
| t_ubzdt_pn | t_ubzdt_pn | 1 | |
| t_vorgn | t_vorgn | 1 | |
| t_xmanpropval_pn | t_xmanpropval_pn | 1 | |
| t_xreversed | t_xreversed | 1 | |
| t_xreversing | t_xreversing | 1 | |
| t_xsettled | t_xsettled | 1 | |
| t_xsettling | t_xsettling | 1 | |
| t_xvabg_pn | t_xvabg_pn | 1 | |
| t_zuonr | t_zuonr | 1 | |
| ubzdt_pn_d | ubzdt_pn_d | 1 | |
| vorgn_d | vorgn_d | 1 | |
| xmanpropval_pn_d | xmanpropval_pn_d | 1 | |
| xreversed_d | xreversed_d | 1 | |
| xreversing_d | xreversing_d | 1 | |
| xsettled_d | xsettled_d | 1 | |
| xsettling_d | xsettling_d | 1 | |
| xvabg_pn_d | xvabg_pn_d | 1 | |
| zuonr_d | zuonr_d | 1 |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Compare Derived Area DOC_IT 01
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FAA_COMPDRVDAREADOCIT01 (
AFABE,
ANLN1,
ANLN2,
AWORG,
AWREF,
AWSYS,
AWTYP,
BELNR,
BUKRS,
DOCLN,
DRCRK,
GJAHR,
RLDNR,
SLALITTYPE,
SUBTA,
ANLKL_D,
AWITEM_D,
AWORG_REV_D,
AWREF_REV_D,
AWTYP_REV_D,
BLDAT_D,
BUDAT_D,
BWASL_D,
BZDAT_D,
HSL_D,
KSL_D,
KTOGR_D,
MIG_SOURCE_D,
MOVCAT_D,
OBART_D,
OBJID_D,
OSL_D,
PANL1_D,
PANL2_D,
POPER_D,
PREC_AWORG_D,
PREC_AWREF_D,
PREC_AWTYP_D,
PREC_SUBTA_D,
PROZS_PN_D,
RECID_D,
RFCCUR_D,
RHCUR_D,
RKCUR_D,
ROCUR_D,
S_ANLKL,
S_AWITEM,
S_AWORG_REV,
S_AWREF_REV,
S_AWTYP_REV,
S_BLDAT,
S_BUDAT,
S_BWASL,
S_BZDAT,
S_HSL,
S_KSL,
S_KTOGR,
S_MIG_SOURCE,
S_MOVCAT,
S_OBART,
S_OBJID,
S_OSL,
S_PANL1,
S_PANL2,
S_POPER,
S_PREC_AWORG,
S_PREC_AWREF,
S_PREC_AWTYP,
S_PREC_SUBTA,
S_PROZS_PN,
S_RECID,
S_RFCCUR,
S_RHCUR,
S_RKCUR,
S_ROCUR,
S_SGTXT,
S_SUBTA_REV,
S_UBZDT_PN,
S_VORGN,
S_XMANPROPVAL_PN,
S_XREVERSED,
S_XREVERSING,
S_XSETTLED,
S_XSETTLING,
S_XVABG_PN,
S_ZUONR,
SDM_STATUS,
SGTXT_D,
SPLIT_NUMBER,
SUBTA_REV_D,
T_ANLKL,
T_AWITEM,
T_AWORG_REV,
T_AWREF_REV,
T_AWTYP_REV,
T_BLDAT,
T_BUDAT,
T_BWASL,
T_BZDAT,
T_HSL,
T_KSL,
T_KTOGR,
T_MIG_SOURCE,
T_MOVCAT,
T_OBART,
T_OBJID,
T_OSL,
T_PANL1,
T_PANL2,
T_POPER,
T_PREC_AWORG,
T_PREC_AWREF,
T_PREC_AWTYP,
T_PREC_SUBTA,
T_PROZS_PN,
T_RECID,
T_RFCCUR,
T_RHCUR,
T_RKCUR,
T_ROCUR,
T_SGTXT,
T_SUBTA_REV,
T_UBZDT_PN,
T_VORGN,
T_XMANPROPVAL_PN,
T_XREVERSED,
T_XREVERSING,
T_XSETTLED,
T_XSETTLING,
T_XVABG_PN,
T_ZUONR,
UBZDT_PN_D,
VORGN_D,
XMANPROPVAL_PN_D,
XREVERSED_D,
XREVERSING_D,
XSETTLED_D,
XSETTLING_D,
XVABG_PN_D,
ZUONR_D,
PRIMARY KEY (AFABE, ANLN1, ANLN2, AWORG, AWREF, AWSYS, AWTYP, BELNR, BUKRS, DOCLN, DRCRK, GJAHR, RLDNR, SLALITTYPE, SUBTA)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA