P_LDCMP

DDL: P_LDCMP SQL: PFILDCMP Type: view BASIC

P_LDCMP is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (finsc_ld_cmp) and exposes 14 fields with key fields rldnr, bukrs.

1 data source(s) 14 fields

Data Sources (1)

SourceAliasJoin Type
finsc_ld_cmp finsc_ld_cmp from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PFILDCMP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY rldnr finsc_ld_cmp rldnr
KEY bukrs finsc_ld_cmp bukrs
CURTPH curtph
CURTPK curtpk
CURTPO curtpo
CURTPV curtpv
CURTPB curtpb
CURTPC curtpc
CURTPD curtpd
CURTPE curtpe
CURTPF curtpf
CURTPG curtpg
periv periv
opvar opvar 
@AbapCatalog.sqlViewName: 'PFILDCMP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #BASIC
@VDM.private:true
@ClientHandling.algorithm: #SESSION_VARIABLE


define view P_LDCMP
  as select from finsc_ld_cmp 
{

  key finsc_ld_cmp.rldnr,
  key finsc_ld_cmp.bukrs,
    curtph   as CURTPH,
    curtpk   as CURTPK,
    curtpo   as CURTPO,
    curtpv   as CURTPV,
    curtpb   as CURTPB,
    curtpc   as CURTPC,
    curtpd   as CURTPD,
    curtpe   as CURTPE,
    curtpf   as CURTPF,
    curtpg   as CURTPG,
    periv    as periv,
    opvar    as opvar,
    acc_principle       as acc_principle,
    cast( case when functional_currency <> '  ' then functional_currency
                                                else curtph             
          end                                    
          as finsc_functional_curtype 
        ) as functional_currency

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FINSC_LD_CMP"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More