P_RABUSRECNCLNWITHUNQCNDNTYPE
Business Reconciliation Detail with Condition Type
P_RABUSRECNCLNWITHUNQCNDNTYPE is a CDS View in S/4HANA. Business Reconciliation Detail with Condition Type. It contains 66 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| P_RABusRecnclnDetWithCndnType | view_entity | from | COMPOSITE | Business Reconciliation Detail with Condition Type |
Fields (66)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | AccountingPrinciple | AccountingPrinciple | 1 |
| KEY | CompanyCode | CompanyCode | 1 |
| KEY | ConditionType | ConditionType | 1 |
| KEY | PerformanceObligation | PerformanceObligation | 1 |
| KEY | RevenueAccountingContract | RevenueAccountingContract | 1 |
| _AccountingPrinciple | _AccountingPrinciple | 1 | |
| _CompanyCode | _CompanyCode | 1 | |
| _Contract | _Contract | 1 | |
| _Mapping | _Mapping | 1 | |
| _RAPerformanceObligation | _RAPerformanceObligation | 1 | |
| _SenderComponentMapping | _SenderComponentMapping | 1 | |
| AdditionalCurrency1 | AdditionalCurrency1 | 1 | |
| AdditionalCurrency2 | AdditionalCurrency2 | 1 | |
| CARevnRecgnQtyUnit | CARevnRecgnQtyUnit | 1 | |
| CompanyCodeCurrency | CompanyCodeCurrency | 1 | |
| CostCurrency | CostCurrency | 1 | |
| FiscalYearPeriod | FiscalYearPeriod | 1 | |
| InvoiceCurrency | InvoiceCurrency | 1 | |
| Material | Material | 1 | |
| MaterialName | MaterialName | 1 | |
| PerPerdInvoicedAmtInSlsDocCrcy | PerPerdInvoicedAmtInSlsDocCrcy | 1 | |
| PostdContrLbltyAmtInCoCodeCrcy | PostdContrLbltyAmtInCoCodeCrcy | 1 | |
| PostdDfrrdCostAmtInCoCodeCrcy | PostdDfrrdCostAmtInCoCodeCrcy | 1 | |
| PostdDfrrdCostAmtInSlsDocCrcy | PostdDfrrdCostAmtInSlsDocCrcy | 1 | |
| PostdUnbilldRblAmtInCoCodeCrcy | PostdUnbilldRblAmtInCoCodeCrcy | 1 | |
| PostedContrLbltyAmtInAddlCrcy1 | PostedContrLbltyAmtInAddlCrcy1 | 1 | |
| PostedContrLbltyAmtInAddlCrcy2 | PostedContrLbltyAmtInAddlCrcy2 | 1 | |
| PostedDfrrdRevnAmtInCoCodeCrcy | PostedDfrrdRevnAmtInCoCodeCrcy | 1 | |
| PostedInvoiceAmtInSlsDocCrcy | PostedInvoiceAmtInSlsDocCrcy | 1 | |
| PostedRevnInSlsDocCrcy | PostedRevnInSlsDocCrcy | 1 | |
| PostedUnbilldRblAmtInAddlCrcy1 | PostedUnbilldRblAmtInAddlCrcy1 | 1 | |
| PostedUnbilldRblAmtInAddlCrcy2 | PostedUnbilldRblAmtInAddlCrcy2 | 1 | |
| RABusinessRecnclnViewType | RABusinessRecnclnViewType | 1 | |
| RAContractAssetsAmount | RAContractAssetsAmount | 1 | |
| RAContrLiabilitiesAmount | RAContrLiabilitiesAmount | 1 | |
| RADeferredRevenueInSlsDocCrcy | RADeferredRevenueInSlsDocCrcy | 1 | |
| RADeltaRecgdCostInSlsDocCrcy | RADeltaRecgdCostInSlsDocCrcy | 1 | |
| RAOperationalDocumentItem | RAOperationalDocumentItem | 1 | |
| RAPostdContrAstAmtInCoCodeCrcy | RAPostdContrAstAmtInCoCodeCrcy | 1 | |
| RAPostdDfrrdCostAmtInAddlCrcy1 | RAPostdDfrrdCostAmtInAddlCrcy1 | 1 | |
| RAPostdDfrrdCostAmtInAddlCrcy2 | RAPostdDfrrdCostAmtInAddlCrcy2 | 1 | |
| RAPostdDfrrdRevnAmtInAddlCrcy1 | RAPostdDfrrdRevnAmtInAddlCrcy1 | 1 | |
| RAPostdDfrrdRevnAmtInAddlCrcy2 | RAPostdDfrrdRevnAmtInAddlCrcy2 | 1 | |
| RAPostedContrAstAmtInAddlCrcy1 | RAPostedContrAstAmtInAddlCrcy1 | 1 | |
| RAPostedContrAstAmtInAddlCrcy2 | RAPostedContrAstAmtInAddlCrcy2 | 1 | |
| RAPostedCostAmountInAddlCrcy1 | RAPostedCostAmountInAddlCrcy1 | 1 | |
| RAPostedCostAmountInAddlCrcy2 | RAPostedCostAmountInAddlCrcy2 | 1 | |
| RAPostedCostAmountInCoCodeCrcy | RAPostedCostAmountInCoCodeCrcy | 1 | |
| RAPostedCostInSlsDocCrcy | RAPostedCostInSlsDocCrcy | 1 | |
| RAPostedInvoiceAmtInAddlCrcy1 | RAPostedInvoiceAmtInAddlCrcy1 | 1 | |
| RAPostedInvoiceAmtInAddlCrcy2 | RAPostedInvoiceAmtInAddlCrcy2 | 1 | |
| RAPostedInvoiceAmtInCoCodeCrcy | RAPostedInvoiceAmtInCoCodeCrcy | 1 | |
| RAPostedRevenueAmtInAddlCrcy1 | RAPostedRevenueAmtInAddlCrcy1 | 1 | |
| RAPostedRevenueAmtInAddlCrcy2 | RAPostedRevenueAmtInAddlCrcy2 | 1 | |
| RAPostedRevenueAmtInCoCodeCrcy | RAPostedRevenueAmtInCoCodeCrcy | 1 | |
| RAPostedUnbilldRblsAmount | RAPostedUnbilldRblsAmount | 1 | |
| RARecgdCostAmountInSlsDocCrcy | RARecgdCostAmountInSlsDocCrcy | 1 | |
| RARecognizedRevnInSlsDocCrcy | RARecognizedRevnInSlsDocCrcy | 1 | |
| RevnAcctgOperationalDocument | RevnAcctgOperationalDocument | 1 | |
| SalesDocumentCurrency | SalesDocumentCurrency | 1 | |
| SrceRecgdCostAmtInSlsDocCrcy | SrceRecgdCostAmtInSlsDocCrcy | 1 | |
| SrceRecgdInvcAmtInSlsDocCrcy | SrceRecgdInvcAmtInSlsDocCrcy | 1 | |
| SrceRecgdRevnAmtInSlsDocCrcy | SrceRecgdRevnAmtInSlsDocCrcy | 1 | |
| SuspendedCostAmtInSlsDocCrcy | SuspendedCostAmtInSlsDocCrcy | 1 | |
| SuspendedRevnAmtInSlsDocCrcy | SuspendedRevnAmtInSlsDocCrcy | 1 | |
| TransactionCurrency | TransactionCurrency | 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.
-- Business Reconciliation Detail with Condition Type
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_RABUSRECNCLNWITHUNQCNDNTYPE (
ACCOUNTINGPRINCIPLE,
COMPANYCODE,
CONDITIONTYPE,
PERFORMANCEOBLIGATION,
REVENUEACCOUNTINGCONTRACT,
_ACCOUNTINGPRINCIPLE,
_COMPANYCODE,
_CONTRACT,
_MAPPING,
_RAPERFORMANCEOBLIGATION,
_SENDERCOMPONENTMAPPING,
ADDITIONALCURRENCY1,
ADDITIONALCURRENCY2,
CAREVNRECGNQTYUNIT,
COMPANYCODECURRENCY,
COSTCURRENCY,
FISCALYEARPERIOD,
INVOICECURRENCY,
MATERIAL,
MATERIALNAME,
PERPERDINVOICEDAMTINSLSDOCCRCY,
POSTDCONTRLBLTYAMTINCOCODECRCY,
POSTDDFRRDCOSTAMTINCOCODECRCY,
POSTDDFRRDCOSTAMTINSLSDOCCRCY,
POSTDUNBILLDRBLAMTINCOCODECRCY,
POSTEDCONTRLBLTYAMTINADDLCRCY1,
POSTEDCONTRLBLTYAMTINADDLCRCY2,
POSTEDDFRRDREVNAMTINCOCODECRCY,
POSTEDINVOICEAMTINSLSDOCCRCY,
POSTEDREVNINSLSDOCCRCY,
POSTEDUNBILLDRBLAMTINADDLCRCY1,
POSTEDUNBILLDRBLAMTINADDLCRCY2,
RABUSINESSRECNCLNVIEWTYPE,
RACONTRACTASSETSAMOUNT,
RACONTRLIABILITIESAMOUNT,
RADEFERREDREVENUEINSLSDOCCRCY,
RADELTARECGDCOSTINSLSDOCCRCY,
RAOPERATIONALDOCUMENTITEM,
RAPOSTDCONTRASTAMTINCOCODECRCY,
RAPOSTDDFRRDCOSTAMTINADDLCRCY1,
RAPOSTDDFRRDCOSTAMTINADDLCRCY2,
RAPOSTDDFRRDREVNAMTINADDLCRCY1,
RAPOSTDDFRRDREVNAMTINADDLCRCY2,
RAPOSTEDCONTRASTAMTINADDLCRCY1,
RAPOSTEDCONTRASTAMTINADDLCRCY2,
RAPOSTEDCOSTAMOUNTINADDLCRCY1,
RAPOSTEDCOSTAMOUNTINADDLCRCY2,
RAPOSTEDCOSTAMOUNTINCOCODECRCY,
RAPOSTEDCOSTINSLSDOCCRCY,
RAPOSTEDINVOICEAMTINADDLCRCY1,
RAPOSTEDINVOICEAMTINADDLCRCY2,
RAPOSTEDINVOICEAMTINCOCODECRCY,
RAPOSTEDREVENUEAMTINADDLCRCY1,
RAPOSTEDREVENUEAMTINADDLCRCY2,
RAPOSTEDREVENUEAMTINCOCODECRCY,
RAPOSTEDUNBILLDRBLSAMOUNT,
RARECGDCOSTAMOUNTINSLSDOCCRCY,
RARECOGNIZEDREVNINSLSDOCCRCY,
REVNACCTGOPERATIONALDOCUMENT,
SALESDOCUMENTCURRENCY,
SRCERECGDCOSTAMTINSLSDOCCRCY,
SRCERECGDINVCAMTINSLSDOCCRCY,
SRCERECGDREVNAMTINSLSDOCCRCY,
SUSPENDEDCOSTAMTINSLSDOCCRCY,
SUSPENDEDREVNAMTINSLSDOCCRCY,
TRANSACTIONCURRENCY,
PRIMARY KEY (ACCOUNTINGPRINCIPLE, COMPANYCODE, CONDITIONTYPE, PERFORMANCEOBLIGATION, REVENUEACCOUNTINGCONTRACT)
);Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA