FAA_COMPDRVDAREADOCIT01

CDS View

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)

ViewTypeJoinVDMDescription
FAA_CompDrvdAreaDocit02 view from Compare Derived Area DOC_IT 02

Fields (140)

KeyField CDS FieldsUsed 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)
);