P_RRBWRITTENOFFDYNAMICITEM

CDS View

P_RRBWRITTENOFFDYNAMICITEM is a CDS View in S/4HANA. It contains 37 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_RRBWrittenOffDynamicItem view from CONSUMPTION Written Off Dynamic Item

Fields (37)

KeyField CDS FieldsUsed in Views
KEY RRBDynamicItem RRBDynamicItem 1
KEY RRBSalesPricingDocument RRBSalesPricingDocument 1
_TransactionCurrency _TransactionCurrency 1
_UnitOfMeasure _UnitOfMeasure 1
AccountingDocument AccountingDocument 1
AmountToBeBilledInTransacCrcy AmountToBeBilledInTransacCrcy 1
AmtToBePostponedInTransacCrcy AmtToBePostponedInTransacCrcy 1
AmtToBeRejectedInTransacCrcy AmtToBeRejectedInTransacCrcy 1
BilledAmountInTransacCrcy BilledAmountInTransacCrcy 1
BilledQuantity BilledQuantity 1
BillingControlCategory BillingControlCategory 1
BillingPlan BillingPlan 1
BillingPlanItem BillingPlanItem 1
BillingPlanItemUsage BillingPlanItemUsage 1
CanceledAmountInTransacCrcy CanceledAmountInTransacCrcy 1
CompanyCode CompanyCode 1
ControllingObject ControllingObject 1
DocumentCurrency DocumentCurrency 1
FiscalYear FiscalYear 1
LedgerGLLineItem LedgerGLLineItem 1
Material Material 1
NetAmount NetAmount 1
OpenAmountInTransCrcy OpenAmountInTransCrcy 1
OpenQuantity OpenQuantity 1
OriginalAmountInTransacCrcy OriginalAmountInTransacCrcy 1
ReferenceDocument ReferenceDocument 1
ReferenceDocumentItem ReferenceDocumentItem 1
RejectedAmtInTransCrcy RejectedAmtInTransCrcy 1
RejectedQuantity RejectedQuantity 1
SalesDocument SalesDocument 1
SalesDocumentItem SalesDocumentItem 1
SalesDocumentItemText SalesDocumentItemText 1
TimeSheetOvertimeCategory TimeSheetOvertimeCategory 1
TotalBillableQtyInBaseUnit TotalBillableQtyInBaseUnit 1
TransactionCurrency TransactionCurrency 1
UnitOfMeasure UnitOfMeasure 1
WorkItem WorkItem 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_RRBWRITTENOFFDYNAMICITEM (
    RRBDYNAMICITEM,
    RRBSALESPRICINGDOCUMENT,
    _TRANSACTIONCURRENCY,
    _UNITOFMEASURE,
    ACCOUNTINGDOCUMENT,
    AMOUNTTOBEBILLEDINTRANSACCRCY,
    AMTTOBEPOSTPONEDINTRANSACCRCY,
    AMTTOBEREJECTEDINTRANSACCRCY,
    BILLEDAMOUNTINTRANSACCRCY,
    BILLEDQUANTITY,
    BILLINGCONTROLCATEGORY,
    BILLINGPLAN,
    BILLINGPLANITEM,
    BILLINGPLANITEMUSAGE,
    CANCELEDAMOUNTINTRANSACCRCY,
    COMPANYCODE,
    CONTROLLINGOBJECT,
    DOCUMENTCURRENCY,
    FISCALYEAR,
    LEDGERGLLINEITEM,
    MATERIAL,
    NETAMOUNT,
    OPENAMOUNTINTRANSCRCY,
    OPENQUANTITY,
    ORIGINALAMOUNTINTRANSACCRCY,
    REFERENCEDOCUMENT,
    REFERENCEDOCUMENTITEM,
    REJECTEDAMTINTRANSCRCY,
    REJECTEDQUANTITY,
    SALESDOCUMENT,
    SALESDOCUMENTITEM,
    SALESDOCUMENTITEMTEXT,
    TIMESHEETOVERTIMECATEGORY,
    TOTALBILLABLEQTYINBASEUNIT,
    TRANSACTIONCURRENCY,
    UNITOFMEASURE,
    WORKITEM,
    PRIMARY KEY (RRBDYNAMICITEM, RRBSALESPRICINGDOCUMENT)
);