Skip to Content
avatar image
Former Member

Data Source for Recent Orders (Individual Customer)

Hello Colleagues,,

There is a  standard view for "Accounts" call "Recent Orders" where is possible to view recent order from SAP ERP.

From a customer requirement, I need to show recent orders created in ERP for a "Individual Customer". We haven´t find the way to activate same option "Recent Orders" for individual customer in C4C. Any Advice?

I'm considering to create a Report directly  from data source where recent order are saved in C4C and lauch this report in "individual Customer" Resume view. However, the problem on this option is that I can´t not find the data source for such recent orders coming from ERP to C4C. Any of you know the data source for Recent Orders.

Any advice is welcome.

Thanks in advanced,

Niko

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Oct 16, 2015 at 07:10 PM

    Data Source: Sales Order Item

    Object Information

    Data Source NameSales Order ItemData Source IDCODCOIBDescriptionContains data on the quantities and values of sales order items. It allows you to analyze the distribution of sales order items across organizational units.TypeBasic Data SourceOriginSAPObsolete

    Documentation

    Show details Show full documentation

    Hide details Hide documentation

    No documentation available.

    Show details Access Control

    Hide details Access Control

    Access Context NameAccess Context IDEmployee or Territory or Sales Data1015

    Overview of Fields

    Show details Characteristics

    Hide details Characteristics

    Characteristic NameCharacteristic IDData TypeMaster Data - Data SourceMaster Data - CharacteristicVisibilityPosting DateACO_DOC_POSTING_DATEDate field (YYYYMMDD) stored as char(8)Visible for Report ModellingMonthACO_DOC_POSTING_MONTHCharacter StringVisible for Report ModellingQuarterACO_DOC_POSTING_QUARTERCharacter StringVisible for Report ModellingWeekdayACO_DOC_POSTING_WEEK_DAY_CODECharacter StringVisible for Report ModellingYearACO_DOC_POSTING_YEARCharacter StringVisible for Report ModellingYear MonthACO_DOC_POSTING_YEAR_MONTHCharacter StringVisible for Report ModellingYear QuarterACO_DOC_POSTING_YEAR_QUARTERCharacter StringVisible for Report ModellingYear WeekACO_DOC_POSTING_YEAR_WEEKCharacter StringVisible for Report ModellingParent Item IDACO_ITM_PARENT_ITEM_IDAlphanumeric Character StringVisible for Report ModellingItem Posting DateACO_ITM_POSTING_DATEDate field (YYYYMMDD) stored as char(8)Visible for Report ModellingPosting Month (Item)ACO_ITM_POSTING_MONTHCharacter StringVisible for Report ModellingPosting Quarter (Item)ACO_ITM_POSTING_QUARTERCharacter StringVisible for Report ModellingPosting Weekday (Item)ACO_ITM_POSTING_WEEK_DAY_CODECharacter StringVisible for Report ModellingPosting Year (Item)ACO_ITM_POSTING_YEARCharacter StringVisible for Report ModellingPosting Year Month (Item)ACO_ITM_POSTING_YEAR_MONTHCharacter StringVisible for Report ModellingPosting Year Quarter (Item)ACO_ITM_POSTING_YEAR_QUARTERCharacter StringVisible for Report ModellingPosting Year Week (Item)ACO_ITM_POSTING_YEAR_WEEKCharacter StringVisible for Report ModellingCurrency of Net AmountACO_ITV_NET_AMT_CURRCharacter StringVisible for Report ModellingPrice CurrencyACO_ITV_NET_PRICE_AMOUNT_CURRCharacter StringVisible for Report ModellingRequested Quantity UnitACO_ITV_REQU_QTY_UNTCharacter StringVisible for Report ModellingCurrency of Tax AmountACO_ITV_TAX_AMOUNT_CURR_CDCharacter StringVisible for Report ModellingDistribution ChannelCCO_DBA_DISTR_CHAN_CODECharacter StringVisible for Report ModellingDivisionCCO_DBA_DIVISION_CODECharacter StringVisible for Report ModellingSales OrganizationCCO_DBA_SALES_ORG_UUIDUninterpreted sequence of bytesFunctional Unit Master DataFunctional UnitVisible for Report ModellingSales TerritoryCCO_DBA_SLS_TERRITORY_IDCharacter StringVisible for Report ModellingExternal ReferenceCCO_DOC_BUYER_IDAlphanumeric Character StringVisible for Report ModellingChanged ByCCO_DOC_CHANGED_BY_UUIDUninterpreted sequence of bytesCCAIDNTYB_SOLIDNTYUUIDVisible for Report ModellingSales Order IDCCO_DOC_IDAlphanumeric Character StringVisible for Report ModellingSales OrderCCO_DOC_UUIDUninterpreted sequence of bytesSales Order HeaderSales OrderVisible for Report ModellingSales EmployeeCCO_DPY_SLS_EMP_PTY_UUIDUninterpreted sequence of bytesEmployee Master Data (deprecated)EmployeeVisible for Report ModellingSales PartnerCCO_DPY_SLS_PRT_PTY_UUIDUninterpreted sequence of bytesBusiness Partner Master DataBusiness PartnerVisible for Report ModellingOriginal ProductCCO_IPR_ORIG_PRODUCTUninterpreted sequence of bytesVisible for Report ModellingProduct CategoryCCO_IPR_PRD_CATEGORY_IDAlphanumeric Character StringVisible for Report ModellingProduct TypeCCO_IPR_PRD_TYPE_CDCharacter StringVisible for Report ModellingProductCCO_IPR_PRODUCTUninterpreted sequence of bytesProduct Master DataProductVisible for Report ModellingQuantity UoMCCO_IPR_QTY_MEAS_UNT_CDCharacter StringVisible for Report ModellingAccountCCO_IPY_BUYER_PTY_UUIDUninterpreted sequence of bytesAccount Master Data (deprecated)AccountVisible for Report ModellingEmployee ResponsibleCCO_IPY_EMPL_RSP_PTY_UUIDUninterpreted sequence of bytesEmployee Master Data (deprecated)EmployeeVisible for Report ModellingShip-ToCCO_IPY_PROD_REC_PTY_UUIDUninterpreted sequence of bytesBusiness Partner Master DataBusiness PartnerVisible for Report ModellingSellerCCO_IPY_SELLER_PTY_UUIDUninterpreted sequence of bytesCompany Master DataCompanyVisible for Report ModellingSales UnitCCO_IPY_SLS_UNIT_PTY_UUIDUninterpreted sequence of bytesFunctional Unit Master DataFunctional UnitVisible for Report ModellingProduct Availability Confirmation CommitmentCCO_ISL_ITM_AVAIL_CONFIRM_CDCharacter StringVisible for Report ModellingItem Confirmed DateCCO_ISL_ITM_CONFIRMED_DATECounter or amount field with comma and signVisible for Report ModellingReason for RejectionCCO_IST_CANCEL_REASON_CDCharacter StringVisible for Report ModellingItem Changed ByCCO_ITM_CHANGED_BY_UUIDUninterpreted sequence of bytesCCAIDNTYB_SOLIDNTYUUIDVisible for Report ModellingSales Order Item IDCCO_ITM_IDAlphanumeric Character StringVisible for Report ModellingItem Processing TypeCCO_ITM_PROC_TYPE_CDCharacter StringVisible for Report ModellingApproval StatusCCO_ITM_S_APPROVALCharacter StringVisible for Report ModellingATPCCO_ITM_S_AVAILABILITYCharacter StringVisible for Report ModellingCancellation Status (Item)CCO_ITM_S_CANCELLATIONCharacter StringVisible for Report ModellingConsistency Status (Item)CCO_ITM_S_CONSISTENCYCharacter StringVisible for Report ModellingItem Delivery StatusCCO_ITM_S_FULFILMENTCharacter StringVisible for Report ModellingCompleteness StatusCCO_ITM_S_GEN_DATACharacter StringVisible for Report ModellingItem Billing StatusCCO_ITM_S_INVOICINGCharacter StringVisible for Report ModellingItem StatusCCO_ITM_S_QUOTECharacter StringVisible for Report ModellingItem Document TypeCCO_ITM_TYPE_CDCharacter StringVisible for Report ModellingSales Order ItemCCO_ITM_UUIDUninterpreted sequence of bytesVisible for Report ModellingConfirmed Quantity UnitISL_ITM_CONFIRMED_QTY_CURR_CDCharacter StringVisible for Report Modelling

    Show details Key Figures (Data Source)

    Hide details Key Figures (Data Source)

    Key Figure NameKey Figure IDKey Figure TypeData TypeAggregation TypeUnit/Currency FieldVisibilityItem Net AmountACO_ITV_NET_AMTAmountCounter or amount field with comma and signSummationCurrency of Net AmountVisible for Report ModellingItem Net PriceACO_ITV_NET_PRICE_AMOUNTAmountCounter or amount field with comma and signSummationPrice CurrencyVisible for Report ModellingRequested Item QuantityACO_ITV_REQU_QTYQuantityCounter or amount field with comma and signSummationRequested Quantity UnitVisible for Report ModellingItem Tax AmountACO_ITV_TAX_AMOUNTAmountCounter or amount field with comma and signSummationCurrency of Tax AmountVisible for Report ModellingSales Order Confirmed QuantityISL_ITM_CONFIRMED_QUANTITYQuantityCounter or amount field with comma and signSummationConfirmed Quantity UnitVisible for Report ModellingCounter0COUNTValue4-byte integer, integer number with signSummationVisible for End User Personalization

    Where Used List

    No usages found

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 16, 2015 at 07:11 PM

    Data Source: Sales Order Header

    Object Information

    Data Source NameSales Order HeaderData Source IDCODCOHBDescriptionContains data on the quantities and values of sales orders in total. It allows you to analyze the distribution of sales orders across organizational units.TypeBasic Data SourceOriginSAPObsolete

    Documentation

    Show details Show full documentation

    Hide details Hide documentation

    No documentation available.

    Show details Access Control

    Hide details Access Control

    Access Context NameAccess Context IDEmployee or Territory or Sales Data1015

    Overview of Fields

    Show details Characteristics

    Hide details Characteristics

    Characteristic NameCharacteristic IDData TypeMaster Data - Data SourceMaster Data - CharacteristicVisibilityCreated OnACO_DOC_CREATED_DATEDate field (YYYYMMDD) stored as char(8)Visible for Report ModellingPosting DateACO_DOC_POSTING_DATEDate field (YYYYMMDD) stored as char(8)Visible for End User PersonalizationMonthACO_DOC_POSTING_MONTHCharacter StringVisible for End User PersonalizationQuarterACO_DOC_POSTING_QUARTERCharacter StringVisible for End User PersonalizationWeekdayACO_DOC_POSTING_WEEK_DAY_CODECharacter StringVisible for End User PersonalizationYearACO_DOC_POSTING_YEARCharacter StringVisible for End User PersonalizationYear MonthACO_DOC_POSTING_YEAR_MONTHCharacter StringVisible for End User PersonalizationYear QuarterACO_DOC_POSTING_YEAR_QUARTERCharacter StringVisible for End User PersonalizationYear WeekACO_DOC_POSTING_YEAR_WEEKCharacter StringVisible for End User PersonalizationExternal IDCCO_BTD_REF_ID_CONTENTAlphanumeric Character StringVisible for End User PersonalizationDistribution ChannelCCO_DBA_DISTR_CHAN_CODECharacter StringVisible for End User PersonalizationDivisionCCO_DBA_DIVISION_CODECharacter StringVisible for End User PersonalizationSales OrganizationCCO_DBA_SALES_ORG_UUIDUninterpreted sequence of bytes/MOM/FUNCUNITFunctional UnitVisible for End User PersonalizationSales TerritoryCCO_DBA_TERRITORY_IDCharacter StringVisible for End User PersonalizationPayment TermsCCO_DCDT_PAYMENT_TERMSCharacter StringVisible for Report ModellingDelivery PriorityCCO_DDT_DELIVERY_PRIORITY_CDCharacter StringVisible for End User PersonalizationIncotermsCCO_DDT_INCOTERMS_CLASSIF_CDCharacter StringVisible for End User PersonalizationIncoterms LocationCCO_DDT_INCOTERMS_LOCATIONCharacter StringVisible for End User PersonalizationExternal ReferenceCCO_DOC_BUYER_IDAlphanumeric Character StringVisible for End User PersonalizationCreated ByCCO_DOC_CREATED_BY_UUIDUninterpreted sequence of bytesCCAIDNTYB_SOLIDNTYUUIDVisible for End User PersonalizationFulfilment Block ReasonCCO_DOC_FULF_BLOCK_REASON_CDCharacter StringVisible for End User PersonalizationSales Order IDCCO_DOC_IDAlphanumeric Character StringVisible for End User PersonalizationBilling Block ReasonCCO_DOC_INV_BLOCK_REASON_CDCharacter StringVisible for End User PersonalizationOrder ReasonCCO_DOC_ORDER_REASONCharacter StringVisible for End User PersonalizationDocument TypeCCO_DOC_PROC_TYPE_CDCharacter StringVisible for End User PersonalizationCancellation StatusCCO_DOC_S_AG_CANCELLATIONCharacter StringVisible for End User PersonalizationConsistency StatusCCO_DOC_S_AG_CONSISTENCYCharacter StringVisible for Report ModellingDelivery StatusCCO_DOC_S_AG_FULFILMENTCharacter StringVisible for End User PersonalizationCreditworthiness StatusCCO_DOC_S_CREDIT_WORTHCharacter StringVisible for End User PersonalizationExternal Overall StatusCCO_DOC_S_EXTERNAL_LCCharacter StringVisible for End User PersonalizationBlockingStatusCodeCCO_DOC_S_OVERALL_BLOCKINGCharacter StringVisible for End User PersonalizationTransfer StatusCCO_DOC_S_REPLICATIONCharacter StringVisible for Report ModellingSales OrderCCO_DOC_UUIDUninterpreted sequence of bytesVisible for Report ModellingPricing DateCCO_DPT_PRICE_DATE_TIMECounter or amount field with comma and signVisible for End User PersonalizationReason for RejectionCCO_DST_CANCEL_REASON_CDCharacter StringVisible for End User PersonalizationCurrency of Gross AmountCCO_DTV_GROSS_AMOUNT_CURR_CDCharacter StringVisible for End User PersonalizationCurrency of Net AmountCCO_DTV_NET_AMOUNT_CURRENCY_CDCharacter StringVisible for End User PersonalizationCurrency of Tax AmountCCO_DTV_TAX_AMOUNT_CURRENCY_CDCharacter StringVisible for End User PersonalizationAccountCCO_DOC_BUYER_PARTYUninterpreted sequence of bytesCODCUSTOMERAccountVisible for End User PersonalizationBuyer Party Role categoryCCO_DOC_BUYER_ROLE_CAT_CDCharacter StringVisible for MDAV ModellingSales UnitCCO_DOC_SALES_UNITUninterpreted sequence of bytes/MOM/ORGCENTREOrg UnitVisible for End User PersonalizationSales Unit Party Role CategoryCCO_DOC_SALES_UNIT_ROLE_CATCharacter StringVisible for MDAV Modelling

    Show details Key Figures (Data Source)

    Hide details Key Figures (Data Source)

    Key Figure NameKey Figure IDKey Figure TypeData TypeAggregation TypeUnit/Currency FieldVisibilityGross AmountCCO_DTV_GROSS_AMOUNTAmountCounter or amount field with comma and signSummationCurrency of Gross AmountVisible for End User PersonalizationNet AmountCCO_DTV_NET_AMOUNT_CONTENTAmountCounter or amount field with comma and signSummationCurrency of Net AmountVisible for End User PersonalizationTax AmountCCO_DTV_TAX_AMOUNT_CONTENTAmountCounter or amount field with comma and signSummationCurrency of Tax AmountVisible for End User PersonalizationCounter0COUNTValue4-byte integer, integer number with signSummationVisible for End User Personalization

    Where Used List

    Object TypeObject NameObject IDAssociationData SourceSales Order ItemCODCOIBUSED_AS_MDR
    Add comment
    10|10000 characters needed characters exceeded