SAP Table CRMD_ACC_PL_ATTR stores Account Planning account plan attributesdata

  

In this post, I will try and describe everything you need to know about the SAP crmd_acc_pl_attr table. What it is, including what type of data it stores.

A list of fields which make up the table structure and on an S/4Hana System for CRMD_ACC_PL_ATTR what does this table look like.

And what relationships it has with other SAP tables.

Also see here for example ABAP code to select data from CRMD_ACC_PL_ATTR....Right lets get started!


SAP CRMD_ACC_PL_ATTR dictionary attributes

Object Name: CRMD_ACC_PL_ATTR
Dictionary Type: Transparent table
Description: Account Planning account plan attributes


CRMD_ACC_PL_ATTR field list

Field Data Element Data Type length (Dec) Check table Description Conversion Routine Domain Name MemoryID AppClass SHLP SHLP Field ConvExit
CLIENTMANDTCLNT3(0) *ClientMANDTTESTCRM
GUIDSYSUUID_XRAW16(0) UUID in X form (binary)SYSUUIDCRM
PROJECT_GUIDCGPL_GUID16RAW16(0) Project Planning: 16-Character GUID for Projects and ActivtsCGPL_PROJECT_GUIDCRM
AUTH_GROUPCRM_ACC_PL_AUTH_GROUPCHAR4(0) Authorization GroupCRM_ACC_PL_AUTH_GROUPCRM
PERIODCRM_ACC_PL_PERIODCHAR24(0) *Planning PeriodCRM_ACC_PL_PERIODCRM
BP_GUIDBU_PARTNER_GUIDRAW16(0) Business Partner GUIDSYSUUIDCRM
NODE_GUIDBU_NODE_GUIDRAW16(0) GUID of Hierarchy NodeSYSUUIDCRM
SALES_ORGCRMT_ACC_PL_SALES_ORGCHAR14(0) Sales OrganizationHROBJEC_14CRM
DIVISIONCRMT_ACC_PL_DIVISIONCHAR2(0) DivisionCRM_ACC_PL_DIVISIONCRM
DIS_CHANNELCRMT_ACC_PL_DISTR_CHANNELCHAR2(0) Distribution ChannelCRM_ACC_PL_DISTR_CHANNELCRM
CURRENCYCRM_MKTPL_CUKYCUKY5(0) TCURCMKTPL: Currency ObjectWAERSCRM
CREATED_ONLINECRM_ACC_PL_CREATED_ONLINECHAR1(0) Created OnlineFLAGCRM
TERR_PATH_GUIDCRMT_TERRITORY_PATH_GUIDRAW16(0) Territory Path GUIDSYSUUIDCRM
TERR_PATH_IDCRMT_TERRITORY_PATH_IDCHAR30(0) Territory Hierarchy IDCRM_TERRITORY_PATH_IDCRM
PLANBASISCRM_ACC_PL_PLAN_BASISCHAR1(0) Planning Basis (Product or Product Category)CRM_ACC_PL_PLAN_BASISCRM
PLANNED_BYBU_PARTNER_GUIDRAW16(0) Business Partner GUIDSYSUUIDCRM
TERR_IDCRMT_TERRITORY_IDCHAR30(0) Territory IDCRM_TERRITORY_IDCRM
ACTION_PROFILECRM_ACC_PL_ACTION_PROFILECHAR30(0) *Account Planner: Name of Action ProfilePPFDCNTXTCRM
ORIG_SYSTEMCRM_MKTPL_ORIG_SYSTCHAR1(0) CRM Marketing Planning - Campaign Original SystemCHAR1CRM
TIME_ZONESYSTZONLOCHAR6(0) Time ZoneSYCHAR06CRM
PPR_TYPECRM_ACC_PL_PPR_TYPECHAR4(0) PPR TypeCRM_ACC_PL_PPR_TYPECRM


View list of all tables