CFS_S_PRT_ITEM_DETAIL SAP (Sales Summary: Data for Adobe Print) Structure details

Dictionary Type: Structure
Description: Sales Summary: Data for Adobe Print




ABAP Code to SELECT data from CFS_S_PRT_ITEM_DETAIL
Related tables to CFS_S_PRT_ITEM_DETAIL
Access table CFS_S_PRT_ITEM_DETAIL




Structure field list including key, data, relationships and ABAP select examples

CFS_S_PRT_ITEM_DETAIL is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Sales Summary: Data for Adobe Print" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_CFS_S_PRT_ITEM_DETAIL TYPE CFS_S_PRT_ITEM_DETAIL.

The CFS_S_PRT_ITEM_DETAIL table consists of various fields, each holding specific information or linking keys about Sales Summary: Data for Adobe Print data available in SAP. These include ADDRESS_DATA (), TITLE (Form-of-Address Key), TITLE_TEXT (Title text), NAME1 (Name 1).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)


SAP CFS_S_PRT_ITEM_DETAIL structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
KUNNRCustomer Numbers KUNNRCHAR10Assigned to domainALPHAKUNNRKUNC_KUNNR
ADDRESS_DATA 0
TITLEForm-of-Address Key AD_TITLECHAR4AD_TITLE
TITLE_TEXTTitle text AD_TITLETXCHAR30TEXT30
NAME1Name 1 AD_NAME1CHAR40TEXT40
NAME2Name 2 AD_NAME2CHAR40TEXT40
NAME3Name 3 AD_NAME3CHAR40TEXT40
NAME4Name 4 AD_NAME4CHAR40TEXT40
NAME_TXTConverted name field (with form of address) AD_NAMETXTCHAR50TEXT50
NAME_COc/o name AD_NAME_COCHAR40TEXT40
STREETStreet AD_STREETCHAR60TEXT60CLSTRTNAME
HOUSE_NUM1House Number AD_HSNM1CHAR10TEXT10
POST_CODE1City postal code AD_PSTCD1CHAR10CHAR10
POST_CODE2PO Box Postal Code AD_PSTCD2CHAR10CHAR10
POST_CODE3Company Postal Code (for Large Customers) AD_PSTCD3CHAR10CHAR10
CITY1City AD_CITY1CHAR40TEXT40CLCITYNAME
CITY2District AD_CITY2CHAR40TEXT40CITY_PART
PO_BOXPO Box AD_POBXCHAR10CHAR10
PO_BOX_LOCPO Box city AD_POBXLOCCHAR40TEXT40CITY_NAME
PO_BOX_REGRegion for PO Box (Country, State, Province, ...) AD_POBXREGCHAR3REGIO
PO_BOX_CTYPO box country AD_POBXCTYCHAR3LAND1
COUNTRYCountry Key LAND1CHAR3LAND1LND
LANGULanguage Key SPRASLANG1ISOLASPRASSPRH_T002
REGIONSTATE (State, Province, County) REGIOCHAR3REGIO
TRANSPZONETransportation zone to or from which the goods are delivered LZONECHAR10ZONE
TELNR_LONGComplete number: dialling code+number+extension AD_TELNRLGCHAR30CHAR30
MOBILE_LONGComplete number: dialling code+number+extension AD_TELNRLGCHAR30CHAR30
FAXNR_LONGComplete number: dialling code+number+extension AD_FXNRLNGCHAR30CHAR30
EMAILE-Mail Address AD_SMTPADRCHAR241SXIDNAD_SMTPADR
HOME_PAGEUniversal Resource Identifier (URI) AD_URILCHR2048AD_URI
ADRNRAddress ADRNRCHAR10ALPHAADRNR
SENDING_COUNTRYSending country for processing address SLANDCHAR3LAND1
CLASSIFICATION 0
NIELSNielsen ID NIELSCHAR2NIELS
NIELSBEZDescription BEZEI20CHAR20TEXT20
RPMKRRegional Market RPMKRCHAR5RPMKR
KUKLACustomer classification KUKLACHAR2KUKLA
KUKLABEZDescription BEZEI20CHAR20TEXT20
BRSCHIndustry key BRSCHCHAR4BRSCH
BRSCHBEZDescription of the Industry Key TEXT1_016TCHAR20TEXT20
BRAN1Industry Code 1 BRAN1_DCHAR10BRACO
BRAN1BEZDescription VTEXTCHAR20TEXT20
BRAN2Industry code 2 BRAN2CHAR10BRACO
BRAN2BEZDescription VTEXTCHAR20TEXT20
BRAN3Industry code 3 BRAN3CHAR10BRACO
BRAN3BEZDescription VTEXTCHAR20TEXT20
BRAN4Industry code 4 BRAN4CHAR10BRACO
BRAN4BEZDescription VTEXTCHAR20TEXT20
BRAN5Industry code 5 BRAN5CHAR10BRACO
BRAN5BEZDescription VTEXTCHAR20TEXT20
KEY_FIGURES 0
UMSA1Annual sales UMSA1CURR15(2) UMSA1
UWAERCurrency of sales figure UWAERCUKY5WAERS
UMJAHYear For Which Sales are Given UMJAHNUMC4JAHR
JMZAHYearly number of employees JMZAHNUMC6JMZAH
JMJAHYear for which the number of employees is given JMJAHNUMC4JAHR
PERIVFiscal Year Variant PERIVCHAR2PERIV
PERIVBEZDescription of fiscal year variant LTEXT_009CHAR30TEXT30
GFORMLegal status GFORMCHAR2GFORM
GFORMBEZDescription VTEXTCHAR20TEXT20
CONTACT_PERSON 0
ORDER_INFO_CUST 0
PRICING_CUST 0
SHIPPING_CUST 0
PART_DELIVERIES 0
TRANSP_DATA 0
BBBNRInternational location number (part 1) BBBNRNUMC7NUM07
BBSNRInternational location number (Part 2) BBSNRNUMC5NUM05
BUBKZCheck digit for the international location number BUBKZNUMC1NUM01
BRSCHIndustry key BRSCHCHAR4BRSCH
BRSCHTXTDescription of the Industry Key TEXT1_016TCHAR20TEXT20
BAHNSTrain station BAHNSCHAR25BAHNH
BAHNEExpress train station BAHNECHAR25BAHNH
LZONETransportation zone to or from which the goods are delivered LZONECHAR10ZONE
LZONETEXTDescription BEZEI20CHAR20TEXT20
LOCCOCity Coordinates LOCCOCHAR10LOCCO
BILLING_DATA 0
DELIVERY_TERMS 0
PARTNER_DATA 0
STATISTICS_S001 0
STATISTICS_MEAS 0
LAST_SD_DOC 0
Q_NOTIFICATIONS 0
ZHLMELDNo. of Notifications QZHLMELDINT410INT4
ZHLMOFNNo. of Notifications with Status Outstanding QZHLMOFNINT410INT4
ZHLMIARNo. of Notifications with Status Being Processed QZHLMIARINT410INT4
ZHLMMABNo. of Notifications with Status Completed QZHLMMABINT410INT4
QMELDTAB 0
S_NOTIFICATIONS 0
SMOFNNo.of recorded notifications SMOFNDEC9MCZAEHLER
SMMABNo. of completed notifications SMMABDEC9MCZAEHLER
SGAUSZTDowntime entered SGAUSZTQUAN13(3) MENG13
SUNITUnit for Breakdown Duration MAUEHUNIT3CUNITMEINS
QMELDTAB 0
CREDIT_INFO 0
PROMOTIONS 0
PAYMENT_CARDS 0
QUICKINFO 0
KUNNRCustomer Numbers KUNNRCHAR10ALPHAKUNNRKUNC_KUNNR
NUM_DELIVERY_BLOCK10 digit number NUM10NUMC10NUM10
NUM_INVOICE_BLOCK10 digit number NUM10NUMC10NUM10
NUM_BACKLOG10 digit number NUM10NUMC10NUM10
NUM_OPEN_ORDER10 digit number NUM10NUMC10NUM10
NUM_OPEN_DELIVERY10 digit number NUM10NUMC10NUM10
NUM_OPEN_INVOICE10 digit number NUM10NUMC10NUM10
CONSUMPTION_CREDIT_LIMITCredit limit used in % KLPRZ_CMNUMC3ABPRC
FLAG_CUSTOMER_HIERARCHYSingle-Character Indicator CHAR1CHAR1CHAR1
FLAG_CUSTOMER_MATERIAL_INFOSingle-Character Indicator CHAR1CHAR1CHAR1
FLAG_CREDIT_INFOSingle-Character Indicator CHAR1CHAR1CHAR1
FLAG_REMINDERSingle-Character Indicator CHAR1CHAR1CHAR1
DATE_LAST_REMINDERLast dunned on MADATDATS8DATUM
BUKRSCompany Code BUKRSCHAR4BUKRSBUKC_T001
LAST_ORDERSales Document VBELN_VACHAR10ALPHAVBELNAUN
LAST_INVOICEBilling Document VBELN_VFCHAR10ALPHAVBELNVF
NEXT_CONTACTSD document no. of a sales activity in sales support CAS_VBELNCHAR10ALPHAVBELNVCA
LAST_DELIVERYDelivery VBELN_VLCHAR10ALPHAVBELNVL
DATE_LAST_ORDERDocument Date (Date Received/Sent) AUDATDATS8DATUM
DATE_LAST_INVOICEBilling date for billing index and printout FKDATDATS8DATUM
DATE_NEXT_CONTACTDate on Which Record Was Created ERDATDATS8DATUM
DATE_LAST_DELIVERYDelivery date LFDATDATS8DATUM
BACKORDERS 0
EX_ADDRESS_DATACheckbox XFELDCHAR1XFELD
EX_CLASSIFICATIONCheckbox XFELDCHAR1XFELD
EX_KEY_FIGURESCheckbox XFELDCHAR1XFELD
EX_CONTACT_PERSONCheckbox XFELDCHAR1XFELD
EX_ORDER_INFO_CUSTCheckbox XFELDCHAR1XFELD
EX_PRICING_CUSTCheckbox XFELDCHAR1XFELD
EX_SHIPPING_CUSTCheckbox XFELDCHAR1XFELD
EX_PART_DELIVERIESCheckbox XFELDCHAR1XFELD
EX_TRANSP_DATACheckbox XFELDCHAR1XFELD
EX_BILLING_DATACheckbox XFELDCHAR1XFELD
EX_DELIVERY_TERMSCheckbox XFELDCHAR1XFELD
EX_PARTNER_DATACheckbox XFELDCHAR1XFELD
EX_STATISTICS_S001Checkbox XFELDCHAR1XFELD
EX_STATISTICS_MEASCheckbox XFELDCHAR1XFELD
EX_LAST_SD_DOCCheckbox XFELDCHAR1XFELD
EX_Q_NOTIFICATIONSCheckbox XFELDCHAR1XFELD
EX_Q_MELDTABCheckbox XFELDCHAR1XFELD
EX_S_NOTIFICATIONSCheckbox XFELDCHAR1XFELD
EX_S_MELDTABCheckbox XFELDCHAR1XFELD
EX_CREDIT_INFOCheckbox XFELDCHAR1XFELD
EX_PROMOTIONSCheckbox XFELDCHAR1XFELD
EX_PAYMENT_CARDSCheckbox XFELDCHAR1XFELD
EX_QUICKINFOCheckbox XFELDCHAR1XFELD
EX_BACKORDERSCheckbox XFELDCHAR1XFELD

Key field Non-key field



How do I retrieve data from SAP structure CFS_S_PRT_ITEM_DETAIL using ABAP code?

As CFS_S_PRT_ITEM_DETAIL is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on CFS_S_PRT_ITEM_DETAIL as there is no data to select.

How to access SAP table CFS_S_PRT_ITEM_DETAIL

Within an ECC or HANA version of SAP you can also view further information about CFS_S_PRT_ITEM_DETAIL and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!